One crystal report executing another crystal report ?

 5 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member

Has anybody accomplished one report executing another crystal report and passing a parameter .

I know this can be done by adding an hyperlink to the report and passing a parameter. Can somebody share the excat sysntax after publishing both on lbi.

 

Matthew Nye
Veteran Member Send Private Message
Posts: 514
Veteran Member
something like this:

"http://lbiserver/efs/FSRemote?fsid=FSRemote?fsid=RS:RS-Reporting Services:12&parametername=parametervalue "

you can see more options in the RS user guide, Chapter 8: Scripting Reports
If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member

Instead of executing the crstal report when a parameter is passed, I would like to bring up the latest instance of the report via the parent report.

According  to chapter 8 of the reporting services manual & InstanceId=Latest should be added. Has anybody tried this ? Does this work ?

Matthew Nye
Veteran Member Send Private Message
Posts: 514
Veteran Member
yeah, just append that to the end of the URL. Keep in mind that if there is no historical instance it will run the report with Data Refresh.
If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member

This is very helpful. Is there anyway i can prevent the whole report to run with report refresh if there is no historical instance created.

Matthew Nye
Veteran Member Send Private Message
Posts: 514
Veteran Member
the only way would be to explicitly define the numbered instance. Instance=##
If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/