How to build a 'Drillthrough' item that works in a PDF.

[Peager]

I am working with Report Server 2005 and am trying to create an http URL that will render in a PDF that will provide a link back to the report. I have been able to get the following to work without passing report parameters:

"[URL unfurl="true"]http://mcsql/Reports/Pages/Report.aspx?ItemPath=%2fRS+Reports%2fMonthly+MAT+Sales+by+REP"[/URL]

But what I really want is to be able to add a couple of parameters to it and get something like this to work:

="[URL unfurl="true"]http://mcsql/Reports/Pages/Report.aspx?ItemPath=%2fRS+Reports%2fMonthly+MAT+Sales+by+REP&Workdate="+Parameters!WorkDate.Value+"&ShowCOGS="+Parameters!ShowCOGS.Value[/URL]

This would be used as a "Jump to URL" in the "Action" property of a textbox.

Anybody got any ideas?

 

[xlbo]

Are you saying that you want to reference parameters FROM an already generated PDF ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Peager]

Yes! There's a lot of times where we have a PDF stored and someone will want to rerun it changing one of the parameters. A number of our reports have 12 - 15 parameters so it would be slick if we could pass these back into the app, letting the end user change the one or two they want.

Paul

 

[xlbo]

Don't think this can be done. I wouldn;t have thought that the PDF will store any kind of parameter information. It is a presentation app not an interactive one.

Quite willing to be proved wrong though....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Peager]

The first link works properly as you would expect. As I see it, the problem centers around being able to evaluate the formula with the result becoming the link. The docs infer that it can be done saying that the link can be stored in a variable or parameter... I just couldn't get it to work.

Paul

 

[SgtJarrow]

Don't know if this helps, but the correct format to pass parameters through a SSRS Report using http is as follows:

[URL unfurl="true"]http://hostname/ReportServer?/<optional[/URL] folders>/ReportName&<parametername>=<parametervalue>&<parameter2name>=<parameter2value>

As to storing the values or retrieving them from the PDF...I also don't think that is possible. Of course, I have never researched this much as we have our own custom reporting application here that display all our reports in a Report Viewer embedded into the application itself. We capture the last parameters for any report run and store those in a database. Anytime that same person tries to run the same report, we pull the last used parameters and prefill them for the user. Then they can change the ones they want.

Of course, you seem to be trying to use a click through....not much experience there. Hope you find a solution though. I'd be interested in it as well.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer