![Page 1: SQL Reporting Services SSRS Presentation for Sage User Network Sept 11 th 2008](https://reader036.vdocuments.us/reader036/viewer/2022062313/56649cd95503460f949a1eb9/html5/thumbnails/1.jpg)
SQL Reporting Services SSRS
Presentation for Sage User Network
Sept 11th 2008
![Page 2: SQL Reporting Services SSRS Presentation for Sage User Network Sept 11 th 2008](https://reader036.vdocuments.us/reader036/viewer/2022062313/56649cd95503460f949a1eb9/html5/thumbnails/2.jpg)
SQL Reporting Services SSRSWho Am I?
• Steve Littlewood • Independent Sage Line500 / 1000 Consultant• Preactor Reseller• Stock / Production Controller in the past• 1994 Systems Manager on a Chameleon site• 1998 Consultant with MIH / TSP / BDE• 2008 .......• Specialising in Stock / Manufacturing / Reporting /
Distribution / Project Management
![Page 3: SQL Reporting Services SSRS Presentation for Sage User Network Sept 11 th 2008](https://reader036.vdocuments.us/reader036/viewer/2022062313/56649cd95503460f949a1eb9/html5/thumbnails/3.jpg)
SQL Reporting Services SSRS
• Some of you will be using it already• Report Manager - Stock Search
• But all of you have it!• Assuming that you have SQL 2000 or 2005• It is not free, you have already paid for it
![Page 4: SQL Reporting Services SSRS Presentation for Sage User Network Sept 11 th 2008](https://reader036.vdocuments.us/reader036/viewer/2022062313/56649cd95503460f949a1eb9/html5/thumbnails/4.jpg)
SQL Reporting Services SSRSWhat is it?
• Obviously a Reporting tool• But think of it as a Screen Enquiry Builder • With Drill Down functionality• Oh and you can print if you need to!• Competes directly with Crystal Reports• Competes with Sage BI / Enquiries? • Overlap of some functionality with Excel
![Page 5: SQL Reporting Services SSRS Presentation for Sage User Network Sept 11 th 2008](https://reader036.vdocuments.us/reader036/viewer/2022062313/56649cd95503460f949a1eb9/html5/thumbnails/5.jpg)
SQL Reporting Services SSRSDeployment
• Great delivery methods• On demand – via a web page “Pull”• Email on a schedule “Push”• To a file server on a schedule, e.g. as an Excel
document. With an option the email users that a new version is available via a hyperlink
• To a report “snapshot” so that processing can be run overnight
• “Linked” reports – different parameters, but same report definition so low on maintenance
![Page 6: SQL Reporting Services SSRS Presentation for Sage User Network Sept 11 th 2008](https://reader036.vdocuments.us/reader036/viewer/2022062313/56649cd95503460f949a1eb9/html5/thumbnails/6.jpg)
SQL Reporting Services SSRS Deployment continued
• Microsoft stack• Call reports from your own application• Preactor do this in V10 – pack of SSRS reports • A Sage FCE could do it!• From Sage 1000 CRM :
• in Company Context• in Account Manager Context from My CRM
• Just a URL. So call it from anywhere!
• So some examples......
![Page 7: SQL Reporting Services SSRS Presentation for Sage User Network Sept 11 th 2008](https://reader036.vdocuments.us/reader036/viewer/2022062313/56649cd95503460f949a1eb9/html5/thumbnails/7.jpg)
SQL Reporting Services SSRSExamples – Stock Value Summary
Click to drill to a detail screen(Wh=BB shown on next slide)
![Page 8: SQL Reporting Services SSRS Presentation for Sage User Network Sept 11 th 2008](https://reader036.vdocuments.us/reader036/viewer/2022062313/56649cd95503460f949a1eb9/html5/thumbnails/8.jpg)
SQL Reporting Services SSRS Stock Value Detail
Folder Navigation
Tabs for permissions, schedules etc
Parameters Hide parameters
Export to Excel, PDF etc
![Page 9: SQL Reporting Services SSRS Presentation for Sage User Network Sept 11 th 2008](https://reader036.vdocuments.us/reader036/viewer/2022062313/56649cd95503460f949a1eb9/html5/thumbnails/9.jpg)
SQL Reporting Services SSRSLive Examples
Report Server URL
http://scl-it/Reports2005/Pages/Folder.aspx?ItemPath=%2flaptop_dev_2005%2f_slect_REP
![Page 10: SQL Reporting Services SSRS Presentation for Sage User Network Sept 11 th 2008](https://reader036.vdocuments.us/reader036/viewer/2022062313/56649cd95503460f949a1eb9/html5/thumbnails/10.jpg)
SQL Reporting Services SSRS From Sage1000 – in Company Context
This is a Reporting Services screen running within Sage 1000 with the Company passed as a parameter.
![Page 11: SQL Reporting Services SSRS Presentation for Sage User Network Sept 11 th 2008](https://reader036.vdocuments.us/reader036/viewer/2022062313/56649cd95503460f949a1eb9/html5/thumbnails/11.jpg)
SQL Reporting Services SSRS From Sage1000 – in Account Manager Context
Same report, but from My CRM it shows my Customer Accounts
![Page 12: SQL Reporting Services SSRS Presentation for Sage User Network Sept 11 th 2008](https://reader036.vdocuments.us/reader036/viewer/2022062313/56649cd95503460f949a1eb9/html5/thumbnails/12.jpg)
SQL Reporting Services SSRS
The End
http://www.sl-ect.co.uk/SSRS_home.aspx
Visit
For more information about the Reports & Enquiries Pack (REP)