YetAnotherForum
Welcome Guest Search | Active Topics | Log In | Register

Issues in Retrieving Digital State Tags using SSRS Options · View
Previous Topic · Next Topic
alomairs
#1 Posted : Sunday, January 08, 2012 11:18:12 AM
Rank: Newbie
Groups: Member

Joined: 1/25/2011
Posts: 8
Location: Oman
Hello There,

Am using SSRS to develop some reports by retrieving data from PI using the PI OLEDB provider..

My Inquiry is When trying to retrieve Digital State value, am getting numbers in (-) minus!!! instead of (on/off or any othere state)

Any Idea how to solve this.

Thanks and Regards
Back to top
 Report Abusive | Report SPAM
Sponsor  
 

OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System.
We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ  or contact OSIsoft vCampus for more details.
Back to top  
jhcoxx
#2 Posted : Sunday, January 08, 2012 11:09:56 PM
Rank: Member
Groups: Member

Joined: 7/5/2010
Posts: 27
Location: Texas
This won't exactly help you, other than giving you some encouragement (maybe) that you are getting close.

From work done a long time ago with the PI-API, it appeared that Digital state values in PI are stored as negative numbers - so maybe there is something in the PI OLEDB object model that would allow you to specify that PI does a conversion from the negative integer to the text strings defined as the Digital State set.

Hopefully, someone who has used PI OLEDB can give you the answer - but it appears that you're on the right track.

jhcoxx
Back to top
WWW  Report Abusive | Report SPAM
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

YAFVision Theme by Jaben Cargman (Tiny Gecko)
Powered by YAF | YAF © 2003-2008, Yet Another Forum.NET