Hi,
I have a main report that receives from an application
a selection formula based on criteria chosen by end user.
I have added a sub-report in the footer section for summarize some items.
This sub-report should running on the same range of records of the main report, but this don't happen, it summarize items that are not in the main report.
Unfortunately I cannot modify the application.
Is there a way to pass the actual selection formula or the entire sql statements from main report to sub-report.
I have tested the special field "Record selection formula" in the main report at runtime but it seems
to have only the static formula inserted at design time.

Thanks in advanced.
Best regards

You need to pass the selection criteria down to the subreport (ie @IDNumber) using the 'Change Subreport Links' when you right click on the report.

In the subreport you would feed the link into the record selection criteria and this should bring back the desired results.

Hope this helps.