Date Range Selection to Subreport

[ricolame]

Hi folks,

Another head-swelling problem for me.

I have a parameter {?Period} that returns the no of months i should look back to trace records

i have written successfully a formula minDate

minimum(PastXMonths({?Period}))

where it will return the minimum date i should start searching


Now, how should I use this min date to my subreports so that my individual subreports will trace back records from current to this mindate ?

What I have done so far yet unsuccessful :
1. I have create a field link to my subreport for minDate and clicked 'selecting data in subreport using this field'

2. When into select expert for the subreport and convert
{CUSTOMER_ORDER.ORDER_DATE}= {?Pm-@minDate}

to

{CUSTOMER_ORDER.ORDER_DATE}>= {?Pm-@minDate}

for one of my subreport. Likewise for other with purchase order

It returns empty subreports now

Initially i used a ?Date range parameter which i created and linked it to the subreports, and it works fine


Anything that I have seriously overlooked? I'm going bonkers. Thanks a million!

 

[ricolame]

Btw i'm on Crystal 10

 

[ricolame]

hi guys,

i've solved this problem. What i've done are all correct in fact just that some foolish mistake on my part =S

with regards,