CrossTab Repeat Rows

[Former Member]

Hi all,

I have an unique requirement of repeating the row details for each line of data i display.

For Eg:

Business Area Personnal Unit Count of Employees

ABC XXXX 50

YYYY 60

BBC 1234 30

2222 20

The above example with a sample data shows the way it is built if i use crosstab expert wizard. Now my requirement is on the business area column i need ABC to be repeated for second record also, like this i need for BBC etc.,

Could anyone please suggest me is it possible to achieve it by using crosstab expert wizard?

Thanks & Rgds,

Guru

[Former Member · Accepted solution]

I dont thinkk it is possible to achieve it using Cross tab but hav ing a blank report it is indeed acheivable.

[Former Member · Accepted solution]

Hi Mohammed,

Thanks for your reply. You mean to say, this can be achieved using Standard Report? if so, i have achieved it but this is my unique requirement to work on my Xcelsius Dashboard. I use Crystal Reports to retrieve data from SAP BW Query and then take it to Liveoffice and the same is taken into Xcelsius dashboard. Crosstab would really help us in optimizing our BW Query.

Thanks,

Guru

[Former Member · Accepted solution]

To my knowledge, our requirement cannot be met with the limited options in the cross tab. So go ahead with standard report, as i understand from your posts that you have already acheived it.:)

However, now with latest editins u can create Xcelsius over BW query directly.