Print and Export to Excel a TableView

[Former Member]

I have a 6.10 BSP application that shows in one of its views many registers result of a Select, this registers are shown in a TableView, I want to put a button on the bottom of the screen so the users can click on it and Print only the TableView and not the rest of the view, How can I do this?. Right next to the button for Print I want to put another button so the users can click on it and Export to Excel the same TableView, again How can I do this?.

Thanks in advance,

Ruben Hopkins.

[thomas_jung · Accepted solution]

You might also want to look at this weblog:

/people/thomas.jung3/blog/2004/09/02/creating-a-bsp-extension-for-downloading-a-table

It offers the solution as a custom BSP extension. However I see that you said this was a 6.10 version BSP. Its been quite a while since I worked on a 610 system, but I would image most of what is discussed would need at least a 620 system.

[former_member181879]

You should first read at least one of the weblogs from Thomas on this topic. He does describe a lot of ideas.

My simplest idea for print would be just do a window.open with a new URL. This new page only renders the table in very simple HTML (no complex CSS, etc). At the bottom of the page do a print button = window.print() and a close button = top.close(). Primitive, but it is going to work.

The excel export stuff has been discussed to death in this forum already.

[Former Member]

Take a look at the weblogs from Thomas:

/people/thomas.jung3/blog/2005/02/14/bsp-and-microsoft-excel--learning-to-live-together

/people/thomas.jung3/blog/2004/08/09/bsp-download-to-excel-in-unicode-format