You’re offline. This is a read only version of the page.
So at my place of employment we do our previous days sales and reports every morning. Recently I started toying around with the "memorized reports" option. It's pretty straight forward how to pull up the reports and save them to the memorized category. I am struggling the data though.......
What I want is to be able to set the reports up with a filter, say like "Date sold - Yesterday" -- And when you pull it up, it will always be the previous day. When I am currently doing it, it will do the initial day --- If I were to do it right now it would do Sunday June 5th, which is great because that is yesterday. However, if I come in tomorrow and do that same report, it will continue with Sunday June 5th instead of following "yesterday."
I hope this makes sense. I am just trying to make my team's life easier by setting up all the reports for them and just having them print them in seconds.
Thanks!
*This post is locked for comments
Hello,
This may work providing every single day store is open and next day report is generated.
Follow Brian Buchanan's instructions and locate the report "Sales - Detailed Sales Report.qrp". Open it with NotePad. You don't need to change anything if the filter is as indicated by BB. You may need change to True or False in the columns for the ones you want "ColHidden = False for the others "ColHidden = True.
Save it by renaming "Custom - XXXX.qrp" in the reports folder. It works if you save as UTF-8 file. Check after save the extension remains ".qrp".
Restart the Operations Manager and you should see this in custom report. It is a little easier then typing the dates every time as it will start on today's date but with calendar drop down is only 5 clicks and generate.
I found this somewhere (possibly here on the Dynamics Forum) - If you aren't afraid of tweaking things yourself it is pretty straightforward.
If not I can forward the .qrp report to you.
To modify a report to only show data from yesterday in Store Operations, follow these steps:
C:\Program Files\Microsoft Retail Management System\Store Operations\Reports
SelCriteria = "convert(varchar(10),(Getdate()-1),101) = convert(varchar(10),[Transaction].Time,101)"
6. Begin Filter
End Filter
11. On the File menu, click Save As.
12. Change the file name to Custom - XXXXX Report.qrp
Note Replace the XXXXX characters with a descriptive title for your custom report.
13. In the Save as Type list, click All Files, and then click Save.
14. If Store Operations Manager is running, you will have to close the application and then restart it before the modified report will be available.
15. In Store Operations Manager, click Reports, point to Custom, and then click your modified report.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (