Personalization, Customization and Productivity Tools

[kylegunn]

I am trying to preview an existing report in Crystal and all I keep getting is a blank report with just the title, headings, etc.  However when I run the report in MAS everything looks fine.  Any help would be appreciated.

Thanks,

Kyle Gunn

MAS 200 4.30.0.18

Crystal Reports 10.0.5.820

[connex · Accepted solution]

What tables are you using in the report?  If the report uses table with the letters Wrk at then end of the name, then those are work tables that are refreshed by MAS 200 when the report is run and would explain why they are empty when run outside of MAS.

[kylegunn]

Yup! That was it.  Thanks connex!!

Kyle

[BigLouie]

To expand on what my esteemed colleague posted. When a works table is use a temp table with a time stamp is created, this is what the report reads. For example SO_CustomerSlsHistByItemWrk.M4T becomes SO_CustomerSlsHistByItemWrkJJM090708896069.M4T. To be able to preview the report you would preview the report and then go find the works table. Rename the original adding _bak or something like that and then on the table with the time stamp, strip out the time stamp. Now when you finish working on the report you can run it and see data. When finish clean things up by deleting the files with data and renaming the blank works table back to it's correct name.

[connex]

To expand on what MY esteemed colleague posted.  I always leave test data in the work file and leave the original as _Original in case I ever need it again (which I haven't)

[russnobbs]

Does the method of finding and renaming the data filled work table that these esteemed gentlemen describe work in the same manner for FORMS  as well as for reports?

[BigLouie]

I think my esteemed colleague would agree, the answer is Yes.

[connex]

Yes! It works for any Crystal report that uses a work table.

[eludden]

For anyone that comes across this post that happens to be running the 4.5 SQL version, the WRK tables are created in the TEMPDB under Temporary Tables.  Following the same example, you could then use a SQL query SELECT * FROM tempdb.dbo.[##SO_CustomerSlsHistByItemWrkJJM090708896069] from SQL Server Management Studio to view the temorary WRK table records.

[connex]

With 4.5 SQL does this same technique work to copy the temporary file contents to the permananent work file (the one without the user and date/time stamp)?