Accessing Common Dialog

[gengwall]

Has anyone scripted the use of windows common dialog functions for Open File and Save File within a Brio EIS? I would like to have a save file dialog box open when the user pushes a button on the EIS to export a section. Right now, I have to hard code the export file name information in or provide text boxes for the user to enter the information. The problem is that trying to get users to enter full path names for their saved (exported) sections is pretty tuff.

 

[Mafia]

my god! I just face the same problem now!

 

[Mafia]

oh,dear friend
you can just Call the export function without any parameters as below:
ActiveDocument.Sections["CaoPan"].Export();


or, you can also use old ExecuteBScript as:
ExecuteBScript("export section root.'ZhangYQ',''"

just test it, OK? any problem you can also contact me at:
mike_ZhuBL@sohoo.cum

 

[gengwall]

Nope - trick 1 doesn't work. I get the following error (Brio Explorer 6.1):

Line(1)adSpaScript(x):uncaught exception: Incorrect argument(s)

Trick 2 works but it doesn't allow me to NOT include the column headers in the output. Or, at least, I don't know how to not include the column headers.

 

[Triton46]

Your export statement doesn't have any parameters. It should look like this:

ActiveDocument.Sections["Results"].Export("C:\\temp\\result.csv",bqExportFormatCSV,true)

(bqExportFormatCSV,true) this part can be used multiple ways.

 

[Triton46]

*Note on Trick2

In version 6.5.2.0, Quickview will NOT recognize ExecuteBScript but Insight and Designer will.

Brio no longer supports ExecuteBScript.