cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal reports 2011 for enterprise and SAP BW

shlomi_weiss2
Participant
0 Kudos

Hi guys

I'm using Crystal reports for enterprise XI 4.0 and I try to connect to a simple query that has 4 key figures on the rows and Calendar year month on the columns.

I'm connecting to BW through BICS and I manage to see my query.

My problem is that I need my report to be designed as a crosstab, as BW is showing it and in Crystal I get everything in columns.

I tried to insert a crosstab but I couldn't make it appear the way I wanted it.

Any help will be appreciated

Shlomi

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Shlomi,

Did you insert the Key Figures as Rows in the Crosstab?

Also, I'm pretty sure Crosstabs cannot mimic the appearance of the output produced by the BW/Analyzer.

Try creating a manual crosstab.

-Abhilash

shlomi_weiss2
Participant
0 Kudos

Hi Abhilash

Thanks for the answer

I have the key figures on the rows and I actually managed to create a crosstab after all

But I couldn't change my main report to crosstab, only to add a crosstab one of the headers of the report.

Do you have some steps on how to create a manual crosstab?

Regards

Shlomi

Former Member
0 Kudos

Hi Shlomi,

You can only add a crosstab to the report page header or footer but not to the details section or main report.

Gerald