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.

image

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

image

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.

image

It is working well now.

image

Done !

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: