Create RMS Store Manger Report From SQL Querry in Administrator

(0) Share

Report

Posted on by Jenifer Schmirtt

100

Hello, I am new to RMS. I have been able to create reports that are not in our store manager by using sql in the administrator. I export the results into excel and email them to the appropriate people - every day. How can I have them pull the results or receive them automatically?
- Do I need crystal reports? But I do already have the query and don’t want to spend more money.
- Do I have to make a stored procedure that emails the results on the sql server?
- Ideally it would be an option to choose from under the Reports in the Store Manager Hopefully there is an easy solution!Thanks - any help is greatly appreciated!Jen

*This post is locked for comments

All responses (1)

Answers (0)

Juan 100 on at

Like (0)

Report

Re: Create RMS Store Manger Report From SQL Querry in Administrator

What kind of reports do you need? You can tag some reports if the tables share same info on some tables. I'm sure that if you where able to use the querys you can modify some reports.