Friday, December 10, 2010

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.

No comments: