Issues with Migrating SSRS 2005 to SSRS 2008
Hi All,
Our Team working on migration of reports. But in our SSRS 2005 reports RDL's they added small piece of code(Highlighted) in
eg:
********************************************************************************
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">
<DataSources>
<DataSource Name="xyz">
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>="server=" + Parameters!ServerName.Value.ToString() + "; database=" + Parameters!Database.Value.ToString() + ";"</ConnectString>
</ConnectionProperties>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="ABC_sp">
<Fields>
<Field Name="NAME"
DataType="String" Width="1.5" >
<DataField>NAME</DataField>
</Field>
<Field Name="CITY"
DataType="String" Width="1.0" >
<DataField>CITY</DataField>
</Field>
</Fields>
</DataSets>
***********************************************************
In code we customized the DataType="String" Width="1.5"(Included)
when we trying to migrating the report to 2008, But its dropping these things and also i tried to overwrite in 2008 R2 but nothing is supporting to this piece of code and its showing the error as
Error: The 'DataType' attribute is not allowed and The 'Width' attribute is not allowed
So please give me the suggestion or solution for this problem.
Thanks,
kumar
November 1st, 2010 12:17pm
Hi kumar,
The field data type on the report is inherited from the dataset query, and does not support any custom via editting its xml code. If you have any concern, please submit a feedback at
https://connect.microsoft.com/SQLServer/Feedback .
thanks,
Jerry
Free Windows Admin Tool Kit Click here and download it now
November 4th, 2010 2:42am