To hide column from a table box

[#1]

Hi,

I have a table box with almost 20 columns. I do not want to display all the columns, I would need to display only few columns, but when i send to excel, i need all the 20 columns in excel.

So my view, if i can hide the columns on a table box, my display would be limited at the same time on send to excel i get all the columns.

Any help around this ?

Thanks !!

[sujeetsingh]

USE STRAIGHT TABLE

[#3]

Hi

Using straight table will solve half of the issue. I have hide columns, but when i send to excel...only displayed columns will be exported but not hidden columns

Thanks !!

[sudeepkm]

May be you can have two straight tables.

First one with Layout as Top and with few columns hidden and hide the caption

Second one with Layout as bottom with all columns visible and Show caption in such a way that the two tables look like single table. The export to excel will export data from second table which has all the columns visible.

Please take a look at the QVW attached.

[#5]

Hi Sunil

Send to excel will do just that  - send exactly what you have on the screen to excel. The alternative is to create a copy of the table, but with all the columns showing, for export.

To automate the export (and have it still work in AJAX, assuming that is what you are using) would be to either:

1) Use a button - add the external action "export" and in the setup specify the columns you need and CSV (although not strictly an excel document), if this is possible

or

2) Shrink the table and overlap some items on it so only the excel button shows - eg

then instruct your users to use this button!

Erica

[MK_QSL]

May be someone can suggest you a Macro which can solve your problem.

[#7]

Another alternative would be a button, that when you press it does these actions:

1) sets the variables controlling whether the columns are visible, so that they are visible

2) exports to csv

3) returns the columns back to normal again

Erica

[#8]

Sunil are you using AJAX?

[#9]

Hi Erica,

Nope. I`m not using AJAX. The other alternative solution from Sudeep & your suggestion on using a button to make column visible / hide should work.

Any particular reason about asking if I`m using AJAX?

Thanks !!

[#10 · Accepted solution]

Thanks all !!