Records are missing when we schedule a Report

[_nil1729]

Dear All,

I'm facing an issue in scheduling a report. We have few user, When these users run a report on change request table they are getting total number records in the report as around 1700.

and when the same person scheduling this report he is receiving less number of records i.e around 1350.All the missing records are accessible by him. But he is not receiving those records in scheduled mail. This issue is happening to only few users. When these users Export the "Excel" from the report he is getting the correct count.

When we schedule a report to our mail in PDF format we used to have a big and lengthy "Query Condition:"   in the starting page of the PDF file. But for this user when he schedule a report to our mail in PDF format that lengthy   "Query Condition" is missing and number of records reduced. when i run the same query on change task table it is working fine. Problem is mainly with Change request Table.

Why this user in not receiving all the records in mail when report was scheduled ?

Size of the mail is less than 3MB. Total number of records in the Excel file is less than 10,000.

Thanks and Regards

Anil

[_nil1729]

Issue was resolved,

In our query business rule   we have used a condition "gs.getSession().isInteractive()" this was causing problem in filtering records from change_request table.

After removing this condition from business rule, we were able to get correct number of records in scheduled email.