markus.krenn (3/26/2009)
Hi Boyan Penev,why do you need parameters?
Your Resultset of the StoredProcedure has only one row containg the value of the colors. So, my meaning is that you can use an expression like this in the color-Property:
=First(Fields!HeaderColour.Value, "usp_CTL_Get_Report_Colours")
Then also the disadvantage of the parameters is eliminated.
With kind regards,
Markus Krenn
This would be fine if it was only to be used in the report body, but you cannot access datasets like this for headers and footers hence for these you would have to store them in parameters (or in hidden textfields in the main report area that were then accessed by name from the header and footer).
BR,
Mark
SQL Novice - Here to learn.