Hi Grant
I aren't using report server, just opening the report in winforms.
Local.reportpath returns the name of the report ie Quote.rdl
The error I get is
"An error occurred during local report processing"
With inner exception
"The definition of the report 'Quote.rdl' is invalid"
Any ideas?
Thanks
Kirsten
The error dump is as follows;
Microsoft.Reporting.WinForms.LocalProcessingException occurred
Message=An error occurred during local report processing.
Source=Microsoft.ReportViewer.WinForms
StackTrace:
at Microsoft.Reporting.WinForms.LocalReport.EnsureExecutionSession()
at Microsoft.Reporting.WinForms.LocalReport.InternalRender(String
format, Boolean allowInternalRenderers, String deviceInfo, PageCountMode
pageCountMode, CreateAndRegisterStream createStreamCallback, Warning[]&
warnings)
at Microsoft.Reporting.WinForms.LocalReport.InternalRender(String
format, Boolean allowInternalRenderers, String deviceInfo, PageCountMode
pageCountMode, String& mimeType, String& encoding, String&
fileNameExtension, String[]& streams, Warning[]& warnings)
at Microsoft.Reporting.WinForms.LocalReport.Render(String format,
String deviceInfo, PageCountMode pageCountMode, String& mimeType, String&
encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings)
at Microsoft.Reporting.WinForms.Report.Render(String format, String
deviceInfo, String& mimeType, String& encoding, String& fileNameExtension,
String[]& streams, Warning[]& warnings)
at SoftwareByDesign.ReportGenerator.ReportEngine.MakePdf(String
reportFilename, String outputFilename, String connectionString, String
storedProcname, String ParamCount, String Param1Name, String Param1Type,
String Param1Value, String Param2Name, String Param2Type, String
Param2Value, String Param3Name, String Param3Type, String Param3Value,
String param4Name, String Param4Type, String param4Value, String param5Name,
String Param5Type, String param5Value) in
C:\Dev2\jobtalk\Reporting\SoftwareByDesign.ReportGenerator\ReportEngine.vb:l
ine 108
InnerException: Microsoft.Reporting.DefinitionInvalidException
DefaultNamespacePrefix=msrs
DefaultServerErrorNamespace=http://www.microsoft.com/sql/reportingservices
ErrorNotVisibleOnRemoteBrowsers=For more information about this error
navigate to the report server on the local server machine, or enable remote
errors
ExceptionLevelHelpLink=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=M
icrosoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=pvInvali
dDefinition&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer
=1.0
Message=The definition of the report 'SGSalesQuote.rdl' is invalid.
SkipTopLevelMessage=False
Source=Microsoft.ReportViewer.Common
StackTrace:
at
Microsoft.Reporting.ReportCompiler.CompileReport(ICatalogItemContext
context, Byte[] reportDefinition, Boolean
generateExpressionHostWithRefusedPermissions, ControlSnapshot& snapshot)
at
Microsoft.Reporting.PreviewStore.StoredReport.EnsureCompiled(CatalogItemCont
extBase itemContext)
at
Microsoft.Reporting.PreviewStore.GetCompiledReport(CatalogItemContextBase
context, Boolean rebuild, Byte[]& reportDefinition, ControlSnapshot&
snapshot)
at
Microsoft.Reporting.PreviewStore.GetCompiledReport(CatalogItemContextBase
context, Boolean rebuild, ControlSnapshot& snapshot)
at
Microsoft.Reporting.LocalService.GetCompiledReport(CatalogItemContextBase
itemContext, Boolean rebuild, ControlSnapshot& snapshot)
at
Microsoft.Reporting.LocalService.CompileReport(CatalogItemContextBase
itemContext, Boolean rebuild)
at
Microsoft.Reporting.WinForms.LocalReport.EnsureExecutionSession()
InnerException:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException
DefaultNamespacePrefix=msrs
DefaultServerErrorNamespace=http://www.microsoft.com/sql/reportingservices
ErrorNotVisibleOnRemoteBrowsers=For more information about this
error navigate to the report server on the local server machine, or enable
remote errors
ExceptionLevelHelpLink=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=M
icrosoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsProces
singError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=1
.0
Message=The report definition is not valid. Details: The report
definition has an invalid target namespace
'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition'
which cannot be upgraded.
SkipTopLevelMessage=False
Source=Microsoft.ReportViewer.Common
StackTrace:
at
Microsoft.ReportingServices.ReportPublishing.ReportPublishing.Phase1(ICatalo
gItemContext reportContext, Byte[] definition, IChunkFactory
createChunkCallback, CheckSharedDataSource checkDataSourceCallback,
ResolveTemporaryDataSource resolveTemporaryDataSourceCallback,
DataSourceInfoCollection originalDataSources, IDataProtection
dataProtection, String& description, String& language,
DataSourceInfoCollection& dataSources, Boolean& hasExternalImages, Boolean&
hasHyperlinks)
at
Microsoft.ReportingServices.ReportPublishing.ReportPublishing.CreateIntermed
iateFormat(ICatalogItemContext reportContext, Byte[] definition,
IChunkFactory createChunkCallback, CheckSharedDataSource
checkDataSourceCallback, ResolveTemporaryDataSource
resolveTemporaryDataSourceCallback, DataSourceInfoCollection
originalDataSources, PublishingErrorContext errorContext, AppDomain
compilationTempAppDomain, Boolean
generateExpressionHostWithRefusedPermissions, IDataProtection
dataProtection, String& description, String& language,
ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources,
UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean&
hasExternalImages, Boolean& hasHyperlinks)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CompileOdpRepo
rt(ICatalogItemContext reportContext, Byte[] reportDefinition, IChunkFactory
createChunkCallback, CheckSharedDataSource checkDataSourceCallback,
ResolveTemporaryDataSource resolveTemporaryDataSourceCallback,
DataSourceInfoCollection originalDataSources, PublishingErrorContext
errorContext, AppDomain compilationTempAppDomain, Boolean
generateExpressionHostWithRefusedPermissions, IDataProtection
dataProtection, String& reportDescription, String& reportLanguage,
ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources,
UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean&
hasExternalImages, Boolean& hasHyperlinks)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateIntermed
iateFormat(ICatalogItemContext reportContext, Byte[] reportDefinition,
IChunkFactory createChunkFactory, CheckSharedDataSource
checkDataSourceCallback, ResolveTemporaryDataSource
resolveTemporaryDataSourceCallback, DataSourceInfoCollection
originalDataSources, AppDomain compilationTempAppDomain, Boolean
generateExpressionHostWithRefusedPermissions, ReportProcessingFlags
processingFlags, IDataProtection dataProtection)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateIntermed
iateFormat(ICatalogItemContext reportContext, Byte[] reportDefinition,
IChunkFactory createChunkFactory, CheckSharedDataSource
checkDataSourceCallback, AppDomain compilationTempAppDomain, Boolean
generateExpressionHostWithRefusedPermissions, ReportProcessingFlags
processingFlags, IDataProtection dataProtection)
at
Microsoft.Reporting.ReportCompiler.CompileReport(ICatalogItemContext
context, Byte[] reportDefinition, Boolean
generateExpressionHostWithRefusedPermissions, ControlSnapshot& snapshot)
InnerException:
_____
From: [email protected] [mailto:[email protected]]
On Behalf Of Grant Castner
Sent: Monday, 4 October 2010 1:28 PM
To: ozDotNet
Subject: Re: Giving the client ability to design their own reports
-fromoutput of stored procedure
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/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
--
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:
