Display subreports dynamically in different order

  • Thread starter Thread starter Fons Ponsioen
  • Start date Start date
F

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
 
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
 
Back
Top