November 3, 2010 at 12:38 pm
You cannot vote on your own post
0
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 in advance
kumar
November 3, 2010 at 1:16 pm
I'm not certain how that worked to begin with but I know 2008 changed how it handles certain nodes.
Also, I assume your RDL is redacted as it is missing some tags, such as </DataSet> but I will try to provide a revised snippet:
<?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>
So a potential revised Dataset node would be listed as:
<DataSet Name="ABC_sp">
<Fields>
<Field Name="NAME">
<DataField>NAME</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="CITY">
<DataField>CITY</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
</DataSet>
The width parameter, would do nothing in this location as it is defining the interaction with the datasets, not the actual layout of the RDL.
That would be located within the <ReportItems> node, such as:
<ReportItems>
<Tablix Name="Tablix1">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>2.4132in</Width>
I hope this helps. Please feel free to provide examples of how it used to impact the report and I would be happy to look further.
November 3, 2010 at 3:07 pm
Jeff,
Thanks for reply.
Our reports are Customized in ssrs 2005 now we should migrated to ssrs 2008 version and those reports need to have that piece of code. I mean
schema:- xmlns:tm="uri://doesntmatter/"
<DataSet Name="ABC_sp">
<Fields>
<Field Name="Name" DataType="String" Width="1.5">
<DataField>Name</DataField>
</Field>
I just customized the code by adding couple of things
1) By adding a schema to rdl file
2) by declaring the schema infront of the datatype and width.
its resolved the my solution but even though i am not see the data.
Please help me out with this issue!!!!!!!!!!
Thanks,
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply