Hi All,
I realised that getting sparkline in Visual studio 2008 is not so easy. So I downloaded report builder 3.0 and run the table with sparkline. I was happy that I was able to run it.
But when I tried to save this report and access it through visual studio 2008 it would give me the below error.
"The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded."
To resolve this issue..I followed the below steps
1. Open another running report xml code in visual studio and copy the first 2 lines ..I had the below
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
I realised that getting sparkline in Visual studio 2008 is not so easy. So I downloaded report builder 3.0 and run the table with sparkline. I was happy that I was able to run it.
But when I tried to save this report and access it through visual studio 2008 it would give me the below error.
"The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded."
To resolve this issue..I followed the below steps
1. Open another running report xml code in visual studio and copy the first 2 lines ..I had the below
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
I later got the error message as stated below
"Deserialization failed: The element 'Report' in namespace
'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' has
invalid child element 'ReportSections' in namespace
'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition'.
List of possible elements expected: 'Description, Author, AutoRefresh,
DataSources, DataSets, Body, ReportParameters, Code, Width, Page,
EmbeddedImages, Language, CodeModules, Classes, CustomProperties, Variables,
DeferVariableEvaluation, ConsumeContainerWhitespace, DataTransform, DataSchema,
DataElementName, DataElementStyle' in namespace
'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' as
well as any element in namespace '##other'. Line 4, position 4."
For this deleted the lines that contained
<ReportSections>
<ReportSection>
and </ReportSections>
</ReportSection>
Bingo!
I was able to open the reports made in report builder 3.0 in Visual studio 2008
hi, i already done this, but still getting error
ReplyDeleteWarning 1 Deserialization failed: The element 'DataSet' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' has invalid child element 'SharedDataSet' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition'. List of possible elements expected: 'Fields, Query, CaseSensitivity, Collation, AccentSensitivity, KanatypeSensitivity, WidthSensitivity, Filters, InterpretSubtotalsAsDetails' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' as well as any element in namespace '##other'. Line 173, position 8. 173 0
I am also having this issue. Any thoughts?
DeleteTry and change the dataset for the report from shared dataset to embedded dataset. Save and apply the workaround from the article.
DeleteSorry..checked this after a long time..were you able to fix the issue?
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteI loved your tip.
ReplyDeleteWorked exactly as you said. Fantastic!
I am happy that my tip helped in resolving your issues :)
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteBrilliant mate! Thank you!!
ReplyDeleteYou are welcome :)
DeleteThank you my man, Great..!
ReplyDeleteWorked for me! Thank you!
ReplyDeleteI confirm, you solution works fine! Thank you! Save my life!
ReplyDeleteHi, I tried your solution, it works if I don't save the file. But the problem is, when I save .rdlc file after modifying as per your instructions, it saves with the older namespace. What is the reason for this?
ReplyDelete