![]() Sort by customer name and invoice date (descending) The invoice list in the drop-down window of the multi-valued parameter was to be sorted by any of these criteria: Good tip ! Using SSRS for more than a year, I never noticed that option of interactive sorting.Ī more complicated sorting requirement had to be addressed for a set of invoices, more specifically the list of available invoices in a multi-select parameter. sort by invoice number desc (note that the invoice date even with the time portion does not necessarily corresponds to highest/lowest invoice number) sort by customer name and invoice date (ascending) This required a first dataset holding the various sorting choices to feed a sorting selection parameter The value of the parameter chosen by the user is then used in the sorting of the second dataset providing the list of invoices shown in the multi-select parameter. Make sure that the order of the parameters in the report is (1) and (2) the invoice list parameter. The T-SQL statement for the invoice list of the multi-select parameter was something like: ![]() WHEN = 'Customer and Document Number (highest number first)' THEN InvoiceNumber WHEN = 'Customer and Document Date (most recent date first)' THENĬONVERT(char(4), YEAR(InvoiceDate)) + RIGHT('0'+ CONVERT(varchar(2), MONTH(InvoiceDate)), 2) + RIGHT('0'+ CONVERT(varchar(2), DAY(InvoiceDate)), 2) second sorting level: InvoiceDate descending or InvoiceNumber descending WHEN = 'Document Number (lowest number first)' THEN InvoiceNumber WHEN = 'Customer and Document Date (most recent date first)' OR = 'Customer and Document Number (highest number first)' first sorting level: Customer in ascending alphabetical order or Invoice number in ascending number (InvoiceNumber must be the same type as the customer name) or a constant value 'x' to ignore the first level here fabricate the three sorting levels SELECT InvoiceNumber, InvoiceDate, CustomerName, InvoiceStatus, InvoiceAmount, Currency, isCreditNote. WHEN = 'Document Date (most recent first) and Number' THEN .There are lots of audiophiles using Macs. I always found this ironic, as iTunes lacks audiophile features that other Windows OS players(ex.foobar2000) had. There certainly are other softwares for music playback, but all of them were heavy and laggy, not to mention the cost and the not so user-friendly UI. I’ve used Macs for about 5 years now(13in Macbook Pro, 11in Macbook Air, and now a 13in Macbook Air). After about 5 years of searching, I think I concluded on a “perfect music player” for Mac. I hereby introduce Vox! Vox is a fairly new music player, created around 2012 or 2013. This year, Vox had a major update, and the new interface and features are shockingly awesome. So.here are reasons why you should use Vox: Here are reasons why you should use Vox if you have a Mac. Vox has some of the best designs I’ve ever seen. This does not matter to me because I listen to the podcasts in order from the beginning of GP2.It supports just about any file you can think of. Obviously, the iPhone isn't smart enough to do live updating on GP2. If I play one of these podcasts on the iPhone, its play count is incremented and it drops off the Good Podcasts playlist. The Live Update feature on the iPhone only works on the primary playlist, however. When I sync to my iPhone, GP2 retains its order (and Good Podcasts does not). ![]() Then I have a "GP2" playlist where the only criteria is "Playlist is Good Podcasts." I manually rearranged both playlists (which, of course, have the same podcasts on them). ![]() ![]() It includes podcasts where the playcount is 0 and the where the podcast name is any of the podcasts I like to stay current with (about 30 podcasts). I have a "Good Podcasts" playlist that does all the hard work. This allows the playlists to update automatically when listening in iTunes or when you sync. I found another workaround for this issue: link 2 smart playlists and they can both have "Live updating" checked. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |