HomeRecommended LinksLatest LinksTop HitsWhere's that GP Window?Contact
Home » Listing Details
Top Websites
  1. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  2. Dynamics GP Help
    Over 1700 resources listed.
  3. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 900 resources listed.
  4. Mariano Gomez at The Dynamics GP Blogster
    Over 700 resources listed.
  5. Microsoft Dynamics Partner Community Blog
    Over 700 resources listed.
  6. Mohammad Daoud's Dynamics GP Blog
    Over 500 resources listed.
  7. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 400 resources listed.
  8. Inside Microsoft Dynamics GP Official Blog
    Over 400 resources listed.
  9. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 300 resources listed.
  10. eOne Business Solutions Blog
    Over 300 resources listed.
  11. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Dynamics CPM
    Over 200 resources listed.
  14. Rose Business Solutions Blog New
    Over 200 resources listed.
  15. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  16. Victoria Yudin's Dynamics GP Website
    Over 100 resources listed.
    Victoria Yudin
  17. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  18. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  19. Leslie Vail at Dynamics Confessor Blogspot
    Over 100 resources listed.
  20. BKD Dynamics GP Insights Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.
Useful Dynamics GP Links
  1. Dynamics GP Add-On Products and ISV Solutions
  2. Dynamics GP Community Homepage - Blogs, Product Forums and Newsgroups

ID:11863
Title:Using SQL Server Reporting Services(SSRS) with Microsoft Dynamics GP
URL:http://waqasb.blogspot.com/2010/02/using-sql-server-reporting-servicesssrs.html
Description:

In Dynamics GP we have a cool feature to have SQL server reporting services(SSRS) reports, Microsoft SQL Server Reporting Services (SSRS) offers a very powerful report writing capability for any SQL Server based system. Specifically for Microsoft Dynamics GP, Microsoft has created a library of over 200 pre-built reports to use.

In Order to access and leverage the SSRS Library that is provided by Microsoft and to upload it to your Dynamics GP system you need to perform some simple steps

Step 0 :        Prerequisites

-      SQL Server Reporting Services 2005 With SP2 Or Later

-      SQL Server Reporting Services 2008 With SP3 For SQL Server Reporting Services Wizard

-      IIS 6.0

-      Internet Explorer 7 or 6 with SP2

-      Dynamics GP 10.0 with Service Pack 1 or Later


Step 1 :        Install & Setup IIS

-      For Windows 2003

o    Click Start, point to Control Panel, and then click Add or Remove Programs, The Add or Remove Programs tool starts.
o    Click Add/Remove Windows Components, The Windows Components Wizard appears.
o    In the Windows Components list, click Application Server, but do not select the check box.
o    Click Details, and then click to select the Internet Information Services (IIS) check box.
o    For Further Details Please refer to windows manual.

-      For Windows 2008

o    Click Start -> All Programs -> Administrative Tools -> Server Manager.

o    In Server Manager, scroll down to Roles Summary, and then click on Add Roles. The Add Roles Wizard will start with a Before You Begin page. The wizard asks for verification of the following:
o    Select Web Server (IIS) on the Select Server Roles page. An introductory page will open with links for further information
o    Choose the IIS services to be installed on the Select Role Services page.
o    Click Next

-      For Windows XP

o    Click Start, point to Control Panel, and then click Add or Remove Programs, The Add or Remove Programs tool starts.
o    Click Add/Remove Windows Components, The Windows Components Wizard appears.
o    In the Windows Components list, Select the Internet Information Services (IIS) check box.

o    Click Next.

Step 2 :        Install & Setup SQL Server with Reporting Services

-      Install SQL Server 2005 / 2008 with SQL Reporting Services, refer to SQL server installation help for complete details.

-      After Installation Run SQL Server 2008 reporting service configuration manager. 

 

-      Select Server to connect.

-      Specify/setup/Apply proper Web services URL.

-      Specify/setup/Apply proper Report Manager URL.

Step 3 :        Install SQL Server Reporting Services For Dynamics GP

-      Run the Reporting Services setup wizard from GP CD2

-      Click Next On Welcome Screen.

-      Accept the license agreement.

-      Select Feature “U.S English Version”

-      Complete.

Step 4 :        Run Microsoft SQL Server Reporting Services Wizard

-      Click Start >> Programs >> Microsoft Dynamics >> Business Intelligence >> Microsoft SQL Server Reporting Services Wizard.

-      Click “Next” on welcome screen.

-      Specify “Dynamics GP Server Name” & “SQL User ID & Pass” on Connect to data source screen.

-      Select “Company” and specify Module against which you would like to deploy SRS standard reports on Select Database and module screen.

-      Specify “Target Server URL” , in define location & deploy report screen. This URL is report server URL. ( Refer Step 2 for URL ).


-      Click Finish.

Step 5 :        Setup SQL Reporting Service In Dynamics GP

-      Define the reports and web services path in “Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Reporting Tools Setup”:
-      Specify “Report Manager URL”. ( Refer step 2 for URL Details )

-      Specify “Report Server URL”. ( Refer step 2 for URL Details )

Step 6 :        Browse Standard SRS Report in Dynamics GP

-      Go to Administration tab and find “Custom Report List”:










Helping Links:

SSRS With Dynamics GP FAQ ( KB 954242 )

https://mbs.microsoft.com/knowledgebase/kbdisplay.aspx?wtntzsmnwukntmmyxupyzqpouxnxspsypwwwwonwumqpnovy&wa=wsignin1.0

Happy Reporting !

Category:REPORTING: SQL Reporting Services
Link Owner:
Date Added:June 17, 2010 07:06:46 PM
Number Hits:94
RatingsAverage rating: (0 votes)
Reviews

No Reviews Yet.

 
Latest links
GPWindow.com

Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.

www.saci.com
PHP Link Directory