Crystal cross tabs

[lynnshs]

I'm trying to combine 2 sets of data in a cross tab, but one set of data should only appear in the last column.

eg: Col1 Col2 Col3 Col4
8 A 9 B 10 C 11 D

but I only want the letter info to appear in the last column.
Any ideas?
Thx.

 

[dgillz]

Where are the numbers coming from, a database field?

Is there somelogic besides "last column" we could apply to the number field?

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

 

[lynnshs]

yes, from a db field.
Actually, the logic would be suppress if 0, but I can't seem to add a suppression formula to a field in a cross tab.

 

[lynnshs]

Maybe my question should be is it possible to do a union on 2 cross tabs if the row names are the same?

 

[dgillz]

You can do a union query in sql and base your one crosstab report off of that.

What database type are you using?

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]

lynnshs,

We could probably help, but you are supplying insufficient information. What is your CR version? What are your row, column, and summary fields?

Also, what do you mean by last column? Is it the row total?

It is possible to conditionally suppress in crosstabs, but you need to use functions like currentfieldvalue and gridrowcolumnvalue().

-LB