I'm in the process of evaluating Strata as a replacement Report Writer for my company.
So I've started by recreating one of my weekly reports, I've got my data in Strata no problem, started adding fields to the report designer along with groups, now I need a way to count records in one of my groups. I can't seem to find a formula that does what I need. If anyone knows the correct way to accomplish this It would be greatly appreciated.
Thank for any and all responses
OldCityCat
Kirix Support Forums
Getting a Record Count for a Report Group
2 posts
• Page 1 of 1
- OldCityCat
- Registered User
- Posts: 1
- Joined: Sat Jan 07, 2012 12:29 pm
Re: Getting a Record Count for a Report Group
A quick option:
In a group header or group footer, use the formula:
=count(fieldname) , where "fieldname" is any numeric field in the group detail.
Two issues:
1) This only works on numeric fields
2) The formatting is a bit wonky, as it will give you x.0000000... as far as your report will allow. Cleaning this up is a bit of a kludge -- shrink the column width of that field as far as you'd like. Then, in the cell immediately to the right, put in something some text like " records" or " items" and left justify.
I'll check in with our tech team on Monday to see if there are other workarounds I am not aware of. UPDATE: This appears to be the only workaround at this time; we'll add it to our bug list. Sorry about that.
Best,
ken
In a group header or group footer, use the formula:
=count(fieldname) , where "fieldname" is any numeric field in the group detail.
Two issues:
1) This only works on numeric fields
2) The formatting is a bit wonky, as it will give you x.0000000... as far as your report will allow. Cleaning this up is a bit of a kludge -- shrink the column width of that field as far as you'd like. Then, in the cell immediately to the right, put in something some text like " records" or " items" and left justify.
I'll check in with our tech team on Monday to see if there are other workarounds I am not aware of. UPDATE: This appears to be the only workaround at this time; we'll add it to our bug list. Sorry about that.
Best,
ken
Ken Kaczmarek
Kirix Support Team
Kirix Support Team
-
Ken - Kirix Support Team
- Posts: 147
- Joined: Mon Dec 19, 2005 10:36 am
2 posts
· Page 1 of 1
Return to Strata Help & Feedback