Solved

Reporting Services - Deployment Build Events

Posted on 2008-06-16
6
472 Views
Last Modified: 2012-05-05
Is there any posibility to delete report on report server during deployment from Visual Studio - e.g. via some utility during build events? We are talking about 2005 version.

I found similar thread here
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2279928&SiteID=17
0
Comment
Question by:srnar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 4

Expert Comment

by:zx10r
ID: 21795657
If you need to delete a report on the report server go to http://localhost/reports. Navigate to the report folder and click the button labeled Show Details. You will get check boxes next to your reports, you can then just check the ones you need to remove and click delete.
0
 
LVL 8

Author Comment

by:srnar
ID: 21796469
Yes, but I am looking for an automated way during the report deployment. We have number of Reporting services projects (with different paths to different report servers) and we want to service them fully from Visual studio.

We want to minimize administration via Web GUI (changing of defaults, datasources etc.). Of course we can delete all reports at once via .Net script - but this is not "automated deployment process from Visual studio".
0
 
LVL 18

Expert Comment

by:chrismc
ID: 21800210
I suggest setting up a SQL Trace on the ReportServer database and then try deleting a report by hand as suggested by zx10r or doing directly in SQL Management Studio (SSMS) then look at the trace and see what stored procedures were called.
It will all be done through Stored Procedures so it's just a case of reverse engineering.


0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 8

Author Comment

by:srnar
ID: 21800353
Thanks to all but none of these fits to my requirement. To chrismsc: there is a rich web service interface for reporting services administration - I don't want to use private reporting services stored procedures.

Back to the topic: we would like to have one integrated deployment process.

There may be another solution: use a deployment utility that may have own configuration (e.g. NAnt, RSBuild).

Do you have some recommendation? Here are some extra questions:
1. How easy it is to use as a central report deployment utility
2. Is it able to run extra commands before and after a report deployment (eg. via Exe or DB call). RSBuild has a collection of DBExecutions - but I don't know if they are executed prior or post deployment.
3. Is it able to read configuration from Visual Studio projects (e.g. path for testing, production deployment)? RSBuild is not able.
4. What are costs of such a tool?
0
 
LVL 18

Accepted Solution

by:
chrismc earned 125 total points
ID: 21800525
Hi srnar,
I take your point.

I think this is probably more of a .Net question. I tend to use SSRS "out of the box" and I guess most people monitoring this zone would probably tackle this from the SQL end of things.

I wasn't aware of RSBuild which sounds interesting. It looks like it's open source so maybe some of your requests can be added to it?

Using the supplied stored procs is what all these other tools are doing. So if you can't get the control you want from these tools, this approach may be the only way to provide the control you want. SSRS isn't that hard to reverse engineer generally.


0
 
LVL 8

Author Closing Comment

by:srnar
ID: 31467590
There is no solution via build events simply because they are missing in Reporting Services Projects. RSBuild utility provides a solution although not as flexible and with necessary coding in .Net.

Points rewarded for saying thanks.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question