"The summury/running total field could not be created." error message

[15011967]

Can someone help me to disolve the error in this formula?
the message i received from Crystal reports id "The summury/running total field could not be created."


Count(({View: 1_ National Appeals\8_ Finalised.Registry<String>}='Adealaide' and
CDateTime({View: 1_ National Appeals\8_ Finalised.DATEREGISTERED<String>})>={?StartDate} and
CDateTime({View: 1_ National Appeals\8_ Finalised.DATEREGISTERED<String>})<={?EndDate}) or
({View: 1_ National Appeals\8_ Finalised.TransferFrom1<String>}='*' and
CDateTime({View: 1_ National Appeals\8_ Finalised.DATEREGISTERED<String>})>={?StartDate} and
CDateTime({View: 1_ National Appeals\8_ Finalised.DATEREGISTERED<String>})<={?EndDate}))

 

[Naith]

You're getting this error because you're saying 'Count {Something} = 'Something'. This is incorrect count logic.

This looks like a record selection formula, but for the life of me I can't think why you're trying to do a count in here...

Count(({View: 1_ National Appeals\8_ Finalised.Registry<String>}='Adealaide'

What are you trying to do here?

Only count the field where it's equal to 'Adelaide'?

If you only want to bring back Adelaide records, and then count them, you don't need to qualify the count in the record selection. But you do need to specify:
{View: 1_ National Appeals\8_ Finalised.Registry<String>}='Adealaide'

Then you just create a count summary, or formula
Count({View: 1_ National Appeals\8_ Finalised.Registry<String>})
in the report.

Naith

 

[15011967]

Naith,
Thanks for your prompt answer. I am very net to Crystal and i do not much experience with select expert.

I wanted to generate a report that will give me a total number of application, subbmited in specified period in each of the registers. I used the following fields: Region, DateRegistered and TransferFrom1. The rows which should be counted contains any value in Registry field and any value in TransferFrom1 field, grouped by registry.

Could u please show how to get this?
Thanks in advance.