You might try to change the .vFileName to &vFileName Dan Goldberg _____
From: [email protected] [mailto:[email protected]] On Behalf Of Tom Frederick Sent: Friday, February 05, 2010 2:39 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: PDF files on Network What works on C:\RBTI is: SET VAR vCurrDir TEXT = ((CVAL('CurrDir'))+'\PDFs\') SET VAR vRep TEXT = 'MHA' SET VAR vRepTitle TEXT = ((CTXT(.vZID))+'_'+.vRep+'_'+.vStDate+'_'+.vStTime+'.PDF') SET VAR vFileName TEXT = (.vCurrDir + .vRepTitle) PRINT Mental_Health_Assemment WHERE ZID = (.vZID) + OPTION PDF + |FILENAME .vFileName + edited 20 lines out |OPEN OFF Once the PDF is done the user can review it, decide to keep it, print and send to storage. Under HIPPA rules I have to limit who has access and who can write reports. Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 O - 217-245-9504 F- 217-245-2350 Email - [email protected] _____ From: [email protected] [mailto:[email protected]] On Behalf Of Walker, Buddy Sent: Friday, February 05, 2010 4:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: PDF files on Network Tom Do you speicify the path when writing the report/pdf . For example do you PRINT reportName ...FILENAME C:\RBTI \pdfileFolder\filename.pdf Or PRINT reportName .. FILENAME pdfileFolder\filename.pdf I would suggest to write the pdf to everyone's local temp folder and then copy (rename it when doing the copy) it to the network. This will prevent someone over writing another person's file. I create a lot of PDFs that are stored on the network. Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Tom Frederick Sent: Friday, February 05, 2010 4:59 PM To: RBASE-L Mailing List Subject: [RBASE-L] - PDF files on Network Our database creates PDFs of reports, stores them to a sub, records the location, and has a retrieve/print form. This process is used in 8 report buttons and works very well on a single PC. When I move the database from C:\RBTI to a network server (Y:\ECC), the entire database program runs fine but the PDFs do not get built. File names go to a PDF name table, and a 1kb file with the correct name goes to the subdirectory (Y:\ECC\PDFs) but the PDF file is empty. Move the same database back to (C:\RBTI) and everything runs correctly again. All I can think of is I am missing a network naming structure. Using (cval('currdir') to get the correct directory regardless of which computer I go to. The inability to create the PDF on the network has got me stumped. Using latest v8 and v9. Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 O - 217-245-9504 F- 217-245-2350 Email - [email protected]
