on 10-15-2008 2:57 PM
Hi,
In my report i have used grouping. So i get details, subtotal and Final Total. I want only specific number of lines to be displayed in my report(eg:32).
In Details Section-- Section Expert, i gave "New page after " formula as "Record Number = 32". But on considering the Subtotal lines , Im not getting exactly.
Please help me on this issue.
Thanks
Eswari.B
Hi,
This is the sample format of my report. I need 32 lines in a page.
*Region * Customer name
Argentina Buenos Aires
Bruceu2019s Bikes
details Down Under Bikes
-
-
Grp Footer SUBTOTAL
-
-
-
-
Australia Koala Road
Peddles of Perth
Kangeroo Trikes
-
-
Grp Footer SUBTOTAL
-
-
-
-
Help me in this issue.
Thanks
Eswari.B
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I don't know if this is what you are after, but you can create a 'bean counter' formula.
create a formula with the following formula :
shared numbervar x:= x + 1;
x
and put this is in whichever section of the report you want to tally the number of lines.
You will then see the number incrementally increase with each repeated section.
Hope this is of help
Do you want to display subtotals for each page instead of each group? If so try creating running total using the formula for reset like
reminder(pagenumber,2)=0
evaluate on change of group.
insert one more details section detail b and place this formula adn use the supress condition for that section like
recordnumber <>32
this shows the subtotal after 32 records.
Regards,
Raghavendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eswari,
Please ignore my earlier post and try this :
(recordnumber+(groupnumber*2))/pagenumber > 32
Thanks,
Sastry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
should you be doing a Top N selection?
regards,
dom
sorry..this will only work with groups
Edited by: Dom Horton on Oct 15, 2008 4:16 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eswari,
Please try this in New Page After :
If (recordnumber+(groupnumber*2)) >31 Then True
Thanks,
Sastry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.