Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Passing Selection Results to Subreports


I'm sure that this is a stupid question But If I have carried out a selection query in my main report which returns say 1000 postcodes how can I pass these to t a subreport to select the same 1000 postcodes? By linking the fields that contains the postcodes the parameter created only contains the first postcode.


Former Member

Hi James,

Try creating a formula like


stringVar str:="0";

Place this formula in report header

Now create another formula like


stringVar str;

Now create a command in the subreport like

select * from table where postcode in ({?StringParameter})

Now place the subreport in report footer and link the command level parameter from subreport ({?StringParameter}) with formula @Evaluate

Now the subreport results uses all the passcodes from main report.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question