Display a report from SQL Server database

[PeggyC]

I am using SQL Server 2008 to store my data, and I am currently looking for a method to display the data into reports.  LabWindows/CVI is the implementation for the application, which contains the user interface to query the data and to load the report.  I want to ask what are the ways to do?

Thanks.

Peggy

[Eric_B.]

Peggy,

To do database interaction with CVI, you need the LabWindows/CVI Database Connectivity Toolkit.  Do you have this toolkit?  If so, there are examples installed in the example finder (Help»Find Examples) to show how to use that toolkit and I can give more help with that if you need it.

What data are you trying to present?

[PeggyC]

Yes.  I have SQL Toolkit.  Kind of similar to the report that is being displayed after TestStand test execution.  I need to create that report, display it to the user, and provide function to send that report to printer.  And, I am not sure how/what is the appropriate way to accomplish this task. 

From SQL Server, it is saying that I need to use Print Server.  But, I am not sure how to integrate that into LabWindows/CVI.

Also, I am thinking if is possible that I can use XML.  Dynamically generate the static XML report, launch the browser, and let the browser to handle the printing (This is my concept and I am also not sure if this is doable).

Any suggestions/opinions?

Thanks.

Peggy

[Al.B]

Hi Peggy,

I would recommend using the Report Generation Control in CVI, which will allow you to both generate your report and print from within CVI.

To add the NIReports control, navigate to tools»Create ActiveX controller, then follow the steps in the wizard, selecting NI-reports as the activex server.  After completing the wizard, you should see a new instrument which will give you access to the reporting functions.   If you would like to stick with XML, there is another activeX server available to help with that: Microsoft XML.

Let me know if you have any additional questions!