Who's On?

	Membership:
	Latest: Raju
	Past 24 Hours: 1
	Prev. 24 Hours: 2
	Overall: 5205

	People Online:
	Visitors: 313
	Members: 0
	Total: 313

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1369
Roger French	1315
mark.cook	1244

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

Posts: 412

4/16/2009 7:22 PM

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

Posts: 514

4/16/2009 7:40 PM

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

Ruma Malhotra

Veteran Member

Posts: 412

4/17/2009 1:45 PM

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

Posts: 514

4/17/2009 2:22 PM

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.

Ruma Malhotra

Veteran Member

Posts: 412

4/17/2009 2:50 PM

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

Posts: 514

4/17/2009 3:07 PM

the only way would be to explicitly define the numbered instance. Instance=##