Formatting Text

Stimulsoft Reports.NET discussion
Post Reply
fkmfkm
Posts: 181
Joined: Thu Jul 05, 2007 11:26 pm
Location: Kuala Lumpur

Formatting Text

Post by fkmfkm »

{(Detail.Breached == "1Y")? "Breached SLA Cases" : "{<font-color="red">Within SLA Hours</font-color>}"}

Some how the font color is giving me error...can it be done ?
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Formatting Text

Post by Alex K. »

Hello,

Please try to use the following expression:

Code: Select all

{(Detail.Breached == "1Y" ? "Breached SLA Cases" : "<font-color=\"red\">Within SLA Hours</font-color>")}
Thank you.
fkmfkm
Posts: 181
Joined: Thu Jul 05, 2007 11:26 pm
Location: Kuala Lumpur

Re: Formatting Text

Post by fkmfkm »

Opps I guess its not working cause i export to excel..

How can I do coloring if I am exporting to excel..?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Formatting Text

Post by HighAley »

Hello.

The text is exported to Excel right.
text.png
text.png (9.76 KiB) Viewed 4873 times
Could you describe your issue more detailed?

Thank you.
fkmfkm
Posts: 181
Joined: Thu Jul 05, 2007 11:26 pm
Location: Kuala Lumpur

Re: Formatting Text

Post by fkmfkm »

Sorry,

I mean I would like to have conditional formatting as in my first post ....
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Formatting Text

Post by Alex K. »

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your task in more details?

Thank you.
fkmfkm
Posts: 181
Joined: Thu Jul 05, 2007 11:26 pm
Location: Kuala Lumpur

Re: Formatting Text

Post by fkmfkm »

You see when I export to Excel i get this..

[img]
Capture.PNG
Capture.PNG (6.69 KiB) Viewed 4859 times
[/img]
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Formatting Text

Post by Alex K. »

Hello,

Please clarify which version are you use?
Also, please check the last prerelease build, it the issue still present, please send us a simple report which reproduces the issue for analysis.

Thank you.
fkmfkm
Posts: 181
Joined: Thu Jul 05, 2007 11:26 pm
Location: Kuala Lumpur

Re: Formatting Text

Post by fkmfkm »

Hi,

I am using 2014.1.1900.0
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Formatting Text

Post by Alex K. »

Hello,

Please check the last prerelease build, it the issue still present, please send us a simple report which reproduces the issue for analysis.

Thank you.
Post Reply