Help with Cascading Parameters

[Ofina]

I have an invoice report that has as parameters Starting Date, Ending Date, and Customer.

I know how to do cascading parameters where they are all dynamic. But, this one has me stumped.

I would like the user to select a starting date (static), an ending date (static) and then have the list of available customers to choose from be only those with invoices within those dates.

Can I do this?

 

[LaurieHamlin]

Maybe I'm missing something? If I understand you, do this.
In the Select Expert use invoice date > {?state date} and invoice date < {?end date}.
You create the parameters the same way as you always have.

 

[Ofina]

I have start date and end date in the select expert already and customer too.
But, my drop down for customers in the parameter window includes all customers ever invoiced, and I want it to only show me those customers who have been invoiced within the dates entered into the parameter window right above.

 

[LaurieHamlin]

Where does the data live?

 

[Ofina]

I admit to not only not understanding why it matters, or even what answer you are looking for. SQL? Is that what you mean?

 

[LaurieHamlin]

You mean SQL Server? If it lived in Access I could tell you how to group on dates.
I believe you're looking for the customers whose invoices are between the dates?
How is the customer data and invoice data set up (what tables are they in)?

 

[Ofina]

Forgive me, but can you explain why it is relevant what the table name is?
The data is in SQL server, but obviously I'm doing this in Crystal.

I know how to set up cascading parameters in Crystal if each one is dynamic, but the two date parameters are static.

 

[LaurieHamlin]

I didn't ask for the table name, I asked if the data is in the same table or multiple tables.
It seems to me, if you're entering dates and getting data from outside the date range, that the problem is in the way the tables are linked. Assuming the data is in multiple tables.
If by static you mean always the same, hard code those dates into the Select Expert, you don't need parameters.