480 likes | 653 Views
Basic SQL Reporting. Welcome. Connect Conference 2013. This is an exciting opportunity for everyone involved. The benefits go beyond just training and education—collaborate with your peers and inspire others around you. educate • collaborate • inspire. Basic SQL Reporting.
E N D
Welcome Connect Conference 2013 This is an exciting opportunity for everyone involved. The benefits go beyond just training and education—collaborate with your peers and inspire others around you. educate • collaborate • inspire
Basic SQL Reporting Topics of Discussion • Sharing the Reporting folder • Importing data into SQL • Understanding report structure • Executing a report with no limits • Setting limits for a report
Basic SQL Reporting Topics of Discussion • Changing the sorting & grouping for a report • Adding a new sort and or group on a report • Previewing reports • Customizing the grid • Setting up users & user groups for accessing reports • Adding new DDMS reports
Basic SQL Reporting Sharing the Reporting Folder and Importing Data • Normal MS Windows sharing of the Reporting folder within the DDMS folder on the DDMS server • Importing existing data into the SQL database • For more information on importing • Attend conference class: What to do with Exceptions • See the DDMS KnowledgeBase via customer support portal here: http://support.ecisolutions.com/
Basic SQL Reporting Understanding Report Structure • Two parts to reports • Heading • Appears at the top • Includes general information • Report title • Date • Page number • Detail • Contains actual report data • More complex reports may group data • Groups may contain header & footer information
Basic SQL Reporting Executing a Report with No Limits • Reporting Task Menu • Execute a report • Expand list • DDMS canned or standard reports in blue • Can not be deleted • Any reports changed and saved are in black • Click on report name • Click preview
Basic SQL Reporting Executing a Report - No Limits
Basic SQL Reporting Customer Master Listing — No Limits
Basic SQL Reporting Setting Limits for a Report • Reporting Task Menu • Execute a report • Click Limit tab • Available limits for report appear on the left & cannot be changed • Choose limit • Set criteria for limit • Click Add New at the bottom • Click Preview when ready
Basic SQL Reporting Setting Limits for a Report
Basic SQL Reporting Customer Master Listing With Limit — Zip Code
Basic SQL Reporting Changing Sorting and Grouping for a Report • Reporting Task Menu • Execute a report • Click sorting and grouping tab • Predefined groups appear if available on report in the order they print on the report • Headers and footers are per group • Click Group to change • Click available Sort to change, can change multiple sorts if available • Click drop down arrow in Group By box to select field name for new sort • New sort name appears in the Defined Group box
Basic SQL Reporting Changing Sorting and Grouping for a Report
Basic SQL Reporting Changing Grouping — Salesperson
Basic SQL Reporting Changed Grouping — Salesperson
Basic SQL Reporting Adding a New Sort and or Group on a Report • Reporting Task Menu • Execute a report • Click Add New Sort • Can set Group properties and Group fields • Can add multiple sorts • Will print in the order new sorts are added • If to make permanent, click Save Changes and enter a description for the report
Basic SQL Reporting Adding a New Sort and or Group on a Report
Basic SQL Reporting Adding a Sort — Vendor Master Listing
Basic SQL Reporting Adding a Sort — Vendor Master Listing
Basic SQL Reporting Saving Changes for New Report
Basic SQL Reporting Sort added to Vendor Master Listing — State
Basic SQL Reporting Custom Report Added to Report Group
Basic SQL Reporting Options • Options tab • Gives the ability to add additional information to a report such as: • Location • Totals only • Additional text, up to 60 characters • Limits added or changed
Basic SQL Reporting Options
Basic SQL Reporting Options
Basic SQL Reporting Previewing Reports • Reporting Task Menu • Click Preview Reports • Can preview on screen • Can print report to printer • Can save a report to a file • Can change page setup • Find text • Zoom
Basic SQL Reporting Previewing Reports
Basic SQL Reporting Customizing the Grid
Basic SQL Reporting Customizing the Grid
Basic SQL Reporting Adding Users or Groups • Used for security • If users and or groups are not setup then access is open to all • Can add from left side or right click
Basic SQL Reporting Adding Groups and Users
Basic SQL Reporting Adding a User to a Group
Basic SQL Reporting Adding a User — User Added
Basic SQL Reporting Set Allowed Groups to Reports
Basic SQL Reporting Set Allowed Groups to Reports
Basic SQL Reporting Set Allowed Groups to Reports
Basic SQL Reporting User Group Added
Basic SQL Reporting Adding New DDMS Reports • Click Set up Reports on the left under Reporting Tasks • Highlight Report Group in grid • Click Add Report on the left under Current Options
Basic SQL Reporting Adding New DDMS Reports
Basic SQL Reporting Adding New DDMS Reports • New window opens. Drill down to: • DDMS folder • Reporting (Not Reports) • eci2 • Click report group name.xml • Click Open • Select report from drop down menu • Click continue • Report is now added
Basic SQL Reporting Adding new DDMS reports Path to files may vary, consult your IT person. Examples: \\192.168.1.100\reporting\eci2\ \\ddms-server\reporting\eci2\ \\ddms-server\reporting\eci2\ \\ddms-server\DDMS\reporting\eci2\
Basic SQL Reporting Adding New DDMS Reports
Basic SQL Reporting New Report Added
Basic SQL Reporting DDMS KnowledgeBase Find help in the DDMS KnowledgeBase
Basic SQL Reporting Session Survey Don’t forget to turn in your session survey for a chance to win a $250 gift certificate Surveys can be turned in at the Conference Registration in the Trinity Foyer or in the Lab located in the Pegasus Ballroom (both located on the lobby level)
Customer Service & Support Contact Information • Support - 800-366-4778 - Monday – Friday - 7AM-7PM CST • Training • - 800-959-3367 Option 5 • professional.services@ecisolutions.com • - Virtual class training • - One on One training • - Onsite training