Show Debit Credit displasment for the same columns
We are creating a Matrix report to show financial data and I need to show Debit and Credit in different columns but I having some problems The examples I am trying to get are: Amount Output 1,600 1,600 -5999 5,900 -600 600 I have tried {0,-10:#,###,###} but that did not work.jon magnusson
October 31st, 2009 5:18pm

I'm afraid that you'll need to provide a little more background information than this. Are you explicitly adding two different columns to the matrix or are the debits and credits contained in the same field? If so, how do we know if one value is supposed to be presented as a debit or a credit?What is your data source and what version of Reporting Services are you using?Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com
Free Windows Admin Tool Kit Click here and download it now
October 31st, 2009 7:28pm

Right sorry, debit is > 0 and Credit is < 0.Version is SQL 2005 and Data Source isSQL database , LedgerBalances.I am relay just asking for a format string that can shift based onvalue. I have sorted out the problem by creating two columns but that is a bit cumbersome solution.RegardsJon Magnussonjon magnusson
November 10th, 2009 8:32pm

Hi Jon, The debits and credits are normally stored in the same column to facilitate summation and data manipulation. As the author of accounting database design (from accountingdes.com) suggested, employ the use of CASE WHEN and IF ELSE conditional statement to generate your trial balance. There are some sql tips on how to generate the usual profit and loss and balance sheet statement from the book itself. You may try it out.
Free Windows Admin Tool Kit Click here and download it now
January 4th, 2011 2:00am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics