By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

In Crystal, what does COUNT ({table.column1},{table.column1}) do? & SQL equivalent?

P: 8
In Crystal, I've come across the following code but don't really understand it:
Expand|Select|Wrap|Line Numbers
  1. COUNT ({tableName1.column1},{tableName1.column1}) 
I'm involved in creating equivalent reports from an old system using Crystal, into a new system with SQL Server 2005 without Crystal, so i need to understand what exactly this statement does so i can do something which produces equivalent results in SQL Server.
The fact that it repeats the same column twice inside the function's brackets is confusing me, what would this do?
It's been explained to me as being like Excel's COUNTIF statement, where it basically counts the repetitions of the column contents but surely that would produce more than 1 result and COUNT can only handle 1 result at a time?

Any help would be appreciated
Feb 10 '10 #1

✓ answered by ck9663

I'm not into crystal report. But "google-ling" this function tells me the first parameter is the record you're counting for every group of parameter two.

Good Luck!!!

~~ CK

Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
I'm not into crystal report. But "google-ling" this function tells me the first parameter is the record you're counting for every group of parameter two.

Good Luck!!!

~~ CK
Feb 11 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.