CaseI receive a error when uploading my report.
Error number: 0x80048298
Information:
[CrmException: Exception of
type Microsoft.Crm.CrmException was thrown.]
Microsoft.Crm.Application.Platform.Report. InternalCreate(String xml) +721
Microsoft.Crm.Application.Platform.Entity.Create() +109
Microsoft.Crm.Application.Forms.AppForm. RaiseDataEvent(FormEventId eventId)
+408 Microsoft.Crm.Application.Forms.EndUserForm. Initialize(Entity entity) +57
Microsoft.Crm.Application.Forms.EndUserForm. Execute(Entity entity) +13
Microsoft.Crm.Web.Tools.ReportProperty. ReportPropertyPage.ConfigureForm() +202
Microsoft.Crm.Application.Controls.AppPage. OnPreRender(EventArgs e) +30
System.Web.UI.Control.PreRenderRecursiveInternal() +62
System.Web.UI.Page.ProcessRequestMain() +1499
Problem I made a mistake and created a report in VS2005 instead of VS2003. How could I change this?
Gary Cowan gave a real good tip on :
http://sqlservertipsandtricks.blogspot.com/2008/06/converting-reporting-services-ssrs-rdl.htmlbut it wasn’t really complete for my case. In the end it turned out I had to change the document as following.
SolutionIf you want to convert a SSRS rdl from 2005 to 2000, you can try the following
1) Open the .RDL file in a text editor and change the XML.
2) Change the first node to look like this:
Report
xmlns=”http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition”
xmlns:rd=”http://schemas.microsoft.com/SQLServer/reporting/reportdesigner”
3) Do a search for “Interactive” You should find 2 nodes InteractiveWidth and InteractiveHeight. You need to delete these nodes.
4) The XML in the RDL file is different between 2005 and 2000 when you want to pass parameters to a SQL procedure.
In 2000 they pass parameters this way in the RDL file. I used
< Query>
< CommandType> StoredProcedure< /CommandType>
< CommandText> =”procGetInvMovement”< /CommandText>
< QueryParameters>
< QueryParameter Name=”@BegDate”>
< Value> =Parameters!pBegDate.Value< /Value>
< /QueryParameter>
< QueryParameter Name=”@EndDate”>
< Value> =Parameters!pEndDate.Value< /Value>
< /QueryParameter>
< /QueryParameters>
< DataSourceName> JLG SQL< /DataSourceName>
< /Query>
and in 2005 they do it this way:
< Query>
< rd:UseGenericDesigner> true< /rd:UseGenericDesigner>
< CommandText> =”Execute procGetInvMovement ‘” & Parameters!pBegDate.Value & “‘, ‘” & Parameters!pEndDate.Value & “‘”< /CommandText>
< QueryParameters>
< QueryParameter Name=”pBegDate”>
< Value> =Parameters!pBegDate.Value< /Value>
< /QueryParameter>
< QueryParameter Name=”pEndDate”>
< Value> =Parameters!pEndDate.Value< /Value>
< /QueryParameter>
< /QueryParameters>
< DataSourceName> JLG SQL< /DataSourceName>
< /Query>
Notice how they don’t include the parameters in the commandtext tag in 2000
5) Delete the CommandType-tag if you want to use a query
6) In to the 2000 version of the .RDL file. You will need to add this line:
StoredProcedure after the first tag.
7) In the ReportParameters don’t use the tag Hidden
THIS IS NOT SUPPORTED SO I WOULD BACKUP YOUR REPORTS BEFORE ATTEMPTING THIS AND USE THIS ADVICE AT YOUR OWN RISK.
Posts
