Topic: 2nd Sub Report Based On Parameter From 1st Sub Rep Posted: 24 Oct 2016 at 11:30pm
Hi CR Experts
I have a sub report which is based on a parameter from another sub report.
I cannot select the sub report1 fields to link to subreport 2 in the change sub report links option.
Therefore I have attempted to share the fields which will be the parameter for sub report 2 from sub report 1 to the main report.
I have used the below formula to share
Subreport 1
Whileprintingrecords;
Shared stringvar substring;
Substring:= {Command.2 Sub Assembly Code}
Main Report
whileprintingrecords;
Shared StringVar substring;
substring
The correct field which I need as parameter for sub report 2 appears when a add the filed to the footer of the main report. I have then linked the filed to sub report2 using the change links sub report option.
However the sub report is still not filter by the parameter. Please advise?
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 25 Oct 2016 at 5:34am
I have not tried this, but in the selection formula for the second sub-report, can you put the shared variable in there and use as a filter (by passing setting up a parameter)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum