Skip to Content
avatar image
Former Member

No of lines in report

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 16, 2008 at 05:35 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Oct 15, 2008 at 02:12 PM

    Hi Eswari,

    Please try this in New Page After :

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

    Thanks,

    Sastry

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 02:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 02:23 PM

    Hi Eswari,

    Please ignore my earlier post and try this :

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

    Thanks,

    Sastry

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 04:16 PM

    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

    Add comment
    10|10000 characters needed characters exceeded