Ramblings of a DBA

Tara Kizer
posts - 166, comments - 837, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

Reporting Services Tip #1

I've been working on SQL Server 2000 Reporting Services for the past couple of weeks.  I plan on blogging about my experience by providing tips.

Reporting Services Tip #1:

If you've created a report that you would like to deploy to a server without using Report Designer, you can upload the rdl file in Report Manager.

We've got a disconnected network where we can not connect to production except through the web application, Citrix, or by walking down to the production server room.  This means that we can not deploy the reports through Report Designer from our own desktop.  So, all that we need to do is copy our rdl and rds files to production then upload them to Reporting Services using Report Manager.  To see the upload file option, go to http://hostname/reports.

It's too bad that you can't upload multiple files using wild cards.  I thought about adding the reports by adding them to the appropriate tables in the ReportServer database, but I am just not interested in that headache right now since I've got a manageable number of reports at the moment.

You can also delete your reports in Report Manager.  Just navigate to the report, then click Show Details.  The RS toolbar changes when the details are shown.  You should now see a Delete and Move option.

Print | posted on Tuesday, May 18, 2004 2:03 PM | Filed Under [ SQL Server - Reporting Services ]

Feedback

Gravatar

# re: Reporting Services Tip #1

Hey Tara - I went to a presentation in Melbourne, Australia about Reporting Services last night, maybe for your problem look into a tool called "rs.exe" which runs ".rss" script files (written in VB.NET) and allows you to create folders, set permissions, and upload RDL files. The guy demonstrated it last night: see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp

I hope this helps!
5/18/2004 8:36 PM | Thomas Williams
Gravatar

# Take Outs for 19 May 2004

Take Outs for 19 May 2004
5/20/2004 1:44 AM | Enjoy Every Sandwich
Gravatar

# re: Reporting Services Tip #1

Since you have access to the Report Manager, do you have access to the Reporting Services Web Service. If so, you can use the web service to upload the RDL directly from code, either via script, or a custom VB app.
5/20/2004 12:01 PM | Brian Sherwin
Gravatar

# re: Reporting Services Tip #1

I am using reporting services WS but I don't know how to get the toolbar to show when the content is returned from SOAP API.
7/28/2004 8:53 AM | John
Gravatar

# re: Reporting Services Tip #1

I am using reporting services WS but I don't know how to get the toolbar to show when the content is returned from SOAP API.
PrimeQuote.com
7/28/2004 8:53 AM | John
Gravatar

# re: Reporting Services Tip #1

I would recommend you to use reportviewer webcontrol that comes with reporting service.... it works like a charm
8/3/2004 6:06 AM | Saravanan
Gravatar

# re: Reporting Services Tip #1

You can get this webcontrol in this folder...
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Applications\ReportViewer
8/3/2004 6:08 AM | Saravanan
Gravatar

# re: Reporting Services Tip #1


the report viewer is just an IFrame and works if you call your reports directly (not using web services).
FYI, I ended up writing my own web control that would use SOAP for calling reporting services.
There is only one issue that I am having is with "drill down" functionality, that is a bug and hopefully will be fixed by the next release.

PrimeQuote.com
10/26/2004 10:01 AM | John
Gravatar

# Reporting Services Tip #3

1/5/2005 2:03 PM | Ramblings of a DBA
Gravatar

# Reporting Services Tip #3

1/6/2005 3:57 PM | Ramblings of a DBA
Gravatar

# re: Reporting Services Tip #1

Hi,

This is vishal vidhale.I would like to know how can i show my reports on web pages by using Report Server then and then my client see all reports.

If it is possible then please give me solution as soon as possible because now i am hang out.

Thanks & Regards,
Vishal Vidhale
9325057418
2/22/2006 1:03 AM | Vishal Vidhale
Gravatar

# re: Reporting Services Tip #1

It sounds like you need to get a good book about Reporting Services. Have you developed the reports yet?
2/22/2006 9:43 AM | Tara
Gravatar

# re: Reporting Services Tip #1

Hi
This is Uday working in Infosys.I would like to know how to achieve drill down reports.
3/6/2006 10:55 PM | Uday Shankar
Gravatar

# re: Reporting Services Tip #1

Hi Guys,

I have got a unique requirement in reporting service. I have 3 parameters(name,privilege,privilegeinfo) in my report which is to be received through a web service. I just want to know whether it is possible to inculcate this if the users are going to view the reports using the URL (eg. http://hostname/reports)??? Since there is inbuilt security for RS it would be great if the above scenario can be accomplished.Any help in this regard is highly appreciated.

Thanks,

Regards,
Raja
5/19/2006 7:54 AM | Raja
Gravatar

# re: Reporting Services Tip #1

I am a Quality Engineer. I have been working on testing the reports created using Reporting Services. For the performace figures like 'how much time is required for execution of particualr report?' that i am taking from ExecutionLog table of ReportServer Database. But the problem is the time taken for execution of report is not same although we execute the same report with the same parameter and with the sane database. It has lots of variations in timings. I have tries restarting services before taking exact time? but its of no use. Can anybody guide me to take the exact timings (consistency) for the same report execution?
6/23/2006 4:33 AM | Dinesh
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET