Deleting reports in report builder

[sticky]

Apologies if this is a dumb question, but...

How do you delete reports in Report Builder?? I'm running version 3.5, have created some reports that I want to junk. I could delete them manually in the DB, but I'd rather use the 'correct' procedure, which I would have thought would be a delete option in the report builder. Problem is I can't seem to find one!

Michael

[sticky]

I just started on writing a stored procedure to use to delete reports - and it occurred to me that you most likely have one already, as the previous version of Report Builder included the option to delete reports. If so, would you be able to share it with us?

I see creating a report also creates a view, so that'll have to be deleted also.

Report Builder doesn't seem to handle the views being renamed (via the Report Builder interface) very well. I've tried renaming a few, but instead of renaming exist database entries or views - it creates new entries/views. So as a result I've got a lot of orphaned database entries and views :-(.

[Hemoco]

sticky wrote:
I just started on writing a stored procedure to use to delete reports - and it occurred to me that you most likely have one already, as the previous version of Report Builder included the option to delete reports. If so, would you be able to share it with us?.

The sql was coded in the application.

Something like

"delete from tsysreportsoftware where homepagequery = @viewname"
"delete from tsysreportserver where homepagequery = @viewname"
"delete from Tsysreporthomepage where homepagequery = @viewname"
"delete from tsysreporthardware where homepagequery = @viewname"
"delete from tsysreportgeneral where homepagequery = @viewname"
"delete from tsysreports where reportquery = @viewname"

[Hemoco]

Remove from tables : tsysreports,tsysreportgeneral,tsysreporthardware,Tsysreporthomepage,tsysreportserver,tsysreportsoftware

[lhawk]

If you know how to navigate through the database you can delete the created reports there. I have my DBA do it for me when I don't want a report anymore. Cheers

[jbcsystech]

Agreed, if I just knew which entries to remove, that might work well enough for me.

[sticky]

Cool that'd be great. In the meantime, would you be able to provide us with the database entries that need to be removed to cleanly delete a report? I've found some entries, but not sure if I've found them all.

Thanks
Michael

[Hemoco]

This was deleted out of the last version to make sure people don't shoot themselves in the foot. (which they did a lot)

I'll see if we can add this feature again in a next version with some extra precautions.

[jbcsystech]

I'd like to know the same thing. It's nice that I can have lots of reports, but if I don't like one I've been messing around with how do I get rid of it?