There have beena few request lately that once a customer recieved their newly created custom report from our Report Service that it wasn’t clear right off the bat how to get the template into TraceFinder for use.
The video below shows how to import the xmlt file which is a VBA enabled template written by our “Professional Service” group when you make a request via the blog or sales team.
It then shows how to make sure you can can use it in the application once you’ve imported it.
The video is from the soon to be released TF 3.0 but the workflow is the same.
If the video is blurry please click the cog wheel at the bottom of the panel and increase the video display resolution.
The results can be seen below.
If you (suddenly) get an error like the following (which may vary depending on OS) when generating custom reports, it is likely caused by a recent security update for MS Office.
Good news is that Microsoft realized this problem and provided a “fix it” tool at http://support.microsoft.com/kb/2703186.
This is what happens based on my investigation if you care:
There is an EXD file created for some VB 6.0 runtime files when you use the controls provided by the runtime files in the Visual Basic designer. Those files are located in %APPDATA%\Microsoft\Forms\ folder (which may vary depending on OS). The problem is that, when security update installs new versions of certain runtime files, the EXD files become invalid and hence this error occurs.
To fix the error, you need to delete the EXD files and they will be re-created as needed. To delete those files, you can either use Microsoft provided “fix it” tool from the link above, or go to the folder directly and delete them.
This link http://technet.microsoft.com/en-us/security/bulletin/ms12-027 gives you some details why the security update is necessary and which software are affected.
In Tracefinder you have the ability to review your data in the form of you final report in Report View.
By selecting the report you want to see and the data you want see it from, as long as its a Standard Report shipped with TraceFinder, you can see a preview of the report without actually creating the pdf or paper.
This is a virtual report help in memory while you review it. It allows the user to see the end result but still be able to make some changes.
A feature of many of the Standard reports that are sample centric is the Active View tab.
This tab allows the user to stay in the reporting area and make data review type changes. It will display the results found in the text of the report, but give you the ability to perform chromatographic editing just like in Data Review. Once all the changes are made then simply press an Update Report button that will appear above the virtual reports and the data on the report will be updated and the results in the Data Review Screen will be too.
This keeps you from clicking around from Report View and Data Review.