Formula Question on Dates/Week 1

[Myla944]

Crystal Verion 9.0 - SQL Server 2000

Good Morning,

I am working on a report that I need to show product sold for each week (Saturday to Sunday). I am alittle confused on how to use date formula's.

I am working with {tblinvoicedate.Invoice}, {totalQty.Invoice}.

I have grouped the bakeries, grouped the owners and want to run the dates across (manual cross-tab fashion). I have created a ranged parameter using the Saturday to Sunday dates and it does not work. Do I need to create a selection formula or a regular formula to aquire the dates I need? I have the dates, product description and quanty in the detail section for now has I am not sure how to proceed.

Thank you,

Myla

 

[paulmarr]

Hi Myla,

You had the right idea - you create a date range parameter (making sure it is the same data type as the database field you are going to record select on).

Then in the record selection - base it on the database field containing the date - choose "is equal to" from the first dropdown box - and then drop down the second box and your parameter should be the first selection on the list.

If it is not there than you have the data type setting wrong on the parameter.

Hope this helps!

paulmarr