Crystal reports Sub report with multiple pages

[born2program]

I am developing a crystal report that has a graph in the report header. I also have a subreport (that contains a cross tab) in the report footer. Everything works fine but if the results of the cross tab in the subreport expands past the width of the subreport container it truncates the results. Is there a way around this?

I tried an example of "wrapping" the cross tab, but no luck. I also tried placing the subreport in a empty crosstab on the main report (something I saw on tek-tips), but still no luck.

Using Crystal Reports XI.

Thanks.

 

[lbass]

The crosstab solution asks you to create a crosstab that generates virtual pages to the right that match the necessary width for the subreport crosstab. Then you manually stretch the subreport to the width of the crosstab. The crosstab itself can then be suppressed by suppressing labels, summaries, and removing the grid, but you need to not suppress the crosstab object itself.

You should also be sure you need to use a subreport or whether there might be a way of adding the crosstab without needing a subreport.

-LB

 

[born2program]

Thanks for the Info. I'll try this. I've never done virtual pages in a crosstab before. What is involved in doing this? Thanks.

 

[lbass]

Virtual pages are automatically created if you place a field with many instances as your column field. Say you have a customer ID with 100 instances. Placed in the crosstab as a column field, this will create multiple pages to the right. Try this in the report header to see how it works.

-LB