Display subreports dynamically in different order

[Fons Ponsioen]

Ketaki, I have never done this but I think this suggestion
will work.

Rather than moving them around, Base each report month(date
()).
By setting the query for the first report equal to Month
(date()) and the next to month(date())+1 etc you should be
able to accomplish what you expressed.

Hope this helps.

Fons

 

[Ketaki]

Hi Fons,

I'm sorry but I couldnt understand the solution that you
have mentioned, could you please elaborate it a little
more for me?
the recordsource for each subreport is already a query for
me. how can i associate the month function with the
queries?

Thanks,
Ketaki