I am fairly new to JasperReports Server, but I'm getting the hang of it overall. However, one thing is confounding me. I cannot figure out how to get a count of records in a cross tab.
For example, my Incident domain contains fields for Region and Type, and a measure for Size (amongst other things).
I can create a crosstab that gives me the total (or average) size for incidents per Type across the top and Region down the left... but I cannot figure out how to get it to give me the total number of incidents in each. Size is an optional field, so when I try putting it with Count All, I only get the number of non-null records, but I need the full total.
I figured out what feels like a hack - I put a calculated measure with a formala of "1" and then used Sum on that field, but that seems like the wrong thing to do.
Any help appreciated. We're on version 7.0 right now but are about to update to 7.2.