Date Range 1

[dembyg]

Hello all, I need someones assistance with a report ive created. I created a form which allows users to select a from and to date. I would like the next form which has an embedded crosstab report to display data within the date range selected. Ive add to my report a parameter field for a date range however i need help with getting the selected from and to date over to my embedded crosstab..

 

[Madawc]

If you've one of the more recent versions of Crystal, you should be able to create a formula field that holds the value only if the date range applies, e.g.

if {your.date} in [@startdate to @enddate]
then {Your.value}
else 0

Create a crosstab to show the formula field value, rather than the orignal data value.

I am assuming you have some good reason for not putting the date range in the record selection, maybe records outside the range are needed for something else.

It always helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[dembyg]

Thanks for you help... however i guess my question is how do i get the report to load with the selected start and end dates.

 

[dembyg]

how do you load a report with parameters selected on a previous aspx page

 

[Madawc]

If you have access to the parameters, put {your.date} in [@startdate to @enddate] in Report > Selection Formulas > Record.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10