Question
[email protected]
IN
Last activity: 18 Oct 2024 8:34 EDT
Report Definition data value not matching with the Excel Report
While report definition overall data does not matching in the excel report.
while seeing the overall data in report in 101 but report also showing 74. while downloaded in excel format also getting very less data.
Maantic Inc
IN
Can you check under the data access tab what are the values provided under 'Maximum number of rows for export' & 'Maximum elapsed time in seconds for export'?
[email protected]
IN
[email protected]
IN
@SohamM95 Max rows 10lakhs, max elaps time 60sec, But the data is very less. how to resolve this issue
[email protected]
IN
@SohamM95 While run the query 104 records in index table. but report 73 data present. While download excel 61 data present.
Maantic Inc
IN
Do you have remove duplicate checkbox checked? From the tracer take the SQL and run it in query runner and see if here are any differences.
[email protected]
IN
In the schema table ALL not mapped in it. because of that issue will come?
Apart from that all property mapped correctly, only the ALL it not be there. if we mapped in db means will get proper data count?
Maantic Inc
IN
What do you mean by ALL? The columns that are referred in the report definition need to be exposed on the table. Please run the tracer while running the report and take the query and compare the results provided by it in the query runner against the total count that came from the previous SQL that you ran before.
Updated: 18 Oct 2024 8:34 EDT
Bits In Glass
CA
@Jeevan A Soham is asking you to compare the Query runner results and ReportDefinition results. To get the Query Please follow the Steps
- Navigate to the tracer settings and check the DB Query option is enabled or not. If not enable that.
- Run your Report Definition and once it is completed, navigate to SQL Step where you can find the Query.
Use the Query in Query Runner(Configure>System>Database>Query Runner). Execute the Query and compare with Report Definition results. If there is a mismatch, then the columns to be exposed.