Sunday, March 11, 2012

error in report builder

I am trying to create a filter in the report builder on reporting services. When I try to filter I get a yellow triangle with an exclamation point and cannot get a list. When i put my cursor over the yellow triangle, I get the error "the requested list could not be retrived because the query is not valid or a connection could not be made to the data source. Any idea how this can be fixed so I can get a list of values?

This usually means you have something wrong with the data source connection behind the report model. Check that your model has a data source specified, and that the data source has a valid connection string and appropriate credentials.

Hope that helps!

|||I am not sure if you found a solution to this problem, but I also ran into the same problem recently.

Currently, I am using a folder structure like:
Home>Dept>App>(Model, Datasource, Reports)

I found that by granting "View folders" at the home level to the group/user resolved the issue. I created a custom Item-Level role with just this task to restrict access, but either the Browser or Report Builder roles would work as well as they have the "View folders" task associted with them.

However, if at all possible I would like to avoid giving users access to the Home folder so if someone could explain where and why this dependency exists it would be much appericated.

No comments:

Post a Comment