Tallnfluffy
Technical User
I need to know if it is possible to pass a variable from one report to another without entering a static entry using the promptex command.
The reason I require this is because I need to link multiple reports together. The ideal solution would be to use nested on-demand sub-reports but, as I've recently found out, a sub-report cannot contain another subreport.
What I want to do is something like this:
Report A
Name, Administrator, Category, Count
Report B (Linked to report A by name)
Category1, Category2, Unique_ID
Report C (linked to report B by Unique_ID)
Text1, Text2, AmountSpent
The above is a very simple example which, at first glance, would point to the use of drill downs, but unfortunately the actual report specifications are far more complex and drill downs simply will not do.
The only solution would be the use of hyperlinks but having checked out the syntax for promptex there appears no way I can pass a dynamic variable to another report eg. the name field for a particular record.
I can't believe Crystal 9.0 does not have the facility to cascade reports using dynamic variables and I am desperately hoping I've missed something obvious. Can anyone help?
![[sadeyes]](/data/assets/smilies/sadeyes.gif "[sadeyes] [sadeyes]")
The reason I require this is because I need to link multiple reports together. The ideal solution would be to use nested on-demand sub-reports but, as I've recently found out, a sub-report cannot contain another subreport.
What I want to do is something like this:
Report A
Name, Administrator, Category, Count
Report B (Linked to report A by name)
Category1, Category2, Unique_ID
Report C (linked to report B by Unique_ID)
Text1, Text2, AmountSpent
The above is a very simple example which, at first glance, would point to the use of drill downs, but unfortunately the actual report specifications are far more complex and drill downs simply will not do.
The only solution would be the use of hyperlinks but having checked out the syntax for promptex there appears no way I can pass a dynamic variable to another report eg. the name field for a particular record.
I can't believe Crystal 9.0 does not have the facility to cascade reports using dynamic variables and I am desperately hoping I've missed something obvious. Can anyone help?