Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Problem with Background color Post Reply Post New Topic
Author Message
venky_115
Groupie
Groupie
Avatar

Joined: 15 Jun 2010
Location: United States
Online Status: Offline
Posts: 67
Quote venky_115 Replybullet Topic: Problem with Background color
     Posted: 21 Jun 2011 at 1:24am

Hi,

We are using crystal reports XI, i have a problem with the background color like the column name is Account
 
SNo     Account
-------------------
 1
 2        P1005
 3        P1006
 
 
so wherever the Account data is null i want to highlight with yellow color i tried all the way using formulae fields at background tab and highlight expert, this is not working, anybody can adivse asap?
 
Regards
venkat
 
Regards
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 21 Jun 2011 at 3:41am
in the format field, border tab, background x-2 button, you've tried something like:
 
if isnull({table.account}) then
  crRed
else
  crNoColor
 
Just checking as I would think that this would work
IP IP Logged
venky_115
Groupie
Groupie
Avatar

Joined: 15 Jun 2010
Location: United States
Online Status: Offline
Posts: 67
Quote venky_115 Replybullet Posted: 21 Jun 2011 at 11:26pm
Thanks for the reply, i have tried this before only but not working, any  other suggestions please?
Regards
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 22 Jun 2011 at 5:27am
this might work
go to file
report options
check off convert null value boxes
this should pull them in as a zero.
IP IP Logged
venky_115
Groupie
Groupie
Avatar

Joined: 15 Jun 2010
Location: United States
Online Status: Offline
Posts: 67
Quote venky_115 Replybullet Posted: 17 Jul 2011 at 10:13pm
Checked it and i have selected directly to back ground color this also not reflecting as other fields are reflecting ..
Regards
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 18 Jul 2011 at 12:15am
try to create a variable where it contains:
if isnull({tbl.field}) then '-' else {tbl.field}
put this variable in the report.

then right click on this field and select 'Highlighting Expert...'
> click 'New'
in the right hand:
- value of = this field
  is equal to
  '-'

- background = silver (or red, as you want)
click OK.

check it.

the purpose of using variable is because we cannot see the field to select because of 'null' value for this field (this is my opinion).



hope it help.

regards,
emir


Edited by Emir_W - 18 Jul 2011 at 12:17am
Emir W
IP IP Logged
venky_115
Groupie
Groupie
Avatar

Joined: 15 Jun 2010
Location: United States
Online Status: Offline
Posts: 67
Quote venky_115 Replybullet Posted: 31 Jul 2011 at 11:06pm
Thanks a ton Emir, this worked out
Regards
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.