I am working on one small where I want to show excel reports on PI active view web site with client has open office installed on machine
You can simply copy paste the excel portion, on .pdi (processbook) file.
This processbook file could be uploaded to sharepoint and could be linked to PI Activeview webpart.
But there are application own limitation about the portion of excel copy and paste in processbook.
Regards, open office you can try the about solution once and test.
Thanks & Regards,
Thanks for your reply Paresh,
We are working on small project which has budget limitation.
So we cannot install PI datalink on client machines (so PDI solution won't work here..).
As we have only one PDI and excel license which is installed on server.
So I want one web page which will take a request(like start date, End Date and Time Interval) from client and which will show appropriate report.
Only thing we can do is to install open office and PI ActiveView on client machines
Greetings for the day!
First thing need to understand complexity of the report you are looking for. The only possibility that I could see is using VBA code with PI SDK reference.
You can pass the date from processbook to excel, this is just for your info. This works in Activeview on web, I have already tested it before.
If you need a sample for it do let me know will provide. Check if that is of any help to you.
May be other member would have any other opinion.
Given you don't have a large budget, i think PI DataLink Server and Excel services is out of the question, but still the most sustainable (until we have the new PI Integrator for BI). You could get by DataLink server using some UDF's on Excel services, or use OLEDB EnterPrise queries.
Some other ideas, not breaking the bank: write a small .NET program (or some clever PowerShell) that takes the parameters, opens Excel, renders the workbook with the given Parameters and PI DataLink, and saves the workbook as a .JPG file. Not too complex, but getting this to run in the background is a major challenge as Excel is not supported to run as a background program. Some hacking required here, but it might work for a small scale scenario.
Retrieving data ...