100 likes | 227 Views
SQL Reporting. Jay Shavitz & Emo Chakarov January 29, 2011 Ft. Lauderdale. SQL Reporting. What is SQL? S tructured Q uery L anguage Example: SELECT * FROM SLS WHERE BILL_DATE = ‘01/07/2010’. SQL Reporting. Existing Database Structure Fragmented Good for speed
E N D
SQL Reporting Jay Shavitz & Emo Chakarov January 29, 2011 Ft. Lauderdale
SQL Reporting • What is SQL? • Structured Query Language • Example: SELECT * FROM SLS WHERE BILL_DATE = ‘01/07/2010’
SQL Reporting • Existing Database Structure • Fragmented • Good for speed • Not suitable for SQL reporting • Even worse with multiple stores
SQL Reporting SELECT * FROM SLS0110 UNION SELECT * FROM SLS0210 UNION SELECT * FROM SLS0310 UNION SELECT * FROM SLS0410 UNION SELECT * FROM SLS0510 UNION …… where do we stop?
SQL Reporting • So how do we solve these problems? • Consolidate/export the data into a single relational database • Use favorite reporting engine to generate reports
SQL Reporting • Free • Powerful • Easy to setup • Integrated reporting services
SQL Reporting • Setting it all up • Install SQL Server • Deploy Reports (if using Reporting Services) • Configure RMSQLExport utility • Export the data
SQL Reporting Report Samples
SQL Reporting Creating Reports