Colouring Rows of a Table depending on a particular condition.

[Former Member]

Hi,

The problem I am facing is coloring specific rows of a table depending on the satisfaction of a particular condtion. For example: All rows having the value in the amount column greater than 1000 have to be coloured in red and the remaining yellow.

Can anyone please help me out with this row-coloring problem?

Regards,

Gaurav.

[Former Member · Accepted solution]

Hi Gaurav,

I don't see the possibility of doing that with VC 7.1. What you could do instead, is have an extra [status|http://img262.imageshack.us/img262/5350/statuskl5.jpg] column, of type image URL and put in there a red ball or a yellow ball depending on the amount.

Good luck,

Dharmi

Edited by: Dharmi Tanna on May 20, 2008 9:11 AM

[Former Member · Accepted solution]

Dear Dharmi

we try to show a colored column in a table too. So i came accross your hint about the column with type image URL.

But i am not able to find a column type mentioned.

Can you please tell me, how to define a column showing an image?

Thanks in advance and best regards

Martin

[Former Member · Accepted solution]

Hi Martin,

Have used an image column to display image.

You can define the condition in the URL field, to display the image. Something like:

=IF(@img=="50",store@IMAGE_URL&"Green_dot.png",IF(@img=="40",store@IMAGE_URL&"Yellow_dot.png",IF(@img=="39",store@IMAGE_URL&"Red_dot.png","")))

Where store@IMAGE_URL has the URL to the location where the images are stored.

Let me if it helps.

Regards,

Dharmi

[Former Member]

Dear Dharmi

thank you very much for the fast response!

But i still cannot get it...

There might be a confusing about the versions:

The thread is in the section SAP NetWeaver Visual Composer 7.1 (what we are using too)

In NW 7.0 i can find the column type Image, but in 7.1 i only has following choice: String, Boolean, Number, Date and Time.

So my problem before entering the formula (if i put the formula resulting in an URL to an image, it is shown as a string like expected)

Probably i oversee something totaly obvious...

Best Regards

Martin

[Former Member]

Hi Martin,

Image is control which can be found under Advance Controls in SAP VC 7.1, when you click om Compose Models. You can drag this Image control to your table, it then becomes the column wherein you can give the URL.

Let me know if you have any more doubts.

Regards,

Dharmi

[Former Member]

Hi Venkat,

would you please send the business card-email.

Thank you very much

[Former Member]

Hi Christoph,

I and Guarav haven't received any PDF yet....

Regards,

Dharmi

[Former Member]

Hello All,

Just wanted to share one information, the "coloring specific rows of a table depending on the satisfaction of a particular condtion" will be supported on 711 SP2 release.

Best regards,

Jitendra

[Former Member]

Hi,

Colring is not yet Supported .It will be supported forn EHP packages

Govindu

[Former Member]

Hai ,

Its possible in VC 7.1 . just send ur mail i will forward pdf with full step by step .

Regards ,

Venkat

[Former Member]

Hi Venkat,

Can you please mail it, that can be found under my name?

Thanks,

Dharmi

[Former Member]

Hi Venkat,

Can you please send that pdf to me.My id is there in my business card.

Thanks a lot.

Edited by: Gaurav Narkar on May 21, 2008 2:41 PM

[Former Member]

Dear Venkat

we try to show a colored column in a table too, so could you send me the mentioned PDF too?

My contact info can be found in my profile.

Thanks in advance and best regards

Martin