SSRS – Report Builder Parameter Error when using a SharePoint List

Some time back I was struggling to get a Parameter working for a SharePoint list.

The report had 2 datasets, and the parameter had to come from the second dataset. Which was a Calculated Feld using a LOOKUP FIELD by the way.


So the BU parameter was a lookup value from the second dataset PROJECTS. So I though just as straightforward a calculated field to the primary dataset and that’s it.

But apparently it a parameter does not accept a calculated field that hold a lookup function Sad smile


Solution :

Remove the calculated field from the primary dataset.

Go to the TABLIX Properties and go to FILTERS, and add the Lookup Field expression there to filter the returned items in the list.


It is working well now.


Done !


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: