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!

Retriving sub report Parameter values into main report

Status
Not open for further replies.

sikkilamkiran

Programmer
Aug 9, 2005
21
IN
hi,
Im having a problem in retriving the sub report parameter values into main report.im using the following code.

in the sub report im having a parameter called dimension.
im capturing the values of the dimension using a formula

DimensionValue:
whileprintingrecords;
shared stringvar x;
x:=join({?Dimension Name},',');
x

in the main report im capturing the sub report parameter values using a fomula

GetDimVal:
whileprintingrecords;
shared stringvar x;
x

now if i use the GetDimVal formula after the subreport section im able to see the values , nut if i use this variable before sub report section. it doesnt show me any value.
I have tried to use EvaluateAfter() function but couldnt find how to use it exaclty.

can any one please suggest a solution. i would be really thankfull to them..

waiting for answers....

regards
kiran
 
Why not create the same parameter in the main report and then link the subreport to the main report on the parameters? Then you can use the main report parameter anywhere in the report.

In the edit subreport links box, you would move the parameter from the main report to the right, and then in the bottom left corner, use the dropdown to choose {?Dimension Name}, NOT the default {?pm-?Dimension Name}.

-LB
 
hi lbass,
thanks for the instant reply,
i have created the parameter in the main report rather than sub report and when im going to links tab there is no
{?Dimension} parameter on the left side instead of
?pm-?Dimesion.
please reply
 
This assumes that you have created a parameter {?Dimenion} in both the main report and the subreport. If you go to edit->subreport links->you can move {?Dimension} from the upper left field list to the upper right box. In the lower left, use the dropdown list to select {?Dimension} for the subreport parameter.

-LB
 
Thanks You very much LBass..
I got the parameters and i mapped it.
its really gr8 to have a solution so soon
Thank you lbass once again.
-Kiran
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top