Need to create count variable in iReport

[raja.shekar]

I need to find the count of a field in iReport. For example i need to create a variable called "CallCount" which have count of "CallType" field. So i need to use "CallType" field in Category section of Piechart and "CallCount" variable as measure. So that pie chart will show the call types and its call counts. Please help me on this....

[dhruvisha]

You can use sql script to get count in the report for the "CallType" field .

 

select count(CallType) as CallCount from <table_name> <condition if any> [/code]

Now you can use CallCount variable in your report.

[raja.shekar]

Hi dhruvisha,

Thanks for your feedback.

I am using domain dataset to create the report from iReport. Please suggest how can i create count variable for calltype..