Hello Rabi, I don't see your report file, however, do you have any diary fields in it? (worklog, Audit trail, etc)
We have noticed that these type of fields (CLOB) are killing the performances when it comes to reporting. Try to remove them and run your report again just to see. On our side we do not publish reports containing those fields anymore. We only distribute them on request directly to the user and with a notice about performance. Rabi Tripathi wrote: > > 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" > > -- View this message in context: http://www.nabble.com/Somebody-please-run-this-ITSM-7-report-for-me-tp21919656p21931329.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
