PASSING PARAMETER VALUES BETWEEN HYPERLINKED REPORTS

[barryhallmp]

Hi All,

Thanks in advance for any replies!

Crystal version 10
SQL Server 2000

I have three reports based on three different stored procedures.

All three stored procedures have a variable requiring input [@userID]
which automatically gets created in each report as a parameter [@userID].

I need to be able to link the three reports, so that when a user opens
either report 1, 2 or 3 they are then able to navigate to either of the
other two reports and from that report to either of the other two and
from that report to either of the other two etc. etc. Essentially I need
a loop of reports. Because of this I can't use normal subreports.

Therefore, I've been looking at the "hyperlink to another report"
functionality which seems to be working well to navigate to the other
reports.

However, I would like for the end user to only be prompted for their
input into the parameter value when they open the very first report, and
then for the parameter value to be passed through to whichever of the
hyperlinked reports they choose.

I've tried to pass the values between reports using global variables yet
haven't been able to get this to work. I think possibly because the
parameter value is evaluated prior to the variable?!?!

So, any ideas on how I could achieve this?

Many thanks,
BH

 

[IdoMillet]

If you create one main report and insert the other 2 as linked onDemand subreports, you would end up with 3 tabs (assuming the user clicks on both subreports). The user would then be able to cycle between these 3 tabs.

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com