cancel
Showing results for 
Search instead for 
Did you mean: 

How to increase the width of the Crystal Report

Former Member
0 Kudos

Hello All

How to increase the width of the Crystal report template in the CR designer in .NET 2005 editor ?

I need to design a report which has to accomodate more number of columns.So achieve that i need to redesign the report having more width.

CrystalReports version 10.2.3600.0

Thanks in advance

Srivatsa

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI Srivatsa,

You can make a wider report by creating virtual pages. Virtual pages are the extra pages to the right of the main page that get created to accommodate cross-tabs that are wider than a single page. By inserting a cross-tab in a report then suppressing it, you can create a report that is multiple pages wide.

Insert and Suppress a Cross-Tab

-


1. On the 'Insert' menu, click 'Cross-Tab'.

2. In the Cross-Tab Expert, click any field and move it into the 'Columns' box, and click any field and move it into the 'Summarized Fields' box. Do not move any fields into the 'Rows' box.

3. Click the 'Customize Style' tab and select the following check boxes:

" Suppress Empty Rows

" Suppress Empty Columns

" Suppress Row Grand Totals

" Suppress Column Grand Totals

4. Click the 'OK' button and then insert the cross-tab into the Report Header section.

5. On the 'Report' menu, click 'Format Sections'. Click 'Report Header' and select the 'Underlay Following Sections' check box.

When you run the report you will not see the cross-tab, but you will be able to scroll to the right and see multiple virtual pages.

====================

NOTES:

" As there are no rows to the Cross-Tab, it does not carry on to Page 2 and the virtual pages do not appear past the first page.

" To increase or decrease the number of virtual pages do one of the following:

- Limit the number of records for the field in the 'Column' box of the 'Cross-Tab Expert' using the 'Select Expert'.

- Change the width of the 'Column' field in the Cross-Tab by moving the edges of the field.

====================

How to Insert Fields on Virtual Pages

-


You cannot drag-and-drop a field onto a virtual page, you can only do so on the main page. To get a field to appear on a virtual page:

1. Insert the field on the main page.

2. Click the 'Preview' tab.

3. Drag the right edge of the field to the right, onto the virtual page.

4. Drag the left edge of the field to the right, onto the virtual page.

Hope this helps!!

Regards,

Shweta

0 Kudos

Hi Srivatsa,

Or even easier is simply change the printer page orientation to landscape. If you need it even bigger install a printer that can handle large paper sizes. Plotters can get up to 42 inches or more.

Cross tabs can be limiting depending on what you want to do but they can also be of great use if it fits your model.

Thank you

Don

Former Member
0 Kudos

Hi,

i am using Crystal report Server XI, i tried to increase the width of crystal reportviewer using follwing code

rcDoc.ReportDocument.PrintOptions.PaperSize = CrystalDecisions.ReportAppServer.ReportDefModel.CrPaperSizeEnum.crPaperSizePaper

rcDoc.ReportDocument.PrintOptions.PaperOrientation = CrystalDecisions.ReportAppServer.ReportDefModel.CrPaperOrientationEnum.crPaperOrientationLandscape;

but not working. I have 12 columns names in page header, 10 are displayed inside the section and 2 resides out of the section region.

How to resolve

Padmanaban V

Answers (0)