Discussions

Expand all | Collapse all

Printing table report

  • 1.  Printing table report

    Posted 12-24-2020 20:45

    Hello,

    I have a table report with 70 columns and some of the rows are colored.

    I need to print this often but need the color to remain- when I save it as a spreadsheet the color doesn't stay but I can't print it as a PDF since it wont include the entire report.

    Does anyone have any ideas to print the report while retaining the color?

    Thank you!



    ------------------------------
    Miriam Klugman
    ------------------------------


  • 2.  RE: Printing table report

    Posted 12-24-2020 21:06

    Can you explain what's not working with print to PDF?  Are you missing the colour or some of the columns.



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Printing table report

    Posted 12-24-2020 21:08

    I'm missing some of the columns- there are 70 columns on my report.

    Thank you



    ------------------------------
    Miriam Klugman
    ------------------------------



  • 4.  RE: Printing table report

    Posted 12-24-2020 22:03

    I know it's PDF but try setting landscape and selecting a large paper size. I'm not at my computer now though to test      Also try gong to your name at the top right, then manage my preferences and set to condensed  



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Printing table report

    Posted 12-24-2020 22:09

    I tried that and now I can get all the columns on the PDF but the text is so small and illegible.

    Thanks



    ------------------------------
    Miriam Klugman
    ------------------------------



  • 6.  RE: Printing table report

    Posted 12-24-2020 23:22
    Edited by Mark Shnier (YQC) 12-25-2020 10:21

     If the purpose of the PDF is to archive data then it can be wide and the user can scroll across  and zoom in on the important parts. 

     But if the data does have to be readable without a magnifying glass  and the number of fields when laid out horizontally causes the font to be too small then if you really do need all those fields to be on the report your only other option is to expand in a vertical direction. 

     What do I mean by that? 

     Suppose for example you have I said the fields which describe contact information.  You can create formula fields that would stack several fields vertically. 

    So instead of having say 4 fields  across, those related fields would be stacked vertically.  So you may end up with say only 40 fields across the page instead of 70.

    for example. 

    Five  wide columns like

    Company First Last Title email Phone

    Your Quick Base Coach Mark Shnier Chief Builder of Builder mark.shnier@gmail.com

    vs

    Your Quick Base Coach

    Mark Shnier

    Chief Builder of Builder

    mark.shnier@gmail.com

    (800) 970-2000 x3704

    the formula to stack fields is

    List("\n", [field 1], [field 2], [field 3], [field 4], [field 5])



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------