Cognos Reporting Tools » Cognos ReportNet » Running Reports -- into Excel or Acrobat

ID #1001

How do I use ReportNet to generate Mail Merge data for a mailing list?

First make sure that your browser allows pop-up windows! Otherwise Microsoft Excel and Adobe Acrobat won't have a chance to open your reports.

Then, when your report comes up with the data you're intersted in, click the icon_result_CSV.gif CSV button near the right end of the top of your report window. (Hover your mouse pointer over the various buttons to see a quick "tooltip" describing what each does.)

CSV stands for "Comma-Separated Values" and it's a clean way to transfer your ReportNet rows and columns into Excel -- without any fancy formatting or headers or footers in the way to clutter things up. Once your data is in Excel you can pull it into a Microsoft Word mail-merge form... perhaps a form letter or a mailing-labels page, it's up to you!

If you click the CSV button and you don't wind up within Excel, don't worry -- you can just save the results as a <filename>.CSV file and Excel or Word will be able to run with it. (In this case your system isn't set up to send *.CSV files to Excel, which is no big deal.)

See also: Making sure Excel or Acrobat can open your ReportNet ...

Last update: 2005-12-20 15:57
Author: Will Trillich
Revision: 1.0

Print this record Print this record
Send to a friend Send to a friend
Show this as PDF file Show this as PDF file
Export as XML-File Export as XML-File

Please rate this entry:

Average rating: 0 out of 5 (0 Votes )

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry