Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

RB5.56 --> RB6.02

edited September 2001 in General
I have a report that looked fine in RB5.56, but show problems in RB6.01 and
RB6.02.
I was hoping that version 6.02 would solve the problems, but it doesn't.

For the moment, I still have a working copy of my project in Delphi 5,
ReportBuilder 5.56.
So I can compare exactly the results (with the same databases) between
RB5.56 and RB6.02.

So, this is the procedure I went through for the 'conversion' :
I copied the problem report (pas and dfm files) to Delphi 6, ReportBuilder
6.02.
I opened the report designer, and saved the report again. A few messages
came :
"Error : Field FormReportsFinancialType3.ppMasterFieldLink1 does not have a
corresponding component. Remove the declaration ?"
I answered Yes.

After building, I hoped that the conversion was succeeded.
However : there are still 2 problems.
I find this very difficult to explain,but I will try by first describing the
report :

My report is a DADE report with 3 dataviews in a master-detail-detail
relationship.
The SQL code of the first view :
SELECT ADCOMP.ARefRub, ADCOMP.Ref,
ADCOMP.NameNlRub, ADCOMP.NameNl,
ADCOMP.ClientRef, ADCOMP.ClientOut
FROM "ADCOMP.DB" ADCOMP
ORDER BY ADCOMP.NameNl


The SQL code of the second view :
SELECT FAFACT.FactNr, FAFACT.ClientRef,
FAFACT.FactDate, FAFACT.Currency
FROM "FAFACT.DB" FAFACT
ORDER BY FAFACT.FactNr


The SQL code of the third view :
SELECT FAPREST.FactNr, FAPREST.ProdCode,
FAPREST.Price, FAPREST.Description,
FAPREST.Saler, FAPREST.CommPct,
FAPREST.CommAmount, FAPREST.Currency
FROM "FAPREST.DB" FAPREST

In the design tab of the designer, I have a main report and 2 subreports.
The detail band of the main report, contains subreport1, the detailband of
subreport1 contains subreport2. In all 3 reports, there are some
TppVariables to do some sommations etc., in event code.
The detail band of the main report also contains some fields to display the
identification of each 'company' (master record from the ADCOMP database)
that is listed

PROBLEM 1 :
The data traversal is not correct.
In my report, records from ADCOMP are listed, that should not appear, but
that are 1 record position PRIOR to the exact record.
(this problem is new since RB6.02)

PROBLEM 2 :
The subreports are not displayed for SOME main report records.
The detail band of the main report displays the identification fields of the
'company' master record. The subreports are missing.
(this problem is present in RB6.01 and RB6.02)

Can I do something else ?

Comments

  • edited September 2001
    You shouldn't get this message if the conversion was successful. Are you
    using Interbase? We have a patch that fixes a conversion issue for Interbase
    for 6.02


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited September 2001
    I am not using Interbase, but Paradox.
    To be sure of what I am telling, I did the conversion again. These are the
    messages that I see :

    "Error :
    Field FormReportsFinancialType3.ppMasterFieldLink2 does not have a
    corresponding component.
    Remove the declaration ?"

    This message is repeated for ppMasterFieldLink3, 1, 6, 4 and 5

    Should it be useful if I send you a copy of the .pas and .dfm files before
    and after the conversion ?

  • edited September 2001
    If you send us the 5.56 report we can trace through the conversion process.
    Describe the dataview configuration in detail, such as any calcfields,
    search criteria, which tables are joined in each dataview... Can a similar
    dataview configuration be created with DBDEMOS that shows this conversion
    problem, we can just recreate it here if that is the case? If it isn't
    reproducable with DBDEMOS, you may want to send us small versions of your
    tables so we can recreate the report in 5.56. Zip it up and send it to
    support@digital-metaphors.com


    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.