Hyperlinking Between Reports 1

[paulosinuk]

Hi,

I'm using CR XI and SQL Server.

I have the following scanario:

Report 1
Details Section - Hyperlink to Report 2

Report 2
Report Header & Footer - Hyperlink to Report 1
Details Section - Hyperlink to Report 3

Report 3
Report Header & Footer - Hyperlink to Report 1
Report Header & Footer - Hyperlink to Report 2

I'm using hyperlinking since on-demand sub-reporting doesn't allow a sub within a sub. All 3 reports have been published into Crystal Server and I've established the links based opening each from Crystal Server and pasting the link.

My problem is that I want to conditionally control what is displayed on reports 2 & 3 based on the row selected from Report 1 or 2.

I can see a data context property against the hyperlink but I don't know if this or some other option can be used to filter the contents of the sub report.

Any help would be appreciated.

Thanks

Paul

 

[Turkbear]

Hi,
If you are dynamically building the hyperlink to the other reports, maybe you could construct it in such a way ( with a formula using the returned data from the Main report(s)) that it passes the parameters and values needed as part of the URL..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[paulosinuk]

Any chance of an example?

 

[Turkbear]

Hi,
The exact construction of the URL is dependant on how you are running the report ( which viewer, custom code or EPortfolio( or whatever they are calling it in XI - InfoView I think?), etc).

This one, for instance,from a custom calling page, uses the viewrpt.cwr and activeX viewer to get the data for a particular work request :

[URL unfurl="true"]http://myceserver/viewrpt.cwr?id=29069&apsname=Guest&apsauthtype=secEnterprise&init=actx&promptex-WORK_REQUEST_NO=12[/URL]

WORK_REQUEST is a parameter defined in the report and used in the record selection criteria.







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[paulosinuk]

Hi,

This almost works but the parameters don't seem to be accepted. I have 3 parameters, how would the syntax change to accomodate 3 parameters on the end?

Thanks

 

[Turkbear]

Hi,
Specify each one by name appended to the promptex- string:
Here is an exampple from one of our apps: ( edited , of course)

[URL unfurl="true"]http://MyServer/viewrpt.cwr?id=29044&apsname=Guest&apsauthtype=secEnterprise&promptex-District="3"&promptex-Municipality="ADRN"&promptex-County="ALL"&promptex-LMaintZone="ALL"&init=actx[/URL]

Hope it helps..




To Paraphrase:"The Help you get is proportional to the Help you give.."