Reports - Set Conditional format on subreport

I have a report with Main/Subreports - the main Report displays the current Invoice#,

I want to highlight the same number row data on the subform.

see attached.
ScreenShotC Formating
I tried setting the conditional formatting on the fields of the continuous form.

but it does not make any difference - What am I doing wrong.
Karen SchaeferBI ANALYSTAsked:
Who is Participating?
 
Eric ShermanConnect With a Mentor Accountant/DeveloperCommented:
It could be one of several issues ... kind of hard to guess with all the property settings in Access.  Can you just load up a sample db with your report in it.  

In my sample changing the background color also works ... see below.  I changed the Font as well as the back color of the controls in the detail section of the report.

Test Report 2

ET
0
 
Eric ShermanAccountant/DeveloperCommented:
1.) Open your sub report in design view.
2.) Then enter your Conditional Formatting Rule displayed above for each field ...  

Creation Date
Vendor
Invoice Date
Invoice #


ET
0
 
Karen SchaeferBI ANALYSTAuthor Commented:
Did that - not displaying correctly.

K
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Eric ShermanAccountant/DeveloperCommented:
Post a sample of your db.  It worked in the application here that I tested with.  Should be something pretty simple ... could spend hours guessing at it.

In my sample db I formatted the font color to red in the detail rows of the sub-report based on the employee id 1111111 on the main report and it worked.

 
TestReport


ET
0
 
Karen SchaeferBI ANALYSTAuthor Commented:
Ok if I change the font color it seems to work, but I want to change the background color to a light grey, so when printed in black and white it is still highlighted.

any ideas why it does not display the back ground color.
0
 
Karen SchaeferBI ANALYSTAuthor Commented:
thanks for your input, time prevents me from researching this issue further - I have to deliver what I have.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.