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
custom sort profile
Author Message
DVD Profiler Desktop and Mobile Registrantbest49erfan
Registered: March 15, 2007
Posts: 15
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
How can I create a report that will sort Blu Rays first, then Disney movies, then all the rest?  I have tried to make several reports, but have not been able to figure it out.
DVD Profiler Unlimited RegistrantMsPaula
Ms Paula
Registered: March 14, 2007
United States Posts: 168
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
There's a couple of ways that I can think of...
Easy enough to sort by media type to get your BR before the regular DVDs but then since 'Disney' is not a media type, I'm sure you've found that won't fully work.
Another method, if you don't already use the Slot or Location fields would be to first populate those (for example all BR's would have a Location of 1, All Disney films a location of 2 and everything else gets a location of 3.  Then you could sort the collection by this column and be sure to print the report using the "As sorted" option.  Down-side to this method is that you'd have to go into every profile to place this Location value on each disk - at least you'd only have to do this once though.
Lastly, you could try manipulating the Collection number values to force your collection to sort the way you'd like. Dowside to this methd though is that every time you added a new purchase you'd have to foce a title numbering change all over again.
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting MtnMike:
Quote:
Another method, if you don't already use the Slot or Location fields would be to first populate those[...]Down-side to this method is that you'd have to go into every profile to place this Location value on each disk

Which would be made a lot easier with BulkEdit

But why don't you simply print 3 reports? First all BDs, then all DVDs with a Tag 'Disney' and at last one of the DVDs that don't have that tag, meaning all the rest.

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Unlimited RegistrantMsPaula
Ms Paula
Registered: March 14, 2007
United States Posts: 168
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Mithi:
Quote:
Which would be made a lot easier with BulkEdit

But why don't you simply print 3 reports? First all BDs, then all DVDs with a Tag 'Disney' and at last one of the DVDs that don't have that tag, meaning all the rest.

cya, Mithi


Thanks for that....forgot all about BulkEdit!
As for printing 3 separate reports, I assumed the OP wanted a report they could call in one pass - running 3 separate ones just sounded 'too easy' 
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting MtnMike:
Quote:
running 3 separate ones just sounded 'too easy' 

Too easy, eh?


Quote:
Easy enough to sort by media type to get your BR before the regular DVDs but then since 'Disney' is not a media type, I'm sure you've found that won't fully work.

@best49erfan
You could define a custom media type named "Disney-DVD" and assign that to all your Disney additionally to being "DVD" (if it is a big number BulkEdit might come in handy)
Now in the collection-list right-click on title "View Columns -> Media Type" and click on that header twice to sort descending by media-type. The orde should now be "Blu-ray" "DVD, Disney-DVD" and "DVD" 


cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
    Invelos Forums->DVD Profiler: Layouts and Reports Page: 1  Previous   Next