>Hi All.
>
>I am printing a 2 column report that has 3 data groups.
>
>What I would like to do is to force the report to start printing in column 2 when it sees a particular data group.
>
>Anyone know of a slick trick to accomplish this?
What do you mean by 2 columns ? Is it just two columns of data that you are showing in a solid (single column) page or it is actual two column page layout
(physical page space is divided in two columns) ?
If former, then this should not be all that difficult to implement by having maybe two sets of textboxes which you 'fire' interchangeably by printwhen clause.
If later then things are more complicated. Conventional trickery could involve perhaps inserting number of dummy records inside report cursor to force report to advance to next column (while keeping track of how many rows are printed and how many are remaining before jumping to the next column or page). Maybe doable but minefield. With 3 levels of grouping (headers/footers ?) God help you.
If this is very very firm requirement, then you might wanna take look at
www.report-sculptor.com With RS you can take matters totally in your own hands and drive report from inside your own code. Current page positioning is available to you via engine properties so you can implement various scenarios of keeping content together, changing control positioning on the fly etc.
See sample provided in RS demo project for more ideas.
HTH
Sergio