Results 1 to 2 of 2

Thread: count on crystal report

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Oct 2013
    Posts
    27

    count on crystal report

    Select count(id) from table where company_id='"& textbox.text &"'

    How i can formulate it in crystal report?

    i've formulate in SQL Expression Field - Selection Formulas - Group Selection but there's an error "a number required here" the cursor sign at {?CompanyID}.

    Count ({table.id},{table.company_id} = {?CompanyID} , "")

    whats wrong??\

    thanks

  2. #2
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: count on crystal report

    It seems that you have to declare numeric data type the parameter because the field 'company_id' is numeric
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width