making a report using data from a database in labview

[JimiH]

How can I make a report in LabView using data from a database(access). So I need to create a sjabloon(standard) and fill in the specific data for different instruments. The database is is filled with data from a teststand sequence and is used for calibrating instruments, so I have to create a report with the measurements. I know I can do this directly with TestStand but there is a need to do this in a LabView build application. Maybe there is somebody who can help me with an example of how to do this.

[MikeS81]

Hi W1ldb1ll,

do you already have your data in LabView? You can use the Report Generation Toolkit to create Reports. Which format of report do you want to create (Word, Excel, html, ...)?

Mike

[Norbert_B]

Since i asume that the LV application should run independend from TestStand, i think that the data really has to be extracted from the database. The easiest way to do this is to use Database Connectivity Toolset for LV. If you don't have access to this tool (and cannot purchase it), you can either go the hard way and implement the needed functions on your own. But esp. for the database toolset, this will be very difficult.
The other possibility is to use an "interim tool" which does the database-communication for you. The data retrieved has to be accessable from LV nevertheless, so you have to get it either using files, TCP or other "multiapplication communications channels".....

hope this helps,
Norbert

[JimiH]

Hi Mike. I dont have the report Genaration toolkit. The prefered format is Word. The program is build in LabView with a Call to Teststand that genarates the data and puts it in a database. Are there any free tools to retrieve this data in a reasonably easy way?

Thanx

[JimiH]

Hi Norbert, what do you mean by Interim Tools?

Thanx

[Norbert_B]

You can create a tool reading datasets from databases and store them in any format using any programming language. As i said, you can even write this using LabVIEW without using the database toolkit. But this will be hard. Other languages might me simpler for this, depending on the purpose of the language. Perharps somthing like a script would be sufficient.
When i said "interim tool", i thought of such a tool (e.g. storing the data into a file) written in another language than LV.

Norbert

[MikeS81]

Hi W1ldb1ll,

see also this link http://forums.ni.com/ni/board/message?board.id=170&view=by_date_ascending&message.id=81991#M81991, maybe it heps.

Mike