Getting Started

 View Only
  • 1.  quickbase table report

    Posted 12-10-2021 15:20
      |   view attached
    Hi everyone,

    I'm having some issues creating table report, the problem is that the report shows duplicate record and I don't know how to filter duplicate records out. 


    ------------------------------
    Mike Nouri
    ------------------------------


  • 2.  RE: quickbase table report

    Posted 12-10-2021 19:07
    I'm not quite sure what you plan to do with this report but why don't you try using a different report tape. Try the Report Type of Summary report and then you will only see one entry per summary group.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: quickbase table report

    Posted 12-10-2021 20:36
    I tired to create a Summary report and but the problem is that there limit of 6row under the Grouping and crosstab section. I will need 8 to complete my report.

    ------------------------------
    Mike Nouri
    ------------------------------



  • 4.  RE: quickbase table report

    Posted 12-10-2021 22:54

    There are a couple of options. 

    One is to make a formula field to concatenate a few of the relative fields together. That will save in fields. The other is if the numerical values are also repetitive, you can choose to not group them but rather use them as a field and average them.  



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------