CODEWITHSUNDEEP
reporting-servicesssrs-2008
Richard Edwards
Richard Edwards

Reputation: 1399

Filtering reporting services dataset based on proc

I have a reporting services dataset returned from a stored proc. I'd like to further filter the data based on a parameter. I've added that filter to the dataset but it's still giving me all of the data. Does filtering work with a proc based dataset or just with a cmd text based select statement?

Before I get bombarded with 'just add the fourth parameter to the proc' type answers, this isn't an option in this case otherwise believe me, I'd prefer that solution.

Upvotes: 0

Views: 1179

Answers (1)

Richard Edwards
Richard Edwards

Reputation: 1399

I have it figured out I think but I'm not sure why it's doing what it's doing. When I look at the data from the stored proc using sql management studio, the data field I'm trying to filter looks fine, no added spaces etc. For instance I can do WHERE field1 = 'Loaded' and it filters fine there. When I add the filter into reporting services on the dataset, I had to do a trim on the field for it to match. It seems as though reporting services is added spaces to the data for some reason.

For instance I had to do,

trim(Fields!ReportDepartment.Value)=trim(Parameters!department.Value)

for it to match.

Anyone else had this issue?

Upvotes: 1

Related Questions