aggregate function in IIF?

hello,
I am trying to use aggregae function within IIF clause. I am trying
to run this code
=iif( Fields!CLIENTID1.Value=Fields!CLIENTID2.Value,0,count(
Fields!CLIENTID1.Value ). It gives me an error that aggregate functions
cannot be used in report parameter expression.
Can any one help me to solve this problem.
Thanks
Najamtry the other way round:
COUNT(iif(Fields!CLIENTID1.Value=Fields!CLIENTID2.Value,0,Fields!CLIENTID1.Value))
"siddiqins" wrote:
> hello,
> I am trying to use aggregae function within IIF clause. I am trying
> to run this code
> =iif( Fields!CLIENTID1.Value=Fields!CLIENTID2.Value,0,count(
> Fields!CLIENTID1.Value ). It gives me an error that aggregate functions
> cannot be used in report parameter expression.
> Can any one help me to solve this problem.
> Thanks
> Najam|||=iif( Fields!CLIENTID1.Value=Fields!CLIENTID2.Value,0,count(
Fields!CLIENTID1.Value ). It gives me an error that aggregate functions
It looks like you are missing the closing bracket of the count function. try
this:
=iif( Fields!CLIENTID1.Value=Fields!CLIENTID2.Value,0,count(
Fields!CLIENTID1.Value )). It gives me an error that aggregate functions
"siddiqins" wrote:
> hello,
> I am trying to use aggregae function within IIF clause. I am trying
> to run this code
> =iif( Fields!CLIENTID1.Value=Fields!CLIENTID2.Value,0,count(
> Fields!CLIENTID1.Value ). It gives me an error that aggregate functions
> cannot be used in report parameter expression.
> Can any one help me to solve this problem.
> Thanks
> Najam