Hi All,
Since I have had many requests for copies of the script I have written, I
thought it might be nice to just publish this.
Attached is the script to be submitted to DAS for writing to PDF format.
The trick is to write to the Distiller Printer which creates the
C:\DISTASST.PS file. This is then moved to an IN folder watched by the
Distiller Assistant which will then convert it into PDF and move it to an
OUT folder.
(See attached file: Dasaspdf.spt)
You will need to modify the constants in the scripts to suit your
requirements.
The logic of the script is as follows :
- Use the Title of the report for the destination filename. If the title
is blank, use UNKNOWN. (The title is set using File/Properties from BO) - Print the report to the Distiller Printer. ( This name is one of the
constants ) - Wait for C:\DISTASST.PS to be created (This will timeout after 150
seconds) - Move DISTASST.PS to the C:\IN folder with the new name.
- Lauch Distiller Assistant
- Distiller Assistant should have been configured to watch C:\IN for .PS
files and create the PDF files in the C:\OUT folder. - Wait for the PDF file to be created in the C:\OUT folder
- Move the PDF file to the destination LAN folder.
- Log the various steps to the LOG file.
Here are some instructions I put together for installing Acrobat Distiller
software.
Install Acrobat Distiller 3.01
- Start Control Panel / Printers
- Add Printer
- Next
- Select File
- Next
- Choose HP, HP LaserJet 4/4M PS
- Next, Next, No Test Page, Finish,
- Insert NT Server CD for the drivers
- Load Acrobat 3.01 CD
- Run INSTALL.EXE
- Next, Yes,
- Check OFF all options and ON for only Acrobat Distiller 3.01
- Next, Next, Name, Company, Serial Number,
- Next, Yes, Next, Check OFF Register and Read Me
- Finish
- OK
- Remove CD
Setup Adobe Distiller as a service ( Only if you have the Resource Kit )
- Start DOS Window
- INSTSRV AcroDistiller SRVANY.EXE
- Run the Registry Editor (REGEDT32.EXE):
- under
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\AcroDistiller: create
a ‘Parameters’ key - under the above key, create an ‘Application’ value of type REG_SZ and
specify the following value C:\Acrobat3\Distillr\ACRODIST.EXE - Exit from Registry Editor
- From Control Panel, click Services
- Select AcroDistiller then click Startup
- Set Startup to Automatic
- Check ON $B!H (BAllow service to interact with Desktop $B!I (B
- Click OK and Start AcroDistiller service
- Acrobat Distiller will start
- Select Actobat 2.1 Compatible
- From Menu, Distiller, watched Folders,
- Add Folder
- Select C:\
- OK
- Check ON $B!H (BDelete files in Out folder older than 10 days $B!I (B
- Exit
- From Control Panel, click Services
- Select AcroDistiller then click Startup
- Check OFF $B!H (BAllow service to interact with Desktop $B!I (B
- Click OK and Stop AcroDistiller service
P.S.Mohan
Bankers Trust Co.
(212) 602-1842
p.s.mohan@bankerstrust.com
name="Dasaspdf.spt"
Content-Disposition: attachment; filename=“Dasaspdf.spt”
Attachment converted: Macintosh HD:Dasaspdf.spt (???/----) (0000E5D9)
X-Lotus-FromDomain: SANDERS@INTERNET
Date: Thu, 14 Jan 1999 17:39:30 +0100
Réf. : Re: Réf. : combining incompatible objec
ts
I have a query which is returning sums of volumes, sums of prices, and
average prices. BO splits this into 2 queries which are joined on all of
the common fields (all fields except the above). I have put the sales on
one tab and the purchases on a second tab. I created a weighted average
price as a variable defined as the Total Purchase Dollars / Total
Purchase Volume, which are defined as sums in the second tab. I want to
subtract this variable (Weighted Average Price) from each Sales price on
the first tab to get a margin for each row.
When I attempt to do this, I get #IERR in each margin column.
Thanks for any help you can give me.
Listserv Archives (BOB member since 2002-06-25)