"Tree" style columns in report?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
I'm not sure if this is titled right or not, and I'm having a hard time thinking about how to describe it, but I was wondering if there was a way to format column headers on a report like the attached image.

Photo of Matthew

Matthew

  • 60 Points

Posted 4 years ago

  • 0
  • 1
Photo of Ceci New York

Ceci New York

  • 0 Points
Looks like you're talking about a "Summary Crosstab" report - see here for the online help on the topic:

http://www.quickbase.com/user-assistance/Default.html#about_the_summary_view_page.html


and then also here for "Create a Summary or Crosstab Report"

http://www.quickbase.com/user-assistance/Default.html#creating_a_summary_view.html
Photo of Matthew

Matthew

  • 60 Points
Yes! That's exactly what I want.
Here's the thing though, In the "Summary Crosstab report" example in the Help page(http://www.quickbase.com/user-assistance/images/summaryrpt.png), The different status's (Not started, In process, etc)  would be my "Vendor 1, Vendor 2, etc" looks like it needs to be a multiple choice field; Where in my form, Vendor 1, 2, etc. are Sections, and lookup fields.
Second, I simply would want the values of the "Bid" and "Lead" (% Complete and Number of tasks in example) displayed, not calculated in any way.
Photo of Xavier Fan

Xavier Fan, Champion

  • 630 Points 500 badge 2x thumb
If your Vendor 1, Vendor 2 (and their associated fields) are individual fields on a single record, then unfortunately summary reports won't work.

Summary / crosstab reports are intended for a situation where you have a Vendor table, where each Vendor record would have their own "Bid" and "Lead" numbers.  Then you can create a summary crosstab report by Vendor.
Photo of Matthew

Matthew

  • 60 Points
Is there a way to make a crosstab report using some fancy coding?
Photo of Xavier Fan

Xavier Fan, Champion

  • 630 Points 500 badge 2x thumb
Probably - but that's something I can help you with. =(