Break on a column

building reports desktopintelligence
1

Hi,

Can anyone help me on this. I have a cross tab in a report, displays data like this:

         CITY1   CITY 2

APPT 100
50

The count 50 displays on the 2nd row. How do I get the counts for APPT show up in one row?

Thanks
:? :? :?
Candy

eye_candy :us: (BOB member since 2005-03-18)

2

You illustration is incomplete, try to give a better one by using code display ([code] [./code])
.

haider :es: (BOB member since 2005-07-18)

3

You should look into calculation context.

When you got:
city 1
city 2
city 3
number of city 3

And you want
city 1 : Total number of city 3
city 2 : Total number of city 3
city 3 : Total number of city 3

Calculations contextes is the way to go.

martensnl :netherlands: (BOB member since 2006-12-19)

4

provide some sample data along with expected output.

Rakesh_K :india: (BOB member since 2007-12-11)