CODEWITHSUNDEEP
dynamics-crm-2011
Mauro De Biasio
Mauro De Biasio

Reputation: 1146

SSRS Pre filtering on account

I'm having trouble with the pre-filtering on the account entity, I'm using crm2011 UR13 and I'm trying to run a basic report on the account entity, i tried this 2 queries:

select * from FilteredAccount as CRMAF_Account

select * from FilteredAccount as CRMAF_FilteredAccount

And no result, beside not filtering if you edit the filter the property is giving an error. I tried the same on the order but with just 1 query since i was being lazy:

select * from FilteredSalesOrder as CRMAF_FilteredSalesOrder

and this one worked fine at the first attempt.

Then I created a report on the account with the wizard, and i have the same error as I had with my custom reports.

Anyone knows if somethig went wrong during the rollup relese? enter image description here enter image description here

As I said is happening only on the account, and if there is the pre-filter. If i delete it the report runs without problems. As I mentioned is not working correctly even for Wizard - out of the box created reports on the Account entity.

Best Regards

Upvotes: 1

Views: 1005

Answers (1)

markus.skergeth
markus.skergeth

Reputation: 56

This happens when the ID field of the entity is not set to searchable = yes.

Navigate to the solution containing the entity (Settings -> Solutions, alternatively open the default solution via Settings -> Customizations -> Customize the System), open the fields subsection (in your case Account -> Fields). Find the field accountid and set the attribute searchable to Yes. Publish all customizations and it should work.

Best regards, Markus

Upvotes: 4

Related Questions