Hi all, I have complaints of slow or never-ending reporting in ITSM 7. After a lot of looking around, I am wondering if the inherent design of the reports is a big factor. Such as a Join done in the report (with a subreport), ODBC overhead etc.
Can somebody run this report for me and tell me how long it takes. If you can use Remedy User instead of a browser and do this on a powerful box (may I suggest production?) that would be nice-- Incident Management Console->Reports On "ReportSelection" popup choose this "Report Name": Incident->Incident Information->All Incidents->Incicent Details By Date Range For "Start Date" and "End Date" select dates that would give you at least 500 Incidents in your environment. Closer to 1000 would be nice. Choose "Destination" = "Screen" Click "Run Report" and start your "Stop Watch" On the prompt asking for titles, just click "Ok" Let me know: (1) how long until the report completes...meaning ReportViewer pop-up has finished loading all data (hint where it shows page info like this "1/6+", presence of "+" means its still loading more. (2) how many Incidents did you catch (3) does your report have "work info" included for incidents? (4) Quick detail of your environment. The network path between your PC and the server, how "strong" is the AR Server/Database Ok, it's quite some work...but may I plead that I would do this for you? :) If you want to be really nice to me, if you could do the same report such that your date criteria catches no Incidents at all, how much time till the Report windows shows up and completes loading with no info on the report? Thank you in advance. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"