Report showing negative sign on right side and percentage sign on left side.

[Mohsin]

Hi Telerik Team,

I have a problem in my report. Report have textboxes in which negative and positive values needs to be displayed. But when data display the negative value sign displays on right side and percentage sign displays on left side. I have used expression for displaying percentage sign. The data is coming from database.
Note: Reporting build is Q2-2011
Please see the attached screen shot for further clarification.

Urgent response is appreciated.

Thanks,
Mohsin

[Elian]

Hello Mohsin,

From the screenshot you provided we cannot tell what the problem is. We have the following questions:

1. What expression do you use to display the data?
2. In what format do you retrieve the data from the database?
3. What culture is set for the report and the textboxes (respectively the culture of the application)?

All the best,
Elian
the Telerik team

[Mohsin]

Hi Elian,

1. = IIf(Fields.Apr= Null," ", CStr(Fields.Apr) + "%")  -  this expression is used in every text box for displaying formatted data. I tried removing expression but the result was same as negative sign appearing on right side instead of left side.
2. I am retrieving decimal data from database. I tried converting them in varchar but not fruitful.
3. Default culture setting is set for report and text boxes.

Thanks,
Mohsin
 

[Elian]

Hello Mohsin,

If the report is with "default" culture it will use your current culture. Probably yours is right-to-left and that's why the textbox is behaving this way (minus sign on the right and % on the left). It actually flips the expression in the report designer as well.
Try to set some left-aligned culture to the report or to the TextBoxes respectively (for example "en") and see if it works.
If it doesn't solve your problem please send us a runnable sample that we can further examine.

Greetings,
Elian
the Telerik team

[Mohsin]

Hi Elian,

Your tips really help me out and solves my problem.
Thanks for your support.

Regards,
Mohsin