cancel
Showing results for 
Search instead for 
Did you mean: 

No of lines in report

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Eswari,

You give the serial number for your sample report to understanding better.

Thanks,

Sastry

Former Member
0 Kudos

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

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Eswari,

Please ignore my earlier post and try this :

(recordnumber+(groupnumber*2))/pagenumber > 32

Thanks,

Sastry

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Eswari,

Please try this in New Page After :

If (recordnumber+(groupnumber*2)) >31 Then True

Thanks,

Sastry