SQL Statements

[Greeham]

Can someone tell me how to insert an SQL Statement in my Report?

I need the following:

I'm using a table named F_DOCS.
I've included a lot of calculated records and formulas but now I need to obtain the number of records where F_DOCS.DO_HOUR is within a range of time.
I would like to obtain this by using an SQL Statement.

Thank you ALL !!

 

[kenhamady]

A report can only have one SQL statement, so you would need a subreport to get a second statement and return different results.

A report can have many SQL expressions, but these only add columns to your original statement. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[Guest_imported]

What about using a stored procedure?

 

[IdoMillet]

Can you explain why you don't want to compute
this via a conditional total within the report?

- Ido

 

[kenhamady]

Ido has a great idea. If these records are already in the report, you can simply do a conditional total. There is a FAQ that explains how to do conditional totals (see the FAQ on common formulas). Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal