Support : Dialog Search Aids : Successful Searching : REPORT

REPORT

The REPORT command arranges selected data from a set of records into tables that display the information in columns.

With the exception of REPORT TITLES output, which is available in a variety of delivery formats, reports are displayed only at your computer, and are not available as offline prints or via electronic delivery.

To prepare a report, first consult the database Bluesheet to determine which data fields are available for the REPORT feature. Note the field codes of the fields you want to include in your report. Conduct your search as usual and SORT your records if necessary. Then enter the REPORT command, the set number followed by a slash (/), the field codes in the same order that you want the columns in the table arranged, another slash (/), and the records you want included in the table.

In the following example, D&B — Dun's Market Identifiers^® (File 516) is searched for information about the top 10 industrial motion picture production companies in the U.S. The primary SIC code (PC=) for these companies retrieves 220 records. These are sorted by sales (SA=) in descending order (D), so that the companies with the highest sales will be listed first. Then the top 10 companies (CO) are requested in a REPORT that includes sales (SA) data.

The requested cost estimate shows the cost of the report, listed as "Report Elements." Refer to the current database Bluesheet for information on REPORT formats. For the most current pricing information, enter HELP RATES n (where n is the database number).

Notes:

The maximum line width for a standard REPORT is 132 characters (except for post-processing formats, which allow up to 240 characters).

REPORT is not available in OneSearch. However, REPORT TITLES is available in a OneSearch consisting only of fulltext market research or country analysis and risk files (for example, the files in the MARKETFULL DIALINDEX category and Files 627,628).

Dialog ERA^SM (Electronic Redistribution and Archiving) Service can be used with REPORT to distribute print or electronic copies of search results to other employees or departments within your organization, or to store search results in an in-house system.

• To create a report:

File 516:D & B - Duns Market Identifiers  2007/Feb
       (c) 2008 D&B
 
      Set  Items  Description
      ---  -----  -----------
?s pc=78120104
     S1     220  PC=78120104  (INDUSTRIAL MOTION PICTURE 
                 PRODUCTION)
?sort s1/all/sa,d
Processing
      S2     220  Sort S1/ALL/SA,D
?report s2/co,sa/1-10

Align paper;  press ENTER
?<enter>
          DIALOG(R)File 516:D & B - Duns Market Identifiers
                   (Copr. 2008 D&B) All rts. reserv.
 
Company                         Sales
Name                            Dollars
------------------------------  ----------
 
E.U.E. Screen Gems Ltd (inc)    60,000,000
Sound Images Inc                15,000,000
Northwest Teleproductions, Inc  13,400,000
Sbk Pictures, Inc                9,000,000
M V P Communications Inc         8,100,000
Caribiner Inc                    7,600,000
S O S Productions, Inc           7,033,446
A F I Productions Inc            6,235,523
Avid Productions Inc             5,083,818
Broadcast Production Group (in   4,000,000
?cost
      20feb08 19:00:09 User300069 Session D921.3
            $6.89 0.711 DialUnits File516
            $6.00 20 Report Elements
    $12.89 Estimated cost File516
    $0.53 INTERNET
    $15.19  Estimated cost this search
    $13.42 Estimated cost this search

Usage Notes

DialogClassic Web: Menu and Editor Tab options are available for formatting and saving output in multiple formats, including Text, HTML, Adobe PDF and Microsoft Word. See the DialogClassic Web support page for more information.

DialogLink 5: The Reports Tab in the DialogLink Type-Ahead buffer is used to create customized Microsoft® Word or Microsoft® Excel reports from your search results. Examples are available for both Excel and Word reports.

(Post-Processing Formats) 

top