I've spent time on the SQL Server side developing a view with the data I need but still trying to find a way of using a dataset to query this...

I was familiar with Previous() but unsure how I could loop thru and find the time difference between the Previous() and Current and store the greatest time difference.

The source query is limited because I'm OSI PISQLCLIENT which is pretty limited. It doesn't support sub queries or date function.

The SQL portion doesn't seem to be the problem, it's getting a Parameter Long value or a Text value and converting to long for the SQL Call.

October 5, 2020 at 6:26 pm

#3792980

"What you will likely need to do is take in a "Text" input from the report side and process it on the SQL side to break it up into int64/BIGINT...