Count Records in report

[Samir Patel]

Hi,

I have value stored in the Table with the Preferences related to customer , Customer Select the value single / double / triple...and i need to show the count of single / double / triple in my report...

I.e When I run my Report based on tour ID , then In that report i need to show :

Count of Single = xx
Count of Double = YY
Count of Triple = ZZ

How should i write the Count function to retrieve the value from the table?

Regards
samir

[Peter]

Hello Samir Patel,

For a conditional count you can nest the IIF operator into a Count aggregate as shown in the following sample expression:
=Count(IIF(Fields.Year=2005,1, Null))

However have in mind that Telerik Reporting Table item is a separate data item. Thus you can use aggregates over table's data in the table itself.

Check out the attached sample.

Greetings,
Peter
the Telerik team