Reporting Services 2005 report deployment using Reporting Services 2003

Hi,

I have a problem. I have certain reports designed in reporting Services 2005. Can the same be deployed through Reporting Services 2003.

Thanks in advance.

No. Reports made in later versions are not directly backwards portable to previous versions.

Reporting Services 2005 - Simple Q

Hi All,

We have an installation of 2005 on Win box. We have deployed reports in one folder Folder A and some reports in a subfolder of A called B.

Now we have put integrated windows authentication. I have edited the security of sub folder B and just provided login to User X. The main folder A has both users X and Y as users, X being content manager and Y being Browser. But whenever I login as User Y I still see the sub folder.

Is there any way to hide that folder?

Also to mention that both users X and Y are part of BUILT IN \ Adminsitrators group

Thanks

Manbish

This is behavior is because we try to prevent you from locking yourself out of the report server.

It is documented here: http://msdn2.microsoft.com/en-us/library/ms157255.aspx

Hope this helps,

-Lukasz

Reporting Services 2005 - Problems displaying a report via a ReportViewer control.

I have a report that displays fine in VS 2005 (in the Preview tab), and if I hit it via a URL in IE as a deployed report. However, when I embed it in a ReportViewer control for display on a web site, I get no data back for the report. I am using an Oracle database for the data source. None of the the logs in reporting services show anything wrong, there are no events in the event viewer to indicate any problems, Oracle logs also show no problems and no errors are returned to the page when the "View Report" button is clicked.

Anyone out there have a clue? I certainly don't.

Mike

The web site is executing the report viewer control with a certain (ASP.NET) user context. Most likely this account does not have any permissions to access the installation of the Oracle client software (or the Oracle client software is not installed at all on the web server).

Check this KB article for more details how to configure directory security: http://support.microsoft.com/?kbid=870668

-- Robert

|||

I thought the same thing at first, but permissions checked out fine. I found out that the problem is a rather esoteric interaction of Div and Table HTML element display characteristics during report generation (at least that's what the MSDN article says at http://msdn2.microsoft.com/en-us/library/ms252090.aspx).

The gist of it is that when you have the ReportViewer control properties set to render Asynchronously and have the height set to a '%' value (I was using 100%), the calculated height passed in the HTML is set to '0' so no report displays. You have the choice of using a fixed height and Asynchronous rendering or a percentage height and synchronous rendering.

Mike

|||

Thanks for posting your findings!

-- Robert

sql

Reporting Services - Overload and OutofMemoryException - Workaround?

We're having a good bit of trouble with a deployed report overloading
the server during times of heavy use. The report renders directly
from an external app to Excel, running the report by way of URL. I
haven't found any tuning that helps us - we have about 1200 clients
who try to run the report in a 2-hour span. Sometimes it seems like
they're all hitting it in the same 10 minutes. I can see the activity
in the performance monitor. Once active report requests reach 40 or
so, we usually get an OutOfMemory exception and RS recycles. It picks
back up, but the users who were waiting all get errors.
I couldn't find a metering option to force requests into a 'holding'
queue if active requests reach a threshold, so I'm trying to build a
workaround. I'm posting the basics of it here, in case it might help
anyone else.
' This code will go into the page that redirects users
' to the report. The page will either prompt the user
' to refresh or will have a refresh META tag
Dim rs As New sqlrpts.ReportingService
rs.Credentials = New System.Net.NetworkCredential _
("userid", "password", "domain")
' or - System.Net.CredentialCache.DefaultCredentials()
Dim jobs As sqlrpts.Job
Dim intx As Int16 = 0
For Each jobs In rs.ListJobs
intx = intx + 1
Next
' If intx is above the threshold we'll set (probably 25-30),
' we'll display a 'please wait' message. Otherwise, we'll
' redirect to the report URL
If anyone knows a better way around this, please reply on this thread
or email me.
Thanks!
Tim ShayHi Tim,
Just need to check with you quickly, which counter are you using to
determine the OutOfMemory exception and RS recycle?
Also, have you tried using ACT to test the report URL and see how many
RPS it can process? Coz we're having similar problem and is wondering
why RS cannot process concurrent user requests for the web application
we're developing.
Appreciate your input, thanks!
CCC
tshay@.foodlion.com (TShay) wrote in message news:<1fe4fd2c.0409100828.795a3ae3@.posting.google.com>...
> We're having a good bit of trouble with a deployed report overloading
> the server during times of heavy use. The report renders directly
> from an external app to Excel, running the report by way of URL. I
> haven't found any tuning that helps us - we have about 1200 clients
> who try to run the report in a 2-hour span. Sometimes it seems like
> they're all hitting it in the same 10 minutes. I can see the activity
> in the performance monitor. Once active report requests reach 40 or
> so, we usually get an OutOfMemory exception and RS recycles. It picks
> back up, but the users who were waiting all get errors.
> I couldn't find a metering option to force requests into a 'holding'
> queue if active requests reach a threshold, so I'm trying to build a
> workaround. I'm posting the basics of it here, in case it might help
> anyone else.
> ' This code will go into the page that redirects users
> ' to the report. The page will either prompt the user
> ' to refresh or will have a refresh META tag
> Dim rs As New sqlrpts.ReportingService
> rs.Credentials = New System.Net.NetworkCredential _
> ("userid", "password", "domain")
> ' or - System.Net.CredentialCache.DefaultCredentials()
> Dim jobs As sqlrpts.Job
> Dim intx As Int16 = 0
> For Each jobs In rs.ListJobs
> intx = intx + 1
> Next
> ' If intx is above the threshold we'll set (probably 25-30),
> ' we'll display a 'please wait' message. Otherwise, we'll
> ' redirect to the report URL
> If anyone knows a better way around this, please reply on this thread
> or email me.
> Thanks!
> Tim Shay

Reporting Services - cannot connect remotely

Hi,
I was wondering if anyone could help me. Im new to SQL and Reporting
Services.
Ive created a report and deployed it to the report server. When im
logged onto that server I can view the report ok, but when I try to
view it from a workstation I get an error message
'An error has occurred during report processing.
Cannot create a connection to data source 'ICTUForms'.
For more information about this error navigate to the report server on
the local server machine, or enable remote errors '
ICTUForms is a datasource im connecting to.
Can anyone help?I'm guessing you don't have access to the report's underlying data when you
connect on that workstation. Are you using Windows anthentication? You're
probably a local admin on the server (therefore "sa" on MSSQL) when you open
a session there, so all tables are accessible.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mo" <markhayward27@.gmail.com> wrote in message
news:8353a3cb-2baa-4443-b6ab-d13d00188771@.q27g2000prf.googlegroups.com...
> Hi,
> I was wondering if anyone could help me. Im new to SQL and Reporting
> Services.
> Ive created a report and deployed it to the report server. When im
> logged onto that server I can view the report ok, but when I try to
> view it from a workstation I get an error message
>
> 'An error has occurred during report processing.
> Cannot create a connection to data source 'ICTUForms'.
> For more information about this error navigate to the report server on
> the local server machine, or enable remote errors '
>
> ICTUForms is a datasource im connecting to.
>
> Can anyone help?

Reporting Services

Anyone running Reporting Services?

I need to get it deployed and but I'm having trouble getting my brain around how it gets installed. We have a Production SQL Server instance (2000 Standard Edition) running our Main APPS and then a Sharepoint Instance on another box. Today I'm installing yet another Instance on the Shareport Database Server for CRM -

I am going to want to report against Sharepoint, CRM and Probably Exchange.. Where would Reporting Services Server get installed? On one of my SQL Servers? on a Seperate Admin Server? on my Web Server? Do I need a seperate Instance for my Reporting Services Backend Database?

Also, I have Reporting Services 2000 Developer Edition on our MSDN Subscription CDs.. Is this what I use in my Production Environment and if not, where can I download Reporting Services from? I can't find it on the MS Site.. Thanks for your help!I have set this up a few times. Total pain in the ass. You are going to need Standard or Enterprise. Standard only works on the same machine SQL Server is installed. Enterpise you can install on a web server seperate from your db server but it requires a seperate sql server liscense.

Please read the installation section of the reporting services books online as well as the read me file and the Server Deployment Checklist in the Reporting Services books Online. And there are some seperate steps when runing sharepoint and RS on the same box. You can expect some errors. some of which you will not be able to find in Google or Google groups.

have fun.|||Thank you Sean. I'm trying to see where I can get the Media from now.. We have SQL Server Standard (2000) on all of our SQL Servers... Sounds I will need to Install Reporting Services Standard on each Database Server??? what about reporting against Exchange?