Report generation toolkit (1.1.2) and 8.5

[_Bryan]

I am not as crazy as I thought!

I wrote a program today that collects data from excel reports in many directories using cell names and it worked well.  Unitl I saved it.  I had been saving the sub vi's, but when I went to close them I got a message about unsaved changes and I guess I clicked to save the changes today.  The program never worked the same again.  I would get errors like 41106 and 41110 at random (problems with excel not opening and other stuff).  I tried adding waits which slowed everything down and worked mostly.  But the only way to not drop data and get errors was to have a copy of excel open while getting my data.

  Well I just uninstalled/reinstalled the toolkit and rebuilt the vi that was having problems with the fresh install and everything is great again.  So my question is why does the toolkit have problems when I save it in 8.5?  The warning does say that the vi's are from 7.1 and I cant find any updates so I am hoping this is the latest version that came with my 8.5 suite.

[parthabe]

We ve also got the LV 8.5 Dev Suite, but some of the VIs in the RG toolkit still show up while closing that they re made in version 7.1. I dont understand why this is so.

[CarlaU]

Hi Bryan,

There should not be a problem with saving the VIs from the Report Generation toolkit in LabVIEW 8.5. I have checked the readme files to make sure but RGT 1.1.2 should work with any version of LabVIEW later than 7.0. However, the readme does discuss an specific upgrade issue. It says if you previously created VIs that use the built-in Report Generation VIs in LabVIEW Professional, Full, or Base packages or VIs from a previous version of the Report Generation Toolkit, installing the Report Generation Toolkit 1.1.2 might break the VIs you created. If the VIs you created contain any of the following VIs, edit them so they are compatible with the Report Generation Toolkit 1.1.2.

Append Front Panel Image to Report VI—The Image Format input of the LabVIEW 6.1 version of this VI is a different enumerated type than the current toolkit version. Right-click the input and select Create»Control or Create»Constant from the shortcut menu to create a compatible control or constant.

Append Table to Report VI—The connector pane position of the show grid lines input changed from the Report Generation Toolkit 1.0.1 version of the VI. Reconnect the original wire to the new input location.

Get Report Settings VI—The cluster order of the font settings input changed from the Report Generation Toolkit 1.0.1 version of the VI. Right-click the output and select Create»Indicator from the shortcut menu to create a compatible indicator.

Report Express VI—If a VI includes the LabVIEW built-in version of the Report Express VI on the block diagram, the VI breaks after you install the Report Generation Toolkit 1.1.2. Double-click the Report Express VI to launch its configuration dialog box, then click the OK button. Reconnect all wires to the Report Express VI.

You might need to relink the following subVIs after installation because the connector panes changed in the Report Generation Toolkit 1.1.2. Right-click the VIs and select Relink to SubVI.

• New Report
• Dispose Report
• Append Front Panel Image to Report
• Append Hypertext Link Anchor to Report
• Append File to Report
• Append Horizontal Line to Report
• Set Report Font

One thing that might have happened is if you had created the program in an earlier version of the toolkit, then saved it in the new version of the toolkit, maybe some of the upgrade issues regarding the VIs listed aboved cause LabVIEW to start giving you errors. Also, which version of excel are you using? After you re-did the VI program, have you tried to save it again and see if the same problem occurs?

Carla

[_Bryan]

Hello Carla,

Thanks for the reply.  I built the vi on a new machine that I just installed 8.5 on, so there were no previous versions to conflict with.

I am using excel 2003 and was mostly getting the 41106 error, excel did not open.  When I rebuilt the program I was not brave enough to save the report vi's to 8.5, so I just left them as is.

On my way to lunch I came up with the attached image and it seems to work well for a temporary fix.  It would be nice if there was a longer or adjustable timeout when LV tries to open excel to keep error 41106 from happening.  But as long as excel opens sooner or later my band-aid should work for now, otherwise I will need to code a limit on how many attempts it makes opening excel before shutting down the program.

[HDRM]

Hi!

I've got the same problem with LV 8.5.1, RG Toolkit 1.1.2 and MS Office 2007. Wenn creating a new report with the "New Report.vi" (an Excel template is used), error -41106 is returned sporadically.

As a first workaround, I repeat the "New Report.vi".

Regards

Manuel

[Wise_Owl]

I got the same error number with LabVIEW 2010 and Office 2007 and traced it to a dangling registry entry after installing and uninstalling Office 2010 beta.  See http://digital.ni.com/public.nsf/allkb/3E4102D8B91D0F9E86256CE0006BADCB for details about where to look in the registry.  I had entries for 1.7 and 8.5 (Excel 2010 and Word 2010 respectively) and upon deleting them, my problems went away.