Subreport cutting off horizontal data in crosstab

Posted on 2010-03-29
Medium Priority
Last Modified: 2012-05-09
I can't find a way to make a really wide crosstab subreport print anything other than what will fit on the paper size that is defined in the main report when there is additional data horizonally that needs to be displayed or printed.  

I've tried making the subreport really really wide by dragging out the right margin in the design pane.  No luck with that.

I've even tried making the main have the same crosstab as the subreport has so the main will know how wide the subreport needs to be, even that didin't work.  

I do have "can grow" checked on the subreport, it has no affect.  

I've seen this same issue on other Crystal forums, but no one seems to have a solution.  Any ideas?
Question by:TLStrother
LVL 77

Accepted Solution

peter57r earned 500 total points
ID: 29065583
The basic issue here is that subreports have no say in the pagination of a report.  It is all controlled by the main report.
So I don't see that there is any solution to this.

Your only options are to include the crosstab in the main report or in a report on its own.
LVL 101

Expert Comment

ID: 29103487
Agree.  That may have changed in CR2008 which does allow you to have pages in both portrait and landscape but I don't know if it allows the change to occur in a subreport.

LVL 13

Expert Comment

ID: 29260616
Why is the crosstab in a subreport in the first place? If you can 'put the same crosstab in the main report' then that may well be the way to go.

Author Comment

ID: 29925690
As it turns out the rest of the info that isn't displayed in designer is displayed just fine if you use either the DHTML or Advanced DHTML viewer after publishing in the CE environment.  Seems odd that the designer can't display it but the viewer can, but I guess it's not that important since the users can see it.  Seems weird though.

Author Closing Comment

ID: 31708692
It's only in the Crystal Designer environment that the extra info can't display horizontally.  Once published in CE or BOE the DHTML or Adanced DHTML view can display the extra wide subreport perfectly.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
From store locators to asset tracking and route optimization, learn how leading companies are using Google Maps APIs throughout the customer journey to increase checkout conversions, boost user engagement, and optimize order fulfillment. Powered …
Suggested Courses

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question