11 Replies Latest reply on Jan 16, 2018 3:54 PM by gregor

How to Passing Parameters from MS SQL Reporting Services (SSRS)

DavidBrookes Jul 27, 2015 12:38 PM

Has anyone tried to pass parameters from SSRS to PI ODBC?

If possible I would like to learn how.

Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)

dng Jul 27, 2015 7:49 PM (in response to DavidBrookes)

Hi David,

I haven't seen many customers using SSRS with PI ODBC; however, it should be possible with PI OLEDB. Have you checked out the white paper: Integrating PI System 2010 with Microsoft SSRS?
Like Show 0 Likes(0)

Actions
- Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
  
  twipf Sep 2, 2015 8:08 PM (in response to dng)
  
  Daphne, I was looking to get information off this post, however the linked paper is no longer available? This seems like a topic of interest yet.
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
    
    dng Sep 2, 2015 8:39 PM (in response to twipf)
    
    Hi Tyler,
    
    I have sent you a PI Square message regarding this white paper. Thanks.
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
      
      twipf Sep 2, 2015 9:55 PM (in response to dng)
      
      Thanks Daphne, I've received and downloaded it.
      
      Like Show 0 Likes(0)
      
      Actions
    - Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
      
      jamespr Jan 12, 2018 9:11 PM (in response to dng)
      
      Hello Daphne,
      
      Could be possible to have the white paper too? I tried to download it but is not available.
      
      Kindly regards,
      Jaime Olmo
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
        
        gregor Jan 15, 2018 10:00 AM (in response to jamespr)
        
        Hello Jaime,
        
        Please let me investigate, why this download link is not working for you. I may contact you via direct message about this. Meanwhile and also for other interested users, there is a more recent document available with the UC 2016 Hands-On Lab Workbooks. After downloading this package, please look for Build Better Reports with PI SQL Framework.
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
        
        jamespr Jan 15, 2018 8:39 PM (in response to gregor)
        
        Hello Gregor Beck,
        
        The portal only says: "The file you selected is not available. A newer or updated version may be available.Go to the following link to search for your download: All Downloads." No more details. The newer version in the Hands-On Lab looks promising. Anyway I would like to have the version of 2010 for reference with our legacy systems.
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
        
        gregor Jan 16, 2018 11:59 AM (in response to jamespr)
        
        Hi Jaime,
        
        I am working on making the White Paper from 2010 available to you. Please stand by.
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
        
        gregor Jan 16, 2018 12:35 PM (in response to jamespr)
        
        Hi Jaime Olmo,
        
        I've added a manual override to your SSO profile. You should now be able to download Integrating PI System 2010 with Microsoft SSRS.
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
        
        jamespr Jan 16, 2018 3:15 PM (in response to gregor)
        
        Thank you very much for the doc!
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
        
        gregor Jan 16, 2018 3:54 PM (in response to jamespr)
        
        I have more good news. The White Paper is now available to anyone signed in with an SSO account.
        
        Like Show 0 Likes(0)
        
        Actions

Go to original post