![]() ![]() 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. For a full list of changes see the change notes.It supports just about any file you can think of. It’s also now possible to hide the album and artist labels in the art column for a cleaner appearance. The height for each album is now adjusted to save space when an album only contains a few tracks and the art column has been made narrow. The layout of the track table when the art column is visible and the “Show Every Album in Album Art Column” option is enabled has been improved. It’s now possible to change the character used to split the field from a comma to a slash. The option to split a genre into several values in the genre browser column (so that a track with the genre “Pop, Rock” will show up under “Pop” and “Rock”) has been extended to the artist field as well. It’s also now easier to change the field shown in each browser column right click the top row to select a different type for that column. It’s now possible to make Swinsian automatically select the currently playing track by enabling “Automatically Select Playing Track” in the Navigate menu. There are several new features as well as some improvements to the interface. Version 2.1 of Swinsian is now available to download. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |