Posted 22 June 2018, 1:19 am EST
Hi Team,
I have an issue with the Active Reports. Please give me suggestions to fix it.
In the database i have 149915 records for report to print but in the Application UI i am not able to see those except headers and footers of the report only.
So that i altered my SQL Query to print only top 5000 so its working fine. Now the problem is my client needs all the data in the report UI so how can i solve this ? and may i know the limit like how many rows/records it will print. My version is Active Reports 9 Designer. Please share your thoughts and help me to fix this.
[b]Existing Query In RDLX File: - Unable To Generated Report Except Headers & Footers
SELECT SECREC.* FROM ----
Current Query In RDLX File: - Generated Report
SELECT TOP(5000) SECREC.* FROM ---- [/b]
Thanks,
Mahesh.