Hi Kirsten, A similar issue has happened to me when updating settings for the reportviewer control. Check that the reportpath attribute for localreport has the correct path. It will sometimes reset the path to the rdlc file. I know that I have to set the reportpath to (for example) "marketing/report.rdlc" even though both the .aspx web form and .rdlc file are both in the same directory
Kind regards, Grant On Sun, Oct 3, 2010 at 12:43 PM, Kirsten Greed <[email protected]>wrote: > 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/7bef97fb-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-40cc-a408-3d1a43ae4e33&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 > > > > > -- 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:
