Resource management through report
I have developed a material tracking report.I want to make this report robust in terms of fetching output.Now this report fetches GRN records which may be about 200 in number for a single day for movement type 103/105 w/e.
This means for an year it could be 365 * 200 = 73000.
I tried this case of 1 year in DEV and found DEV server crashed as archive went beyond 100%.
How can i programmatically/otherwise control such exceptions of large data display.
I want that report should show some error message where records go beyond limit.