Post reply

Row as Column

  • August 1, 2010 at 7:14 am

    #227361

    Hi all,

    My requirement is to show the spending of a customer, which is coming from 3 different tables.

    The report contains the data of only one customer, the report has 5 columns, in which 2 columns come from 2 tables and the other 3 columns come from one table, these column data is present as rows in those tables, How do I achieve this report? :w00t:

    any help is appreciated.

    Thanks.

  • August 1, 2010 at 9:05 am

    #1200755

    Without more details it's hard to know, but typically a report that presents row data as a column is a crosstab report. You can search on that, or look up the PIVOT operator.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply