Active reports 9 - Unable to print the report for 150000 records,What is limit?

Posted by: Annapurna.Yacha on 22 June 2018, 1:19 am EST

    • Post Options:
    • Link

    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.

  • Posted 24 June 2018, 6:13 pm EST

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels