John:
It appears to me that the ones not printing have in common that they first create temporary tables and then run Crystal against those temporary tables. The ones that work are simpler ones that work directly with the existing tables. Doug could give you a definitive answer when you speak with him. And, to give credit where credit is due, it was Bob who was responsible for the previous post!

Bruce - thank you for the correction and Bob, please accept my apologies along with my thanks.

Bruce - what you say makes good sense - any idea where these files are crearted?

The user's Windows temp directory.

Thank you sir Bates!

I have ensured r/w access to %TMP% & %TEMP% (both pointing to same place) .... and everything is as it should be.

I even added everyone as RW.. so, there is something else...

Anyone - are there registry keys that are created by WKSETUP that I could try deleting - ie" kill profile, clean reg keys and start over?

It's worth confirming the r/w access from a user's perspective. Log into as the user, jump to that location with %TEMP% as a run command, create a folder and a file within that folder. Then delete the file and the folder. All reports are copied to the temp folder and manipulated. Not just those creating work files. Bruce originally asked you if other Adagio apps are printing properly. If they are, then we can say it's a Ledger issue.

Hi Bob,

Thank you for your input.

I have verified all of the above and was able to create a folder in the %TMP% directory, create a file in it, add to the file, close the flle, open the file and verify the contents were saved, jumped up one notch to the newly created test folder and then deleted the folder.

No problems!

So, I went to another database that has more data and watched what happens in the temp folder.

Files are created and are added to and then, they were deleted and the preview never displays.

Sounds like a LoadLibrary() when going to Crystal problem to me...

Is there a log file somewhere that might tell us more?

Again, thank you!!!

Reviewing the results from \SOFTRAK\SYSTEM\chksys.exe will confirm your setup.

Again, have you tried a report from AR or AP?

Hi Bob,

AP - Print open payables which also uses a temp file previews no problem.
AR - checked all reports - they all print..

I ran chksys and everything is A-ok!

Cheers, JK

//-------------------------------------------------------------
Here are the results from chksys:
//-------------------------------------------------------------

======= Checking Special System Configurations ======

========== Checking 32-bit System Status ==========
--- OK ---

======= Checking Report Tables Configuration =======
*** NOTE: Report Tables drive is: [M:];
Override status for user [Charlie.Costello] is [N].

=============== Checking Products ==============
Adagio Invoices Status:
M:\qrasp\QRTQIW80.qrw
Date: [03/09/2009] OK.
M:\qrasp\QRTQIZ81.qrw
Date: [11/20/2008] OK.
M:\qrasp\QRTQIB81.qrw
Date: [03/10/2009] OK.
M:\qrasp\QRTSMW90.qrw
Date: [11/05/2008] OK.
M:\qrasp\QRTSMZ90.qrw
Date: [10/24/2008] OK.

Adagio Invoices Status:
M:\qrasp\QRTQIW90.qrw
Date: [08/25/2011] OK.
M:\qrasp\QRTQIZ90.qrw
Date: [01/13/2011] OK.
M:\qrasp\QRTQIB90.qrw
Date: [06/22/2011] OK.
M:\qrasp\QRTSMW90.qrw
Date: [11/05/2008] OK.
M:\qrasp\QRTSMZ90.qrw
Date: [10/24/2008] OK.

Adagio Ledger Status:
M:\qrasp\QRTALW90.qrw
Date: [05/31/2011] OK.
M:\qrasp\QRTALZ90.qrw
Date: [05/31/2011] OK.
M:\qrasp\QRTMCW80.qrw
Date: [08/12/2003] OK.
M:\qrasp\QRTSMZ90.qrw
Date: [10/24/2008] OK.

Adagio Payables Status:
M:\qrasp\QRTAPW68.qrw
Date: [08/01/2012] OK.
M:\qrasp\QRTAPZ80.qrw
Date: [03/28/2007] OK.
M:\qrasp\QRTAPB68.qrw
Date: [10/20/2009] OK.
M:\qrasp\QRTAPT68.qrw
Date: [12/27/2002] OK.
M:\qrasp\QRTAPJ68.qrw
Date: [09/13/2004] OK.

Adagio Receivables Status:
M:\qrasp\QRTARW90.qrw
Date: [06/09/2011] OK.
M:\qrasp\QRTARB90.qrw
Date: [12/16/2008] OK.
M:\qrasp\QRTARZ90.qrw
Date: [08/23/2010] OK.
M:\qrasp\QRTSMW90.qrw
Date: [11/05/2008] OK.
M:\qrasp\QRTSMZ90.qrw
Date: [10/24/2008] OK.


. . . . 0 Error(s) and 0 Warning(s) Reported.
================== Finished ===================


//-------------------------------------------------------------
Here is the lanpak status:
//-------------------------------------------------------------


== VERSION == TOTAL
Version 9.0E 10
Version 9.0D 0
Version 9.0C 0
Version 9.0B 0
Version 9.0A 0
Version 8.1 0
Version 6.8 0

==== List of actual Lanpak Versions: ====
Serial #: 1211114556: ** Unknown version **; Lanpaks: 10


//-------------------------------------------------------------
Here is R/W for standard Adagio folders:
//-------------------------------------------------------------

=== STATUS OF COMMON ADAGIO FOLDERS ===
C:\WINDOWS\system32 --- Read/Write Status is OK for this folder.
C:\WINDOWS\CRYSTAL --- Read/Write Status is OK for this folder.
M:\qrasp --- Read/Write Status is OK for this folder.
M:\SOFTRAK\system --- Read/Write Status is OK for this folder.
M:\SOFTRAK\dict --- Read/Write Status is OK for this folder.
C:\SOFTRAK\SYSTEM --- Read/Write Status is OK for this folder.

=== STATUS OF ADAGIO RECENTLY USED DATA FOLDERS ===
AP: k:\juker --- Read/Write Status is OK for this folder.
AP: k:\record --- Read/Write Status is OK for this folder.
AP: k:\sfi --- Read/Write Status is OK for this folder.
AP: k:\threec --- Read/Write Status is OK for this folder.
AP: k:\snl --- Read/Write Status is OK for this folder.
AP: k:\j & s --- Read/Write Status is OK for this folder.
AP: k:\false creek --- Read/Write Status is OK for this folder.
AP: k:\alltech --- Read/Write Status is OK for this folder.
AP: k:\0875521_bc_ltd --- Read/Write Status is OK for this folder.
AP: k:\cil --- Read/Write Status is OK for this folder.
AP: k:\itb_marine_projects --- Read/Write Status is OK for this folder.
AP: k:\canpac --- Read/Write Status is OK for this folder.
AP: k:\mss --- Read/Write Status is OK for this folder.
AP: k:\kemah --- Read/Write Status is OK for this folder.
AP: k:\gatleedm --- Read/Write Status is OK for this folder.
AP: c:\accpac_data\alltech --- ** Folder doesn't exist.
Ledger: k:\jade\jade08 --- Read/Write Status is OK for this folder.
Ledger: k:\record\record10 --- Read/Write Status is OK for this folder.
Ledger: k:\snl\itb07 --- Read/Write Status is OK for this folder.
Ledger: k:\sfi\sfi june 10 --- Read/Write Status is OK for this folder.
Ledger: k:\snl\itb09 --- Read/Write Status is OK for this folder.
Ledger: k:\snl\itb08 --- Read/Write Status is OK for this folder.
Ledger: k:\sfi\sfi june 09 --- Read/Write Status is OK for this folder.
Ledger: k:\false creek\fcbp10 --- Read/Write Status is OK for this folder.
Ledger: k:\snl\itb06 --- Read/Write Status is OK for this folder.
Ledger: k:\juker\juker 2009 --- Read/Write Status is OK for this folder.
Ledger: k:\snl\pay test 2010 - delete 2010.08.01 --- Read/Write Status is OK for this folder.
Ledger: k:\snl\pay test 2010 - delete 2010.06.01 --- ** Folder doesn't exist.
Ledger: k:\threec\threec10 --- Read/Write Status is OK for this folder.
Ledger: k:\record\record11 --- ** Folder doesn't exist.
Ledger: k:\snl\itb10 --- Read/Write Status is OK for this folder.
Ledger: k:\0875521_bc_ltd\samson 2011 --- Read/Write Status is OK for this folder.
Ledger: k:\cil\mes --- Read/Write Status is OK for this folder.
Ledger: k:\cil\mes\mes 2011 --- Read/Write Status is OK for this folder.
Ledger: k:\kemah\kemah11 --- Read/Write Status is OK for this folder.
Ledger: k:\cil\mes\mes 2011 new --- ** Folder doesn't exist.
Ledger: k:\cil\mes\mes 2010 --- Read/Write Status is OK for this folder.
Ledger: k:\cil\cil 2011 --- Read/Write Status is OK for this folder.
Ledger: k:\cil\cil 2010 --- Read/Write Status is OK for this folder.
Ledger: m:\softrak\ledger\samdata --- Read/Write Status is OK for this folder.
Ledger: k:\alltech\alltec11 --- Read/Write Status is OK for this folder.
Ledger: k:\alltech\alltec09 --- Read/Write Status is OK for this folder.
Ledger: k:\alltech\alltec10 --- Read/Write Status is OK for this folder.
Ledger: k:\snl\itb11 --- Read/Write Status is OK for this folder.
Ledger: k:\sfi\sfi dec 11 --- Read/Write Status is OK for this folder.
Ledger: k:\sfi\sfi june 08 --- Read/Write Status is OK for this folder.
Ledger: k:\snl\itb 12 b4 fa --- Read/Write Status is OK for this folder.
Ledger: k:\snl\itb 12 before fa reevaluation --- ** Folder doesn't exist.
Ledger: k:\canpac\canpac 2011 --- Read/Write Status is OK for this folder.
Ledger: k:\_canpac --- ** Folder doesn't exist.
Ledger: k:\itb_marine_projects\itb mp 2011 --- Read/Write Status is OK for this folder.
Ledger: k:\cil\cil-2009 --- Read/Write Status is OK for this folder.
Ledger: k:\snl\itb04 --- Read/Write Status is OK for this folder.
Ledger: k:\sfi\sfi june 11 --- Read/Write Status is OK for this folder.
Ledger: k:\cil\test --- Read/Write Status is OK for this folder.
Ledger: k:\record\record07 --- Read/Write Status is OK for this folder.
Ledger: k:\threec\threec11 march11 --- Read/Write Status is OK for this folder.
Ledger: k:\juker\juker 2011 --- Read/Write Status is OK for this folder.
Ledger: k:\rls --- Read/Write Status is OK for this folder.
Ledger: k:\fourc --- Read/Write Status is OK for this folder.
Ledger: k:\record\record06 --- Read/Write Status is OK for this folder.
Ledger: k:\record\record09 --- Read/Write Status is OK for this folder.
Ledger: k:\record\record08 --- Read/Write Status is OK for this folder.
Ledger: k:\record\record11 (june 11) --- Read/Write Status is OK for this folder.
Receivables: k:\junk --- ** Folder doesn't exist.

=== STATUS OF ADAGIO "EZTASKS" FOLDERS ===
m:\asp --- Read/Write Status is OK for this folder.

=== STATUS OF ADAGIO "CURRENCY" FOLDERS ===
m:\asp --- Read/Write Status is OK for this folder.

Thanks. That's all I can suggest. This information will be of use to Softrak. I think you need an experienced Adagio Consultant on site. Server setups are not my thing.

Hi John,

In the release notes and ReadMe help files for the Oct 17, 2011 service pack of Adagio Ledger 9.0D, this text is included in the Fixes section:

Ledger 9.0D was updated from version 7 to version 8.5 of the Crystal Reports print engine. When installing Adagio for use with Remote Desktop Services (Terminal Services in Windows Server 2008 and previous versions) this necessitated manually copying the crystal folder from the main windows folder to the windows under each user. For example, on Server 2003 you had to copy the crystal folder from C:\windows\ to C:\Documents and Settings\username\windows. This is no longer required. The install and workstation installs will do the copy. The Ledger program will also do the copy if possible, which will avoid the need to do a workstation install in some cases.

If you are not running this service pack but instead the original release of Adagio Ledger 9.0D from June 29, 2011, then try downloading and installing the service pack, log into the terminal server as the user(s), and re-run the workstation setup for the user(s). For each user in question, ensure that they can 'see' a \windows\crystal directory that is not empty. Perhaps compare the file contents to your own - it should not be that much different, if at all.

If this doesn't fix the problem, then you may have to resort to manually copying the C:\windows\crystal directory for each user that has a problem. Depending on your terminal services setup, the destination may be %PROFILEPATH%\windows\crystal, %HOMEBASE%\windows\crystal, or %USERPROFILE%\windows\crystal.

This problem has never affected either AR or AP, but it did affect BankRec.
--
Also to briefly explain reports that require temp files. For reports such as the GL detail listing or the AR Aged trial balance, the temporary file(s) are initially created in the data directory - this occurs while the 'creating work file' progress bar on the report goes from 0% to 100%. When the progress bar completes, the work file(s) get copied to the user's temp directory within a specific unique folder, depending on the report. EG, for the GL Detail listing, the folder name is GLLS#### where #### is some generated task number such as 0003, and the work file names are GLTRNTMI.dat and GLTRNTMR.dat.