Hi Grant and Peter
Thanks for your help I managed to do a test report on the output of an stored proc using SQL Server 2005 Express edition I was very excited when I was able to open the .rdlc file ( after renaming it to .rdl ) , move fields about and then save it. However the edited version will no-longer load in my application - which uses the report viewer to create a .pdf file Something to do with the datasource was changed by opening the file in Report Builder 3 We aren't using Reporting Services, so I am hopeful we may still be able to make it work. Kirsten _____ From: [email protected] [mailto:[email protected]] On Behalf Of Peter Gfader Sent: Saturday, 2 October 2010 2:20 PM To: ozDotNet Subject: Re: Giving the client ability to design their own reports - fromoutput of stored procedure Hi Kirsten, Report builder is an awesome tool for end users to write and change reports. Little gotcha that bit me 3 weeks ago Report Builder 3.0 is for SQL Server 2008 R2 Reporting Services *ONLY* http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/7bef9 7fb-64b5-4c34-bcc4-5e62310e1ae3 I wasn't aware of that ... took me a while of manual hacking in XML to get it deployed on SSRS 2008. .peter.gfader. http://blog.gfader.com On Sat, Oct 2, 2010 at 11:21 AM, Grant Castner <[email protected]> wrote: Hi Kirsten, One option is Microsoft's Report Builder. I trialled an earlier version and it looked good. Version 3 has some new features similar to Office 2010 (e.g. sparklines) From the web site - "Microsoft SQL Server 2008 R2 Report Builder 3.0 provides an intuitive report authoring environment for business and power users. It supports the full capabilities of SQL Server 2008 R2 Reporting Services. The download provides a stand-alone installer for Report Builder 3.0." http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d3173a87-7c0d-40 cc-a408-3d1a43ae4e33 <http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d3173a87-7c0d-4 0cc-a408-3d1a43ae4e33&displaylang=en> &displaylang=en http://msdn.microsoft.com/en-us/library/dd220460.aspx Cheers, Grant On Sat, Oct 2, 2010 at 10:11 AM, Kirsten Greed <[email protected]> wrote: Hi All I am wondering about the best way to give the end user ability to write their own reports - using the output from a stored procedure. I have been designing .rdlc reports using Visual Studio 10 What would the client need to buy or download to be able to create or modify such reports ? Is there a cheaper option than VS 10? Thanks Kirsten -- Castner IT Pty Ltd Dr Grant Castner Director [email protected] 07 3102 4433 Regatta Corporate Building, 2 Innovation Parkway, Birtinya, QLD 4575 Twitter: http://twitter.com/castnerit Facebook: -- .peter.gfader. http://blog.gfader.com/ http://twitter.com/peitor
