Prev: Report Manager Virtual Directory disabled
Next: Issue with Default Parameter
From: Dan White on 23 Jun 2008 16:19
If you're still looking for an answer, I had the same problem. I found
one solution was to give the user select permission to the tables that
the filter list is coming from. This seemed like a bit of a hack, but it
worked.

In my case, my DSV was using SQL views to which the user had select
permission, but apparently Report Builder is going directly to the table
involved. The user did not have select permission directly on the table.
When I gave the user db_datareader access to the database the filter
dropdowns populated.

If someone else has a more precise explanation of what's happening, I'd
be interested in hearing about it.

dan

In article <2cb3fa37-0398-4a58-a065-
5c73ea7cac7e(a)m73g2000hsh.googlegroups.com>, leejmooney(a)googlemail.com
says...
> I have a data source view that is sourcing all of its data from a
> relational database star schema. No data is being provided by analysis
> services databases. The report models are being deployed to a non-SSL
> environment.
>
> Creating the data source connection is not problem, and once tested,
> the connection is confirmed successfully. Creating the data source
> view (DSV) causes no problems. Generating the report model from the
> data source view creates no problems. The report model deploys to the
> report server with no problems. I can connect to the model through
> report builder with no problems.
>
> I can create and run a report, without parameters? you?ve guessed it?
> with no problems. However, if I choose to filter the report content I
> do get a problem! Even though I?ve just run the report based on the
> data source connection, the report builder is unable to populate my
> drop-downs and lists, giving the following error:
>
> ?The requested list could not be retreived because the query is not
> valid or a connection could not be made to the data source?
>
> I don?t see how the report can return data but the tool cannot build
> it?s drop-downs and lists. I?m convinced I?ve overlooked something
> simple but can?t find what it is, and I;ve been looking into it for
> days!
>
> Any help would be greatly appreciated!
>
 | 
Pages: 1
Prev: Report Manager Virtual Directory disabled
Next: Issue with Default Parameter