Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Builder Find reports running longer than 2 hours

Status
Not open for further replies.
Sahubba

Sahubba

Programmer
Mar 16, 2011
108
0
0
US
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
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

t1sugar
  • Locked
  • Question
which version of crystal reports for boxi 4.1; Help 1
Replies
3
Views
80
hilfy
hilfy
Eaglewhite
  • Locked
  • Question
Find Reports in BOXI
Replies
1
Views
40
kray4660
kray4660
PWD
  • Locked
  • Question
Multiple Wildcards in Query
Replies
4
Views
99
SkipVought
S
TammyDCBC
  • Locked
  • Question
Combining 2 complex If statements
Replies
0
Views
21
TammyDCBC
TammyDCBC
amadese
  • Locked
  • Question
BO reports - Universes - dynamic column
Replies
0
Views
30
amadese
amadese

Part and Inventory Search

Sponsor

Back
Top