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

[Michael Fry1]

The field might not be on the form, but there is a Run as where you can set who you want the report to be run as. Maybe the Run as person doesn't have access to all the data?

[_nil1729]

Hi Michael,

We have checked from our end. Run as is the same person who has created the Report. This was happening only with few user.

[Michael Fry1]

And they all have the same roles, same groups?

[_nil1729]

Yes, They have same roles. The main difference for those users and other users is all these users VIP users.

VIP is a custom field on user table.