Report empty?

I have created a basic report that just shows some columns from a query, I'm using a dataadapter and the reportviewer component.

If I execute the query it calles it returns some rows, but the report is empty.

What's wrong with the reportviewer and the report objects?

I'm thinking about just using gridviews because the reports don't work, altough I'd like to use the reportviewer because it can export to excel/pdf.

Thanks.

HI,onishirox:

I can not debug it without any codes from your scenario, but you can have a check with this following walkround to make your codes work:

Binding Data to the ReportViewer Control Dynamically in ASP.NET 2.0 -

http://www.aspfree.com/c/a/ASP.NET/Binding-Data-to-the-ReportViewer-Control-Dynamically-in-ASPNET-20/1/

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be

of assistance

|||

HI,onishirox:
We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

|||

Thanks. I think the problem was that I was using sqlserver2000, seems to work ok now with sql2005.

Report Designer: Refreshing Fields VERY Slow

I have a query that uses temp tables, and the query seems to execute and
refresh fields fine, but as soon as I put in a parameter for a DateTime field
the query will run but the Refresh Fields button takes forever...like 2
hours! I think it is running my rather lengthy query without the parameters
which because of the size of the tables takes a long time.
I have tried changing the data type for the parameter from String to
DateTime and neither seem to refresh the fields quickly.
Can anything be done to refresh the fields list quicker?I thought my MSDN Universal Subscription entitled me to a response within two
days... I guess not.
"Chance" wrote:
> I have a query that uses temp tables, and the query seems to execute and
> refresh fields fine, but as soon as I put in a parameter for a DateTime field
> the query will run but the Refresh Fields button takes forever...like 2
> hours! I think it is running my rather lengthy query without the parameters
> which because of the size of the tables takes a long time.
> I have tried changing the data type for the parameter from String to
> DateTime and neither seem to refresh the fields quickly.
> Can anything be done to refresh the fields list quicker?
>

Report Builder Permissions

Hi there,

I created a System Role: Report Builder User (checked "Execute Report Definitions")

Created a folder Home/FolderName/ReportModels

Created a Report Model, deployed it to the above folder.

The are a few users we would like them to run the report model, they belong to a windows group.

I assigned The "Report Builder User" to this Group.

The issue I have that when they run the Report Builder they get a login window (which then doesn't let them to continue).

I managed to overcome this by assiging to this group a "Browser" role at the Home level.

If I remove this assignment and set it in one level underneath the Home folder they can't run the Report Builder.

We don't want them to be able to view the folders at this level, Is there any other option besides setting the Browser role at the Home folder?

Thank you,

Itzhak

I believe users need to have at least Browser permission on all the parent folders of a given folder in addition to the folder itself. So yes, they will need to have permission to the Home folder. However, this will not (by itself) allow them to see subfolders of the Home folder to which they do not have permission. So you should still be able to hide the folders you don't want them to see.

Hope this helps!

|||

That's what I thought.

Yes, it did help.

Thank you,

Itzhak

sql

Report Builder button doesn't appear....

Users must have permission to the Execute Report Definitions task (normally obtained via the System Users role) for the Report Builder button to be displayed.
--Original Message--
From: Jay@.discussions.microsoft.com
Posted At: Friday, October 21, 2005 4:01 PM
Posted To: microsoft.public.sqlserver.reportingsvcs
Conversation: Report Builder button doesn't appear...
Subject: RE: Report Builder button doesn't appear...
I have run into a similar problem on my machine. The Report Builder button
never appears in my report manager home page.
I'm using Windows 2000 workstation with SQL Server 2005 (September)
Jay
"Allan" wrote:
> Hi,
> I have the latest CTP installed. Users do not see the report builder button.
> Only members of the local admin group seem to have it displayed. Can anyone
> steer me in the right direction'
>
> AllanHow do I do this. Please explain step-by-step. This is a third explanation
I have run across. Please see text below that I posted elsewhere:
Report Builder button does not show when an upgrade to Reporting Services
2005 is completed. If a fresh install is done then no problem. I need to do
an upgrade for an existing Reports Server 2000 and want user to have the
Report Builder button. Some docuementation said to set
EnableReportDesignClientDownload to true, but did not say how to do this.
Another document said Enable Report Design Client Button is set to True in
RSWebApplication.config by default. However, this also did not show how to do
this. I need clear and exact step-by-step instructions.
"Bob Meyers MSFT" wrote:
> Users must have permission to the Execute Report Definitions task (normally obtained via the System Users role) for the Report Builder button to be displayed.
>
> --Original Message--
> From: Jay@.discussions.microsoft.com
> Posted At: Friday, October 21, 2005 4:01 PM
> Posted To: microsoft.public.sqlserver.reportingsvcs
> Conversation: Report Builder button doesn't appear...
> Subject: RE: Report Builder button doesn't appear...
>
> I have run into a similar problem on my machine. The Report Builder button
> never appears in my report manager home page.
> I'm using Windows 2000 workstation with SQL Server 2005 (September)
> Jay
> "Allan" wrote:
> > Hi,
> > I have the latest CTP installed. Users do not see the report builder button.
> > Only members of the local admin group seem to have it displayed. Can anyone
> > steer me in the right direction'
> >
> > Allan
>|||I would also appreciate some help on this. The only time I see the
button is when I'm logged onto the machine that's hosting RS.
Users that have all possible roles assigned do not see the button on
the web site.
How can I make the button visible?

Report against oracle with multiple statements

hello developers!!!!!

How I have to do a Report against oracle with multiple statements?

I need execute multiple SQL statements in the generic query designer with an oracle connection.

thanks

Maybe I'm missing something, but couldn't you just define multiple datasets in the report with one query per dataset?

If the queries have interdependencies, you could look into moving them into a stored procedure and calling the stored procedure from SSRS. You should find several threads on the regular SSRS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) discussing how to call Oracle stored procedures from SSRS.

-- Robert

|||

Robert -- slightly off topic but do you have any idea why the Query Designer would be really slow loading tables from Oracle?

There are two threads on this subject:

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

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

...maybe this deserved looking at for a fix in Katmai if it's not already done... is there an issue with multiple connections for each table that is being added or something?

Thanks in advance,

>L<

|||The query designer is actually a VS component, not an RS component. It might use the OLE DB provider but I'm not 100% certain.

|||

Thanks Brian. I might have known that the query designer was a shared component, but I haven't heard of anybody complaining about its speed except in this (report design) context.

As far as whether the query designer uses OLE DB or not... it can, and does, and when it does it is apparently fast -- against the same data.

It's just when these guys are accessing Oracle and their specified connection to this data source is *not* an OLE DB connection that they see the problem. (10-15 minutes to add a table in the designer ?!? Yuck...) I was thinking maybe the designer was trying to make a separate connection every time they pressed that "Add" button.

>L<

|||

Well, I know this won't really resolve the issue, but the shared VS query designer component is actually only supported for a particular set of OLEDB providers, as described in the following KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;811241

? Microsoft OLE DB Provider for SQL Server
? Microsoft Jet 4.0 OLE DB Provider
? Microsoft OLE DB Provider for Oracle

It is not supported for any other providers.

-- Robert

|||

Thanks for going the extra mile, Robert <s>. That totally makes sense. I will refer them to this post and stop worrying that the query designer has a bug <g>.

>L<

Report against oracle with multiple statements

hello developers!!!!!

How I have to do a Report against oracle with multiple statements?

I need execute multiple SQL statements in the generic query designer with an oracle connection.

thanks

Maybe I'm missing something, but couldn't you just define multiple datasets in the report with one query per dataset?

If the queries have interdependencies, you could look into moving them into a stored procedure and calling the stored procedure from SSRS. You should find several threads on the regular SSRS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) discussing how to call Oracle stored procedures from SSRS.

-- Robert

|||

Robert -- slightly off topic but do you have any idea why the Query Designer would be really slow loading tables from Oracle?

There are two threads on this subject:

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

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

...maybe this deserved looking at for a fix in Katmai if it's not already done... is there an issue with multiple connections for each table that is being added or something?

Thanks in advance,

>L<

|||The query designer is actually a VS component, not an RS component. It might use the OLE DB provider but I'm not 100% certain.

|||

Thanks Brian. I might have known that the query designer was a shared component, but I haven't heard of anybody complaining about its speed except in this (report design) context.

As far as whether the query designer uses OLE DB or not... it can, and does, and when it does it is apparently fast -- against the same data.

It's just when these guys are accessing Oracle and their specified connection to this data source is *not* an OLE DB connection that they see the problem. (10-15 minutes to add a table in the designer ?!? Yuck...) I was thinking maybe the designer was trying to make a separate connection every time they pressed that "Add" button.

>L<

|||

Well, I know this won't really resolve the issue, but the shared VS query designer component is actually only supported for a particular set of OLEDB providers, as described in the following KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;811241

? Microsoft OLE DB Provider for SQL Server
? Microsoft Jet 4.0 OLE DB Provider
? Microsoft OLE DB Provider for Oracle

It is not supported for any other providers.

-- Robert

|||

Thanks for going the extra mile, Robert <s>. That totally makes sense. I will refer them to this post and stop worrying that the query designer has a bug <g>.

>L<

Report against oracle with multiple statements

hello developers!!!!!

How I have to do a Report against oracle with multiple statements?

I need execute multiple SQL statements in the generic query designer with an oracle connection.

thanks

Maybe I'm missing something, but couldn't you just define multiple datasets in the report with one query per dataset?

If the queries have interdependencies, you could look into moving them into a stored procedure and calling the stored procedure from SSRS. You should find several threads on the regular SSRS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) discussing how to call Oracle stored procedures from SSRS.

-- Robert

|||

Robert -- slightly off topic but do you have any idea why the Query Designer would be really slow loading tables from Oracle?

There are two threads on this subject:

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

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

...maybe this deserved looking at for a fix in Katmai if it's not already done... is there an issue with multiple connections for each table that is being added or something?

Thanks in advance,

>L<

|||The query designer is actually a VS component, not an RS component. It might use the OLE DB provider but I'm not 100% certain.

|||

Thanks Brian. I might have known that the query designer was a shared component, but I haven't heard of anybody complaining about its speed except in this (report design) context.

As far as whether the query designer uses OLE DB or not... it can, and does, and when it does it is apparently fast -- against the same data.

It's just when these guys are accessing Oracle and their specified connection to this data source is *not* an OLE DB connection that they see the problem. (10-15 minutes to add a table in the designer ?!? Yuck...) I was thinking maybe the designer was trying to make a separate connection every time they pressed that "Add" button.

>L<

|||

Well, I know this won't really resolve the issue, but the shared VS query designer component is actually only supported for a particular set of OLEDB providers, as described in the following KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;811241

? Microsoft OLE DB Provider for SQL Server
? Microsoft Jet 4.0 OLE DB Provider
? Microsoft OLE DB Provider for Oracle

It is not supported for any other providers.

-- Robert

|||

Thanks for going the extra mile, Robert <s>. That totally makes sense. I will refer them to this post and stop worrying that the query designer has a bug <g>.

>L<

Report against oracle with multiple statements

hello developers!!!!!

How I have to do a Report against oracle with multiple statements?

I need execute multiple SQL statements in the generic query designer with an oracle connection.

thanks

Maybe I'm missing something, but couldn't you just define multiple datasets in the report with one query per dataset?

If the queries have interdependencies, you could look into moving them into a stored procedure and calling the stored procedure from SSRS. You should find several threads on the regular SSRS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) discussing how to call Oracle stored procedures from SSRS.

-- Robert

|||

Robert -- slightly off topic but do you have any idea why the Query Designer would be really slow loading tables from Oracle?

There are two threads on this subject:

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

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

...maybe this deserved looking at for a fix in Katmai if it's not already done... is there an issue with multiple connections for each table that is being added or something?

Thanks in advance,

>L<

|||The query designer is actually a VS component, not an RS component. It might use the OLE DB provider but I'm not 100% certain.

|||

Thanks Brian. I might have known that the query designer was a shared component, but I haven't heard of anybody complaining about its speed except in this (report design) context.

As far as whether the query designer uses OLE DB or not... it can, and does, and when it does it is apparently fast -- against the same data.

It's just when these guys are accessing Oracle and their specified connection to this data source is *not* an OLE DB connection that they see the problem. (10-15 minutes to add a table in the designer ?!? Yuck...) I was thinking maybe the designer was trying to make a separate connection every time they pressed that "Add" button.

>L<

|||

Well, I know this won't really resolve the issue, but the shared VS query designer component is actually only supported for a particular set of OLEDB providers, as described in the following KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;811241

? Microsoft OLE DB Provider for SQL Server
? Microsoft Jet 4.0 OLE DB Provider
? Microsoft OLE DB Provider for Oracle

It is not supported for any other providers.

-- Robert

|||

Thanks for going the extra mile, Robert <s>. That totally makes sense. I will refer them to this post and stop worrying that the query designer has a bug <g>.

>L<