raja.shekar Posted November 24, 2014 Share Posted November 24, 2014 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.... Link to comment Share on other sites More sharing options...
dhruvisha Posted November 24, 2014 Share Posted November 24, 2014 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. Link to comment Share on other sites More sharing options...
raja.shekar Posted November 24, 2014 Author Share Posted November 24, 2014 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.. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now