Subreport and Can Grow problem

[Stoffel24]

Hi
I have a subreport sitting in a page footer section all on its own. In the subreport itself, the information is shown in the group footer. I am grouping on a field called Grade. Hence for each grade, there are results. If there are 5 grades, I get 5 lines of data. HOWEVER [Evil], despite the fact I have set the subreport to can grow = T, as well as setting all the fields within the subreport to can grow = T (I did this cause I figured what the heck - it shouldn't have any effect in this case) the page footer section that the subreport appears in does NOT grow with the subreport. The subreport IS growing - if I make the height of the subreport almost 0, but the page footer section large, the whole subreport is displayed. However, if I make the page footer section small, the subreport gets cut off at the section boundary. Is this a version 9 bug or am I doing something wrong. I was always under the impression that the section grew with the subreport provided can grow was ticked.

Thanks

 

[Ngolem]

I think your problem is the placement of the Subreport in the Page Footer.

Only a certain amount of space is allocated for this since it cannot split across 2 pages by definition.

Describe your report better...is it not possible to place it in a footer somehow...the only solution I can see is to define the page footer large enough to accomodate the largest subreport value...which is a waste of space.

What are you printing that has to be at the bottom of each page but of varying size??

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[Stoffel24]

Scene setting:

report displays results per sample for a lab.
Main report has
RH Title, logos etc
PH Table column headers appear here
GH Suppressed (Grouping on samples)
D Suppressed
GF Results of the sample going across
RF Suppressed
PFa Table lines end here
PFb Subreport
Subreport shows limits for each column. Has all sections suppressed except the Group Footer. Grouping by stage (ie limits differ for different stages).

PFc to PFf General lab info, caveats, directors names and page numbers etc


On the main report, the rows show the samples and the columns show the different results for that sample for eg pH, Turbidity etc. The subreport actually shows the limits for these columns. This must be done as a subreport since the links required make it impossible to do on the main report. Also, this subreport must appear on the bottom of each page, since the users shouldn't have to turn pages to see the limits. I don't believe this issue has to do with the page size and page footers growing too large to fit on one page. The subreport will never be HUGE - maybe 3 or 4 lines at most. So it ought to just take a greater or smaller bite out of the space allocated to the main report group footer where the data lies as the subreport grows or shrinks. Also, when this happens, all the other sections in the page footer area display and print perfectly. Currently, I have set it up as Ngolem suggested - made PFb big enough to accomodate the subreport at its biggest size, but this sometimes leaves white space which I don't like very much. I still feel like this might be a bug! Incidentally I have loaded Service pack 1 and 2 for crystal.

 

[Madawc]

In Crystal 8.5, you can specify that detail or footer sections will appear at the bottom of a page. Would this allow a work-round for your problem?

Madawc Williams
East Anglia, Great Britain

 

[Stoffel24]

Madawc, that is an interesting suggestion. Unfortunately, I can't do that because I need this repeated ONCE on EACH page, so I can't put it in the RH since this will only appear on the first page and I don't want to put it into a details or group section since this will appear more than once per page. So basically I am stuck. I tried playing with that suggestion but really, the current set up I have - although not ideal - is better than anything else suggested. And I STILL feel that the section ought to be growing with the subreport so this should not be an issue!

 

[Ngolem]

well as I said...a page footer is no expandable...as you have found out...so this becomes a design trade-off issue.

You must design your subreport such that it is the same size everytime and give enough space to accomodate the result without waste.



Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!