Hi, I am a brand new Crystal XI user and am looking at a report that someone else created. The problem with it is, if one of the columns of data has a cell that does not contain data, the remaining columns of data move over into the blank cell so the data does not appear in the columns it belongs to?
I'm pasting a sample of my problem below… in my example below
for March… sales person “James" didn’t show revenue in the table we were pulling
from and as a result, my crystal report put the next column over “state” info
into the revenue column? Is there a way to keep this from happening?
Any advice is greatly appreciated!
|
Month
|
Salesperson
|
Revenue
|
State
|
|
Jan
|
Molly
|
$200,000
|
CA
|
|
Feb
|
Jack
|
$300,000
|
NV
|
|
Mar
|
James
|
AZ
| |