Custom Report based on customer sheet

[Joe_H]

For my test set the customer has a report that they want generated but I am unsure how to go about doing this. They want it very high level. Just test name, limits, Result. and for the best part they dont want to change the format at all. They would also like to have the detailed report the TS generates.

I attached the report so you could see what they desire. 

How would I do this in teststand? Would I be better off generating this from the database and not even use TS.

I dont even know where to start with this.

[santo_13]

If you're using Numeric Test Step or Multiple Numeric Test Step, the key is mapping the elements of the Result cluster to the columns in your report.

You can keep track of an array of these result objects and, in the end, iterate through the result objects in LabVIEW, format this report as a table in PDF, and write to file.

Checkout these articles,

https://www.ni.com/en/support/documentation/supplemental/08/teststand-report-generation-and-customiz...

https://www.ni.com/docs/en-US/bundle/teststand/page/customizing-reports.html

https://www.bloomy.com/system/tdf/custom_ni_teststand_reports_-_niweek_2011.pdf?file=1&type=node&id=...

Logging these data to a DB and generating reports on-demand from the DB is also a good approach.

[Laurent_B]

If your template report is an excel or a word file, The links below will give you a solution using the labview report toolkit.

The idea is to set bookmarks in the word/Excel template. During the execution of the test, the measurements can be recorded at any bookmark location.

Regards

Laurent

Building a Microsoft Word Template and Adding Content to Bookmarks Using LabVIEW Report Generation T...

Solved: excel report generation does not exit excel - NI Community

[Joe_H]

So what would be the best way to set up my sequence file. Currently I have it set up like this.

Sequence Call--> Test Sensitivity

1. Call numeric limit test A
2. If Test A fails call test B (Fine tune To find specific limit at which it would pass. -68 - 0 db) . Ex Test A limit is -68d and it fails we then call test B to find out the actual number that it is able to pass.
3. Return actual results from either test A or Test B and only the pass or fail status from test A.

Can a sequence call have a result?

Would this be best to just do Test A and B all in 1 LabVIEW  vi and just pass out the 1 set of data? 

[ee-jallen]

---

@Joe_H wrote:

Can a sequence call have a result?

Would this be best to just do Test A and B all in 1 LabVIEW  vi and just pass out the 1 set of data? 

---

You can just return all the data in one array; it is up to you.  Then to set the sequence call as a test, click the Step Type button.

Choose Tests > Multiple Numeric Limit Test

Set all the limits and other properties for the Multiple Numeric Limit Test step