Date Parameter Help needed from Universe

[satinsilhouette]

HI, I have several derived tables in a universe that all use a begin and end date.

But that is the only similarity.

Right now, these derived tables come up into Crystal reports as separate subreports.

I need for the users to have only one begin date and one end date to show up for a parameter for them to answer. BUT I need all the subreports to use it, or share the same begin date and end date.

How can I best accomplish this?

I tried using sysdate to be the driver parameter and making the subreport (derived tables date) to equal that, but it doesn't seem to work.

Thanks for any help!


Thanks so much!
satinsilhouette

 

[hilfy]

Create the start date and end date parameters in the main report. For each of your subreports, change the links to include the start date and end data params from the main report. Then, in the subreport, edit the selection criteria so that instead of "is equal to" the filter is for "greater than or equal to" the start date and "less than or equal to" the end date.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.