09-13-2010 04:29 PM
Hi, all.
My purpose is to display on the LabView front panel a print preview of a report created with the Report Generation toolkit. I'd also would like to create several LabView controls to change the display settings, as zoom, page navigation, fit to page, fit to window...
After having read all about in the forums (there are several threads), I've decided to create a new topic and consider all the options we have:
HTML: With an ActiveX web browser we can show a report converted to HTML. This functionality doesn't allow much more than showing the report and navigate it with scrolls.
Excel: There are several threads talking about manipulating the Excel application via ActiveX, showing the print preview (in a window apart), but there's nothing about embedding this print preview on an ActiveX control. In case this was possible, I don't think we could remove the upper buttons of the preview window, and transfer their functionality to LabView controls.
PDF: We can convert an Excel report to a PDF with the PDF Creator (see Automatic Creation of a PDF file from Standard Report). Then we can display on the front panel the PDF document, and it's very similar to a preview window, because it has all the controls needed to navigate the report, zoom, etc. (see Display PDF in Dialog box in LabVIEW). It's almost perfect, but I can't find a way to remove or show programmatically the application toolbars and menu options (find, replace, bookmarks...). Another undesired behaviour is the run-time menu that is part of the PDF Reader application.
So, any suggestions?
Regards,
Francisco
09-14-2010 02:40 AM
For excel, I think there is a Microsoft Spreadsheet ActiveX class. I havn't worked with it.
Also there might be methods available to show hide menus/buttons in some of the applications.
Another idea to try is to bring these apps to their print preview. But I think the user would still be able to navigate back from the preview.
Felix