Pika Tips and Tricks

Challenge:

How to get your favorite Pika Report(s) into a spreadsheet format when that is not an output option.

Pika versions prior to v3.06 did not typically include spreadsheet as a output option. No matter what version of Pika currently in use, a work around solution is available.

Solution:

• Select HTML as the output option.
• Copy the report results using your mouse to select all or use the Edit pull-down menu to Select All. Then right mouse click and select to Copy or use the Edit pull-down menu to select Copy.
• Paste into MS Excel by placing cursor in upper left corner, right mouse click and select Paste or use the Edit pull-down menu to select Paste.