Iif problem with RDLC
Iif problem with RDLC
Iif problem with RDLC
Iif problem with RDLC
Iif problem with RDLC
Iif problem with RDLC Iif problem with RDLC Iif problem with RDLC Iif problem with RDLC Iif problem with RDLC Iif problem with RDLC Iif problem with RDLC Iif problem with RDLC
Iif problem with RDLC Iif problem with RDLC
Iif problem with RDLC
Go Back  Xtreme Visual Basic Talk > > > Iif problem with RDLC


Reply
 
Thread Tools Display Modes
  #1  
Old 10-09-2007, 01:24 AM
767pilot 767pilot is offline
Newcomer
 
Join Date: Oct 2007
Posts: 3
Default Iif problem with RDLC


Hi

On a report created with the reportviewer I have a field linked to a database

ie Fields!fuelwt.Value

When the report is run the value is displayed correctly from the database

ie 800

Problem I have is when using an expression in the 'color' property of that fields text box.

ie =Iif(Fields!fuelwt.Value >900, "Black", "Red")

Regardless of the value or the colors that I add the color is always black. Obviously if I add a color in the color properties the color is displayed OK but when I have the above entered the expression appears to be ignored

Any ideas please?
thanks
Gray
Reply With Quote
  #2  
Old 10-11-2007, 02:33 PM
Adel99 Adel99 is offline
Centurion
 
Join Date: Aug 2005
Posts: 160
Default

Hello,
I'm sorry I cannot figure out how to use that logical expression properly. But I have something to say.
If the matter is to format a field differently depending on a condition, then there is something in Crystal Reports called Highlighting Expert, and I suggest it. It is very simillar to the Conditional Formating in Microsoft Excel.

To use Highlighting Expert:
1- Write-click a field and choose Highlighting Expert from the menu.
2- Add a new by clicking the New button, and play with the settings to the right.

YOURS,
Adel,
Reply With Quote
  #3  
Old 10-12-2007, 09:12 AM
767pilot 767pilot is offline
Newcomer
 
Join Date: Oct 2007
Posts: 3
Default

thanks Adel.
I am not using Crystal reports, I am using the builtin ReportViewer.

I've solved my problem now anyhow by deleting and rewriting the report.
Works fine now!

regards
Gray
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Iif problem with RDLC
Iif problem with RDLC
Iif problem with RDLC Iif problem with RDLC
Iif problem with RDLC
Iif problem with RDLC
Iif problem with RDLC Iif problem with RDLC Iif problem with RDLC Iif problem with RDLC Iif problem with RDLC Iif problem with RDLC Iif problem with RDLC
Iif problem with RDLC
Iif problem with RDLC
 
Iif problem with RDLC
Iif problem with RDLC
 
-->