Showing posts with label services. Show all posts
Showing posts with label services. Show all posts

Thursday, March 29, 2012

Deleting reports

So I've got a couple of reports deployed in reporting services 2005 and
Well I want to delete them but I have no clue how. I was wondering if
anybody could either
A) walk me through how to do it.
B) point me in the direction of some sites that explain how to do it
(I'm having no luck with google this morning)
Thanks a ton for the help.
MathiasWhere do you want to delete them from?
The server or your development project?
If you want to delete them from your server, just use Report Manager. Click
on "Show Details". Mark the ones you want to delete, and click on the Delete
button.
You'll need to be Content Manager to do it though. If you don't see the
Delete button, you don't have the rights to do it, and need to log on as a
different user.
If you want to delete them from you development project, you should be able
to right click the report in the management tool, and choose Remove. This
will let you choose between Remove or Delete. Remove means to delete the
reference in your project, but still leave the rdl file in the project
folder. Delete means delete the reference and the rdl-file completely.
Kaisa M. Lindahl Lervik
"Mathias" <mathias.helbach@.gmail.com> wrote in message
news:1141308861.584476.110140@.u72g2000cwu.googlegroups.com...
> So I've got a couple of reports deployed in reporting services 2005 and
> Well I want to delete them but I have no clue how. I was wondering if
> anybody could either
> A) walk me through how to do it.
> B) point me in the direction of some sites that explain how to do it
> (I'm having no luck with google this morning)
>
> Thanks a ton for the help.
> Mathias
>|||Kaisa
Thanks for the help. That was what I was looking for.

Tuesday, March 27, 2012

Deleting Parameter From Preview Pain

Product: Reporting Services 2005

Visual Studio 2005

I've added parameters to my query in the Data Tab. Then removed one. The preview pane still shows the deleted parameter even though it does not exist in my query. I've tried opening the dataset settings and re-adding the parameter, saving, then deleting. This ghost parameter will not disappear from the Preview Pane. Is this a bug or am I not deleting it correctly.

Thanks,

Matt

To solve your preview pane pain, you need to remove the parameter from the Report Parameters collection.

Select Report from the toolbar and Report Parameters. When you add a query parameter a Report Parameter is automatically created for you, but the same is not true when your remove query parameters.

-chris

Monday, March 19, 2012

Deleting a database

I would like to delete a database from Analysis Services from the command line, but I have been unable to find a way to accomplish this. Is there a utility or a script that can accomplish this?

Hi

In MSAS 2k ,You can a write a VBSCRIPT using DSO object in DTS for deletion of OLAPDB.Then run this DTS from DTSRUN "DTS Package name" from commnad line.

Thx and regards

Pankaj

|||

And if you are using Analysis Services 2005, you can write this C# application based on AMO (the management object model for AS2005, successor of DSO from AS2000):

(to reference AMO, use Microsoft.AnalysisServices.DLL from "%ProgramFiles%\Microsoft SQL Server\90\SDK\Assemblies")

using Microsoft.AnalysisServices;

...

Server s = new Server();

s.Connect("localhost");

try

{

s.Databases.GetByName("My Database").Drop();

}

finally

{

s.Disconnect();

}