Home Forums Reporting Services Reporting Services How to use SSRS to format financial report using non-sequential account order RE: How to use SSRS to format financial report using non-sequential account order

  • Here is what I would do.

    I would create a table that lists the accounts that must be in a specific order with a sequence number for the order that that the accounts need to be displayed. I would then join to this table using an left outer join. Where the sequence number is null substitute some default value (use ISNULL or COALESCE to accomplish this) then the query sorts on the sequence number first then the account number.