1 / 37

Welcome To...

Welcome To. ReportSmith & CSS HRizon. Welcome To. Everything You Wanted To Know About Crosstabs. Presented By. CharlesCook.com Specializing In ReportSmith Training & Consulting Charles@CharlesCook.com. Crosstabs . What Is A Crosstab A Spreadsheet Like Report

keefe
Download Presentation

Welcome To...

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. Welcome To... ReportSmith & CSS HRizon

  2. Welcome To... Everything You Wanted To Know About Crosstabs

  3. Presented By CharlesCook.com Specializing In ReportSmith Training & Consulting Charles@CharlesCook.com

  4. Crosstabs • What Is A Crosstab • A Spreadsheet Like Report • Very Much Like A Pivot Table In Excel

  5. Crosstabs • What Is A Crosstab • Basic Layout • Rows Of Data • Columns Of Data • Values • Where Rows And Columns Intersect

  6. Crosstabs • What Is A Crosstab • Crosstab Placement • Group Header Or Footer • The Group Determines The Amount Of Data In The Crosstab

  7. Crosstabs • What Is A Crosstab • Crosstab Placement • Report Header Or Footer • All Data From The Entire Report Group • Group Header Or Footer • All Data In The Group

  8. EEO Example

  9. Crosstab Dialog Box

  10. Row Options & Aliases

  11. Column Options & Subtotals

  12. Column Options & Aliases

  13. Column Options & Aliases

  14. Value Options

  15. Crosstab Options

  16. Payroll Example

  17. Crosstab Dialog Box

  18. Row Options & Aliases

  19. Column Options

  20. Value Options

  21. Value Options

  22. Crosstab Options

  23. Watch Out !!! • Crosstab Size • Vertical Size • Headers And Footers Do Not Grow In Size At Run Time • The Header Or Footer Must Be Large Enough To Hold Your Tallest Crosstab • Define Header / Footer Size When You Create The Crosstab

  24. Watch Out !!! • Crosstab Size • Horizontal Size • Make Sure Your Crosstab Will Always Fit On The Page • Force The Crosstab To Display All Columns • Custom Sort • Display Range

  25. Watch Out !!! • Formatting Bug • ReportSmith Does Not Always Save Your Crosstab Formatting • You Must Reformat The Crosstab When This Happens

  26. Graphing Crosstabs

  27. Graphing Crosstabs • Required Software • Microsoft Graph • An Optional Component Of Microsoft Office • Not Compatible With Office 97 • Office 95 Works

  28. Graphing Crosstabs • Graph Placement • Must Be In The Same Header Or Footer As The Crosstab

  29. Graphing Crosstabs • Creating A Graph • Double Click On Your Crosstab To Select It

  30. Graphing Crosstabs

  31. Graphing Crosstabs • Creating A Graph • Click On The Graph Button

  32. Graphing Crosstabs

  33. Graphing Crosstabs • Creating A Graph • Click In A Header Or Footer To Place Your Graph

  34. Graphing Crosstabs

  35. Graphing Crosstabs

  36. Graphing Crosstabs • Creating A Graph • Double Click On Your Graph To Open Microsoft Graph For Formatting

  37. Presented By CharlesCook.com Specializing In ReportSmith Training & Consulting Charles@CharlesCook.com

More Related