Displaying Data in single Row

building reports desktopintelligence
1

Hi
I am having a report in this format:

Account Subaccount
Acct1 A
Acct1 B
Acct2 D
Acct3 F

My Problem is If a Account has multiple Subaccounts under it, I want to display subaccounts in one row and in seperate colums.

Account Subaccount1 Subaccount2 Subaccount3
Acct1 A B
Acct2 D
Acct3 F

How can I get this?

I am pulling this data from a excel spreadsheet so I don’t have much option of modifying the data at the database level.
Can anybody help me with this.

Thanks so much!

liki_red (BOB member since 2007-01-05)

2

Here is the link

There is no report level solution. but a database level solution is discussed.

KhoushikTTT :us: (BOB member since 2005-02-24)

3

But since I am getting the information from spreadsheets, I cannot try the solution you suggested me.
Can you please tell me if I can create some variables and display the data in that format?

I tried using crosstab but that is not working.

Thanks so much!

liki_red (BOB member since 2007-01-05)

4

Try the solution provided here;

jac :australia: (BOB member since 2005-05-10)

5

I did look into this and it’s working. Thanks so much!!

But I am having one small problems like displaying the header names and the section space between the rows.
When I place everything in section the headers are disappearing.

I am trying to do something to that but I what I got right now from that solution is great!

liki_red (BOB member since 2007-01-05)

6

Insert a row above the datarow, and put a formula like this:

="SubAccount "+FormatNumber(ColumnNumber()-1;"##0")

jac :australia: (BOB member since 2005-05-10)

7

I followed the instructions given by Shyam and got my dat ain a single row.
But now I have another problem.

Each Account has different number of subaccounts and each row is of different size i mean in the section.
Now when I am trying to export this a excel spreadsheet it gives me an error and without which my report is useless. I need to present this my user in excel format. :frowning:

liki_red (BOB member since 2007-01-05)

8

Have you tried saving it as a text file and opening that from Excel?

jac :australia: (BOB member since 2005-05-10)