I have a report with a detail section. It has been working just fine for a long time. I have not modified it in about a year.
The report obtains data from several MySQL tables.
The detail section has several fields that are populated from a table called "stops". In my test case there are only 2 records supplying data from the stops table, so the detail section renders twice on the report.
The problem is that if some fields in the detail section are null for one of the records, it displays data from the other record.
This just started occurring when I installed the latest release, Build 4346_4889.
In order to test, I have hard-coded values previously supplied by arguments, and removed all arguments from the sql statement. So whether I run the report in the report writer preview. or I run it in AA using the Action Javascript Open a Report, Label or Letter layout, it is using the exact same query.
When viewed in the report writer preview, the report is fine. No problem at all.
But when run from a browser using Open a Report, Label or Letter layout, the problem occurs.
In this example, the first stop record has been populated with a company name and address, and the second stop record has only a few default values, and no company name or address.
Screen shot of the report writer preview: ReportWriter_1.png
Screen shot of the report generated with Open a Report, Label or Letter layout: AA-OpenAReport.png
This will happen with several fields in the detail section. And it does not matter whether there are blank fields in the first or second record. It will display the value from the same field of the other record.
Anyone else seeing this behavior?
The report obtains data from several MySQL tables.
The detail section has several fields that are populated from a table called "stops". In my test case there are only 2 records supplying data from the stops table, so the detail section renders twice on the report.
The problem is that if some fields in the detail section are null for one of the records, it displays data from the other record.
This just started occurring when I installed the latest release, Build 4346_4889.
In order to test, I have hard-coded values previously supplied by arguments, and removed all arguments from the sql statement. So whether I run the report in the report writer preview. or I run it in AA using the Action Javascript Open a Report, Label or Letter layout, it is using the exact same query.
When viewed in the report writer preview, the report is fine. No problem at all.
But when run from a browser using Open a Report, Label or Letter layout, the problem occurs.
In this example, the first stop record has been populated with a company name and address, and the second stop record has only a few default values, and no company name or address.
Screen shot of the report writer preview: ReportWriter_1.png
Screen shot of the report generated with Open a Report, Label or Letter layout: AA-OpenAReport.png
This will happen with several fields in the detail section. And it does not matter whether there are blank fields in the first or second record. It will display the value from the same field of the other record.
Anyone else seeing this behavior?
Comment