Query Builder Find reports running longer than 2 hours

[Sahubba]

Hello,

I was wondering if anyone could tell me if there is a way to find Crystal reports that runs longer than 2 hours from the query builder?

Thank you,
Sara

 

[hilfy]

The problem is that the query language is a somewhat limited version of SQL, so there's no way to manipulate the DateTime fields to get the difference between them. This could be done in an application that uses the SDK (.NET or Java), though. The SDK uses the same types of queries as Query Builder, so you would query for the raw data and then do the date comparison in whatever language you write the utility in.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com