crystal reports viewers, crystal reports schedulers, view crystal reports, report analyzers, burst reporting, report scheduler
 
view crystal reports, rpt viewer, crystal reports viewers, crystal reports schedulers, report analyzers, burst reporting, report scheduler
desktop viewer, crystal reports viewers, crystal reports schedulers, report analyzers, burst reporting, report scheduler

Crystal Reports Tools: Improve Performance While Saving Time and Money

Text Lookup User Function Library for Crystal Reports

  Resources  
Best sellers:
cView
Report Analyzer
cViewSERVER
ReCrystallize


Articles:
Administration
Advanced
Basic
Crystal eNL
Database
Financial
Problems Solved
 
Tools:
Analyzers
Bestsellers

CR Schedulers
CR UFLs
CR Viewers
DataBase Tools
Graphics
International
Mail UFLs
ReCrystallizePro


Add'l:

About us

Contact Us
cViewSUITE Ppt
Support

 

CrystalReports
on Steroids

Our Text Lookup User Function Libraryis a set of seven functions--which we detail below. This outstanding tool enables you to search through a text file and extract lines and columns to display in your report.

It allows you to search text documents and return individual lines or columns.
 

Text Lookup Function Library for Crystal Reports, crystal reports text lookup, crystal reports utilities, TextLookupLine, crystal reports solutions, TextLookupColumn, crystal reports tools, TextLookupColumnCount, crystal reports software, TextLookupColumnSeperator, crystal reports add-ons, TextLookupLineNum, looking up text in crystal reports, ber, crystal reports downloads, TextLookupColumnSeparator, crystal reports function libraries, TextLookupCount, crystal software, TextLookupConfirm, crystal downloads, text tools for crystal reports, crystal reports problems,crystal reports developers, crystal reports help, crystal reports modules, crystal reports scripts, crystal reports management tools, crystal reports management software, crystal reports management utilities, crystal reports user function libraries, crystal reports ufls

For example,  you may not have a database table with descriptions of your codes.

By creating a text file with those codes and descriptions, this UFL will read the text file like a table.

This avoids your needing to have repeated if..then ..else in multiple formulas.

Pricing | Buy Now!

A free trial version is available for evaluation on our download page. Please bookmark this page, download that, and test-drive this outstanding product.


The Seven functions of
Our Text Lookup User Function Library:

  1. TextLookupLine( FileName, Search). Open and search FileName for the Search text. The function returns the entire line where the search was found. If the Search is not in the file, an empty string”” is returned.

  2. TextLookupColumn( FileName, Search, Col). Open and search FileName. This function assumes that the file is a series of values on a line with a tab or comma to separate the values into columns. The Search is made on the first column (which is regarded as column 0). The values are viewed as additional columns. If a column number of less than 0 or beyond the end of the line is requested a blank value is returned. If the search is not found a blank value is returned.

  3. TextLookupColumnCount( FileName, Row). Open and search FileName for a specific row (or line). Count the columns in that line and return the number of columns. The values on the line can be tab or comma delimited.

  4. TextLookupColumnSeperator( FileName). Open and search FileName. Examine the columns in that line and whether it is tab or comma delimited. The function will return “Comma” or “Tab” and is intended for diagnostic use.

  5. TextLookupLineNumber( FileName, LineNo). Open and search FileName and return a specific line number from the file. If the line number is beyond the end of the file, a blank is returned.

  6. TextLookupCount( FileName). Open and search FileName and return the number of lines in the file.

  7. TextLookupConfirm( FileName). Look for FileName and identify if the file is found or not. This is intended for diagnostic purposes.

 
A somewhat related tool is Report Analyzer. And you can use it to find far more than a text string. You can use it to find just about any kind of entity.

Some things you can do with this tool:

  • Generate summary and detailed documentation.
  • Analyze report complexity metrics to assist with test plan development and maintenance planning.
  • Easy to use documentation explorer to browse and compare report design settings.
  • Print report design diagrams.
  • Print report data dictionaries.
  • Extensive formula printouts including call trees, object cross references, formatted listing, and conditional formulas.
  • All documentation can be exported in a variety of formats including PDF, HTML and Word.
  • Uses Crystal Reports to produce the documentation, enabling complete customization.
  • Query and print over 600 report settings across all documented reports. Perform instant impact assessment for database changes and formula changes across all documented reports.
  • Locate which reports use specific functions, parameters, and design settings.

Report Analyzer is the ultimate documentation and analysis tool for Crystal Reports users and developers. With a comprehensive library of analysis and documentation reports, Report Analyzer provides you with complete documentation, analysis, and performance suggestions for your Crystal Reports projects. Keep your investment in Crystal Technology at its best performance using Report Analyzer.

For pricing and/or purchase, click here.