AnsweredAssumed Answered

Daily report in SSRS Report Builder 3.0

Question asked by oolabode on Mar 15, 2017
Latest reply on Mar 17, 2017 by oolabode

Hello Experts,

 

I am new to PI, PIOLEDB and Report Builder.

 

I will like to create a report in SSRS Report Builder 3.0 that will display average values of a set of tags from PI with data spanning two days e.g 8AM yesterday to 8AM today (24hr).

 

I found a good post on this forum that helped me get started with the query. PI OLEDB and MS - Reports.

 

I am able to create the query and get results however when I group on the timestamp field report builder splits the dates into two:

8AM - 11:59PM

12AM -8AM

 

What I want is to get each row with the average from 8AM - 8AM and display the start date.

 

Your feedback will be greatly appreciated.

Outcomes