All geek questions in one place

SSRS: Drop-down menu is not populated with filter in Report Builder

Whenever I try to apply a filter to an attribute that has ValueSelection = Dropdown, the pop-up menu does not populate and the error message "The requested list could not be received because the request is invalid or the connection could not be completed for the data source."

If I set ValueSelection = List, I get another error message:

An attempt was made to use the semantic query extension associated with the SQL data extension that is not registered for this report server. (Microsoft.ReportingServices.SemanticQueryEngine)

This occurs in the BIDS environment and is observed in both SQL 2005 and SQL 2008.

I have already studied articles that discussed a similar problem, but none of them apply to my case. The user account in the data source has all the necessary rights, the data can be obtained without any problems (for example, if I try to "Explore the data" in the data source view). SQL Profiler indicates that the query is not sent to SQL Server when trying to populate a drop-down list. Therefore, the query fails, it simply never executes.

+6
source share
2 answers

Your connection is not working. Try checking the connection by trying a simple table and query result.

This will allow you to test the connection before trying to do anything.

0
source

Got this problem, and in my case it was caused by an invalid connection string in the data source - instead of just having the SQL Server name, such as "SOMESQLSERVER_MACHINE", I somehow "SOMESQLSERVER_MACHINE.our.corp.domain". It should be the same thing, but then I realized that the domain is wrong, after deleting it everything works like a charm again. Nevertheless: it is always useful to start with detailed checks of your basic settings. Otherwise, it may be a problem with folder permissions in Report Manager.

0
source

Source: https://habr.com/ru/post/907960/

More articles:


All Articles