Laurie: We have just begun to use SQL Server Reporting Services. We are using them in kind of an unusual way. What we do is build everything in Business Intelligence Development Services. We can design the report that environment. We then use VB .NET to execute the reports via a scheduled job, render them into Excel, and email them to the appropriate parties. In this scenario, the reports and distribution are all kept together in one solution. We did very much the same thing in the past with Crystal Reports. However, Crystal is a bit of a nightmare when it comes to rendering in Excel. It has a nasty habit of adding unwanted empty columns if you don't have every field lined up just so. It is also very inflexible should you want to add fields or change your SQL query. These things can be done, but you have to jump through a lot of hoops. In fact recent versions of Crystal have taken to greying out the SQL queries so you can't edit them. We also get into constant version conflict issues with Crystal. The Microsoft solution is far from perfect, but way better than what we have been working with. The more typical way of using this tool would be to use the Report Manager web based application to build the reports, set up subscriptions, security, etc. We intend to use this approach as well. We just have not gotten through the whole learning curve yet. All in all, we are quite happy with this free reporting solution. By the way, we are using SQL Server 2005 for these services. Thomas Stephen Laxar Coordinator, Hospital Information Systems Children's Hospital Oakland 510-428-3833 [EMAIL PROTECTED] The email message (and any attachments) is for the sole use of the intended recipient(s) and may contain confidential information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message (and any attachments). %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% Thur Jan 18, 2007 7:02 am From: "Lemons, Laurie" <le Subject: [MEDITECH-L] DR & SQL Server Reporting Services To: <[email protected]> From: "Lemons, Laurie" <[EMAIL PROTECTED]> Date: Mon, 15 Jan 2007 09:01:24 -0500 This is a multi-part message in MIME format. --===============1131386268== Content-class: urn:content-classes:message Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C738AD.A45130D2" This is a multi-part message in MIME format. ------_=_NextPart_001_01C738AD.A45130D2 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable We are just beginning to utilize our Data Repository and are faced with = finding a solution for writing/distributing reports. Can anyone share = their experiences, good or bad, with SQL Server Reporting Services = (either 2000 or 2005)? Thank you, Laurie Lemons Information Services Analyst/Programmer ACMH Hospital One Nolte Drive Kittanning, PA 16201 724-543-8517 [EMAIL PROTECTED] ------_=_NextPart_001_01C738AD.A45130D2 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 6.5.7650.28"> <TITLE>DR & SQL Server Reporting Services </TITLE> </HEAD> <BODY> <!-- Converted from text/rtf format --> <P><FONT SIZE=3D2 FACE=3D"Arial">We are just beginning to utilize our = Data Repository and are faced with finding a solution for = writing/distributing reports. Can anyone share their experiences, = good or bad, with SQL Server Reporting Services (either 2000 or = 2005)?</FONT></P> <P><FONT SIZE=3D2 FACE=3D"Arial">Thank you,</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Laurie Lemons</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Information Services</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Analyst/Programmer</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">ACMH Hospital</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">One Nolte Drive</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Kittanning, PA 16201</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">724-543-8517</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">[EMAIL PROTECTED]</FONT> </P> </BODY> </HTML> ------_=_NextPart_001_01C738AD.A45130D2-- --===============1131386268== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.COM. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l --===============1131386268==-- -------------------------------------------------------------------------------- Return-Path: <"Lemons, Laurie" <[EMAIL PROTECTED]>> Received: from acmh.org> by cho.org; Thu, 18 Jan 2007 07:02:10 0000 Received: from smtp2.mail.cho.org ([192.168.1.39]) by smtp2a.in.cho.org with ESMTP; Thu, 18 Jan 2007 07:02:08 -0800 X-ASG-Debug-ID: 1169132526-20fd02c10000-tQnRVc X-Barracuda-URL: http://192.168.1.39:8000/cgi-bin/mark.cgi X-Barracuda-Connect: unknown[204.202.252.254] X-Barracuda-Start-Time: 1169132526 Received: from prosonic.com (unknown [204.202.252.254]) by smtp2.mail.cho.org (Spam Firewall) with ESMTP id 88569203431E; Thu, 18 Jan 2007 07:02:07 -0800 (PST) Received: from prosonic.iserver.net (localhost [127.0.0.1]) by prosonic.com (8.13.6.20060614/8.13.1) with ESMTP id l0IEtTBY050708; Thu, 18 Jan 2007 14:56:20 GMT Received: from mail.acmh.org (mail.acmh.org [67.141.200.80]) by prosonic.com (8.13.6.20060614/8.13.1) with ESMTP id l0FE4cnB026925 for <[email protected]>; Mon, 15 Jan 2007 14:04:38 GMT X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Date: Mon, 15 Jan 2007 09:01:24 -0500 Message-ID: <[EMAIL PROTECTED]> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: DR & SQL Server Reporting Services Thread-Index: Acc4raREfEiIMhOKSUWBMTVVg5MV2g== From: "Lemons, Laurie" <[EMAIL PROTECTED]> To: <[email protected]> X-Mailman-Approved-At: Mon, 15 Jan 2007 18:21:42 +0000 X-ASG-Orig-Subj: [MEDITECH-L] DR & SQL Server Reporting Services Subject: [MEDITECH-L] DR & SQL Server Reporting Services X-BeenThere: [email protected] X-Mailman-Version: 2.1.5 Precedence: list List-Id: Email list for Meditech users <meditech-l.MTUsers.com> List-Unsubscribe: <http://mtusers.com/mailman/listinfo/meditech-l>, <mailto:[EMAIL PROTECTED]> List-Post: <mailto:[email protected]> List-Help: <mailto:[EMAIL PROTECTED]> List-Subscribe: <http://mtusers.com/mailman/listinfo/meditech-l>, <mailto:[EMAIL PROTECTED]> Content-Type: multipart/mixed; boundary="===============1131386268==" Sender: [email protected] Errors-To: [EMAIL PROTECTED] X-Barracuda-Bayes: INNOCENT GLOBAL 0.0000 1.0000 -2.0208 X-Barracuda-Virus-Scanned: by Barracuda Spam Firewall at mail.cho.org X-Barracuda-Spam-Score: -2.02 X-Barracuda-Spam-Status: No, SCORE=-2.02 using global scores of TAG_LEVEL=3.0 QUARANTINE_LEVEL=5.0 KILL_LEVEL=7.0 tests=HTML_MESSAGE X-Barracuda-Spam-Report: Code version 3.1, rules version 3.1.6519 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- 0.00 HTML_MESSAGE BODY: HTML included in message %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.COM.
To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
