keeping details on crosstab in CRXI 2

[psimon1]

Hello

There has to be a way to do this but the brain must not be up yet...

I am doing a CRXI Crosstab report and get the following output:

Before you ask, yes, it does have to be a crosstab report because of the way in which the data is structured.d

division positioni minimum salary mid salary maximum
ABC 123 10 20 30
124 12 20 35
CDE 123 10 20 30
124 10 20 30
DEF 123 10 20 30

etc...

I would like to have everything repeat. I don't want to see division, in this case, suppressed.

I'd love for my output to be:

division positioni minimum salary mid salary maximum
ABC 123 10 20 30
ABC 124 12 20 35
CDE 123 10 20 30
CDE 124 10 20 30
DEF 123 10 20 30

In Excel w/ Pivot Tables and Access w/ CrossTab queries, this isn't a problem. This must be an option in Crystal.

Any ideas?

Thanks in advance.

 

[dgillz]

You need to make your crosstab column a formula field with the concatenation of division and position:

{DivisionField}&" "&{PositionField}

Then I believe you'll get what you want.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[lbass]

Why do you want to do this? Are you planning to export to Excel? There are a couple of things you could do, depending upon purpose. If this is just for display, then you could concatenate the two row fields in a formula:

{table.division}+" "+totext({table.position},0,"")

...and then use that as your row field, instead of the two existing rows. If you plan to export, and want them in separate cells, use the above formula as your first row, keep the current two rows, export, and then delete the column with the concatenation. In either case, you need to go to the customize style tab and choose "suppress subtotals" for each row.

-LB

 

[psimon1]

Thank you.

Yes, I am exporting it to Excel.

{table.division}+" "+totext({table.position},0,"")

had too many arguements, though.

Phil

 

[lbass]

I guess {table.position} is a string--I assumed it was a number.

Don, I didn't see your post.

-LB

 

[psimon1]

Yes, it's a string. So what would the formula be? I'm curious to try it.

Thanks.

 

[lbass]

Virtually the same as Don's:

{table.division}+" "+{table.position}

-LB

 

[psimon1]

Oh, a basic concatenation. Thanks.