Search results for query: *

Turkbear, Yes - data in Oracle has an explicit space at the end. Thanks

kray4660, It looks like the field value is truncated by the time it gets to Crystal - length(field) is showing the truncated value (without the space). Thanks

Characters in the field are identical except for the space and I need to separate the two (with and without space). I can distinguish them in the database - using Oracle 11g and the data type is varchar2. Thanks

Hello, I have a report which groups by a database field. One of the values in the table contains a space at the end. Looks like Crystal is removing the space. For example, If the values in the table are: 'Value1' and 'Value1 ' - they both are being treated as the same 'Value1'. Any idea why...

Hello, I have a crosstab report as follows: Q1 Q2 Q3 Q4 2009 2010 2009 2010 2009 2010 2009 2010 Sale1 100 200 100 200 100 200 100 200 Sale2 100 200 100 200 100 200 100 200 Sale3 100 200 100 200...

Thanks - I might have to go the SQL route....

All, I have a crosstab report that looks like this: Jan Feb ...... Total Rev Budget %var Rev Budget %var Rev Budget %var Name1 $100 $200 50 $50 $200 25 $500 $2000 25 Name2 $150 $500 60 $20 $200 10 $300 $1000 33 I used...

That worked great. Thanks LB. Is there any way to actually show the Year as the column Header. Currently it is a Text Object and would like it to show 2008 and 2009 for Last Year and Current Year (based on database date values). Thanks again. Praveen

LB, Thanks for your help - I would be interested in your solution. Praveen

Hello all, I have a crosstab report that has formula for columns - which ends up being only two columns which represent the year and customer as rows. The summary field is revenue. I am trying to add a column at the end that would calculate the difference in revenue in dollars and also as a...