Is it Possible to have more than one group break horizontally

[Classick]

That is to say

have a group line up like this

Group Break 1 Group Break 2 Group Break 3
+--------------+ +--------------+ +--------------+
|....................| |....................| |....................|
|....................| |....................| |....................|
|....................| |....................| |....................|
|....................| |....................| |....................|
|....................| |....................| |....................|
|....................| |....................| |....................|
+--------------+ +--------------+ +--------------+

Insstead of

Group Break 1
+--------------+
|....................|
|....................|
|....................|
|....................|
|....................|
+--------------+

Group Break 2
+--------------+
|....................|
|....................|
|....................|
|....................|
|....................|
+--------------+

Group Break 3
+--------------+
|....................|
|....................|
|....................|
|....................|
|....................|
+--------------+

[Stan Mathews]

columns

You can have multiple columns. It would probably take some tinkering to get the alignment right.

That is to say

have a group line up like this

Group Break 1 Group Break 2 Group Break 3
+--------------+ +--------------+ +--------------+
|....................| |....................| |....................|
|....................| |....................| |....................|
|....................| |....................| |....................|
|....................| |....................| |....................|
|....................| |....................| |....................|
|....................| |....................| |....................|
+--------------+ +--------------+ +--------------+

Insstead of

Group Break 1
+--------------+
|....................|
|....................|
|....................|
|....................|
|....................|
+--------------+

Group Break 2
+--------------+
|....................|
|....................|
|....................|
|....................|
|....................|
+--------------+

Group Break 3
+--------------+
|....................|
|....................|
|....................|
|....................|
|....................|
+--------------+

[Classick]

but can you have a break per column?

[Classick]

I think basically i want to display 3 different reports on one sheet... is this tryp of formatting possible?

[Stan Mathews]

Not directly.

I think basically i want to display 3 different reports on one sheet... is this tryp of formatting possible?

No. You have to do whatever manipulation you want to a table and print a report based on the table.

IOW you could pre-process the data you want to present and write it (xbasic) to a temporary table, lining up the values as you see fit. Your report could then process the temporary table data in record number order .....

[Bill Parker]

If you are implying the group breaks would only create columns then you should investigate subreports. Subreports are complete reports within a report and provide incredible flexibility.

For me, group breaks generally repeat several times - generating more than 3 columns?

I don't know if subreports will be your answer, but you should definately try them.

Bill.

[Classick]

If you are implying the group breaks would only create columns then you should investigate subreports. Subreports are complete reports within a report and provide incredible flexibility.

For me, group breaks generally repeat several times - generating more than 3 columns?

I don't know if subreports will be your answer, but you should definately try them.

Bill.

yes i am just playing around with them now.. i think that is exactly what i need.. thanks

[Classick]

Just Wanted to post an update... did EXACTLY what i wanted to do... man alpha is cool!

[csda1]

Just a warning when using sub-reports.

It is relatively inefficient, causing at least 1 and normally 2 passes through the data per sub-report. Depending upon grouping, ordering and other criteria, each group can cause additional passes through the data as well.

This can slow shared table operations down a lot depending upon the size of the report, how many records are accessed, and if you used LQO in the query filters for the report. If you find this happens, the best solution is to copy appropriate records to local drive and run the report from there, which has 0 impact on the shared tables

[Classick]

Just a warning when using sub-reports.

It is relatively inefficient, causing at least 1 and normally 2 passes through the data per sub-report. Depending upon grouping, ordering and other criteria, each group can cause additional passes through the data as well.

This can slow shared table operations down a lot depending upon the size of the report, how many records are accessed, and if you used LQO in the query filters for the report. If you find this happens, the best solution is to copy appropriate records to local drive and run the report from there, which has 0 impact on the shared tables

Thanks for the heads up..

In this instance, all of the sub reports are filterd on the same expression, and for the time being... there will only be 50 or so records for each group... so i think it will be ok... but it is good to know about runtime efficiencies.

Oh, and since you're watching this thread, i might as well introduce myself.. I am Ray Difazio's cousin :)

nice to finally "meet" you.

[George Corder]

I have the same delima in that I am trying to build a report to show product sales totals by State. Should I try and do this in columns or subreporting?

Image of what I am trying to achieve.

[Stan Mathews]

at first glance

Your situation appears to be more suitable to building a crosstab opertation to create a temporary table (group rows by product, columns by state, total the sales) and then build the report based on the resulting table.

I have the same delima in that I am trying to build a report to show product sales totals by State. Should I try and do this in columns or subreporting?

Image of what I am trying to achieve.

[George Corder]

Thanks Stan, I have never dealt with the crosstab but will try it.

[Stan Mathews]

fairly straightfroward

Thanks Stan, I have never dealt with the crosstab but will try it.

But make sure you uncheck the

The dictionary file contains, among other things, the forms used to display the crosstab data. Clear Delete pre-existing dictionary file if you wish keep any pre-existing forms.

so that the report(s) you create remain when you re-run the crosstab.