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.

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.

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.

Error in Application Log

The application log keeps generating this error message and I can't seem to find any information on it. Can anyone shed some light?

Event filter with query "select * from __InstanceModificationEvent within 10 where TargetInstance isa 'Win32_Service'" could not be (re)activated in namespace "//./root/Microsoft/SqlServer/ComputerManagement" because of error 0x80041010. Events may not be delivered through this filter until the problem is corrected.

I did a quick search through the forums and here is a thread that suggests that it is could be "unisys sentinel script". Can you see if this applies to your environment and let us know? I see a couple people have posted similar questions on the web and there doesn't seem to be an exact solution.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=465291&SiteID=1

Thanks,
Sam Lester (MSFT)