Frank, The report query is no different than you opening up Enterprise Manager and running a query at the same time as your AR Server is running and accessing the database. We're constantly running manual queries against our production database and we've noticed zero impact on the production system. As mentioned previously, the report query is just a read-only query. Obviously, if you run some massive query that ties up the SQL Server itself, it will not be as responsive to other requests regardless of where they originate. Your report queries should be written as efficiently as possible. This is not unique to SSRS--a poorly written Crystal query could cause the same problem.
The second question is not an issue--it's normal. Whether you build you report in Crystal or SSRS, and underlying change to the data that the report references will cause problems (example: you delete a field the report is referencing). Adding fields will not normally cause any problems. Resizing fields could cause problems with your report depending on the size of the field on the report. It would be a good idea to run tests on your reports if you make significant changes to the tables and data they access to validate your queries and report layout. CRAIG CARTER -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wall, Frank Sent: Thursday, May 04, 2006 9:56 AM To: arslist@ARSLIST.ORG Subject: Re: Questrion on Microsoft SQL Reporting Services and Remedy All, Thanks Craig and Carl for your input. I do have two more questions that have came up. 1. Has anyone seen any issues of query conflict between SQL Reporting Services and the AR Server? 2. Also, has anyone ran into issues with views and tables being regenerated on changes made to Remedy that causes SRS to have any issues? Thanks, Frank Wall Administrator -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carter, Craig J Civ ARPC/DPD Sent: Thursday, May 04, 2006 8:16 AM To: arslist@ARSLIST.ORG Subject: Re: Questrion on Microsoft SQL Reporting Services and Remedy I agree wholeheartedly with Carl's comments below. We have been using SQL SRS for months now accessing the database directly using the SQL driver versus ARODBC. We did develop SQL functions to convert the integer date values stored in Remedy to regular datetime values. It works great and is fast. When accessing the data directly, Remedy will not check permissions for you so you need to ensure only authorized people have access to the reports. This is easy if you call them from Remedy since you can control access to the forms and workflow. Additionally, you can set up permissions within SQL SRS Manager. It's a great alternative to Crystal Reports and we have it loaded on our midtier server for web reporting. The user clicks a button and their report is delivered in PDF format ready to print or save. CRAIG CARTER -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jones, Carl Sent: Thursday, May 04, 2006 6:59 AM To: arslist@ARSLIST.ORG Subject: Re: Questrion on Microsoft SQL Reporting Services and Remedy Frank: The ARODBC driver tends to be sort of flaky under the best of circumstances. I gave up trying to use it with Reporting Services. I have been using Reporting Services against my ARSystem database quite successfully. Use the MS-SQL driver and query against the views rather than directly against the tables. This gets you nice names to deal with. The only problem is with timestamps in ARSystem which are stored as integers rather than SQL date/time values, but a couple of short functions takes care of that. Risk-wise there is none since you are doing only select queries to pull out data, and you're not doing anything that the database system is not designed to do. Carl A. Jones ThyssenKrupp Elevator Desk - (901) 365-5656 x5250 Mobile - (901) 210-1369 ------------------------------ > Date: Wed, 3 May 2006 11:32:01 -0400 > From: Frank Wall <[EMAIL PROTECTED]> > Subject: Questrion on Microsoft SQL Reporting Services and Remedy. > > All, > > I have a couple of questions for any one that has used MS SRS with Remedy. > > 1. Is there a way to have SRS to use a ARODBC connection? > > 2. If a ARODBC connection can not be used, what would be the risk if > any > in using a SQL connection directly? > > Thanks in advance for any input on questions I have. > > Thanks, > Frank Wall > Administrator ________________________________________________________________________ ____ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org