Passing date over parameters

63 Views

Dear all,

I have created a report which consists of 3 sub reports. All three sub reports uses different date fields from different tables (though the database is the same). The main report uses its own date field which is from another table.

So, there are 4 reports in all

Main Report takes date field from table A

Sub Report 1 takes date field from table B

Sub Report 2 takes date field from table C

Sub Report 3 takes date field from table D

Now when I run the main report, it asks me to input dates 4 places (total of 8 places where I have to replicate same date each time I run the report.

Now to over come this I linked the Date parameters of the main report with the date fields of the sub reports.The problem occurs when the results are shown.

All of the results are incorrect except the main report results.

I am wondering how can I pass dates which I have entered into the main report parameter field to all sub report fields so that I don't have to enter dates 8 times each time I open a report.

Here is the record selection formula for main report date field

({foccredsum.date_created} in {?Start Date} to {?End Date})

Now for the sub reports the date fields are different.

How can I integrate the date parameters?

Regards

Jehanzeb