Alpha Video Training
Results 1 to 4 of 4

Thread: Hide Column in Report

  1. #1
    Member
    Real Name
    Greg Carmody
    Join Date
    Apr 2017
    Location
    Sydney Australia
    Posts
    188

    Default Hide Column in Report

    I want to hide a column in a layout table report based on a field in the sql table the report is based upon.

    The report is a nested grouped report with two levels of grouping. The outer groping is based on whether the field 'Encumbered' is set to "Yes" or "No". The inner grouping is based on the value in the 'Financier' field.

    For the outer grouping where 'Encumbered <> "Yes", I want the column 'Agreement No" not to be shown. I can insert an expression into the header column for Agreement No to not display the heading if Encumbered<>Yes. I can also insert an expression into the detail section for that column not to show the value of the agreement no if Encumbered <> Yes.

    That works fine, however the space for the column is still there, albeit will no values in the cells or heading. I tried to insert an expression in the dynamic column width property for each of the cells in that column: if(Encumbered<>"Yes",0,64). But that didn't seem to have any effect.

    Is there a way to remove the space used by the column ?

    Thanks,
    Greg

  2. #2
    Member
    Real Name
    Greg Carmody
    Join Date
    Apr 2017
    Location
    Sydney Australia
    Posts
    188

    Default Re: Hide Column in Report

    Anyone?

  3. #3
    Member
    Real Name
    Greg Carmody
    Join Date
    Apr 2017
    Location
    Sydney Australia
    Posts
    188

    Default Re: Hide Column in Report

    Given that i din't get any better suggestions, i ended up defining a second report layout without the agreement column, and selecting the appropriate report format in the button action based on the flag for displaying the agreement number.

    Greg

  4. #4
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,560

    Default Re: Hide Column in Report

    An html report or a conditional object with the 2 layouts within a single report are options.

    You can generate the html by xbasic string manipulation.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. Hide column in Brrowse
    By rlgiordano in forum Alpha Five Version 11 - Desktop Applications
    Replies: 8
    Last Post: 09-16-2013, 04:55 PM
  2. Having a column hide on load, then unhide on click (of a button or another column)
    By pwatt01 in forum Application Server Version 10 - Web/Browser Applications
    Replies: 0
    Last Post: 01-15-2013, 12:08 AM
  3. How can I hide a grid column
    By mikew in forum Application Server Version 10 - Web/Browser Applications
    Replies: 16
    Last Post: 05-25-2011, 06:13 AM
  4. Hide Column or Hidden
    By bob9145 in forum Application Server Version 10 - Web/Browser Applications
    Replies: 0
    Last Post: 01-30-2011, 11:58 PM
  5. Simple way to hide a column?
    By keuler in forum Alpha Five Version 9 - Desktop Applications
    Replies: 16
    Last Post: 11-07-2008, 12:11 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •