Topic: Count Function in unrepeatly Values! Posted: 09 Oct 2010 at 1:52am
Hello My Dear Friends I Have a report that contains multiple fields and I want to see count of the field "Example Field" with string data value but in normaly condition the count is number of records that SQl syntax is affected. But I want to see number of records or fields that contain no-repeatly values.
example is below:
"Example Fields" John Jack Sara John Sara Bill in normaly condition -> Count("Example Field") = 6 but i want to see -> Count("Example Field") = 4 (only 4 person exists!!)
How I Can See this Result by crystal Report Functions and abilities??
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
