Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

subreport link problem with date range

Status
Not open for further replies.

s1ty1

Technical User
Jul 1, 2010
3
US
hi i created main report with date range parameters (start date and end date). when am trying to lnk with sub report , sub report showing me all values instead of date range selected. in the link i can see only start date parameter to link subreport..
pls guide me.
 
Do you have a date parameter in the subreport and linked the date range parameter in the main report to the date range parameter in the subreport?
 
If you are using both a start and end date parameter, they should not be set up to allow range values. If the end date parameter is missing in edit->subreport links, add it in. Then check the record selection formula in the subreport to make sure it reads correctly:

{table.date} >= {?pm-?Start} and
{table.date} <= {?pm-?End}

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top