Problem with groups
I have a report with a GroupHeader band, a MasterData band and a GroupFooter band. The estructure of the report is:
In group header: [Company Code]
In master data: [Sales]
In group footer: [Total Sales for each company]
In the group footer I have a TfrMemoView with the expression
Total Company [DialogForm.QueryReport1."CODE"]
where code is a CHAR(9) field of a firebird db table (accessed through dbExpress) with the format '9999-9999'.
The problem is the result tha appears on execution: each group footer shows the company code of the next company in QueryReport1. The strange is that the same report against a Paradox table (through BDE) shows the correct result (company code). Is there an explanation for this difference?
I have tried also to avoid the error working with a variable that in group header obp saves the company code, but the memoview shows it with a bad format, though DisplayFormat is set to Text. For example, the code 0030-0000 appears as 30 and 0198-1154 appears as 198.
Can anyone give an idea about this?
Regards
In group header: [Company Code]
In master data: [Sales]
In group footer: [Total Sales for each company]
In the group footer I have a TfrMemoView with the expression
Total Company [DialogForm.QueryReport1."CODE"]
where code is a CHAR(9) field of a firebird db table (accessed through dbExpress) with the format '9999-9999'.
The problem is the result tha appears on execution: each group footer shows the company code of the next company in QueryReport1. The strange is that the same report against a Paradox table (through BDE) shows the correct result (company code). Is there an explanation for this difference?
I have tried also to avoid the error working with a variable that in group header obp saves the company code, but the memoview shows it with a bad format, though DisplayFormat is set to Text. For example, the code 0030-0000 appears as 30 and 0198-1154 appears as 198.
Can anyone give an idea about this?
Regards