Yes, i have 4 tables each with their own dataset. The are placed directly beneath each other (no spaces), with a page break at the end of each table so...

Hi,

When you create a SSRS project, you can create a Share Data Set which can be used by multiple reports.

Regards,

Robbie

Found this:

Switch

(Fields!Priority.Value= 1,"1-Critical",

Fields!Priority.Value= 2,"2-High",

Fields!Priority.Value= 3,"3-Medium",

Fields!Priority.Value= 4,"4-Low",

Fields!Priority.Value= 5,"5-Question")

Thanks guys 🙂