first two rows of report repeated?
I have several relatively simple reports, some two columns, some only one, some simple tables but some are grouped with a group header, master data and group footer.
The sql used to get the data is very similar for each report.
The odd thing is that the first page in all the reports shows the first row to be repeated. Even odder is that one of the reports that shows two repeated rows has data in a particular field of one row but nothing in the same field of the repeated row.
Running the sql on its own against the db shows no such repeats or missing data.
Anyone come across this before and know what is happening ?
Below is an example
My SQL is
Running this sql against the db in my database explorer tool produces this result, correctly showing each year only once.
The sql used to get the data is very similar for each report.
The odd thing is that the first page in all the reports shows the first row to be repeated. Even odder is that one of the reports that shows two repeated rows has data in a particular field of one row but nothing in the same field of the repeated row.
Running the sql on its own against the db shows no such repeats or missing data.
Anyone come across this before and know what is happening ?
Below is an example
My SQL is
SELECT tblLeagueTable.Year,
round(AVG(tblLeagueTable.WeekMinus0),1) AS AvgOfPresentPlusAEAPercent,
round((Sum( CASE WHEN WeekMinus0 < 80 THEN 1.0 ELSE 0.0 END ) / Count(Adno) )*100,1) AS YearPA
FROM
tblLeagueTable
GROUP BY
tblLeagueTable.Year
ORDER BY
round(AVG(tblLeagueTable.WeekMinus0),1) desc,year;
Running this sql against the db in my database explorer tool produces this result, correctly showing each year only once.
Comments
Hi,
I have the same problem. I have a result of a query to a mysql database, and the FrxReport, outputs the 1st row repeated twice. I use a PageHeader and a MasterData components on my report. I use a TFDMemTable. Has anyone solved?
Best Regards,
Ana