5 prompts for dates

[wilekoyote76]

I am trying to create a report in CR11 that will pull data from the db based on 5 weeks worth of data. The user would be prompted when running the report for each date and it would calculate the next 7 days worth of data from within the database. These dates necessarily do not have to be "in order" but could vary over any range. However, they would also have to be sorted.

How in the heck do I do this (I'm somewhat of a newbie)? I've searched a ton of forums and even tried just creating the parameters, but it doesn't allow me to create a date parameter without putting in values to choose from (static). If I choose dynamic, it doesn't allow me to enter dates either. I have looked for putting in custom text but cannot find this even. Suggestions to give me some guidance? Is this going to be harder to do than just keeping the dbase report that was created in Goldmine? I'm trying to upgrade all goldmine reports to crystal reports.

 

[lbass]

Yes, you can create a date parameter without entering dates to choose from--in fact, this would be the most frequent date parameter set up. After choosing date as the datatype, just make sure that "allow custom values" is set to true. Once you have the five parameters, you would just set up a record selection formula like this (report->selection formula->record):

(
(
{table.date} in {?date1} to {?date1}+6
) or
(
{table.date} in {?date2} to {?date2}+6
) or
(
{table.date} in {?date3} to {?date3}+6
) or
(
{table.date} in {?date4} to {?date4}+6
) or
(
{table.date} in {?date5} to {?date5}+6
)
)

-LB