distinctcount ( {database.table} = "Some String" ) 1

[Halfcan]

Hi, I want to do a distinctcount on a table ONLY if it contains a certain string value.
I've tried this:

distinctcount ( {database.table} = "Some String" )

but get "summary/running total could not be created"
Is this possible?
using crystal reports 8.5.
thanks,

J

 

[rhinok]

You have a couple of opions:

1) Use the Running Total Wizard and create a Running Total that performs a distinct count on the field where the value = 'x'.

2) Create a formula that returns 1 when the field value = x and summarize the formula in the footer.


~Kurt

 

[rahulverma2004]

This kind of summation may not be possible.

One way to approach the scanario is to add a formula "in the evuluate section of the running total expert while using distinct count as the summary method for the field
{database.table}.

Your formula could be {database.table} = "Some String"

Thats the condition on which the running total will be returned else null values.

Hope that helps,

Rahul