Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Web Custom Reports - Skyward

VIEWS: 101 PAGES: 17

									Crystal Report Options: Introduction
to Web Quick Picks
Presenters: Mike Bianco / Deb Muenchow
       Agenda

• Review System Requirements

• Review Server Design

• Web Quick Picks Configuration

• See Web Quick Picks in action
System Requirements

  • Monolith 2 is required – there are two choices for upgrading

      Option 1 - Upgrade Monolith 2 yourself

      Option 2 - Sign up to have Skyward Upgrade perform your
      upgrade.

      For more Information/Upgrade Services on Monolith 2:

      http://support.skyward.com/Services/Monolith2Details.aspx
System Requirements

  • Crystal Developer License is required

      • One copy is included when you purchase Web Quick
      Picks for the Web.

      • Crystal Developer can be installed and used by your
      district to write your own reports or it does not have to
      be installed at all.

      • Crystal Developer gives the Crystal software license
      rights to run Web Quick Picks

      • Upgrade Options are available for existing Crystal
      Customers
System Requirements

  • Skyward Server Requirements

     • Your district’s existing report queue server is the server of
     choice

     • Windows 2003/2008 Server (All versions except the Web
     Edition)

     • The services can be installed on any existing Skyward
     Windows Server.

     • .NET Framework Version 3.5 SP1
SkyRAS (Report Application Services)

    • One SkyRAS Stateless AppServer per database

    • One SkyRAS Service per District

    • Monolith CAS Service (1 per database or 1 per district)

    • Report Storage Locations

        • Local Paths
             • Ex. d:\Skyward\WebQuickPicks

        • Network Paths for Report Queue Streaming
            • Ex. \\Server\Skyward\WebQuickPicks
SkyRAS Server Design

           Simple Skyward Environment
           Location of Skyward Database(s)
           Location of IIS Web Services
           Location of WebSpeed Brokers
           Location of AppServers
           Location of Report Queue Services
           Location of Monolith 2 CAS/DAS Services


           Web Quick Picks (Report Application Services)
           Conf igure one SkyRAS AppServer per database
           Conf igure one SkyRAS Service per district
           Local SkyRAS Storage Locations




Simple Skyward Environment
     SkyRAS Server Design

         Skyward Database Server
         Location of Skyward Database(s)
         Location of AppServers
         Location of Monolith 2 CAS/DAS Service




Sky-DB
                                                  Sky-RQ

         Skyward Web Server                       Skyward Report Queue Server
         Location of IIS Web Services             Location of Report Queue AppServer(s)
         Location of WebSpeed Broker(s)           Location of Report Queue Service(s)
         Location of Monolith 2 DAS Service       Report Queue Streaming Optional
                                                  Location of Monolith 2 DAS Service


                                                  Web Quick Picks (Report Application Services)
                                                  Conf igure one SkyRAS AppServer per database
                                                  Conf igure one SkyRAS Service per district
                                                  Local or Network (UNC) SkyRAS Storage Locations
                                                  Skyward Service Account Required is Streaming



Medium Skyward Environment
         SkyRAS Server Design
          Skyward Database Server
          Location of Skyward Database(s)
          Location of AppServers
          Location of Monolith 2 CAS/DAS Services




Sky-DB    Large Skyward Environment

                                                    (2) Sky-RQ
           Skyward Web Servers
           Location of IIS Web Services             Skyward Report Queue Servers
           Location of WebSpeed Broker(s)           Location of Report Queue AppServer(s)
           Clustered using Network Load Balancing   Location of Report Queue Service(s)
           Location of Monolith 2 DAS Services      Both Servers process reports
                                                    Skyward Service Account Required
                                                    Report Queue Streaming Required
                                                    Location of Monolith 2 DAS Services


                                                    Web Quick Picks (Report Application Services)
                                                    Network (UNC) SkyRAS Storage Locations
                                                    Skyward Service Account Required
                                                    Conf igure one SkyRAS AppServer per database
                                                    Conf igure one SkyRAS Service per district
SkyRAS Crystal Report Processing
    1.  Client Submits Crystal Report
    2.  Request is created in the Report Queue
    3.  SkyRAS Service connects to Monolith CAS
    4.  SkyRAS AppServer pulls report information from
        the Skyward Database
    5. SkyRAS Service receives report information and
        parameters from the AppServer
    6. SkyRAS Service pulls from the Skyward Database
        using an ODBC connection.
    7. SkyRAS Service Processes report using they
        Crystal 11 Engine.
    8. SkyRAS Service exports the report to the storage
        location
    9. SkyRAS service updates the Report Queue Record
    10. Client sees the report as complete and can view
        the report
SkyRAS Crystal Report Processing
  • The number of Crystal Reports processed at one time can
  be adjusted by adding the Crystal:# parameter to the
  Report Queue Agent Config File. The default used is two
  and does not require the parameter to be added to the
  Agent Config File.

  • It would not be advisable to set this above 25, as there are
  three Crystal processes occurring at once and Crystal can
  only handle 75 threads at one time.

  • If there are multiple databases using the Report Queue
  Service, the Crystal:# parameter is split between all, as it’s
  needed.

  • Typically SkyRAS.exe uses 2 to 3 % of the processor per
  report
Copying Crystal Reports
  • Existing Custom reports created in Crystal need to be copied to
  the Web Crystal Storage locations.


  1.   Browse to Web Student menu path of CR\PS\UT\CR
  2.   Click Add
  3.   Enter a Template Description
  4.   Select the Copy Customer Reports checkbox
  5.   Select the Copy Skyward Reports checkbox
  6.   Click Save and Run.
  7.   This process copies reports to the Skyward Report Location
Install the Web Quick Picks Viewer
  • There is a Windows and MAC OSX viewer

  • The Download Viewer button (WS\CR\RE) will change depending
  the client computer

  1.   Browse to Web Student menu path CR\RE
  2.   Apply filter.
  3.   Click Download Viewer for Windows/MaC
  4.   Click Run.
  5.   Click Run
  6.   Click Next, at the Welcome Screen.
  7.   Accept the License Agreement and click Next.
  8.   Click Next to start the installation.
  9.   (Accept all the defaults for the Viewer Installation)
Testing Web Quick Pick Reports
  • Running a Crystal Report (WS\CR\RE)

  1.   Browse to Web Student menu path CR\RE
  2.   Apply filter.
  3.   Choose the Appropriate Entity
  4.   Highlight a report – ex. Emergency Phone Listing
  5.   Click Run
  6.   Click Print
  7.   Report Processes in Print Queue popup window
  8.   When complete highlight report and click view
  9.   Click Open and the report will open in the Crystal 11 viewer
SkyRAS Troubleshooting
    • The SkyRAS Service will log to the Event Viewer in the
    Skyward group

    • There can only be one SkyRAS AppServer per
    database

    • The SkyRAS Service includes the Crystal 11 report
    processing engine

    • The SkyRAS AppServer is used minimally to pull data
    to/from the database, it does not do any crystal report
    processing

    • If SkyRAS fails to connect to the CAS Service it will
    automatically retry again after 60 minutes. This can be
    adjusted in the SkyRAS.config file
Network      Project
 Design    Management




On-going
Network    Deployment
Support
Thank you for attending.

								
To top