Passing Date Parameters to Subreports

[kskid]

I create several summary subreports from a single table. While they are different type of summaries, they all share the same date range.

I created the date parameter in the main report but when I tried to link it to the subreport, there is nothing in the subreport to make that link. I even tried to create date parameters in the subreport hoping to make the link there but nothing doing.

What am I missing or overlooking?

WichitaKid

 

[synapsevampire]

You will need a date field in the subreport, check the fields exposed in there.

Right click the report and select change subreport links.

Select the main report date parameter (make sure it's of type date!) from the available fields on the left, then in the select data in subreport based on list you will see any date fields in the subreport.

Hope this resolves for you.

-k

 

[kskid]

It's there but still nothing

I am getting the report fields which are summary counts but in the database field section all I am getting is the table name.

Report fields:

groupname


Database Fields:
----tablename----

 

[kskid]

Found it. Did not have the date on the main report.

However, I am only picking up the detail records that match the end date of my date range parameter from the main report

WichitaKid

 

[synapsevampire]

It sounds like you selected the date field of the main report to link to, rather than the date parameter from the main report. The reason I think so is that when the main report completes, you're on the last date.

Check the record selection formulas in the main and the sub by selecting Report->Edit Selection Formula->Record

-k

 

[kskid]

The record selection looked ok.

I can link the date from the main report to the subreport but whenever I try to link the subreport with the date parameter, I am restricted to the report area only and cannot access to the subreport table.

I tried using a global variable but apparently it is restricted to the main report and not available use at the subreport level.

WichitaKid