new report.vi

[girish53]

I am using Labview 2021. I want to generate an xlsx file as shown in the Knowledge article as shown below.

I cannot file New Report.vi on my computer. All the other vi's exist. How do I get New Report.vi?

Thank you. 

Girish Joglekar

[Bob_Schor]

Sometime between LabVIEW 2010 and LabVIEW 2015, the Report Generation Toolkit function called (originally) "New Report" was replaced with a function called "Create Report".  You are looking at a "picture" of a very old Block Diagram.  Replace the "New Report" with "Create Report" (from LabVIEW 2021) and see if that fixes things.

Bob Schor

[girish53]

Thank you for your help. There is only one problem. After I save the report, Excel opens the report file. How do I prevent Excel from opening it? The block diagram given below:

Girish

[Bob_Schor]

A decade ago, I wrote and posted on the Forums a Demo showing how to do "useful things" with the RGT.  If you go to the Search bar on the Forum and type "Revised Generate Excel Report", it will pop up.  It may use "New Report" (it's that old), but (a) it should still work, and (b) you know how to fix it.

But I didn't see a "Close Report" at the end of your code -- you've opened Excel with "Create Report", and have a data line that runs through the top corners of all of the RTG functions you use, so to gracefully say "Thank you, and goodbye" to Excel, you need to politely dismiss it with "Close Report".

Bob Schor