CodeGuru Forums -
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic Newsletters VB Forums Developer.com


Newest CodeGuru.com Articles:

  • Installing SQL Server 2008
  • Writing UDFs for Firebird Embedded SQL Server
  • [Updated] Shutdown Manager
  • Building Windows Azure Cloud Service Applications with Azure Storage and the Azure SDK

  • Search CodeGuru:
     



    Go Back   CodeGuru Forums > Visual Basic Programming > Crystal Reports
    FAQ Members List Calendar Search Today's Posts Mark Forums Read

    Reply
     
    Thread Tools Search this Thread Rate Thread Display Modes
      #1    
    Old March 23rd, 2004, 08:36 AM
    shrikant smart shrikant smart is offline
    Junior Member
     
    Join Date: Aug 2001
    Posts: 7
    shrikant smart is an unknown quantity at this point (<10)
    page totals in crystal report

    hello everybody,

    i am a new user to crystel report. i am using the crystal
    report with vb. i have a report with some groups and
    sub-groups. i want to print pagewise totals on each page.
    pl show me the way.

    thanks

    shrikant
    shrikant_smart@rediffmail.com
    Reply With Quote
      #2    
    Old March 23rd, 2004, 09:32 AM
    malleyo malleyo is offline
    Member +
     
    Join Date: Jul 2003
    Location: Florida
    Posts: 651
    malleyo has a spectacular aura about (125+)malleyo has a spectacular aura about (125+)
    In Crystal Reports 8.5, click Insert, Field Object. This will bring up a list of field objects. Expand 'Special Fields' and you can see your options of 'Page Number', 'Total Page Count', 'Page N of M', etc. Just drag and drop onto your report and position where you want it.
    __________________
    I'd rather be wakeboarding...
    Reply With Quote
      #3    
    Old March 26th, 2004, 01:16 PM
    harmonycitra harmonycitra is offline
    Member
     
    Join Date: May 2003
    Posts: 163
    harmonycitra is on a distinguished road (20+)
    I don't know this is the proper way or not. any way this will display page viz totals.

    Create Formula named tot1

    code:

    WhilePrintingRecords;
    NumberVar total;
    total := 0


    formula 2 : tot2

    WhilePrintingRecords;
    NumberVar total;
    total := total + {amount};

    formula 3 : tot3

    WhilePrintingRecords;
    NumberVar total;

    Use the same variable name.

    place tot1 is page header section. This will reset the total value to 0 for each and every page.

    Place tot2 in details section. This will add the values.

    Format both as suppressed.

    Place the tot3 in Page Footer section. This will display page viz total.
    Reply With Quote
    Reply

    Bookmarks
    Go Back   CodeGuru Forums > Visual Basic Programming > Crystal Reports


    Thread Tools Search this Thread
    Search this Thread:

    Advanced Search
    Display Modes Rate This Thread
    Rate This Thread:

    Posting Rules
    You may not post new threads
    You may not post replies
    You may not post attachments
    You may not edit your posts

    BB code is On
    Smilies are On
    [IMG] code is On
    HTML code is Off
    Forum Jump


    All times are GMT -5. The time now is 11:38 AM.



    Acceptable Use Policy

    internet.comMediabistrojusttechjobs.comGraphics.com

    WebMediaBrands Corporate Info


    Advertise | Newsletters | Feedback | Submit News

    Legal Notices | Licensing | Permissions | Privacy Policy


    Powered by vBulletin® Version 3.7.3
    Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
    Copyright WebMediaBrands Inc. 2002-2009