emi_sastra
asked on
Continuation description before the second page detail
Hi All,
I have invoice form with half A4.
The invoice could be more than one page.
First Page
Invoice No : XXX
No. Item Description Qty Price Total
1 A Coca Cola 1 0.5 0.5
2 B Sprite 2 0.5 1.0
3 C Fanta 2 0.5 1.0
Total 0
Second Page :
Invoice No : XXX
No. Item Description Qty Price Total
Subtotal 2.5
4 A Chocolato 1 2 2.0
5 B Nestle 1 1 1.0
6 C Tea 1 0.5 0.5
etc
Total 6.0
How could I do it ?
Thank you.
I have invoice form with half A4.
The invoice could be more than one page.
First Page
Invoice No : XXX
No. Item Description Qty Price Total
1 A Coca Cola 1 0.5 0.5
2 B Sprite 2 0.5 1.0
3 C Fanta 2 0.5 1.0
Total 0
Second Page :
Invoice No : XXX
No. Item Description Qty Price Total
Subtotal 2.5
4 A Chocolato 1 2 2.0
5 B Nestle 1 1 1.0
6 C Tea 1 0.5 0.5
etc
Total 6.0
How could I do it ?
Thank you.
ASKER
- Do you have a group in the report?
No. The datatable just have detail data.
Thank you
No. The datatable just have detail data.
Thank you
SO you are selecting 1 invoice and printing it?
You could put a text box in the page header and conditiionally suppress it with
PageNumber = 1
mlmcc
You could put a text box in the page header and conditiionally suppress it with
PageNumber = 1
mlmcc
ASKER
SO you are selecting 1 invoice and printing it?
Yes.
- You could put a text box in the page header and conditiionally suppress it with
PageNumber = 1
How about its running total at the next page and so on ?
Thank you.
Yes.
- You could put a text box in the page header and conditiionally suppress it with
PageNumber = 1
How about its running total at the next page and so on ?
Thank you.
What do you mean the running total?
mlmcc
mlmcc
ASKER
Please see the Subtotal.
Second Page :
Invoice No : XXX
No. Item Description Qty Price Total
Subtotal 2.5
4 A Chocolato 1 2 2.0
5 B Nestle 1 1 1.0
6 C Tea 1 0.5 0.5
etc
Total 6.0
Thank you.
Second Page :
Invoice No : XXX
No. Item Description Qty Price Total
Subtotal 2.5
4 A Chocolato 1 2 2.0
5 B Nestle 1 1 1.0
6 C Tea 1 0.5 0.5
etc
Total 6.0
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi CodeCruiser,
The subtotal (running total) is printed before detail at 2nd page and so on.
Which link is provide information for that ?
Thank you.
The subtotal (running total) is printed before detail at 2nd page and so on.
Which link is provide information for that ?
Thank you.
>The subtotal (running total) is printed before detail at 2nd page and so on.
You have put the subtotal in page footer section of report right?
You have put the subtotal in page footer section of report right?
ASKER
Subtotal 2.5 Before the detail at 2nd page and so on. Put at Header Section. Should it be put at a new section between header and detail section. So we could suppress it at first page.
Total 6.0 if page > 1 then first page = 0 and so on, just last page print the total. This is put at page footer.
Thank you.
Total 6.0 if page > 1 then first page = 0 and so on, just last page print the total. This is put at page footer.
Thank you.
Where in the report is the subtotal?
DO you have any sections formatted for NEW PAGE BEFORE or NEW PAGE AFTER in the section expert?
mlmcc
DO you have any sections formatted for NEW PAGE BEFORE or NEW PAGE AFTER in the section expert?
mlmcc
ASKER
-Where in the report is the subtotal?
Before the detail at 2nd page and so on. Put at Header Section. Should it be put at a new section between header and detail section. So we could suppress it at first page.
-DO you have any sections formatted for NEW PAGE BEFORE or NEW PAGE AFTER in the section expert?
No.
Thank you.
Before the detail at 2nd page and so on. Put at Header Section. Should it be put at a new section between header and detail section. So we could suppress it at first page.
-DO you have any sections formatted for NEW PAGE BEFORE or NEW PAGE AFTER in the section expert?
No.
Thank you.
Why is it in the header and not a footer?
What is the issue with the subtotal?
mlmcc
What is the issue with the subtotal?
mlmcc
ASKER
- Why is it in the header and not a footer?
Why should it ?
The subtotal (running total) should printed before detail at 2nd page and so on.
Thank you.
Why should it ?
The subtotal (running total) should printed before detail at 2nd page and so on.
Thank you.
Did you put it there?
Generally summary data is displayed after the detail records as a total.
Do you want it on the second page?
Is your questiion how do you get it there?
mlmcc
Generally summary data is displayed after the detail records as a total.
Do you want it on the second page?
Is your questiion how do you get it there?
mlmcc
ASKER
The subtotal is running total from all previous page amount.
Thank you.
Thank you.
ASKER
Please see the Subtotal.
Second Page :
Invoice No : XXX
No. Item Description Qty Price Total
Subtotal 2.5
4 A Chocolato 1 2 2.0
5 B Nestle 1 1 1.0
6 C Tea 1 0.5 0.5
etc
Total 6.0
Thank you.
Second Page :
Invoice No : XXX
No. Item Description Qty Price Total
Subtotal 2.5
4 A Chocolato 1 2 2.0
5 B Nestle 1 1 1.0
6 C Tea 1 0.5 0.5
etc
Total 6.0
Thank you.
ASKER
Please see the Subtotal.
Second Page :
Invoice No : XXX
No. Item Description Qty Price Total
Previous Subtotal 2.5
4 A Chocolato 1 2 2.0
5 B Nestle 1 1 1.0
6 C Tea 1 0.5 0.5
etc
Total 6.0
Thank you.
Second Page :
Invoice No : XXX
No. Item Description Qty Price Total
Previous Subtotal 2.5
4 A Chocolato 1 2 2.0
5 B Nestle 1 1 1.0
6 C Tea 1 0.5 0.5
etc
Total 6.0
Thank you.
What is the problem with the subtotal?
mlmcc
mlmcc
ASKER
What is the problem with the subtotal?
Previous Subtotal 2.5
Where to put it and how to get all previous total ?
Thank you.
Previous Subtotal 2.5
Where to put it and how to get all previous total ?
Thank you.
ASKER
What is the problem with the subtotal?
Previous Subtotal 2.5
Where to put it and how to get all previous detail amount (2.5 for this sample) ?
Thank you.
Previous Subtotal 2.5
Where to put it and how to get all previous detail amount (2.5 for this sample) ?
Thank you.
Can you upload the report file?
mlmcc
mlmcc
Do you have a running total for the amount?
If so just drag and drop it where you want it
mlmcc
If so just drag and drop it where you want it
mlmcc
ASKER
The subtotal is in the page footer. Is that where you want it or do you need it at the top of the page also?
I have added a running total to the report to produce the totals.
I added it to the pagge footer and the header in bold red font
Is that what you need?
mlmcc
rptSMIInvoiceNonPPN.rpt
I have added a running total to the report to produce the totals.
I added it to the pagge footer and the header in bold red font
Is that what you need?
mlmcc
rptSMIInvoiceNonPPN.rpt
ASKER
Let me see it first.
Thank you.
Thank you.
ASKER
The subtotal should be placed before the first detail row at 2nd page and so on if the report has more than one page, otherwise it never appeared.
Thank you.
Thank you.
ASKER
Print it after PageHeaderSection1
Thank you.
Thank you.
ASKER
The purpose is to see previous sub total from 1st page and so on.
Thank you.
Thank you.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
- Is this in the right spot?
Yes. So I just suppress it when the pagenumber = 1, right ?
Now, the sub total (red color) at PageFooterSection1 is fine, but how to suppress others :
1. txtUangMuka
2. txtPotongan
3. txtBiayaEkspedisi
4. txtNilaiFkt
when it has more than one page. Those textbox object should be printed at last page when it has more than one page.
If it has one page, then it also last page.
Thank you.
Yes. So I just suppress it when the pagenumber = 1, right ?
Now, the sub total (red color) at PageFooterSection1 is fine, but how to suppress others :
1. txtUangMuka
2. txtPotongan
3. txtBiayaEkspedisi
4. txtNilaiFkt
when it has more than one page. Those textbox object should be printed at last page when it has more than one page.
If it has one page, then it also last page.
Thank you.
ASKER
- Is this in the right spot?
Yes. So I just suppress it when the pagenumber = 1, right ?
Now, the sub total (red color) at PageFooterSection1 is fine, but how to set to 0 for others :
1. txtUangMuka = 0
2. txtPotongan = 0
3. txtBiayaEkspedisi = 0
4. txtNilaiFkt = 0
when it has more than one page. Those textbox object should be printed at last page when it has more than one page.
If it has one page, then it also last page.
Thank you.
Yes. So I just suppress it when the pagenumber = 1, right ?
Now, the sub total (red color) at PageFooterSection1 is fine, but how to set to 0 for others :
1. txtUangMuka = 0
2. txtPotongan = 0
3. txtBiayaEkspedisi = 0
4. txtNilaiFkt = 0
when it has more than one page. Those textbox object should be printed at last page when it has more than one page.
If it has one page, then it also last page.
Thank you.
ASKER
- Is this in the right spot?
Yes. So I just suppress it when the pagenumber = 1, right ?
Now, the sub total (red color) at PageFooterSection1 is fine, but how to set to 0 for others :
1. txtUangMuka = 0
2. txtPotongan = 0
3. txtBiayaEkspedisi = 0
4. txtNilaiFkt = 0
when it has more than one page. Those textbox object should be printed its value at last page when it has more than one page.
If it has one page, then it also last page.
Thank you.
Yes. So I just suppress it when the pagenumber = 1, right ?
Now, the sub total (red color) at PageFooterSection1 is fine, but how to set to 0 for others :
1. txtUangMuka = 0
2. txtPotongan = 0
3. txtBiayaEkspedisi = 0
4. txtNilaiFkt = 0
when it has more than one page. Those textbox object should be printed its value at last page when it has more than one page.
If it has one page, then it also last page.
Thank you.
ASKER
The PageFooterSection1 is never suppressed or those 4 text object should be movd to other section and suppress it if not need it (not at last page) ?
Thank you.
Thank you.
ASKER
Problem, the subtotal print total invoice amount, not first page amount.
Thank you.
Thank you.
YOu want to suppress the page footer when it isn't the last page?
Try suppressing with
PageNumber <> TotalPages
mlmcc
Try suppressing with
PageNumber <> TotalPages
mlmcc
ASKER
Hi All,
Thank you very much for your help.
Thank you very much for your help.
If so you could put a text box in the group header that says CONTINUED
You can then conditionally suppress it with
Not InRepeatedGroupHeader
mlmcc