Monthly Data Page Change

[Richard G]

I have a set of data with daily values for the month of July, as we are now into August please could someone advise me how to make the first data reading for 01 August start at the top of a new page, at present its at the bottom of page 1 of my report with the July data.

Many Thanks

Richard

 

[macca the hacke]

Why don't you create an additional field within the query that the report runs from. This field should be set to format([fieldname],"mmm"), where [fieldname] is the name of the field you have which has date in. You can then add this field to your report and group by it, and set up group header. You can put a text box in this header which contains the new field created above. Turn the visible condition to false for the text box so that it doesn't show on the report. You can then force a new page before/after this section.