TimeLinx Reporter

TimeLinx Reporter is the powerful yet easy-to-use report writer for both TimeLinx and Sage SalesLogix. 

Creating reports is a snap with the TimeLinx Reporter Wizard!   We've done all the hard work for you by only showing appropriate tables and clearly-labeled fields.  Without any programming knowledge, you can easily create reports like shown below with the five-step Wizard:  

5 EASY STEPS:

1.  To create a report, just follow the Wizard.  Give the Report a Name and click "Next":

2. Choose as many tables that you want to pull data from using the user-friendly table list. We take care of all the table linking automatically so the data relationships are correct.

3. Add the fields you want to report on from each table by moving them from the left column to the right column and move them up and down to set the report column order from left to right. We've done all the hard work by showing plain English descriptions rather than cryptic names and symbols, and eliminating all "programmer" fields. 

Do you want to see what the report looks like before going any further? Just click "Preview".  Want to know if you're choosing the correct field?  Click "Values" while highlighting any field and we'll show you the data in the database! Then click "Next". 

4. Would you like some of the columns to have totals or sub-totals, or change the color, style, font, grouping or formatting?  Just click "Properties" while the field name is highlighted. Filters are easy, too.  Just choose the Filters option in the Wizard.   

5. The next step in the Wizard is the Sort order. Just choose the order you want, and click "Finish":

Now save the report so you can edit it, copy it, or make it available to others to run. Or even use Advanced layout features, much like Crystal Repots.

You're DONE!

REPORT EXAMPLES

A columnar report takes 2 minutes to create, with filters, sorting, subtotals, and fancy fonts.  And the charts take just two minutes longer.  Really.

Columnar Sample:

Click Image to Enlarge

NEW FEATURES

v4.1 Newest Features:

• You can now define dashboards using the new Dashboard Wizard. A dashboard is a set of chart reports that displays on your desktop in its own window. These charts automatically refresh at an interval you specify so you can always see the most current data.
• TimeLinx Reporter (TLXR) now supports Windows 7:
  • When you run a report, the taskbar button shows a moving green bar indicating something is happening.
  • You can now right-click a report and choose Pin to Taskbar to pin it to the taskbar; choosing that item in the taskbar launches TLXR and previews that report (this obviously works best when TLXR itself is pinned to the taskbar).
  • TLXR report files now display a report icon in Windows Explorer. Double-clicking an SFX file launches TLXR and previews that report.
• You can now create a desktop shortcut for a report. Right-click any report in the Reports Explorer and choose Create Desktop Shortcut. This will create a shortcut on your desktop with the same name as the report. Double-clicking this shortcut previews the report without opening TLXR, which is handy if you just want to run one report without having to find it in the Reports Explorer.
• Usage statistics are now maintained for reports, and the new Usage Reporting function in the Tools menu allows you to report on these statistics. This allows you to determine which reports are actually being used, how often, and by whom.
• A new type of display for date fields is now available in the Field Properties dialog: "Month/Year". This displays the month and year part of the date, which the "Month" option formerly did. "Month" now outputs only the month part of the date, which is handy, for example, in cross-tab reports where you want to show the date in the rows and the year in the columns to compare sales by month and year. Reports you created prior to version 4.1 using "Month" are automatically changed to use "Month/Year" so they work as they did before.
• When you install a new version of TLXR over an existing one, if there are any new or modified sample reports, a dialog appears telling you that and allowing you to select which of those to import. You can also choose the Check New or Updated Sample Reports function in the Tools menu.
• You can now configure how much memory TLXR reserves for itself at startup. This is especially useful in Windows Terminal Server environments where multiple users run TLXR on the same server at the same time.

 Charts

• Multi-page charts are now supported. In the new Size/Paging page of the Chart Wizard, turn on Paging and set the number of points you want on each page.
• Linking, such as drilldowns, from charts is now supported. The Properties dialog for the Category (X-axis) field has a Link page that works the same as other report types. This allows you, for example, to display a chart showing sales by salesperson and click a certain salesperson to drill down to a report showing individual sales for that salesperson. Linking even works in charts displayed in a dashboard. To support this feature, a different preview window is used for charts. It has the same features as the preview window used for other report types but cannot used tabbed pages showing other report types, only other charts.
• Charts now use the Segoe UI font for text in Windows Vista or later because it looks better, especially when rotated.

 Cross-Tab Reports

• Cross-tab reports now support displaying the amount and/or percentage change between columns. The Display page of the Properties dialog for a data field has new "Show difference from previous column" and "Show percentage change" options. You can turn on one or both of these.
• You can now specify whether cross-tab reports include row and column totals using new options in Step 5.
• The Select only top option in a cross-tab report now applies to the totals for the first row field rather than the row field itself. For example, setting "Select only top" to 10 now displays the top 10 values rather than the top 10 alphabetically.

 Other Features

• Emailing now supports SSL/TSL for SMTP, which means you can now email using Gmail or Hotmail accounts or other SMTP servers that require SSL/TSL. Also, emailing using MAPI with Microsoft Outlook as your email program no longer displays the dreaded Outlook security dialog.
• Certain characters that weren't allowed in the name of a report, such as a period, comma, question mark, slash, and so on, are now allowed. The only character you can't use is a backslash ("\").
• Certain characters that weren't supported in the body or subject of an email, such as "&" or ">", are now allowed.
• There's better support for adding images stored in your database to reports.
• Output to text, comma-separated (CSV), table, and XML files is now faster.
• Exclusion conditions now work faster than before.
• The Preview window now remembers the setting of the zoom option. If you run a report and change the zoom to 200%, the next time you preview a report, it'll be at 200%.
• The Ask At Runtime filter and report progress dialogs now always appear on top of any other windows so they can't get lost behind something else if you click on a different window.
• The Setup dialog has a new page (page 2) for contact information.
• The activation process is now simpler. Clicking the Click here to activate the program now link in the Welcome dialog (displayed when you're running an unactivated version) now displays the License Manager dialog where you can add as many licenses as you need rather than bringing up a Registration dialog that only allows one license to be activated.
• New templates are automatically imported when you run TLXR.
• The OnSelect script for a report can now access the report using the Report object. This is useful if, for example, you want to change the default filter for a report when it's selected.
• You can now use the built-in RunSQL function in formulas.
• It's easier to work with the Dynamics tab in the properties dialog for Pictures and Rectangles in the Advanced Report Designer. You no longer have to enter values in 960th's of a inch; instead, you can enter value in inches or centimeters, depending on how your system is configured.
• File dialogs, such as those displayed when you output to file or export a report, now support Windows Vista and later features, such as search and recent places.
• The ask-at-runtime filter dialog now appears on top of the report progress window so it doesn't get hidden behind other windows.
• The new GetValueForParameter function is like the existing GetValueForField but allows you to specify the caption, data type, and size of the parameter being requested from the user.
• You can now filter on the Source Database field. This allows a report to drill down based on a data source. For example, suppose you have a cross-tab report that retrieves data from multiple data sources and it has Source Database as the column field. Clicking a specific data source should drilldown and run a detail report for that data source only, so the linked report has a filter on Source Database.
• The progress dialog that appears when running a report that retrieves data from multiple databases now shows the name of the database the data is currently being retrieved from and the number of records retrieved. 

v3 New Features:

• The Formula Editor lets you create your own formulas without using the Advanced Report Designer or customizing the data dictionary.
• Turn on the new "Show totals in group headers option" in of the Quick Report Wizard to display group totals in the group header.
• TimeLinx Reporter now supports Crystal Reports. You can add reports TimeLinx Reporter using the External Report Wizard.
• The Preview window is no longer modal, meaning you can open multiple instances.  Also, the newPreview reports in the Options dialog allows you to determine whether different preview windows are used when you run more than one report, or whether reports appear as different tabs in the same preview window.
• Several output options are available. You can specify that a timestamp is added to the file created to prevent overwriting existing files.
• Previous versions of TimeLinx Reporter create a report as a PDF file when emailing the report to someone. You can now specify the type of file used as an attachment.
• You can now specify that each group in a report should be output to a separate file or email and that the email address should come from a field in the report itself. This can be used, for example, to email invoices to customers; the report is grouped by customer name and includes the customer's email address, so each customer's records are emailed to them.
• Reports are now stored as export files in a folder structure that exactly matches the folders in the Reports Explorer.
• The "Send summary queries to database engine" setting in the Options dialog allows you to specify whether TimeLinx Reporter or the database engine does data summarization. This may significantly improve the performance of certain types of reports.
• TimeLinx Reporter can now handle Crystal reports that report on tables that aren't in the data dictionary, such as custom views in your database.
• TimeLinx Reporter now handles custom SQL statements with ORDER BY or GROUP BY.
• The Formula Editor now allows you to specify what table the formula appears in, as well as its data type, size, and number of decimals.
• The Formula Editor allows you to use complex formulas, such as using the RunSQL or SQLookup functions.
• The new SQLookup function allows you to retrieve a value from another table without doing a join to that table.

Included Report Samples