I would like to have a parameter in my main report where the user can specify the sort order for a subreport, for example, "category" or "startdate".
I've made a formula to create a shared variable from this main report parameter:
Shared StringVar subReportOrder;
subReportOrder := {?History Order}
I've also made a formula in my subreport:
Shared StringVar subReportOrder;
if subReportOrder = 'Category' then
"HISTORY.CATEGORY"
else
"HISTORY.STARTDATE"
Finally, I clicked the sub report Sort Order icon and tried to select my subreport formula. However, it doesn't appear in the list.
Suggestions?
I've made a formula to create a shared variable from this main report parameter:
Shared StringVar subReportOrder;
subReportOrder := {?History Order}
I've also made a formula in my subreport:
Shared StringVar subReportOrder;
if subReportOrder = 'Category' then
"HISTORY.CATEGORY"
else
"HISTORY.STARTDATE"
Finally, I clicked the sub report Sort Order icon and tried to select my subreport formula. However, it doesn't appear in the list.
Suggestions?