(double)clicking part of report (1 Viewer)

TjS · Aug 12, 2009

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 · Aug 12, 2009

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 · Aug 12, 2009

Thanks in advance!
I will look at the hyperlink

TjS · Aug 12, 2009

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 · Aug 12, 2009

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 · Sep 1, 2009

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

(double)clicking part of report (1 Viewer)

TjS

Registered User.

DCrake

Remembered

TjS

Registered User.

TjS

Registered User.

SQL_Hell

SQL Server DBA

TjS

Registered User.

Similar threads

Users who are viewing this thread