multi column report question

Has anyone figured out a way to do a true page break in a multi-column
report. If a group ends somewhere in the first column what I would like to do
is start the next group on the next page not at the top of the next column.
If this is possible, I'd sure like to know how.
ThanksOn Jun 18, 5:55 pm, B. Mark McKinney <b...@.newsproups.nospam> wrote:
> Has anyone figured out a way to do a true page break in a multi-column
> report. If a group ends somewhere in the first column what I would like to do
> is start the next group on the next page not at the top of the next column.
> If this is possible, I'd sure like to know how.
> Thanks
These steps should give you your desired outcome.
1. In the 'Layout' view of BIDS, select the table/matrix control
(where applicable).
2. Right click the table/matrix and select 'Properties.'
3. On the 'Groups' tab, select the 'Add...' button.
4. Below 'Group on:' and 'Expression' enter the following:
'=Ceiling(RowNumber(Nothing)/18)'
5. Select 'Page break at end'
5. Select 'OK' and 'OK' again.
[NOTE: The format in step 4 is: =Ceiling(RowNumber(Nothing)/
NumberOfRowsPerPage) ]
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thank you for the response. Unfortunately that did not solve my problem with
multi-column reports. I have two tables inside of a list and the list
controls the grouping. It correctly breaks at the end of each group but if
the group ends in the first column it starts the next group at the top of
column two instead of the next page. Adding a second list and grouping using
your method inserts more page breaks but does not give you the control that
you need. Infact in some instances you end up stopping one group in the
second column of one page and start the next group at the top of column two
on the next page.
I don't think that there is a solution to this problem currently. Hopefully
there will be one in the future as I have many reports that could benefit
from the multi column layout but the way it is now the output would be
unusable.
That and not being able to deal with large reports are my two biggest beefs.
Yes you can break them up into smaller pieces and you can use pdf print
drivers etc etc but that is a really sloppy and inefficient way to handle
what should be a very basic function. Actually my two beefs are somewhat
related in that if mult- column reports worked I could probably shrink some
of my mid sized reports down to manageable sizes like 200 - 800 pages.
Glitz is great but when the basics don't work the end product looks real
cheezy when customers use it.
Anyway, back to the problem at hand, the way I look at it there is a huge
difference between a column break and a page break.