Sql Server 2008 Reporting Services: Saved report in report builder 2, now cannot open. Says: Untitled.rdl, Deserialization failed
I have recently installed SQL Server on a Windows 2008 (64) bitInstalled Reporting Services.Jobs to copy Production SQL DB to this server runs every night.Everything works fine.I have upgraded several reports from older report servers (sql 2000 & 2005) No problem2 or 3 times a report suddenly cant load in report builder. It is a report which i have been working on, and uploaded to Report Server website, no problem. Then without warning, a report suddenly cannot be loaded.Even though it works perfectly in the website, i cannot load it in report builder.it cannot be loaded from disk (.rdl) either. Even though the .rdl can be uploaded to the reportserver website (web) and works here.In previous cases i just restarted with old version, but this is 4 days work wasted, if I cannot continue.When i load file (or web) in report builder i get message: "Failed to open report 'Untitled.rdl'" Details: "Attribute 'DataType' not declared. Deserialization failed: Attribute 'DataType' not declared. Line 6844 position 20' (translated from danish)I then get a new empty report instead of the 1 I tried to load.If I load the file into an editor, I get Line 6831 </ReportParameter> <ReportParameter Name="numberPrice"> <DataType>Integer</DataType> <DefaultValue> <Values> <Value>1</Value> </Values> </DefaultValue> <AllowBlank>true</AllowBlank> <Prompt>Antal og Pris</Prompt> <ValidValues> <ParameterValues> <ParameterValue> <Value DataType="Integer">1</Value> <Label>Antal og pris</Label> </ParameterValue> <ParameterValue> <Value DataType="Integer">2</Value> <Label>Antal</Label> </ParameterValue> </ParameterValues> </ValidValues>Line 6853I have no Idea what is wrong with the line: 6844 - "<Value DataType="Integer">1</Value>"Or if Report builder 2 has an error.Please advise :-)Mikaelvv
February 19th, 2010 6:05pm
The problem is that the following RDL snippet for ParameterValue elements is not valid: "<Value DataType="Integer">1</Value>". Instead it should be just: <Value>1</Value>Did you find a consistent sequence of steps of loading/editing your report in Report Builder 2 that turns a previously valid report into something invalid like the case you are describing?Thanks,RobertRobert Bruckner http://blogs.msdn.com/robertbruckner
This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
February 21st, 2010 12:21am
First THANKS. By correcting this error and 1 similar, I got my report back, (Biiiig smile)!Second sorry, I am not sure when the report went wrong, as i had it in Report builder a long time without quitting. I edited and tested in RB2, then saved to disk no problem, then uploaded to Reporting Services(web) no problem. I thought report was finished, tested in RS, quit RB2, showed to the user, who pointed out a minor change, no problem. But now i could not open report in RB2. not from disk and not from RS. I tried removing entire input parameter from source, but got new problems, and posted here.After Your reply, I changed the parameter in Visual Studio Text editor, saved, opened in RB2 Success. I then tried playing around with the parameter, as expression and not expression, but i haven't found my nemesis yet. soz.ThanksMikaelvv
February 22nd, 2010 1:34pm
I had a similar problem to this and had a really hard time trying to find out why there was an error. I found the error by trying to open the report in Report Builder V2.0, when it gave me the error, it told me what line it was on and what the
invalid item was.
In VS2008 I then right clicked on the report in solution explorer, and hit View Code. Edited the offending item, saved and Voila!
Hope this helps someone find their error quickly
Regards Phil
Free Windows Admin Tool Kit Click here and download it now
July 22nd, 2011 1:36pm