Summary Report
Hi Everyone,
I am trying to create a report that will summarize a numeric field per address, but I need to display other fields on the record... Does the platform supports this?
Example of ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendhave you considered using a simple table rdport and sing yhe Group by sort option to sort and group by address?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Summary reports are bound to summarizing numeric data which means that your text fields that you have shown above cannot be included in the summary report unless you are grouping by them. There is a way that you can try and 'fake' the summary report by adding all of the text fields that you want in the 'Grouping and Crosstabs' section and add each field as a 'Group By'. The only issue is that it will cap out at 5 fields.
The theory is that your records all have the same values for those 5 fields as is, so its more complex to summarize that way but it technically works and then you summarize the actual columns you want.
Counting in your report above, it looks like you have 10 text fields, so you can create 'combined text' fields, so instead of Customer and ID as different columns do Customer Name (ID) as one field.
If that doesn't work - you'll need to use a table report per Marks suggestion and use summary fields to roll up the # fields you want to report on somehow.
------------------------------
Chayce Duncan
------------------------------
