HOW TO PERFORM A DISTINCT COUNT ?

[sanchoniathon]

Hi,

I have a data item in my query that has the following expression:
count(distinct [Material Real Key] for [Store Real Key])

I validate the report and NO error message.

I have a simple LIST with only 2 columns: [Store Real Key] and [Product Key]
I then create a footer by choosing "Store Real Key (footer)" for my list and validate still no error message.

I unlock my report, i then try to ADD the data item to the Footer but keep on getting this error:
OP-ERR-0088 A syntax error was detected near 'count'.


Anyone any ideas ?

Thanks in advance !

[DustPanMan]

Create a custom calculation Summarization instead of adding the footer and manually updating it.

[sanchoniathon]

Hi DustPanMan,

Can you provide step by step instructions please ?

Thanks !