Put a field in a sub routine that executes a DOS command string.

Something like this:

SHELL ("C:\Progra~1\av\avwin\avwin.exe /p" + {drawings.filename})

 

avwin.exe /P is the program Autoview with the Print Switch, and I want it to print the string path to the drawing held in {drawings.filename} which is in UNC path form of //drawings/customerfiles/file.dwg

 

I have just printed the {drawings.filename} field on my report and it is working correctly, but I can't find the proper syntax to run it from within Crystal. I have searched the web and found several examples, but none work in Crystal. I tried VB syntax and still cant get it.

 

I believe that I need to create a formula field to put this code into, and then put the formula into my SubReport?

 

In my closest attempt, I got it to print the whole string on the report, but did not execute it.

 

Help would be appreciated.

 

Regards,

George L. Hicks

 

'// this code calls c: est.exe
Shell "c:\test.exe", vbNormalFocus

So I should be able to do something like this in Crystal with VB Syntax?

 

Any thoughts?

 

Regards,

 

George