Results 1 to 6 of 6

Thread: Report Count

  1. #1

    Thread Starter
    Fanatic Member Gary.Lowe's Avatar
    Join Date
    May 2000
    Location
    In my sphere of influence
    Posts
    621

    Unhappy

    I am using Crystal reports and I want to be able to display the number of records at the bottom of each page of the report.

    There is a function there already but that adds on the previous page count on the next page.

    e.g

    if one page has 30 records on it I want to be able to display This page contains 30 records at the bottom of the page.

    If the next page contains 35 records I want to be able to display This page contains 35 records at the bottom of the page.

    Thanks
    Gary Lowe
    VB6 (Enterprise) SP5
    ADO 2.6
    SQL Server 7 SP3

    OK I know my spelling and grammer is crap so don't quote me on it!

    To err is human to take the P! is only natural !!

    Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip


  2. #2
    Junior Member
    Join Date
    Dec 1999
    Posts
    21
    How are you gathering your data for the Report (i.e. SQL, Access, etc). I haven't tested this, but I think if your using CR7.0+ then you need to combine the record number field (under Special Fields) and combine it with a running total field.

    Now that I look at it, you might just be able to get away with the running totals field.

    If your using an earlier version of CR, then I don't know if this will work or not.

    Good Luck.

    Scott
    -----------------------------------------------------
    a punk and a programmer, that can't be good.

  3. #3

    Thread Starter
    Fanatic Member Gary.Lowe's Avatar
    Join Date
    May 2000
    Location
    In my sphere of influence
    Posts
    621
    Scott

    I am using Ver6 How do I combine the record number field with a running total field.

    I have the record number field but not a running total field, is this something that is only present in Ver7

    Thanks
    Gary Lowe
    VB6 (Enterprise) SP5
    ADO 2.6
    SQL Server 7 SP3

    OK I know my spelling and grammer is crap so don't quote me on it!

    To err is human to take the P! is only natural !!

    Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip


  4. #4
    Junior Member
    Join Date
    Dec 1999
    Posts
    21

    Question

    I'm not sure. You might want to go to their website and see if they have any upgrades from 6 to 7 (it's a possibility that it may be free or cheap, due to the fact that CR 8 is coming out soon or may already be out). Or you could just download the demo of Version 7 (or 8) and use those components.

    Sorry I can't be much more help. Version 7.0 of Crystal Reports is the first version I've used, so I really don't have much information about past versions.

    Good Luck

    Scott

    ---------------------------------------------------------
    a Punker and a programmer, that can't be good.

  5. #5

    Thread Starter
    Fanatic Member Gary.Lowe's Avatar
    Join Date
    May 2000
    Location
    In my sphere of influence
    Posts
    621
    Thanks anyway Scott

    I don't think I can really be bothered now though, I think I will just tell the lazy Bas$%£ds they will have to count them themselves
    Gary Lowe
    VB6 (Enterprise) SP5
    ADO 2.6
    SQL Server 7 SP3

    OK I know my spelling and grammer is crap so don't quote me on it!

    To err is human to take the P! is only natural !!

    Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip


  6. #6
    Junior Member
    Join Date
    Dec 1999
    Posts
    21

    Talking

    Yeah, I just went through the documentation for ver7. It's a new feature with ver7, so it's your call on it now, since I can't do S&%t else for ya.

    Let me know if I can help with anything else.

    Scott

    ---------------------------------------------------------
    a Punker and a programmer, that can't be good.

Posting Permissions

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



Click Here to Expand Forum to Full Width