DBI 307 Tips and Tricks for Building Rich

DBI 307 Tips and Tricks for Building Rich Reports in SQL Server 2012 Reporting Services Riccardo Muti Microsoft Corporation

design reports immediate understanding insights pop

organize right visual tricks emphasize

United States Department of Agriculture http: //explore. data. gov/Agriculture/U-S-Lettuce-Statistics/w 87 x-qfjw

organize right visual tricks emphasize

tablix = table rows row group Microsoft columns

tablix = table Microsoft

demo building a table

tablix = table Microsoft

tablix = table + matrix column row group Microsoft column group

tablix = table + matrix ++ column Microsoft column group

demo building a matrix

organize right visual tricks emphasize

emphasize data Microsoft

emphasize data no fluff thin font space, not lines dim labels 1 accent color Microsoft

emphasize data visualize rules simple icons Microsoft

emphasize data color scales small area =Code. Color. Scale. RYG(data. Value, 0. 8, 1. 0) Microsoft http: //blogs. msdn. com/b/bobmeyers/archive/2009/07/31/add-excel-like-color-scale-conditional-formatting-to-your-reports. aspx

emphasize data Microsoft

emphasize data Microsoft

emphasize data color scales small area lighter fills darker lines/text Microsoft 98. 7%

emphasize data time = sparkline simple colors expandable align axes? Microsoft

emphasize data bars use color align axis Microsoft

emphasize data sparkpies? simple colors 12: 00 Microsoft

emphasize data cards use a picture butterfly align space between 1 accent hue Microsoft

emphasize data cards use a picture butterfly align 1 accent hue Microsoft

demo emphasize data

organize right visual tricks emphasize

the right visual Microsoft make your tables pop

the right visual Microsoft use bars for categories

the right visual Microsoft use lines for sequence

the right visual Microsoft consider sparklines instead of series

the right visual Microsoft use a scatter chart for correlation

organize right visual tricks emphasize

clipboard data related data short lists output to Excel

clipboard data ? Microsoft

clipboard data … Microsoft

clipboard data Microsoft

related dataset 1 dataset 2 =Lookup(thisfield, other. Field, return. Field, dataset. Name) Microsoft

short lists =Join(Lookup. Set(thisfield, other. Field, return. Field, dataset. Name), delimiter) =Code. Join. Sorted(. . . ) =Code. Join. Distinct. Sorted(. . . ) *NOTE: matches one field only – no group context or filters Microsoft

output to Excel Microsoft

output to Excel Microsoft

textbox names group names redundant visuals hidden columns sparklines

output to Excel Microsoft

sheet names visibility

organize right visual tricks emphasize

design reports immediate understanding insights pop

SQL Server 2012 Eval Copy Hands-On Labs mva Microsoft Virtual Academy Get Certified! @sqlserver @Tech. Ed_europe #ms. Tech. Ed

Learning Connect. Share. Discuss. Microsoft Certification & Training Resources http: //europe. msteched. com www. microsoft. com/learning Tech. Net Resources for IT Professionals Resources for Developers http: //microsoft. com/technet http: //microsoft. com/msdn

Evaluations Submit your evals online http: //europe. msteched. com/sessions