How to programmatically select report GROUPING on NEW LINE or NEW PAGE

[pjohnston440]

Hi all,

I'm using VFP9 and trying to change the report grouping to break on either a NEW LINE or a NEW PAGE depending on a form property.

Manually I can change this under "Report Properties", "Data Grouping" tab, "Group starts on". I would like to know if this can be changed programmatically.

Thanks much,
Pete

 

[JRB-Bldr]

Assuming that you 'feed' your Report Forms with the results from a SQL Query, you can always add a new field (maybe something like GroupCtrl) to the query results which can then be used as desired within the Report Form to control the Group.

All that would need to be done would be to programmatically populate that field as desired before sending the data to your report.

Good Luck,
JRB-Bldr

 

[pjohnston440]

JRB-Bldr,

Thanks, that's a good idea. Currently I have a second report with the grouping break on NEW LINE but your suggestion is a better solution. I'll give it a try.

Thanks again,
--Pete