MS SSRS - Creating and copying custom palette

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.

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:

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.

MS SSRS - Gradient colour to action button

I tried to find how to apply gradient colour to textbox item and after searching options from help and internet I found an answer from the social.msdn.microsoft.com forum site. There was told that gradient colour is possible only in chart and gauge report items.

Luckily there was suggestion to create chart and set it's backgroud, hide all the chart element so that only the gradient fill is seen. I tried that then.

I set BorderSkin (Skin Type) as Raised then it looked like more as buttons in the software what for this report was done. I also named this chart as BackButton. I put my button text to chart title, because I didn't know how to get my textitem over this chart.

I needed to fix appearance of my caption and also set docking properties so that it looked fine (1). DockOffset was set to 10 and Position as TopCenter.

1. Docking settings

Then I set Action for my button text to go back to main the report page.


There is still one thing I hadn't solved, how to hide that light gray line around the button.

Back button with gradient colours.