Raport on two pages

[Asia001]

Hi,
I have problem. I have very wide report, so I can place it on two pages or divide during printing (how Exel).
1)
report wide: one page two page
Smith 12000 12 4 555 etc. -> Smith 12000 12 4 555 etc.
.
.

2)
report wide:
Smith 12000 12 4 555 etc. -> during printing divide how Exel
Smith 12000 | 12 4 555 etc.

I don't know how do it? So if You know how do it please write to me.
Asia

 

[lbass]

What version of CR are you using?

-LB

 

[Asia001]

I have CrystalRepots in Visual Studio .NET 2003

 

[Madawc]

Are you wanting to print it from Crystal, or format it in Crystal so that it will print well in Excel?

If you want to print from Excel, then have a single column in Crystal with the correct field. This will export OK but will then need to be adjusted for Excel use. I've done similar things, though my problem was how to stop Excel printing one row in two pages.

Crystal, unlike Excel, assumes that rows fit on a single page. You can make it a wide page, by setting [Landscape] in Printer Selection and maybe also by selecting the right paper and/or printer. But all of this will be on the assumption that there is just one page per detail line.

Madawc Williams (East Anglia, UK)

 

[Asia001]

I want to printing in Crystal.
So are You tell me that I can't print one line my raport on two page? I can't print landscape, becouse it is for small to me. What can I do else? Maybe someone create formula which do it.

 

[Madawc]

Crystal is a report-writer, not a full programming language. And Excel is unusual in that it does allow such things.

Madawc Williams (East Anglia, UK)

 

[lbass]

Asia001,

One approach is to try to group your rows into a certain number of records. If you have some sequential field, you could group your records into groups containing the number of records you want per page by using a formula like:

if {table.ID} in 1 to 45 then 1 else
if {table.ID} in 46 to 90 then 2 else
if {table.ID} in 91 to 135 then 3 else//etc.

Then you would place the first half of your columns in the main report. Then insert a subreport that contains the remaining columns and that uses the same grouping and link it to the main report on the grouping formula. Then place the subreport in the group footer, with the group footer formatted for new page before and new page after (with "not onlastrecord" added into the conditional formula area).

If you don't have a sequential field, you can use a group formula that counts rows and then groups by the count, which I could provide for you. The problem is that if you have the equivalent of CR 8.0 or 8.5, you will run into a 254-character error message and you cannot use this approach.

-LB