Forum Discussion

MichaelNaser's avatar
MichaelNaser
Qrew Trainee
3 years ago

quickbase table report

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
------------------------------
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    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
    ------------------------------
    • MichaelNaser's avatar
      MichaelNaser
      Qrew Trainee
      3 years ago
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        3 years ago

        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
        ------------------------------