Home› General
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Team DM, don't break your heads

rbuserrbuser
edited November 2001 in General
Hi, i found the error of the famous variables on the group footer and
summary bands. ALL WAS PERFECT IN RB!! and i'm a little more gray haired
now.
The problem is with ExtraDevices... when i export the report to Excel,
some records are saved twice!! That's why the SUM inside RB was
different that the SUM with Excel!
Thanks for all your help and concern trying to help me solve this issue.

--
Guillermo Castaño Acevedo
Gerente de Sistemas - Grupo Millennium Ltda
GuillermoC@GrupoMillennium.com
www.GrupoMillennium.com

Comments

  • rbuserrbuser
    edited November 2001
    The problem raises with the first record of each page when the footer band's
    visible property is set to false.
    I can't export the report with the footer band because it'll cause the Excel
    data to be divided with all the the data in the footer of the report on each
    page break, so in the BeforePrint of the report i'm hiding the footer if the
    report is being exported.
    But, for reasons i don't know when the footer is hidden the first record of
    the next page is exported twice.

    Is this a bug of the RB exporting process or is a Waler problem?

    thanks

  • digitalmetaphorsdigitalmetaphors
    edited November 2001
    Export to a comma delimited text file using RB 's native text file output.
    Then you can import the text file into Excel. If native RB text output
    works, but ExtraDevices doesn't, then send an example to James Waler (the
    author of ExtraDevices).


    Cheers,

    Jim Bennett
    Digital Metaphors


    Digital Metaphors Corporation
    http://www.digital-metaphors.com
    info@digital-metaphors.com
  • rbuserrbuser
    edited November 2001
    If i don't set the band's visible property to false but instead set the same
    property to false to all the components inside the band all works fine.
    I'll try what you say in order to know if it's a RB or a Waler problem when the
    bands are hidden.
    thanks

  • rbuserrbuser
    edited November 2001
    By the way, how can i have a never reset variable in a two-pass report?

  • rbuserrbuser
    edited November 2001
    It must be a RB error because native text file output generates an empty file.
    The .raf in the other hand is generated properly. Only when i hide the footer
    the exporting problems raises.

  • digitalmetaphorsdigitalmetaphors
    edited November 2001
    You have to go to the File | Print To File Setup... and select which text
    controls you want to print to the text file.


    Cheers,

    Jim Bennett
    Digital Metaphors


    Digital Metaphors Corporation
    http://www.digital-metaphors.com
    info@digital-metaphors.com
  • rbuserrbuser
    edited November 2001
    The exporting process to text files doesn't generate repeated records, only
    the waler's excel filter.

This discussion has been closed.