MusicOne Windows · Reports & printing
Report Design
Design your own reports with the fields you need, and choose how they print.
Updated
These two videos show how to design your own reports and the printing options for them.
Watch the video on YouTube: Mechanics - Report Design
Watch the video on YouTube: Mechanics - Reports - Printing Options
Design a report
You can design and print just about any kind of report you want with Music 1. Every field of data on a song card can be included in a report.
Create the report
Open the File menu, select New, and name the report.
In most cases you only use line one to add the fields for your report. If you’re printing to paper and have too much data to fit on one line, you can use line two for more fields.
Click at the top of the line one fields area, so a field is selected in blue.
Off to the right, under the Fields button, you’ll find every field on a song card. Select one and add it. Steve adds Artist, Title, Album and Category.
If you add something by mistake, click Delete and it goes away.
Arrange the columns
Use the little blue buttons to set the order. To print category first, then artist, then title, select Category and click it up to the top, then move Artist up.
If you print on paper or to a PDF file, you’ll want the columns to line up neatly across the page. So tell Music 1 how far across the page each one starts, a bit like a tab stop on a typewriter. Steve sets Category to column 5 (five spaces from the left margin), Artist to column 20 and Title to column 50.
Test print
This type of report is printed to paper or to a fixed-width file, which is a text file. Click OK.
Choose the sort order. Steve sorts first by category.
Do a test print: select the categories (here, Current and Recurrent) and print.
Music 1 asks what to name the report. Name it and save.
Use the report again
Once a report is saved you can use it over and over. In the Tracks view, open the Track menu, select Print, choose any report design you’ve created, and print.
It also works with searches. Search for categories, artists or anything else, then open the Track menu, choose Print and select the report you want. Whatever you found is printed.
Report printing options
Any report you create in Music 1 can be printed several ways. On the report screen, click the Print Mode button.
Color, Black and ASCII print (the top three buttons) print the report to paper.
Fixed width sends it to a text file that you can open in Notepad. That’s helpful for emailing a file for someone to look at.
Comma delimited is the most common file type for exchanging information. If you want to export data from Music 1 to import into Excel, say, comma delimited is usually the file type you want. Tab delimited can work too.
You can name the file whatever you wish, and you can add a date to the name. Steve’s example names the file "Power Country" plus the month, day and year.
The file extension only affects the bottom three options (fixed width, comma separated and tab delimited). For a fixed-width file you want .txt; for a comma-separated file, usually .csv.
Once you’ve set the print mode, it’s selected automatically every time you print that report.