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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RiddleMeThis
    New Member
    • Feb 2010
    • 8

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

    In Crystal, I've come across the following code but don't really understand it:
    Code:
    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
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    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

    Comment

    Working...