Print Page | Close Window

How to increase the width of the Report

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=754
Printed Date: 29 Apr 2024 at 1:17am


Topic: How to increase the width of the Report
Posted By: krisamigo
Subject: How to increase the width of the Report
Date Posted: 27 May 2007 at 10:22pm

Hi all....

I have a problem while i am designing the report the columns are more it is not fitting to the actual page i have to incerease the report width plz can any one help me how to incerease the width of the report
 
Thanks in Advance.


Replies:
Posted By: hilfy
Date Posted: 28 May 2007 at 12:51pm
Go to the File menu and select Page Setup.  You can change the orientation of your paper and the paper size here.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: maniac
Date Posted: 08 Jun 2007 at 11:31am
I think you meant 'printer setup.'
 
Works for me ...
Thanx!
: )


-------------
A+ BS MCSE OOP Security+ Web Developer
Get creative, not even.

Posted By: hilfy
Date Posted: 08 Jun 2007 at 12:26pm
No.  In Crystal XI it's "Page Setup".
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: maniac
Date Posted: 08 Jun 2007 at 1:26pm

k

I'm using standalone CR v9.2.0.448 in case anybody needs to do it that way/version.



-------------
A+ BS MCSE OOP Security+ Web Developer
Get creative, not even.

Posted By: hilfy
Date Posted: 08 Jun 2007 at 1:31pm
Cool!  Thanks!

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: sanjay_usa1
Date Posted: 22 Jun 2007 at 7:06am

Doing this also not solved my problem becuase i have around 25 feilds which needs to be accomodate in same page any other options pls. will be highly appreciated

Posted By: hilfy
Date Posted: 22 Jun 2007 at 7:57am

What size paper are you set to use?  If it's "Letter", try setting it to "Legal" which will give you a lot more room.  It might also help to play with the font size, and possibly the font itself, to see how you can get it to fit.

Do all 25 fields have to fit across in one row?  If not, you could also do some creative design changes to display it in multiple rows.

 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: jkwrpc
Date Posted: 22 Jun 2007 at 9:16am
I posted a solution that worked for me in another thread
 
http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=901 - http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=901
 
The problem shows up if your printer is not capable of larger paper sizes.  I have a number of customers that print reports on ledger size paper, but I did not have a printer on my system that print that same size.  So I was unable to increase the design areas to match my reports needs.  I went through all the steps others have mentioned until I stumbled across this.
 
My solution was to 'trick' CR into thinking I did have a printer that would print the larger sizes as outlined in the other thread. I have not had a problem since. 
 
If someone has a better solution, I would implement it, but until then this work around has spared me much frustration.
 
Regards
 
John W.
http://www.CustomReportWriters.net - www.CustomReportWriters.net

Posted By: salguod11
Date Posted: 29 Jun 2007 at 12:09pm
Similar issue.  Using Crystal 10 to design a simple report with four columns of data coming from the same file (i'e', one line of data per job).  The report is 21 pages usina Arial 10 font.  Is there a "Shrink to Fit" setting whereby if I add more data, CR will automatically shrink the font to fit the columns across the page, show more rows of data per page, and decrease the size of the report?  Switching to Landscape will solve my width problem, but will ADD more pages to the report.
 
Thanks!

Posted By: hilfy
Date Posted: 29 Jun 2007 at 12:21pm
No, there is no "auto fit" feature.  You would have to manually re-size your columns.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: salguod11
Date Posted: 29 Jun 2007 at 12:22pm
Ugh!  But thank you for a very timely response!

Posted By: jkwrpc
Date Posted: 29 Jun 2007 at 12:29pm
I have never seen such an option in CR. I also have never seen such a property exposed when working the CR objects in Visual Studio. That makes me doubtful it exists, but admittedly I could have missed it.
 
If there is a way for this to happen I also would be interested in knowing about it.
 
As an aside, I find that I am able to take the report font size down to about 8pt before users complain about small print size. It does make it possible to fit more columns on a page and certainly more rows. That is not the solution you are looking for but it may give you more design room on the portrait postioning of the paper.
 
Regards,
 
John W.
http://www.CustomReportWriters.net - www.CustomReportWriters.net

Posted By: salguod11
Date Posted: 29 Jun 2007 at 12:35pm
Thank you, John W.  I figured this feature was more of the norm than not amongst leading reporting writing softwares.  The construction accounting software package we use, Sage Timberline, has a report designer module which enables you to do just that.  Adding columns will decrease the font size once the default column width has been consumed.  Turning to landscape and introducing legal size certainly helps maintain visual integrity.  Sometimes, however, after the font size becomes microscopic, a design needs to be rethought!
 
So, time to CPA (cut, paste, and assemble)!

Posted By: lincongca
Date Posted: 24 Sep 2007 at 8:33am
I used Crystal Report XI that the page size could be customized as the following way.

Page Setup->( Click on ) the "Printer" Button -> (Select) "MS Office Document Image Printer" -> (Click On) "Properties" -> The "Page" tab in the new pop up window would allow you to setup the page size whatever you want.

Posted By: leburg
Date Posted: 24 Nov 2015 at 5:19am
It an 8 the smallest font along with legal landscape (14in w/0 margin) about the max for the width of a cr?

Posted By: kevlray
Date Posted: 24 Nov 2015 at 10:21am
I have a report that exports to a text file (used as an import to another database).  It is over 130 inches wide.


Print Page | Close Window