-
Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
dngJul 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?
-
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.
-
Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
dngSep 2, 2015 8:39 PM (in response to twipf)
Hi Tyler,
I have sent you a PI Square message regarding this white paper. Thanks.
-
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.
-
Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
jamesprJan 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
-
Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
gregorJan 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.
-
Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
jamesprJan 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.
-
Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
gregorJan 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.
-
Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
gregorJan 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.
-
Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
jamesprJan 16, 2018 3:15 PM (in response to gregor)
Thank you very much for the doc!
-
Re: How to Passing Parameters from MS SQL Reporting Services (SSRS)
gregorJan 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.
-
-
-
-
-
-
-
-