*sigh*  this has been discussed before. When you run any report on the 4.0 standard it generates a works table that includes the date and time stamp. To edit a form and have data appear follow these steps.

1. Preview desired report.

2. Locate data and time stamped works table.

3. Rename original works table for restoration later.

4. Remove data and time stamp from works table.

5. User Crystal designer to open report and edit.

6. When you refresh data will appear.

7. When finished delete works table with data and rename original empty works table back to original name.

BigLouie's suggestion is for how to preview data in Crystal when modifying a report.  If you are creating a new instance of the GL Trial Balance report from the GL Trial Balance print screen, then you can use his method to see the effect of your edits without closing Crystal & re-running the form or report.

However -- if you are creating a report from scratch, NEVER use a wrk table.  They contain no data.

Try using the GL_DetailPosting table instead of the work table.

---

kralexander wrote: 
  When I use it, I can't get any data. 

---

I forgot to add that the works table is populated by the print engine. So if you want to use the GL Trial Balance report works files as the basis for the report then you must create a new form code for the GL Trial Balance and delete everything and create your report. You will then run the report through the GL Trial Balance print process. It is the only way to get the tables to populate.

I'm not sure if this table will work or not.  I'm currently using GL_Account and GL_PeriodPostingHistory.  I'm trying to pull Beginning Balance, Debit Amount, Credit Amount, Period Change, and Ending Balance.  My problem is after my first month of activity (November 2009), my beginning balance column no longer shows balances.  Any thoughts?

How is what you are trying to do different than the canned trial balance report?

Dawn