Use subreport multiple times in same report

[white_falcon02]

Hi all,

 

I want to create a subreport studio that uses the same saved subreport multiple times but have one variable change. The query in the subreport is 

SELECT DISTINCT DATEADD(MONTH, -13, GETDATE()) AS monthYearFROM "mytable"[/code]

For the first column, I want to display the month and year from 13 months ago. The next time, I want to display the month year from 12 months ago, and so on. Is there a way to do this?

[reportdev]

Create a Main Dataset based on a Levels (if you are using Oracle Levels create an ascending or descending order of numbers/dates)

Create a Subreport./table with Sub Dataset which will accept this Level number/date from Main Datset and iterate through the Main dataset.