"reference in" to "report in"

[drewsali]

Using 8.6, I'm trying to use "Excel Bring to Front.vi" from the report generation toolkit. It's input and output are of the format "report in" and "report out". I'm using activeX controls and application references. How do I convert the ref num to a report in? I've tried various combinations with variants and class operators. Does anyone have an example? Thanks, Andrew

[MikeS81]

Hi Andrew,

can you show what you have done? Did you look inside the vi. There is only a property to set the visible flag. If you have an Excel._Application refnum, then you can use this directly this property node.

Mike

[Davidek]

Hi drewsali

Switching between using the report generation toolkit and ActiveX calls can be tricky. Especially going from ActiveX to Report Generation as the toolkit is built on ActiveX. What I would recommend is, just like Mike recommended to open the VI and find the ActiveX calls are made then do the same direct in ActiveX in your VI. 

Best Regards

David

NISW

[drewsali]

Thanks for your input! I like your ideas for the work around. In this case, I agree, it would be easier to perform the same function using activeX in my top level VI.

Here are a few screen shots. "Excel Bring To Front.vi" had a clever way to go from "report in" to a "reference in". I tried to emulate the unbundle by name with the class operator and the "report" constant but was unsuccessful.

I'm still curious about why I was not able to duplicate the toolkits method of conversion. Suppose I want to make use of one of their more complicated VI's, though a conversion might be tricky, it would behoove me to have that in my toolbox as opposed to having to copy all their work for my uses.

Andrew

[Davidek]

Hi Andrew

I had the same problem a while back and if I remember correctly it is because that unbundle is only possible in a VI that belongs to the toolkit. I'm a bit fuzzy on the details, but I'll check tmr when I'm back in front of a computer with LabVIEW. I think I solved it by rewritting the toolkit VI to fit the customers specific needs, but that is not something I can recommend. That solution was just a stopgap until I had time to do it in ActiveX.

Best Regards

David

[Davidek]

Hi Andrew

You can only unbundle the report reference in a VI that belongs to the NI_Excel class.

Best Regards

David