how do I toggle visibility of column in script?

gib65

<p>I'm trying to create a table that represents a person's tax slip. For example, a T4 slip. The database can return more than one tax slip for that person for that type (so one person may have multiple T4 slips). Our client wants the values for all the slips of a certain type (say T4) for a certain person to be put into additional columns.</p><p> </p><p>For example, one row for a person's T4 slip may look like:</p><p> </p><p>| Employee's EI Premiums | $100.00 | <-- one T4 returned</p><p> </p><p>or:</p><p> </p><p>| Employee's EI Premiums | $100.00 | $200.00 | <-- two T4s returned</p><p> </p><p>or:</p><p> </p><p>| Employee's EI Premiums | $100.00 | $200.00 | $300.00 <-- three T4s returned</p><p> </p><p>I haven't come across a way to add columns dynamically (having a fixed number of empty columns is not acceptable) so I'm thinking of creating something like 10 columns and making them all invisible at first. I would only make them visible if there is data added to them during the onFetch event.</p><p> </p><p>So my question is: how do I make the column visible during the onFetch event?</p>

mwilliams

<p>Well, depending on how your data is set up, this could just be a crosstab.  What does the data look like in your dataset?</p>