passing date parameter

[back2tek]

Hi All,
CR 9..
Main report has prompt parameter field (start_date) type date.
Need to pass prompt value from main to subreport. The subreport has Database field (logindate) type datetime.
I create a formula in the subreport as follows:
@date
cdate(logindate)

I based the link between the subreport and main report on ?start_date and @date...

The report is running for long time, I had to abort it.
Am I missing something?



Appreciate your help..

Steve

 

[synapsevampire]

It may not be passing the paramter to the SQL.

Try creating a formula in the main report of:

datetime(year({?startdate}),month({?startdate}),day({?startdate}),0,0,0)

And link this formula to the subreport. Note that you can go into the subreports Report->Selection Fromulas Record and edit this.

The key is to check the Database->Show SQL Query in the subreport to make sure that the value is being passed in the SQL generated.

If you have other filters in the subreport record selection, they may not be getting passed and cause all or part of the other filters not to pass.

I have a somewhat dated FAQ on this here:

faq767-3825

But the key is to make sure that it's passing the criteria.

-k