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

  • I have the report now sorting the accounts in the correct order that the users want. Now my problem is getting SSRS to be able to incorporate the correct financial statement headings and subheadings (text).

    The report output/preview looks like attached image file: IS-Bal Statement. I can't figure out how to get the headings and subheadings to work in the report like attached image file Statement Labels - see items in red/bold.

    I think that I may need to use some kind of IIF expression but not sure. If I do, then do I need to create some expression for each heading/subheading?

    Can anyone point me in the right direction to make this work?

    Thanks.