Showing posts with label rdl. Show all posts
Showing posts with label rdl. Show all posts

Thursday, March 22, 2012

dropdown menu in sql reporting

Is it possible in SQL Reporting 2005 to have dropdown menu(eg..on mouseover list of static menu appears from which i can navigate to other rdl files while passing all parameters) ..

Do you mean in the parameter pane or within the report ?

Jens K. Suessmeyer.


http://www.sqlserver2005.de

|||

I mean within the report..
As for now on i made one horizontal table and below it vertical menutable..now on form load and other event of the form i pass in navigation parqameter VerticaltableDisplay="N" and only in one event when Cell of horizontal table on top I pass parmeter =IIF(VerticaltableDisplay="Y","N","Y")

and in visiblity property of vertical table gave a condition =IIF(VerticaltableDisplay="Y",Display,Hide)*

It is working for click event ok but how can i do for mouseover event...

as if once clicked on report its visible and if there is no other even and we export to different format the verticaltable is visible

|||Javascript is very restricted in Reporting Services, I guess you cannot use the mouseover events here.

HTH, Jens K. Suessmeyer.

-
http://www.sqlserver2005.de
-

Sunday, February 19, 2012

Drillthrough Event not getting fired

Hi,
I am using VS2005 and SQL Server 2005 reporting Services. I have created a server report (rdl file) and wish to implement drillthrough functionality. On my web page, I added a reportviewer control and added an "OnDrillThrough" Event to the reportviewer.
However, when I click on the element that should raise the drillthrough event, the page gets posted back but the drillthrough event does not get called at all?? Am i missing something?

Thanks
Dabi

Hi Dabi,

I have the same problem as you posted with the drillthrough and I didn't find yet a solution. Can you help me please with it if you found a solution to it?

thanks,

Hanin