Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formating report in CR 10

Status
Not open for further replies.

MSBrady

Technical User
Mar 1, 2005
147
US
Oy!
SQL 2005

I have an Estimate report that is run from Solomon. It has 3 groups. Portrait printer setup. The total Header is about 2 3/4" high, the total Footer is 2 1/4" high. That leaves 3" for the body. Not a problem unless the body runs more than 3". Expected behavior is that output should wrap to the next page. It's not, it's simply being deleted. If I remove either a portion of the header or footer it wraps as expected to the next page.
The body is composed of Tasks and Task Notes which change size by report parameter.
Is this a bug in version 10? I have only the base version, no service packs or hotfixes. Crystal Reports for Solomon has not released any SPs and they do not support SPs from the BO site.

Any help would be hot.
TIA

.batman
 
Right-click, [Format Field]. Check on the [Common] tab, and you'll probably find that [Can Grow] has not been checked.


[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
its probably keep group together, keep section together or keep object together that's causing the problem.

Crystal Reports its trying to format the page in the allotted 3" of space, but when it runs over that it needs to figure out where it is allowed to insert a page break.

If all of your sections are marked as 'keep together' (or maybe objects that cover large portions of the sections) then Crystal Reports has to go back to the top of the object and see if its allowed to create a page break there.

In the worst case this can lead to degenerate behaviour, which means that Crystal Reports would put one line of text on each page.
 
But it's not putting one line of text on each page, the lines it can't find a place for are being dropped completely.
 
I have gone through a turned off all Keep Togethers in all sections except the PF. There are 2 subreports that both have Keep Together turned on. When I run the report using 2 different jobs 1 works as expected the other truncates data.
 
Update to this issue.
One of my users figured out that if she printed on Legal sized paper that everything printed just fine. I went in and checked all the subreports, the main report and everywhere else I could find, including the printer and everywhere it is set to Letter size. Is this a bug?
 
I don't think so -- if you've left the two subreports as keep together, and they are taking up the full height of the section (or they could if they got a certain data set) then all you're doing is just expanding the window that CR can format into when you go to legal sized paper.

is there any way that you can make sure that either:
a. all objects are not keep together (inlcuding objects inside the subreports).
b. The total expected height of the middle section / subreports is less than your alloted space?

On a purely stylistic note having only a 3" window to format into might be really keyholing your user experience. (As in they are contrained to look through the keyhole for the information they want).
 
LOL. Thanks for your reply. They are accounting types and don't much care for a "user experience", they just want the data.
At any rate, I de-selected Keep Together on every Section, Object, Graphic, SubReport, Subreport Sections, Subreport Objects. Same results.
 
Interestingly also in the Crystal component that runs at print preview time, in the Solomon application, if I select A4 it works as expected. If I select Letter again, it truncates.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top