jay shavitz january 21, 2012 los angeles, ca. what is rm sql reporting rm data + power and...
TRANSCRIPT
Jay ShavitzJanuary 21, 2012Los Angeles, CA
What is Rm SQL Reporting
Rm Data + Power and Flexibility of
What is Rm SQL Reporting
Report Flexibility Previously Unavailable
What is Rm SQL Reporting
What is Rm SQL Reporting
Drill Down Reporting
What is Rm SQL Reporting
Multi-Store Reports (Store ID)
Excel 2010 & PowerPivots
What is Rm SQL Reporting
Target Market
Sites with specific reporting requirements beyond RmReports
Multi-unit operations Users who want to mine data
What SQL Reporting is NOT
Not a full replacement for RmReports 1st Release = No automatic reports
(print or email) Number of Initial Reports Limited V18 Only
Documentation
Complete Guide on Dealer Services OS Requirements File Pre-req’s Step by Step
Supported OS
Windows XP Pro Windows 7 Pro 2008 Server 2003 Server 32 Bit (rec) and 64 Bit
Prerequisite Software
IIS – Internet Information Systems .Net Framework 3.5 SP1 Windows Power Shell Windows Installer 4.5
Primary Software
MS SQL Server Express 2008 R2with Advanced Services
Restaurant Manager v18
RmSQL Installation Package
File Links Included in SQL Reporting Guide
Setup Notes
Plan on 2-3 hours for Install & Config Mostly Downloads & SQL Setup / Install More Time for Data Conversion (more on this
later….)
FOLLOW THE GUIDE!
Export Data
Data is converted to SQL RmSqlExport
Initial Export
Minutes / Yr
Small: 30/40 yr Med: 60 /yr Large: 90 / yr
Subsequent Exports
Automatic/Sched After Initial Export Export as often as every 1 Min Set the interval based on requirements Balance ‘Need’ vs Schedule
Generating Reports
Browser Based IE Recommended Firefox OK Chrome Not Yet
Generating Reports
URL: localhost/Reports_SQLEXPRESS
Save as Favorite, Shortcut etc.
Generating Reports
URL: localhost/Reports_SQLEXPRESS
Save as Favorite, Shortcut etc.
Review Live Data