There are some preset palettes in Report Designer to use in charts. I did custom palettes because the variety of colours is not enough in preset palettes. I needed more than 10-13 different colours to the charts. I designed the custom palette using a colour pair system. In that system dark and light shade of same colour make one pair. That way bars in the chart or slices in the pie would be easier to recognize.
This blog is for all those who are interested in practical advices, tips and tricks I've learned when creating data warehousing, data modeling and reporting solutions using IBM Cognos and Microsoft SQL Server technologies.
Showing posts with label Code View - SSRS. Show all posts
Showing posts with label Code View - SSRS. Show all posts
10/31/2010
10/11/2010
Errors while loading the designer - fixed in code view
During these months when I have build reports with Reporting Services, I haven't got many error messages but here is one that I met today...
I got following error message when I tried to open report file in Reporting Services designer:
I could open report file in code view by right-clicking report and choseing "view code". I scrolled to that part of the code which was metioned in error message; line 4921, position 20. Error was in prompt parametervalue command/rule: DataType= "Integer".
Line was: <Value DataType= "Integer">0</Value>
I removed that text ' DataType="Integer" --> <Value>0</Value>
After this correction report could be open in design view.
I got following error message when I tried to open report file in Reporting Services designer:
One or more errors encountered while loading the designer.--- The errors are listed below. --- Deserialization failed: The 'DataType' attribute is not declared. Line 4921, position 20.
I could open report file in code view by right-clicking report and choseing "view code". I scrolled to that part of the code which was metioned in error message; line 4921, position 20. Error was in prompt parametervalue command/rule: DataType= "Integer".
Line was: <Value DataType= "Integer">0</Value>
I removed that text ' DataType="Integer" --> <Value>0</Value>
After this correction report could be open in design view.
Subscribe to:
Posts (Atom)