SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Report Builder Error


Report Builder Error

Author
Message
gunjan.sh
gunjan.sh
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 56
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.
tbeadle
tbeadle
SSC-Enthusiastic
SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)

Group: General Forum Members
Points: 173 Visits: 206
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

MarkRSwanson
MarkRSwanson
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 104
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
tbeadle
SSC-Enthusiastic
SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)

Group: General Forum Members
Points: 173 Visits: 206

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

lindsaylarkins
lindsaylarkins
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 24
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
MarkRSwanson
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 104
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
lindsaylarkins
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 24
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
tenga
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 Visits: 32
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
MarkRSwanson
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 104
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
tenga
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 Visits: 32
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search