Creating a MS Word or Excel Report

[Tim_C.]

I am working on an application that allows the user to enter text bullets (safety check proceedures) in a string control,  and enter the supporting reference in a second string control.  As these pairs are entered they are saved to a database.

The next phase is to create a report generating tool,  this will allow the user to select the proceedures they want included in the report.

I have a couple questions about creating reports:

If I want to have a report that has three colums, Col 1 proceedure, Col 2 Reference Text, and Col 3 compliance checkmark sub divided into three columns yes, no, n/a .   How do I setup a shaded colum header section at the top of each page  AND have all the seperate rows and colums border outlines showing?

Would a report like this be better suited to Excel or Word?

Is it possible to setup footers and headers, AND sections in MS Word?

Thank You

Tim C.

[K C]

Hi Tim,

 

I think Word is the better solution for this. (the best thing is not to use it at all) 

 

There are some VI for formatting table and some function you have to wire yourself.

For headers and footers I use a template. Years back I noticed that I could not create footers with multiple lines so I used a template as a solution.

 

For a lot of functions you have to be very patient if you have to wire it yourself because you must dig into the MS documentation.

 

If you have any problems I always be glad to help.