Re: crystal report subreport - leaves space for main rpt footer

On Oct 2, 4:00 pm, drolaw <dr...@xxxxxxx> wrote:
On Oct 2, 10:46 am, jgosw...@xxxxxxxxx wrote:





On Oct 2, 10:33 am, jgosw...@xxxxxxxxx wrote:

On Oct 1, 1:58 pm, drolaw <dr...@xxxxxxx> wrote:

On Oct 1, 9:35 am, jgosw...@xxxxxxxxx wrote:

HI all,
I have a crystal report that I have a subreport in the group header. I
link the main report to the subreport by a customer id. I want the
subreport to print first, and then the main report. The subreport is
basically a hdr, the customer info(name,addre, etc) and then a form
letter (saying something like your account is overdue, etc). I insert
the form letter using an object and linking a word document to the
object. My main report is then basically a hdr with customer info and
then a date, invoice number and amt hdr. The detail section is
invoices,dates and amts. My page footer is totals, and I have it
broken up into sections. There are 3 sections and I have these
surpressed if I am in the subreport. My problem is, no matter what I
do, the subreport seems to save space for the main report footers. I
can only use about 5 1/2 inches of the page for the subreport. How do
I get around not saving space for the footers in the subreport?

Crystal will always leave space in the report for the footer in the
main report. The only way to get around it is to create a fake group
and put all your totals into that. For example:

1. Create a formula called @FakeFooter.
2. Put this into the formula:
1=1
3. Create a group based on this formula. MAKE SURE YOU MAKE IT THE
OUTERMOST GROUP (not yelling, just emphasizing.)
4. Use this group footer for your totals. Crystal should respons
appropriately when you suppress this group programatically.
5. Make your page and report footer as small as possible.

Hope that helps,
Dave

Dave - Probably not doing something right, but I don't see my formula
when I try to create a new group. I have tried saving the rpt after I
create the formula and reopening but I don't see it.- Hide quoted text -

- Show quoted text -

Dave - I think I found a way around this. i took a formula I don't use
anymore which showed up on my selection to group by. I chged it to say
1=1 and then use this formula as the group. It created the sections
and I moved my page ftrs up into this group and surpress it as I was
doing the footers. This did solve my problem, if I did it correctly as
you described. however, it only works if the invoice is one page long.
If over one page, it prints many invoices, and then continues on the
next page and then my footers. I want the footers(which are totals of
the invoices on the page and subtotals) to print on each invoice page,
thus, that is why I had them in the page footer. Moving them to the
group footer now prints at the end of the group, which is not what I
want - any suggestions, or maybe I missed a step.
Julie- Hide quoted text -

- Show quoted text -

Hey Julie,
1. The problem you discussed earlier is probably just an evaluation
time issue in the try writing whileprintingrecords; or
whilereadingrecords; at the top of your formula and it should show
up.

2. It sounds like you don't even need a formula. Create a group based
of your invoice id/number. That should only fire once per page. Create
a footer based on that grou pand move all your data into that. That
should work for on invoice or many invoices.

Dave- Hide quoted text -

- Show quoted text -

Not sure I am understanding #2. I pretty much have a group based on
invoice id/number. It is the customer number and that is where I have
the subreports - in the group header. Each customer/id is an invoice.
The detail printed is the invoice number, description, invoice date
and amt. So for each customer, I print the date, invoice number, descr
and amt in the detail section, which can be more than 1 page worth, so
I want to be able to print the totals/subtotals at the bottom of each
page. That is where I got into trouble, as the footer on each page is
about 4 1/2 to 5 inches big. Since the subreport is within the group,
I take it that it takes on the characteristics of the main report and
it saves space at the bottom of the page for the footer, even though I
suppress it. Each report prints several customers in one run.
I also have a subreport in the report footer, as this main report only
prints for one customer at a time. Since I extend lines down thru the
section to the footer, to make a box for the detail section and it
connects with the footer, the lines print on my subreport.
Doing your version with the fake footer got rid of the lines in my
ending subreport that was in the report footer, but now it does not
print my totals on the first page or the 2nd if my invoice for the
customer goes over one or two pages, which makes sense, as I have the
totals in the group footer section.
Julie

.

Loading