(double)clicking part of report

[TjS]

In my report i have inserted a chart.
This chart has several columns as result.

My question is that i want to open a new report when clicking on one of the columns in the chart.

Every column refers to another detail information.

please advise?

 

[DCrake]

As far as I am aware you cannot drill down in reports by clicking on the series. However I did post a sample of drilling down in reports a while a go. Here is the Link to it. See if this helps.

David

 

[TjS]

Thanks in advance!
I will look at the hyperlink

 

[TjS]

i am new concerning this...but i try to design the report in the SQL Server Report Designer (MS Visual Studio). The connection is with ODBC to an access db. I don´t think i can use the trick of the snapshot within the MS VIsual studio designer+ maybe another suggestion?

 

[SQL_Hell]

It might be easier to create a webpage with a data grid (which looks like your report) then you will easily be able to deal with "drill down clicking" and opening of another page.

 

[TjS]

i found the solution for this. Quite easy though!

in the designer right click on the series of the graphic part (the columns)
in the submenu click on series properties
then click on Action
then click on radiobutton () report and select the detailled report
then click on the button [Add] and select a parameter from the detailled report

Now when the report is being viewed, and there is clicked on the column (serie) the detailled report will be opened