NicolaTesla1
Programmer
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 !
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 !