LONDON DUBLIN NEW YORK PRAGUE
0870 760 5552 +353 (1) 657 1751 +1 347 293 0790 +420 284 001 611
¦ systems@work.tv ¦ ¦ Downloads ¦ Login Contact Us Case Studies Blog


Knowledgebase Last Updated: Sep 5, 2008 - 4:51:40 PM


Adjusting a Crystal Template
By systems@work Support
Oct 18, 2007 - 12:03:17 PM

Email this article
 Printer friendly page
Under some circumstances you may find that a Crystal Reports template no longer works with the structure of data you are sending it. This can happen if:

  • You have added a data field to the list of Data Selections in an Inquiry Profile.
  • You have upgraded to a new version of time@work or expense@work and there have been some changes in the structure of data sent to Crystal Reports (this is rare).

Solution

Fortunately there are ways of bringing Crystal Reports templates into line with your new data structure without having to recreate the template from scratch.

  1. Run the appropriate Ledger Inquiry Profile and establish yourself at the stage where you can select an existing template or Create a New one.

  2. Click on the Create New button as if you are creating an entirely new template.

  3. Close this template.

  4. Open the template which you want to modify.

  5. Select Database on the Menu Bar and Set Datasource Location…

  6. Select Data_ttx in the upper panel.

  7. Select Create New Collection and Database Files in the lower panel and then use the file browser to find data_ttx in the time@work Maintenance folder.

  8. Then click the Update button.

  9. And then Close.
 
All you have to do now is to save the Crystal Reports template.

You should now find that the template has been made consistent with the data structure now supplied to it by the Inquiry Profile.


© Copyright 2007 by systems@work Limited

Top of Page

Knowledgebase
Latest Articles
Using Linked Documents on Windows Vista or Server 2008
Changes To UK Vat Rates
An Introduction To Reporting
Mapping Reference Analysis To Transaction Analysis
Ledger Modification
Integration To External Systems
Understanding & Resolving Ledger Export Problems
Restoring a Database
Restrict Analysis Values
Suppress Timesheet Modification