On demand subreport parameters that appear only when clicked ?

[crogers111]

CRXI
SQL

From searching an finding a few unanswered posts, I'm guessing this may not be possible.

I have a simple report with fields in the details section with a couple of parameters for the users. (?Client ID & ?FromDate & ?ToDate)

GOAL: I'm trying to set a field on the report to mimic a hyperlink so that when the user clicks the field/link it will prompt for 2 new Parameters: BegDate & Endate that can then be passed to the subereport. The subreport is a different report from a different DB on the same server. The subreport is a simple report linked on 2 fields in the main report. I have added a ?BegDate and EndDate parameter in the subreport.

Currently I have an On-Demand Subreport with a caption to make the 'hyperlink' like functionality work which works great

PROBLEM: the subreport parameters prompt the user when running the main report, not when the user clicks on the suberport link.

- Is there a way to have the parameters in an on-demand subreport only fire when the user clicks on the subreport in the preview ?
- If not is there a different way to go about having a field in the main report act like a hyperlink that will prompt a user for a parameter when clicked.

I played with the actual Hyperlink option in CR some but didn't find a way to make this work as of yet.

Any assistance or ideas are appreciated !

 

[hilfy]

I think the only way to get the functionality you're looking for would be to have a hyperlink in the main report that opens a new report instead of a subreport.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[IanWaterman]

If ?BegDate and EndDate have the same values as main report ?FromDate & ?ToDate you can link them

In Linking windown drag ?FromDate & ?ToDate into main pane, in lower left hand drop down use drop down and scroll down to find ?BegDate and EndDate . To link the parameters must be same data type.

Ian