Varying the number of based on totals

[crysma]

Hi,

I was wondering if there is any way to 'skip over' a column of a table and now display it if the total for that column is zero? For example, if I had the following table:

Col1 Col2 Col3 Col4
Row1 1 0 2 3
Row2 2 0 4 2
Row3 1 0 2 1
Total 4 0 8 6

The total is a calculated value and not in the database. Is there some way to tell not to print items in a column if the total comes to zero?

I'm not sure if i explained this properly. I hope it makes sense. Thanks in advance for your help,

Sheryll

 

[synapsevampire]

If you just want to suppress the data, right click the field and select format field.

Select the Number tab and then select Suppress if blank.

If there aren't negative values, the number should never show.

If you mean completely omit the column, this would be trickier, you'd have to create a report to determine this, and then use a subreport with varied sections with different amounts of columns that are turned on or off depending upon passed values...

Please explain the intent a bit more.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[crysma]

What I need it to do is to omit the whole column entirely if its total is zero. That means that the table in the example above should have only 3 columns, not 4, as the second column should be removed.