Report Builder Error

Question

Post reply

Report Builder Error

gunjan.sh

SSC Veteran

Points: 241
More actions
April 10, 2008 at 2:55 am

#185130

Hi,
I have a report builder application in my website.
On selecting the Report Builder,we get the report models.
On selecting on of the report models,i can add certain fields.
After adding the fields, i click on Filter button and add one more column which is a dropdown.
The problem i face is,after adding that column, I get the following error "The requested list could not be retrieved because the query
is not valid or a connection could not be made to the datasource" and drop down is not populated.
when i run d same query for in Query analyzer,data is retrieved in 10 secs,so it cannot be a time out problem....
I am not able to figure out exact problem.
Can anyone suggest me something for this.
Thanks.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

tbeadle SSCommitted Points: 1635 More actions · Answer 1

[font="Arial"]Hello,

The report builder has to have a link to the table that is providing the drop down list.

You need to look in the sql view port and see if it is linked in.

Regards,

Terry[/font]

MarkRSwanson SSC Enthusiast Points: 182 More actions · Answer 2

I am getting the same error with my Source Fields that are set to ValueSelection of dropdown. Can you clarify on what you mean by "link to the table that is providing the drop down list." Isn't the link setup through binding the Column and in turn binging the Entity from the DSV? I have some Entities that go against Named Queries and others that hit a table in the DSV...this does not seem to make a difference.

Maybe the answer is in your statement "sql view port and see if it is linked in." Please help direct me to where to check this.

Thanks

tbeadle SSCommitted Points: 1635 More actions · Answer 3

[font="Arial"]

There should be a tool that let's you see what the select statement is that the Report is going to use.

That's what I mean by SQL view port.

Regards,

Terry

[/font]

lindsaylarkins SSC Enthusiast Points: 114 More actions · Answer 4

Hi,

I have the same problem with filter drop downs not being populated in SSRS 2005, however in my case it is only happening to a single user which seems to rule out being a database link/security issue.

The user is in the same windows group as all others who have no problem. All the dropdowns are based on physical lookup tables which are referentially related to the main table.

I ran SQL Profiler while the user clicked on the filter dropdown and found no select from the drop down table, so it seems the request is not even getting to the database.

We use roaming profiles and when the user logs onto the PCs of those who can successfully view the filters, the problem still persists.

The above points lead me to think it may be an issue with a client component or setting related to report builder. Does anyone have an idea where I might look or what I could try changing/reinstalling?

Thanks in advance

MarkRSwanson SSC Enthusiast Points: 182 More actions · Answer 5

My problem was with permissions to the folder access in Report Manager. If I recall correctly the users that were having problems only had access to a folder under Home where their Models reside. The SQL data source lives in different folder under Home. Once I gave users Browse access to Home then it eliminated the error, seemed like a pathing situation related to permissions.

Hope this helps.

lindsaylarkins SSC Enthusiast Points: 114 More actions · Answer 6

Thanks very much Mark! - that fixed the issue.

It is odd the user could still report on the database but just couldnt get the filters populated - seems the filters use a different route in accessing the dataconnection to the report generator.

tenga SSC-Addicted Points: 432 More actions · Answer 7

I m really interested to know, how do i incorporate the report builder in our own application, hiding the titles of report manager as well as report builder. I will be glad if u could help me out.

MarkRSwanson SSC Enthusiast Points: 182 More actions · Answer 8

Please give further specifics of what you are trying to do. We have incorporated Reporting Services reports (built through VS) into our site but do not use the Report Manager UI at all. We built a bridge class that is hitting the webservices for Reporting Services. Also have a button that will launch the Report Builder so a user can save a "custom" report.

tenga SSC-Addicted Points: 432 More actions · Answer 9

Thank you so much for your prompt reply. What exactly i m trying to do is that, i have created some of ma reports through the reporting services and analysis services, some of them were static and some we can customize through the report builder.I can view these reports properly in ma report manager and report builder,so i want to use these reports which i have created(static as well as Customized ones) in my own application in ASP.net and of course with the backend SQL(2005) and don't want to show the titles of report builder as well as report manager and would like to have some of my own custom controls for report builder, hiding the in-built controls of report builder.Thank u again for your time and reply.