-
Nov 27th, 2013, 11:37 PM
#1
Thread Starter
Junior Member
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
-
Nov 28th, 2013, 09:41 AM
#2
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|