Dynamically linking and running reports 1

[hanchilicious]

Hey,

Is it possible to call a report by 'drilling down' on a field in another report? The concept is the same as hyperlinking, but hyperlinking only seems to be available to reports which have already been run.

Ideally, I need to pass variables from the calling report to a new report, and have the new report process and return new values to the user once they activate any 'drill downable' field. I'd like to know (a) if this is possible at all, and (b) if it is possible, does it have to be via the web?

Thanks so much for taking the time out to read this.

Kind regards,

Mal

 

[lyanch]

This is very possible. In fact, this is how I deal with normal subreports on demand that you can't export in the web viewers. You need to create a URL to call the subreport and can place data from your report as the parameters for the report called.

Example - in the conditional for the hyperlink:

"

http://report_center/viewrpt.cwr?ID...&apspassword=&apsauthtype=secEnterprise"

+ "&promptex-catalogId=" + '"' + {FragSnapRel.catalogId} + '"'

This makes the hyperlink go to the appropriate catalog ID


Lisa

 

[hanchilicious]

Lisa,

Thanks a lot for your response.

So, if I'm understanding you correctly, reports can call each other pretty much indefinitely, but every time you need values passed, it's a process of report1->url->report2 ad infinitum?

I've been out of the Crystal game for a little while now, so I'm glad to hear it's possible, but I'd most likely need to get into how it's achieved in some detail.

Do you know if there's any whitepapers or urls I should be rifling through? I've been having an exhaustive look online, but to no avail, unfortunately. If it's more straight forward than I'm envisaging, a high level walkthru in the forum would be great, if anybody has the time.

Thanking you again,

Mal