Skip to Content
0
Oct 08, 2009 at 01:19 PM

Crystal report based on BW query with two structures

24 Views

Hi,

I use a BW query with 2 structures. In the rows there is a structure of restricted characteristic 0material. I used this characteristics several times in different rows to restrict these rows to specific products.

Cars

motorcycles

Others

In the columns I have a structure of key figures. Every key figure is restricted to a specific time intervall.

So in BW the executed query looks like this:

Key figure 1 Key figure 2 Key figure 3

Cars 10 30 100

motorcycles 20 100 30

Others 30 40 39

If I use the same query in Crystal then I have access to the 3 keyfigures and to one structure element.

How can I ensure that the query is displayed in CR like in BW? I tried to work with crosstabs but I was not able to get the same display like in BW.

Thanks for any help.

BR, Andreas