too many fields to fit onto one page

[pikco]

I have a report on crystal reports, that requires many columns, as there are many fields to display.

How do I do something like the following -

Say I have columns A-K on the first page
and then columns L-Z on the next page.

As in, there are too many to fit one one page, so the columns overflow onto subsequent pages

Any help is very much appreciated.

 

[JasGrand]

First of all, is your page in portrait or landscape view?

 

[Ngolem]

The size of the page really depends on the printer you are using.

For example: if you used a plotter for printing your report you could have a huge page width and not be limited to legal size paper in landscape mode (14&quot.

Now you say "but I don't have a plotter available to me."

That really isn't a problem if you do not actually print the report through Crystal. Just install the Plotter driver(HP plotters work well I am told) on your system as a printer option. Then base your report on the plotter you have chosen....Crystal then bases its displayed output as WYSWYG as it can on your monitor.

Then export the report to EXCEL. Once in Excel you can print sections of the report on an ordeinary printer.

Jim Broadbent

 

[JasGrand]

much better answer then what i gave... but he never even answered me back.

Jason

 

[synapsevampire]

I think that the simplest solution is to right click the details and select insert section below.

Now place fields A-K into details section A, right click the section, and select new page after.

Place fields L-Z in the Details B section.

Now you have the first fields on page 1, the second on page 2.

This assumes that a single record cover a full page.

An alternative is to create 2 sections, and in the details B section, create seperate Titles next to the fields and not use a new page after, rather let Crystal decide when to create new pages.

-k

 

[Ngolem]

thanks for the comment....we shall see what he says

Jim Broadbent

 

[Ngolem]

SV- I don't see your solution working. You could have hundreds of new pages with one record/2 pages doing it that way.

Jim Broadbent

 

[synapsevampire]

Jim: I based it on their statement:

"As in, there are too many to fit one one page", which I took to mean that each record has too much data for one page.

Note my comment: This assumes that a single record cover a full page.

Which probably isn't be the case, hence the alternative of a seperate section with the fields uniquely identied within.

Difficult to gleen what they have and what they were after without example data and expected output.

-k

 

[Ngolem]

I assume that they have too many columns to fit on a page width...in that case I believe mine is the only effective solution.

It would be nice if the problem was better defined by an example

Jim Broadbent

 

[pikco]

Wow.

Thank you everyone for your replies!


The program gets information from a database, regarding different properties of steel.

Each type of steel has many many different properties eg. manufacturer, kg/m, moments of inertia, etc... about 50 or 60 of them (i know, that's a lot).

The client wants to be able to put out to pdf a number of steel sections, and its properties, as in

Steel section 1

manufacturer - country - kg/m - etc....are the fields

then comes all its data....


These won't fit on one page, but will fit on several, if it can be done, even on landscape view.


Then after those are outputted, I have the next steel section.

Any ideas?