Hello I have a main report and subreport and wish to pass data from the main report to subreport but it is not working.
Subreport Formula:
whileprintingrecords;
shared numbervar stnnav:= Sum ({@Portfolio Base}, {STN_MASTER.PORTFOLIO})/{PF_FEES.TOTAL_NAV}*100
Main Report Formula:
whileprintingrecords;
shared stringvar issport;
shared numbervar stnnav;
if ({SECURITIES.ISSUER}+{SSL.PORTFOLIO})=issport then stnnav
Are my forumlas incorrect. For so reason though, if the subreport returns 3 values or more then 1 value ie 1, 2, 3 the main report will bring back one of those values however, I never know which one it will return. Just wondering what I am missing. The subreport seems to work perfectly fine and the main report seems to work perfectly fine. Your help is appreciated. Thanks everyone.
Subreport Formula:
whileprintingrecords;
shared numbervar stnnav:= Sum ({@Portfolio Base}, {STN_MASTER.PORTFOLIO})/{PF_FEES.TOTAL_NAV}*100
Main Report Formula:
whileprintingrecords;
shared stringvar issport;
shared numbervar stnnav;
if ({SECURITIES.ISSUER}+{SSL.PORTFOLIO})=issport then stnnav
Are my forumlas incorrect. For so reason though, if the subreport returns 3 values or more then 1 value ie 1, 2, 3 the main report will bring back one of those values however, I never know which one it will return. Just wondering what I am missing. The subreport seems to work perfectly fine and the main report seems to work perfectly fine. Your help is appreciated. Thanks everyone.