Re: 911: ITSM 7.x and Reporting
Kathy, If you are trying to run BO Crystal Reports XI .rpt files through the Remedy User Tool, I think, and someone correct me if I am wrong, XI is not supported even though the manuals say so, you have to use version 10. Crystal XI is meant to be used when accessing through the Mid-Tier or directly from the browser via the BO Crystal Reports Enterprise Server XI, which will cost your customers some serious cash to stand up due to the fact that SAP is raising the cost of Crystal Reports Enterprise CPU Licenses another 22% in mid June! Anyone who is planning on standing up or buying another CPU license for the Crystal XI Enterprise Server go out an buy your licenses now! I ran into the same issues when testing out Crystal with AR System version 7.1.0 but Crystal version 10 worked for me. I ran into a lot of issues and limitations with using Crystal 10 through the User Client and had to develop a user interface to force feed my SQL parameters through the active links instead of using the actual .rpt file to run the query when using the user client. We are going with the Enterprise Server XI for reporting. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Wednesday, June 11, 2008 7:25 PM To: arslist@ARSLIST.ORG Subject: Re: 911: ITSM 7.x and Reporting ** The User tool -Original Message- From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 11 Jun 2008 2:12 pm Subject: Re: 911: ITSM 7.x and Reporting ** Kathy, One question where are you runing the reports (web or the user tool)? Howard On 6/11/08, Kathy Morris [EMAIL PROTECTED] wrote: ** Hello, Its been a long while that I have been chiseling away at this mystery. I can not figure out why this report is not executing in ITSM 7.x. We are going live and I have all these reports from Crystal XI, that are not opening in Remedy. Remedy says this is a customization so no help. Even when we tried to copy the OOB reports into a new record, the new copies did not open when we select Run Report button. Only the original OOB reports run. I built an open window action AL, and the Report still does not run. There is no qualification for the report to pass thru the parameter. Does anyone have an idea why the reports are not opening? There were 3 steps: 1. Add .rpt as attachment to Report Form 2. Fill in Category info in Report Form 3. Click Run Report button Am I missing a step? Get the Moviefone Toolbar http://toolbar.aol.com/moviefone/download.html?ncid=aolcmp00051 1 . Showtimes, theaters, movie news, more! __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] Resume = http://www.richter-home.net/resume/ LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ Get the Moviefone Toolbar http://toolbar.aol.com/moviefone/download.html?ncid=aolcmp00051 1 . Showtimes, theaters, movie news, more! __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: 911: ITSM 7.x and Reporting
John, actually I was able to do reporting with version 11. I think Kathy that the issue might possibly be due with the ODBC driver. When I had a similar problem, I'm pretty sure it was because I had a user embedded in my ODBC. Try clearing out any such information, or if that doesn't work, try filling it in. I forget what actually cleared the problem other than it was a bit fussy. Additionally, I recommend checking under tools\options in the ARUser tool under the advance tab that the report server is filled out correctly with the correct TCP/rpc if not default set correctly. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 [EMAIL PROTECTED] 06/12/08 8:56 AM Kathy, If you are trying to run BO Crystal Reports XI .rpt files through the Remedy User Tool, I think, and someone correct me if I am wrong, XI is not supported even though the manuals say so, you have to use version 10. Crystal XI is meant to be used when accessing through the Mid-Tier or directly from the browser via the BO Crystal Reports Enterprise Server XI, which will cost your customers some serious cash to stand up due to the fact that SAP is raising the cost of Crystal Reports Enterprise CPU Licenses another 22% in mid June! Anyone who is planning on standing up or buying another CPU license for the Crystal XI Enterprise Server go out an buy your licenses now! I ran into the same issues when testing out Crystal with AR System version 7.1.0 but Crystal version 10 worked for me. I ran into a lot of issues and limitations with using Crystal 10 through the User Client and had to develop a user interface to force feed my SQL parameters through the active links instead of using the actual .rpt file to run the query when using the user client. We are going with the Enterprise Server XI for reporting. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Wednesday, June 11, 2008 7:25 PM To: arslist@ARSLIST.ORG Subject: Re: 911: ITSM 7.x and Reporting ** The User tool -Original Message- From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 11 Jun 2008 2:12 pm Subject: Re: 911: ITSM 7.x and Reporting ** Kathy, One question where are you runing the reports (web or the user tool)? Howard On 6/11/08, Kathy Morris [EMAIL PROTECTED] wrote: ** Hello, Its been a long while that I have been chiseling away at this mystery. I can not figure out why this report is not executing in ITSM 7.x. We are going live and I have all these reports from Crystal XI, that are not opening in Remedy. Remedy says this is a customization so no help. Even when we tried to copy the OOB reports into a new record, the new copies did not open when we select Run Report button. Only the original OOB reports run. I built an open window action AL, and the Report still does not run. There is no qualification for the report to pass thru the parameter. Does anyone have an idea why the reports are not opening? There were 3 steps: 1. Add .rpt as attachment to Report Form 2. Fill in Category info in Report Form 3. Click Run Report button Am I missing a step? Get the Moviefone Toolbar http://toolbar.aol.com/moviefone/download.html?ncid=aolcmp00051 1 . Showtimes, theaters, movie news, more! __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] Resume = http://www.richter-home.net/resume/ LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ Get the Moviefone Toolbar http://toolbar.aol.com/moviefone/download.html?ncid=aolcmp00051 1 . Showtimes, theaters, movie news, more! __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: 911: ITSM 7.x and Reporting
I would have to open the docs, but for some reason I thought you needed crystal installed on the mid-tier (or have the mid-tier pointing to it). But I might be thinking of web users only. Howard On 6/12/08, Benedetto Cantatore [EMAIL PROTECTED] wrote: John, actually I was able to do reporting with version 11. I think Kathy that the issue might possibly be due with the ODBC driver. When I had a similar problem, I'm pretty sure it was because I had a user embedded in my ODBC. Try clearing out any such information, or if that doesn't work, try filling it in. I forget what actually cleared the problem other than it was a bit fussy. Additionally, I recommend checking under tools\options in the ARUser tool under the advance tab that the report server is filled out correctly with the correct TCP/rpc if not default set correctly. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 [EMAIL PROTECTED] 06/12/08 8:56 AM Kathy, If you are trying to run BO Crystal Reports XI .rpt files through the Remedy User Tool, I think, and someone correct me if I am wrong, XI is not supported even though the manuals say so, you have to use version 10. Crystal XI is meant to be used when accessing through the Mid-Tier or directly from the browser via the BO Crystal Reports Enterprise Server XI, which will cost your customers some serious cash to stand up due to the fact that SAP is raising the cost of Crystal Reports Enterprise CPU Licenses another 22% in mid June! Anyone who is planning on standing up or buying another CPU license for the Crystal XI Enterprise Server go out an buy your licenses now! I ran into the same issues when testing out Crystal with AR System version 7.1.0 but Crystal version 10 worked for me. I ran into a lot of issues and limitations with using Crystal 10 through the User Client and had to develop a user interface to force feed my SQL parameters through the active links instead of using the actual .rpt file to run the query when using the user client. We are going with the Enterprise Server XI for reporting. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Wednesday, June 11, 2008 7:25 PM To: arslist@ARSLIST.ORG Subject: Re: 911: ITSM 7.x and Reporting ** The User tool -Original Message- From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 11 Jun 2008 2:12 pm Subject: Re: 911: ITSM 7.x and Reporting ** Kathy, One question where are you runing the reports (web or the user tool)? Howard On 6/11/08, Kathy Morris [EMAIL PROTECTED] wrote: ** Hello, Its been a long while that I have been chiseling away at this mystery. I can not figure out why this report is not executing in ITSM 7.x. We are going live and I have all these reports from Crystal XI, that are not opening in Remedy. Remedy says this is a customization so no help. Even when we tried to copy the OOB reports into a new record, the new copies did not open when we select Run Report button. Only the original OOB reports run. I built an open window action AL, and the Report still does not run. There is no qualification for the report to pass thru the parameter. Does anyone have an idea why the reports are not opening? There were 3 steps: 1. Add .rpt as attachment to Report Form 2. Fill in Category info in Report Form 3. Click Run Report button Am I missing a step? Get the Moviefone Toolbar http://toolbar.aol.com/moviefone/download.html?ncid=aolcmp00051 1 . Showtimes, theaters, movie news, more! __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] Resume = http://www.richter-home.net/resume/ LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ Get the Moviefone Toolbar http://toolbar.aol.com/moviefone/download.html?ncid=aolcmp00051 1 . Showtimes, theaters, movie news, more! __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Howard Richter Red Hat Certified Technician
Re: 911: ITSM 7.x and Reporting
Were either of the reports I sent you able to be run on your server? They were modified from OOTB reports in Crystal Reports Professional XI version 11.0.0.1282. Given Business Objects/Crystal Reports track record on backwards compatibility (similar to java - lousy), I would have no expectation that CR XI R2 or R3 reports would work if the CRXI executables installed with the User Tool are not at those levels. The only problem I can think of with the reports that I sent you would be if the helpdesk manager (who does our custom reporting) added any of our custom fields to the detail by date report... you would not have those fields on your Incident form. ODBC is configured as installed by the User Tool, with all entries but the Data Source Name blank. You should make sure that there is nothing set in the ODBC driver except Data Source Name on the machine that you are editing your reports on. We do set the FQDN of the report server and its TCP port as well as ODBC Use Underscores = Yes in ALL of our default AR System User Preferences records, which all users have, so anyone logging in to our system will have the correct entries available to the ODBC driver when running the reports. Still casting about for something that might help... Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Wednesday, June 11, 2008 3:58 PM To: arslist@ARSLIST.ORG Subject: 911: ITSM 7.x and Reporting ** Hello, Its been a long while that I have been chiseling away at this mystery. I can not figure out why this report is not executing in ITSM 7.x. We are going live and I have all these reports from Crystal XI, that are not opening in Remedy. Remedy says this is a customization so no help. Even when we tried to copy the OOB reports into a new record, the new copies did not open when we select Run Report button. Only the original OOB reports run. I built an open window action AL, and the Report still does not run. There is no qualification for the report to pass thru the parameter. Does anyone have an idea why the reports are not opening? There were 3 steps: 1. Add .rpt as attachment to Report Form 2. Fill in Category info in Report Form 3. Click Run Report button Am I missing a step? _ Get the Moviefone Toolbar http://toolbar.aol.com/moviefone/download.html?ncid=aolcmp00051 1 . Showtimes, theaters, movie news, more! __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: 911: ITSM 7.x and Reporting
Finally solved the mystery - in case anyone ever experiences this - on the Remedy client - apparently whoever configured the server had the development server pointing towards the Reporting Server in Productions. So whenever I clicked the report - it was not opening. Tools, Options/ Advanced Tab. -Original Message- From: strauss [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thu, 12 Jun 2008 7:58 am Subject: Re: 911: ITSM 7.x and Reporting ** Were either of the reports I sent you able to be run on your server? They were modified from OOTB reports in Crystal Reports Professional XI version 11.0.0.1282. Given Business Objects/Crystal Reports track record on backwards compatibility (similar to java – lousy), I would have no expectation that CR XI R2 or R3 reports would work if the CRXI executables installed with the User Tool are not at those levels. The only problem I can think of with the reports that I sent you would be if the helpdesk manager (who does our custom reporting) added any of our custom fields to the detail by date report… you would not have those fields on your Incident form. ODBC is configured as installed by the User Tool, with all entries but the Data Source Name blank. You should make sure that there is nothing set in the ODBC driver except Data Source Name on the machine that you are editing your reports on. We do set the FQDN of the report server and its TCP port as well as ODBC Use Underscores = Yes in ALL of our default AR System User Preferences records, which all users have, so anyone logging in to our system will have the correct entries available to the ODBC driver when running the reports. Still casting about for something that might help… Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Wednesday, June 11, 2008 3:58 PM To: arslist@ARSLIST.ORG Subject: 911: ITSM 7.x and Reporting ** Hello, Its been a long while that I have been chiseling away at this mystery. I can not figure out why this report is not executing in ITSM 7.x. We are going live and I have all these reports from Crystal XI, that are not opening in Remedy. Remedy says this is a customization so no help. Even when we tried to copy the OOB reports into a new record, the new copies did not open when we select Run Report button. Only the original OOB reports run. I built an open window action AL, and the Report still does not run. There is no qualification for the report to pass thru the parameter. Does anyone have an idea why the reports are not opening? There were 3 steps: 1. Add .rpt as attachment to Report Form 2. Fill in Category info in Report Form 3. Click Run Report button Am I missing a step? Get the Moviefone Toolbar. Showtimes, theaters, movie news, more! __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: 911: ITSM 7.x and Reporting
Kathy, One question where are you runing the reports (web or the user tool)? Howard On 6/11/08, Kathy Morris [EMAIL PROTECTED] wrote: ** Hello, Its been a long while that I have been chiseling away at this mystery. I can not figure out why this report is not executing in ITSM 7.x. We are going live and I have all these reports from Crystal XI, that are not opening in Remedy. Remedy says this is a customization so no help. Even when we tried to copy the OOB reports into a new record, the new copies did not open when we select Run Report button. Only the original OOB reports run. I built an open window action AL, and the Report still does not run. There is no qualification for the report to pass thru the parameter. Does anyone have an idea why the reports are not opening? *There were 3 steps*: 1. Add .rpt as attachment to Report Form 2. Fill in Category info in Report Form 3. Click Run Report button Am I missing a step? -- Get the Moviefone Toolbarhttp://toolbar.aol.com/moviefone/download.html?ncid=aolcmp000511. Showtimes, theaters, movie news, more! __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] Resume = http://www.richter-home.net/resume/ LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: 911: ITSM 7.x and Reporting
The User tool -Original Message- From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 11 Jun 2008 2:12 pm Subject: Re: 911: ITSM 7.x and Reporting ** Kathy, ? One question where are you runing the reports (web or the user tool)? ? Howard ? On 6/11/08, Kathy Morris [EMAIL PROTECTED] wrote: ** Hello, Its been a long while that I have been chiseling away at this mystery.? I can not figure out why this report is not executing in ITSM 7.x.? We are going live and I have all these reports from Crystal XI, that are not opening in Remedy.? Remedy says this is a customization so no help.? Even when we tried to copy the?OOB reports into a new record, the new copies did not open when we select Run Report button.??Only the original OOB reports run.? I?built an open window action AL, and?the Report still does not run.? There is no qualification for the report to pass thru the parameter. Does anyone have an idea why the reports are not opening?? There were 3 steps: 1. Add .rpt as attachment to Report Form 2. Fill in Category info in Report Form 3. Click Run Report button ? Am I missing a step? Get the Moviefone Toolbar. Showtimes, theaters, movie news, more! __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] Resume = http://www.richter-home.net/resume/ LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are