By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 2,185 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

setting subreport background colour to transparent?

P: n/a
I have a report that changes background colour when a running total
field hits a certain value...

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If [tbCostToMinistry_g] >= 2400001 Then
Me.Section(0).BackColor = 16053492
Else
Me.Section(0).BackColor = 16777215
End If
End Sub

I'm looking for a way to get a subreports background colour to change
along with the main report. There appears to be no 'transparent' option
on the sub report... and all the code I've tried doesn't seem to work
(I'm not very good with VB).

Can anyone help?
Thanks.

Jan 4 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Mi***********@gov.bc.ca wrote:
>I have a report that changes background colour when a running total
field hits a certain value...

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If [tbCostToMinistry_g] >= 2400001 Then
Me.Section(0).BackColor = 16053492
Else
Me.Section(0).BackColor = 16777215
End If
End Sub

I'm looking for a way to get a subreports background colour to change
along with the main report. There appears to be no 'transparent' option
on the sub report... and all the code I've tried doesn't seem to work
(I'm not very good with VB).

It needs to be done in the subreport:

If Me.Parent.tbCostToMinistry_g >= 2400001 Then
Me.Section(0).BackColor = 16053492
Else
Me.Section(0).BackColor = 16777215
End If

--
Marsh
Jan 6 '07 #2

P: n/a
Thanks. That worked.

On Jan 6, 7:48 am, Marshall Barton <marshbar...@wowway.comwrote:
Mike.Wolow...@gov.bc.ca wrote:
I have a report that changes background colour when a running total
field hits a certain value...
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If [tbCostToMinistry_g] >= 2400001 Then
Me.Section(0).BackColor = 16053492
Else
Me.Section(0).BackColor = 16777215
End If
End Sub
I'm looking for a way to get a subreports background colour to change
along with the main report. There appears to be no 'transparent' option
on the sub report... and all the code I've tried doesn't seem to work
(I'm not very good with VB).It needs to be done in the subreport:

If Me.Parent.tbCostToMinistry_g >= 2400001 Then
Me.Section(0).BackColor = 16053492
Else
Me.Section(0).BackColor = 16777215
End If

--
Marsh
Jan 8 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.