Skip to main content

Is it possible to remove a report completely from Acumatica if it was saved to the server by using the command “Save to Server” in Report Designer.

I tried searching for the reports in the Acumatica folders including ReportsDefault but coming up empty.

I assume it is located somewhere in the database.

 

Much thanks

@Nelson Yip you should be able to see any versions you saved on the individual report under report versions. You can also reset back to the system default report by removing all of these entries. If you are just looking to get back to default

If you want to completely remove the report, you can remove the entry in the site map

 

 


@ccleary , yes I can remove the site map, but I want to delete it completely off the server or database.

 

 


@ccleary , the report is in the server but I get this error message.

 


If you have access to the database, you can remove the record from the UserReport table, but I’m not sure if it’s possible to remove it through the front-end anymore.


@Nelson Yip I was going to suggest what @TimRodman  said you can remove it from the SQL table.

You can do this in the cloud by creating the script in a customization project, and publishing


 


Thanks @TimRodman and @ccleary !!

 


what is the script need to look like?  sql statement? delete from userreport where name like “deleteme”?
sorry new to acumatica as we are getting ready to deploy.


what is the script need to look like?  sql statement? delete from userreport where name like “deleteme”?
sorry new to acumatica as we are getting ready to deploy.

 

I would include CompanyID to be sure I’m only deleting from the Tenant I want to remove it from.

DELETE FROM UserReport WHERE CompanyID = x AND ReportFileName = 'xxxxxxxx.rpx'

 


thanks ​@Graeme Laughton-Mutu having to re-learn with training wheels


Reply