BIDS Pre-filtered Report: Default filter is blank within Dynamics RRS feed

  • Question

  • I have created a pre-filtered report in BIDS.

    I have set a default filter which works when run within BIDS.

    I upload the report to my test CRM (online).

    The filter is completely blank and the data was not filtered by the default.

    I can't see an error and I have done pre-filtered reports before.  There doesn't seem to be a way to figure out what I have done wrong here.

    Any ideas?

    Tuesday, March 4, 2014 2:50 PM

All replies

  • This happened with me too, there might be some issue while connecting to database. Check the database connection string, User credentials.

    Points needs to be checked :

    1)  Filter --> Default values --> Select Specify Values and Value contains some data.

    and try to delete the filter and recreate new one and specify the values and then upload. It worked for me.

    Friday, March 14, 2014 11:33 AM