Data Reports Question

[WBH1138]

Hi

I'm looking at using VB's Data Reports.

I've previously used Crystal and could use functions to process on each detail line, i.e. check a value and change it's colour to red if -ive, or change a null value to display as "0.00" .

Is there a way of doing this in Data Reports?

Cheers
Wayne

 

[SmokinWrek]

You might put something like this in your code:

If FldVal < 0 Then
   rptMyReport.Sections(1).Controls("txtMyControl").ForeColor = vbRed
Else
   rptMyReport.Sections(1).Controls("txtMyControl").ForeColor = vbBlue
End If

You might want to read this thread as well, lots of different things covered in it:

http://www.tipmaster.com/includes/refinfo.cfm?w=450&h=450

Kevin

 

[SmokinWrek]

oops... that thread is:

thread709-88923

 

[WBH1138]

Thanks, that thread has a lot in it.

As to your code example...what event would I put it in?

 

[SmokinWrek]

Well, for one of my programs that uses a data report, I'm displaying a form so the user can select date ranges, etc. Then I'm issuing the SQL statement to get the relevant data, and performing calculations on it. I would set the properties at that point. Obviously, your program will be different, but I would think that you're issuing an SQL call somewhere, and you could check the data and set properties accordingly then.


Kevin

 

[WBH1138]

sorry, I still don't understand how I can set individual report field properties at runtime, depending on the value of one field on each record i.e.
i.e.
I have columns of name and age on the report.
Everytime I get an age over 65 I want it highlighted in another colour.