Share
ReportHello,
Is there a way to schedule a report in RMS? Example: I want Item Quantity report to be executed @23:59hrs every last day of the month.
Thanks.
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hello,
Is there a way to schedule a report in RMS? Example: I want Item Quantity report to be executed @23:59hrs every last day of the month.
Thanks.
*This post is locked for comments
@Fernando, @Ed Boyer, Thanks for the tips!
Cheers!
Sam
I think one of the ISV partners have an addon that can help you with this. I cant find that ISV currently but I remember this being created by someone.
Nothing like that out of the box; maybe implementing Reporting Services; better approach may be to create an empty copy of the ITEM table (minus any IDENTITY fields like ItemID), create a stored procedure that runs an INSERT against that table, then schedule that store procedure to run the first of every month at midnight. Add a column named DATE or RUNDATE or something like that, where on your INSERT you map GETDATE() into that field, so you can view the actual date of your insert.
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
