I want to mass delete old reports that haven't been run in over a year. I am not a developer and do not want to learn IDE Eclipse. Is there another way using the DataLoader?
With the summer 14 release, You can delete mass reports in salesforce.
In Setup, under Data Management > Mass Delete Records, select Mass Delete Reports and configure a filter to find reports that need to be deleted. Reports that you delete go into the recycle bin. They aren’t permanently deleted until you clear your recycle bin.
Note: You can’t mass-delete reports that are scheduled or are used in dashboards or analytic snapshots.
Edit - this answer is obsolete as of Summer'14, please check varun's one instead.
DataLoader won't help you because the
Report table is not "deletable".
If you have exported a list of obsolete Report Ids (for example last run date over 1 year ago) you can use a simple trick to wipe them.
https://na1.salesforce.com/(report Id)?delrep=1 and it will attempt to delete it (
delrep is the name of "Delete" button on the report page). If you're familiar with clickety-click tools like Selenium - awesome, otherwise generate links in Excel and ask an intern for assistance ;)
It will still fail if report is used on a Dashboard and as far as I know fastest way to detect such dependency is Eclipse / Metadata API (because you just search directory full of XMLs looking for
Report_Name_With_Underscores)... It's a very good initial sweep nonetheless.
I had to delete 1,200 reports that weren't run since 13 months (out of 4,000 total), that would be too horrible deployment to do with Eclipse (and if it'd fail every time it hits "used in Dashboard" I'd go nuts). Hardly anybody noticed (mostly developers who suddenly got faster response times in Eclipse ;)).
Happy to be proven wrong, but from what I've read, it isn't possible with the Data Loader.
You need to move all the reports into a single folder and them delete them in that folder via the Force.com IDE (or Eclipse).