Drillthroughs and report viewers

I'm fairly new to the Reporting Services world and I'm having some
difficulties with getting my drillthrough reports to open within the
same report viewer as its parent report.
Currently, I'm using the "Jump to URL:" navigation feature with the
URL:
http://localhost/Telecomm/WirelessAcctReports.aspx?ReportName=MinutesDrillDown.rdl&YearMonth=200408&rs:ClearSession=true&rc:parameters=false
This will bring up the page WirelessAcctReports with the viewer on it,
but not the report. I've also tried putting brackets around the report
name
http://localhost/Telecomm/WirelessAcctReports.aspx?ReportName=<MinutesDrillDown.rdl&YearMonth=200408&rs:ClearSession=true&rc:parameters=false>
but this gives me the error:
A potentially dangerous Request.QueryString value was detected from
the client (ReportName="<MinutesDrillDown.rd...").
What to I need to do to get this to work.
Also, eventually I will need to pass a parm for YearMonth. Will the
URL accept the Parameters!YearMonth.Value or will I have to pass it a
different way? thanks in advance.
JonathanJonathan,
Try using the "jump to report" as the action. You mentioned that you
will have a detail report that you will pass a parameter to. For example: I
have a report that shows a graph of number customers by geography in a pie
chart. When you select a pie slice (ie United States) then the action it
takes is to drill thru to the detail report displaying the customers for the
United States (parameter passed from the pie chart). I think this is what
you ultimately want to do based upon your posting. Once you define the
detail report (in my case the customer detail - which takes a parameter of
geography) ... then you can select that report to jump to and you can select
what field to pass from the first report as the parameter value for the
detail report. I hope this helps.
"Jonathan" wrote:
> I'm fairly new to the Reporting Services world and I'm having some
> difficulties with getting my drillthrough reports to open within the
> same report viewer as its parent report.
> Currently, I'm using the "Jump to URL:" navigation feature with the
> URL:
> http://localhost/Telecomm/WirelessAcctReports.aspx?ReportName=MinutesDrillDown.rdl&YearMonth=200408&rs:ClearSession=true&rc:parameters=false
> This will bring up the page WirelessAcctReports with the viewer on it,
> but not the report. I've also tried putting brackets around the report
> name
> http://localhost/Telecomm/WirelessAcctReports.aspx?ReportName=<MinutesDrillDown.rdl&YearMonth=200408&rs:ClearSession=true&rc:parameters=false>
> but this gives me the error:
> A potentially dangerous Request.QueryString value was detected from
> the client (ReportName="<MinutesDrillDown.rd...").
> What to I need to do to get this to work.
> Also, eventually I will need to pass a parm for YearMonth. Will the
> URL accept the Parameters!YearMonth.Value or will I have to pass it a
> different way? thanks in advance.
> Jonathan
>