Excel Wierd Data Isuue 1

[northw]

Hi All,
I have a report, when I am exporting it to Word, I dont see any problem, But when I export it to Excel Then data in the Report and Excel sheet is different.
Report = <2
Excel = <2This do

Can someone help me with this.

Thanks in advance.

 

[lbass]

Are you saying cells are getting merged in Excel? Make sure the fields are attached to guidelines on each side (they will turn red in design mode), and attach the right hand side of one field to the left hand side of the field to its right. When you export, choose the report section to determine column width that contains the fields laid out the way you like.

-LB

 

[northw]

Thanks Ibass for the quick reply.

My issue here is <2 (Database field), this is showing up in Report, But when I export this to Excel it is showing up with additional text appended. (<2This do).

Thanks

 

[northw]

Okay, I missed some thing here, Its a substring in the database with 10 char, So its supressed in Crystal reports but it is showing up all 10 charecters in Excel?

Any inputs?

Thanks

 

[lbass]

Is it in a different field from that containing <2? If it is suppressed in Crystal, how was this accomplished? What formula was used?

-LB

 

[northw]

No Formula used, Just the Database field from the Derived table.

CASE
WHEN ( AB_abc.RESULT ) IS NOT NULL
THEN TO_CHAR( ( AB_abc.RESULT ))
ELSE SUBSTR(( AB_abc.TEXT_RESULT ),1,10)
END AS Result

Thanks

 

[lbass]

I'm asking you to explain why all 10 characters are not showing in CR.

If you don't want them all to show, you could just change the substring to reduce the number of characters returned--is this in a command or a SQL expression?

-LB

 

[northw]

lbass, there are chances the result can be 10 charecters, Like <200000000, So we have to leave it as it is from the database.

thanks

 

[lbass]

I thought you were saying the extra text was coming from this field--that is the field we need to look at. Is the text from this field or a different field?

-LB

 

[northw]

From the same field.

Thanks

 

[lbass]

We are going around in circles here. How are you currently getting the unwanted text to not appear in Crystal?

-LB

 

[northw]

Users are going to make changes in the excel, So as of now the issue has been resolved. Any how there is nothing being done in the crystal to supress unwanted data.
Thanks alot for your time lbass.