tarz87 Posted April 22, 2020 Share Posted April 22, 2020 I have a subreport that receives two parameters and therefore generates as many reports as there are combinations of parameters, I have to put a row counter in the sub report but this must not reset every report generated by the sub report but must continue the numbering.Do you have any ideas?Can someone help me?PleaseThanks a lot to everyone Link to comment Share on other sites More sharing options...
paul.taylor Posted April 22, 2020 Share Posted April 22, 2020 Are the two parameters for the subreport coming from columns in your sql from the parent report? Also what datasource are you using? I ask because depending on your SQL flavor, you could probably get add a running total calculation to the parent report's SQL using SUM OVER for each row of data in the a parent report (each subreport). Then pass the running total value to the subreport as an additional parameter and add it to the record count in the subreport. Link to comment Share on other sites More sharing options...
tarz87 Posted April 22, 2020 Author Share Posted April 22, 2020 Yes, the two parameters come from the query of the main reportI am using Oracle as a data sourceUnfortunately, I can't use a SUM OVER because the two queries soon differ.I need the count to not reset when the multiple subreports is generated in the Detail Band of the main report Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now