Grid UFL Structured Data Export Utility

Grid UFL Structured Data Export Utility

Grid UFL Structured Data Export Utility

Price: $99.97

Quantity in Cart: None


Summary

Export structured data to Excel or another application, the smart way. Grid UFL provides you the proper control of your Crystal Reports Export. The ability to export your reports to another application or format is one of the really useful features of Crystal Reports. But when you do this, you run into the limitations of both Crystal Reports and the other application. Grid UFL helps you overcome those limitations.

A really useful UFL:

Grid UFL allows you to treat your saved data as a Grid. To do this, you use the GridCellClear (rows,cols) to declare a work area of a predetermined size. This formula should normally be in your report header section. Then use other formulas in your group and details section to save values in the grid.

You can use GridCellLoadRawValue (row, col, value) to store a value in the working area. You could also use GridCellLoadDelimitedValue(row, col, value, delimiter) to automatically put quote marks or some other field delimiter around the value.

You can save it all to the disk file with GridCellSave(Filename,Separator). Use a comma, tab character or any other ASCII value to separate each value on each line of your disk file.

Think of the possibilities. Grid UFL opens an enormous number of them.

Grid UFL Features

  • Absolute control over grid size, format, and content.
  • Control over individual cell entries.
  • Export file is created while viewing the report.
  • Can create multiple files from one report.
  • Works with a range of Crystal Reports versions.
  • Easy installation.
  • Easy administration.

Uses

Many people use a Crystal Report to do a complex data extract or calculations on some data and then export the results to Excel for additional manipulation. Each new version of Crystal Reports has included improvements to this, but still we hear the formatting is an issue. We also hear that administrators really don't like dealing with this issue.

So, we have the solution: Grid UFL. This User Function Library gives you the level of control that you need. Through the Grid User Function Library, we have made it easier for you to export data as Excel, CSV, Text or Tab delimited files. This new UFL treats your saved data as a Grid. It gives you granular control, which is a huge advantage.

Example uses:

  • Use the GridCellClear (rows,cols) to declare a work area of a predetermined size. This formula should normally be in your report header section.
  • Then use other formulas in your group and details section to save values in the grid.
  • Use GridCellLoadRawValue (row, col, value) to store a value in the working area. You could also use GridCellLoadDelimitedValue(row, col, value, delimiter) to automatically put quote marks or some other field delimiter around the value.
  • Then save it all to the disk file with GridCellSave(Filename,Separator). Use a comma, tab character or any other ASCII value to separate each value on each line of your disk file.

Benefits

No waiting, no fuss.

The Grid UFL processes as the report is processing. This means you could use the GridCellClear in a Group header section, and the GridCellSave in the matching Group Footer to created a different file for each group value. Just watch out for those Repeating Group Header sections or you will find your grid work area resetting on as each group repeats on a new page.

The free trial version has a limit of 20 rows and 20 columns in the output file so you can see how it works, but the full version has no restriction. This UFL is compatible with all versions of Crystal Reports (later than the very old version 5).

You get these benefits:

  • Improved performance. The Grid UFL is processed within the formulas when the report is viewed. No additional processing is needed. You just view the report and the export file(s).
     
  • Improved data flexibility. Some Crystal Reports are designed to extract parts of your corporate data, perform sophisticated filtering, sorting, calculations, and summaries--and then export the data as a CSV (or similar) list of values to use in another process in your system.

    But then when you export using the native Crystal Reports options, you find a field format is not what you expect or the line has a limit on how many values you can export.
     
  • Increased control. With the Grid UFL, you decide the size of a grid work area and then load each cell with the value and format you want. Then at the end of the report, you save it as an external file using the delimiters you want.
     
  • Support for legacy reports. Crystal Reports has been around for a long time, and many older versions are still happily being used in legacy applications. The Grid UFL will install and work with any reports designed with Crystal Reports 5 and later.

Instruction Manual

Free Trial

  • Bookmark this page, in case you have questions.
  • Download the trial version
  • Complete the license purchase.
  • Install the license key.
Customer Reviews
Average Customer Review: Not yet rated
Write an online review and share your thoughts with others.

There are no reviews