Results 1 to 8 of 8

Thread: page count - crystal reports

  1. Apr 20th, 2003, 01:23 PM #1
    kavimegam
    kavimegam is offline

    Thread Starter
    Member
    Join Date
    Oct 2002
    Location
    India
    Posts
    37

    page count - crystal reports

    Hi,
    I have a table of bills.
    I need to calucate total amount i got for a month
    this runs for many pages...
    i need to print total amount in every page
    ( i mite not know how many pages the report will run and how many records each page will contain)
    then the grand total in the last page.
    how can i do it
    thanks in advance
    Reply With Quote Reply With Quote
  2. Apr 24th, 2003, 01:35 AM #2
    SkiNLaB
    SkiNLaB is offline
    Fanatic Member SkiNLaB's Avatar
    Join Date
    Jan 2002
    Location
    Sydney, Australia
    Posts
    747
    i couldnt understand what you wanted, did you want the total number of bills printed on every page?
    Reply With Quote Reply With Quote
  3. Apr 24th, 2003, 02:07 AM #3
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    If I think what you want is correct, you need to use a RunningTotal.

    From the Insert Menu select the first option - Database Field. This brings up the different items you can add to your report. Choose the Running Totals item to bring up its dialog box. Set the proper values for your situation. Then add the new running total field to your page footer.
    Reply With Quote Reply With Quote
  4. Apr 24th, 2003, 11:52 AM #4
    kavimegam
    kavimegam is offline

    Thread Starter
    Member
    Join Date
    Oct 2002
    Location
    India
    Posts
    37
    Hi
    Let me be clear.

    I want a report like the below
    PAGE 1.
    BillNo Amount
    1 5
    2 5
    3 20
    4 10
    ________________
    Total Amt in this page=40

    Page 2.
    BillNo Amount
    5 15
    6 105
    ________________
    Total Amt in this page=120
    Grand Totat =160

    Image a page can accomodate only 4 records and i have 6 records.
    I need report like the above,Total of Amount in every page and Grand Total in the last page.
    If only 3 records are present the both page total and grand total will be same..
    If i have 10 records then 3 pages of report with 4 records in 2 pages and 2 records in 3rd page would be the output.
    all i need is total of amount at the end of every page
    Hope u people got it.
    Please help me out
    Reply With Quote Reply With Quote
  6. Apr 24th, 2003, 12:10 PM #5
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    Put a running total in the PAGE footer... set the running total to reset on each new page.
    Then add a Running Total in the Report Footer... this will give a grand total....
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  7. Apr 30th, 2003, 12:11 PM #6
    kavimegam
    kavimegam is offline

    Thread Starter
    Member
    Join Date
    Oct 2002
    Location
    India
    Posts
    37
    Oops...
    I dont know how to make the Running Total reset for every new page.
    I am not able to add the Special field 'Page Number' , in the On Change Of Field combo box.
    I get errors.
    Please help me.
    How to reset Running Total every new page
    Thanks in Advance
    -KaviMegam
    Reply With Quote Reply With Quote
  8. Apr 30th, 2003, 05:14 PM #7
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    It doesn't look like you can reset a running total after every page, at least I could not find a way. The good news is that you can do what you want using a 3 formulas and 1 running total.

    First - Create a running total that Never resets. This will be used for your Grand Total amount at the end of the report.

    Second - Search in your Crystal Report Help File for this topic
    "Creating running totals using a formula". While it does not describe exactly what you want, I followed its instructions and managed to get a report that prints page totals.

    For your type of report, these are the changes I implemented that were different (but necessary) from the help file.

    Move the AmountReset formula in the PageHeader (not Group Header as described in the help topic).
    Place the AmountDisplay formula in the PageFooter.
    Reply With Quote Reply With Quote
  9. May 12th, 2003, 12:27 PM #8
    kavimegam
    kavimegam is offline

    Thread Starter
    Member
    Join Date
    Oct 2002
    Location
    India
    Posts
    37
    hi,
    I am not able to get any help in the topic suggested by u.
    Can u please guide me to get the soln.
    Thanks
    kavimegam
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width