Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Layouts and Reports Page: 1  Previous   Next
Creating ad hoc reports
Author Message
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 4,526
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
The report generator that comes with DVD Profiler is quite exceptional. It let's you create reports that are visually complex and quite nice to look at. But the versatility comes with a drawback. Designing reports is quite cumbersome, even for simple reports. If you want one-off simple text reports, ProfilerQuery offers two easier solutions.

1. Just run a query in ProfierQuery, right click in the result and select Print. You can sort the result any way you want before printing. As an example, I wanted a report of my Ray Harryhausen movies on Blu-ray, sorted by production year. I had one printed in 2 minutes.

2. Save the result as a .csv file and open it in the spreadsheet of your choice (or select Open result in spreadsheet which does just that and opens it in the default program for .csv files). This will give you all the possibilities of the spreadsheet, for example sums, averages, maximums etc. And then you can print it out.

Using ProfilerQuery means that you need to have an XML export of your collection. It's always good to have an up-to-date export. Using my QuickExport makes that a breeze. Or, you can schedule exports (and other things) in DvdpScheduler, but that requires that you leave your PC logged in, which may not always be suitable.

Of course, if you already have a Profiler report that suits your purpose, that's the easiest way. But for ad hoc reports, that's usually not the case. So knowing the alternatives is always a good thing.
My freeware tools for DVD Profiler users.
Gunnar
    Invelos Forums->DVD Profiler: Layouts and Reports Page: 1  Previous   Next