Solved

Reporting Services - Deployment Build Events

Posted on 2008-06-16
6
466 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
  • 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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL 2000:  Shrink LDF file 11 39
Testing connection to sql 7 58
Crystal Report Grand Total in Main Report from Sub Reports 6 56
Order by but want it in specific order 2 26
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
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 …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now