on 01-19-2015 9:15 PM
Hi All,
as per the rules, I'm moving this thread to a new one.
Could someone please advise on how to change the attached report (Microsoft OneDrive - Access files anywhere. Create docs with free Office Online.) to:
Regards,
Przemek
Hi Przemek,
The updated file is too large to be attached here.
Here's what you need to do:
1) Highlight the two fields on the header > Right-click the fields > Format Objects > Common Tab > Check the option 'Repeat on Horizontal Pages'. This will show the headers on all pages.
2) Right-click the summary field > Format Field > Border tab > Check the formula button beside Background and use this code:
IF Right(GridLabelAt("Polecenie.DzieńNazwa", CurrentRowIndex),2) IN ["So","Nd"] then rgb(224,224,224) else crNoColor
3) Click Save and Close and then move over to the 'Font' tab > Click the formula button beside 'Color' and use this code:
IF Right(GridLabelAt("Polecenie.DzieńNazwa", CurrentRowIndex),2) IN ["So","Nd"] then rgb(224,224,224) else crWhite
This will take care of the the colors.
Hope this helps.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.