Hi,
I am very new to Jet and I have a question about formatting my reports using Jet. I want to have my rows of data come out with alternating shading to make the data more easily read. Is there a way for me to do this before the report is run? or would I have to go back and manually do it after running the report?
Thanks in advance!
Gustavo
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment Hi Gustavo,
This can actually just be done using Excel conditional formatting. You just highlight the rows being replicated and create a conditional formatting rule based on this formula:=mod(row(),2)=1
Then you just set a background color in the conditional format rule for the cells where that formula is true. Does this make sense?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
thanks for responding. My problem is that I want the format to happen after the report to run. Before Jet runs the report, I only have one row of data which is where the formulas are. I can shade that row fine and get the results to come back with that color, but I want the shades to alternate for easier viewing.
Is there/should I add another blank row after the formula row to do this? Only problem with this is that I will have blank rows in between each row with data. -
Jet Reports Historic Posts Hughes!
Your a Genius! I was doing it wrong, but after playing with it some more and doing exactly what you told me I got it to work!
Thank you so much!!!!
V/R,
Gustavo :D -
Jet Reports Historic Posts OH BOY, this is marvellous!! :D
I was looking for something else, but it seems just what I need to enhance my reports!
Hughes, thank you (and Gustavo for the question ;) ).
Happy holidays everybody!!
Willem.
Please sign in to leave a comment.