Formula or Qry Help

[ecugrad]

I'm trying to set-up a qry using three fields: UserName, AccountNumber,EndTime all located in an Oracle table. I want to pull Distinct Names,Count Unique Account Numbers that relate to the Names and the EndTime being todays date.
The Name(string)
AccountNum(Number)
EndTime(DateTime)


Thanks for any help

Mike

 

[kenhamady]

What verison of CR? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[ecugrad]

Ken, I have version 8. Also, I see that you have a refrence guide for sale. Is the guide written for version 8?

 

[kenhamady]

Yes, are you trying to:

1) create a standalone report in CR
2) Create a report in CR that you can launch from VB
3) Create a recordset to pass?

If #1, start the report expert, select the table and these three fields. Group by Name on the group tab. On the total tab, mover over the account number and set it to distinct count. On the select tab, move the date field over and put in the rule that says is equal to and then select the date.

When you are done, hide the group header and details sections. Move the name and accountno to the group footer. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)