1 / 20

Jay Shavitz January 21, 2012 Los Angeles, CA

Jay Shavitz January 21, 2012 Los 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.

eagan-franklin
Download Presentation

Jay Shavitz January 21, 2012 Los Angeles, CA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Jay Shavitz January 21, 2012 Los Angeles, CA

  2. What is Rm SQL Reporting • Rm Data + Power and Flexibility of

  3. What is Rm SQL Reporting Report Flexibility Previously Unavailable

  4. What is Rm SQL Reporting

  5. What is Rm SQL Reporting • Drill Down Reporting

  6. What is Rm SQL Reporting • Multi-Store Reports (Store ID)

  7. What is Rm SQL Reporting • Excel 2010 & PowerPivots

  8. Target Market • Sites with specific reporting requirements beyond RmReports • Multi-unit operations • Users who want to mine data

  9. 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

  10. Documentation • Complete Guide on Dealer Services • OS Requirements • File Pre-req’s • Step by Step

  11. Supported OS • Windows XP Pro • Windows 7 Pro • 2008 Server • 2003 Server • 32 Bit (rec) and 64 Bit

  12. Prerequisite Software • IIS – Internet Information Systems • .Net Framework 3.5 SP1 • Windows Power Shell • Windows Installer 4.5

  13. Primary Software • MS SQL Server Express 2008 R2with Advanced Services • Restaurant Manager v18 • RmSQL Installation Package • File Links Included in SQL Reporting Guide

  14. 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!

  15. Export Data • Data is converted to SQL • RmSqlExport

  16. Initial Export • Minutes / Yr • Small: 30/40 yr • Med: 60 /yr • Large: 90 / yr

  17. Subsequent Exports • Automatic/Sched After Initial Export • Export as often as every 1 Min • Set the interval based on requirements • Balance ‘Need’ vs Schedule

  18. Generating Reports • Browser Based • IE Recommended • Firefox OK • Chrome Not Yet

  19. Generating Reports • URL: localhost/Reports_SQLEXPRESS • Save as Favorite, Shortcut etc.

  20. Generating Reports • URL: localhost/Reports_SQLEXPRESS • Save as Favorite, Shortcut etc. • Review Live Data

More Related