dynamically change width of report

[pko123]

Hi,
We are looking for method to change width of report dynamically. That means.

We have a report with a parameter and based on parameter number of output columns will change along with Column heading. THere might be 50 columns for one parameter and maybe 5 coulmns for other parameter.

IS there any way we can acheive this request in crystal report?

we have created a stored procedure which has maximum number of output columns and based on parameter all output columns will be left shifted and rest will be null.

Problem is if for one parameter number of columns are 50 and width of report is 50 inch and for other parameter number of columns are 2 then there will be lot of blank space at right hand side of the report. Is there any way we can avoid this blank space at the end,

or any other method for above requirement.

thanks in advance

 

[Madawc]

Crosstabs will automatically do at least some of what you want. Does that help?

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[chelseatech]

Crystal Reports 2008 also has the option to change page orientation dynamically from portrait to landscape.

Not available in earlier versions though.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm