new case for the alternating colour rows in crosstab

Hello,

I want to make the crosstab with the alternating colour in rows. With the standard case, I can make it out with the script that I found in one Topic. But this time, I want to keep the colour of the title, and want to make that work in the cross tab with the grand total.

I add the ex report here so that you can understand what I said.

Find more posts tagged with

Comments

mwilliams

Ok. I think this does what you're wanting. Let me know.

XFabien

Excuse me Michael,

I have tried my best to make it out with the script that you have added in the report. But I couldn't make it work, because I am not familiarize with the javascript. Do you mind to add some scripts just make it like the image below? Thank you very much.

mwilliams

Ok, so, to be clear, you want the title to be a different color and the rows, including dimensions and grand totals to be alternating colors? If so, let me know, I'll change the example to do so. I was confused by the first post, thinking you just wanted the grand total. Let me know.

XFabien

yes, just like you said. I want it just like the image that I have posted, including the grand total.
By the way, if I use another data element to replace the label "grand total", that will be more difficult or not?
Because I use a data element which come from the other data set in order that I can change the language for the title of "grand total".

thanks

mwilliams

Nope, that makes no difference because I use the cell ID of the grand total column to highlight it!

Let me change up the example and get back to you!

mwilliams

Take a look at this report. I changed the script to be easier to understand as well.

XFabien

Thank you very Michael, it works very well.

By the way, I noticed that you dont add the script for "Grand Total" in the last line of the table.

mwilliams

No, I didn't, because it worked out correctly with this example, but that should be an easy addition. Let me know if you need help with that.

Vineet Joshi

hi mike
Thanks for the example but
suppose we want to make background color change after every 2nd row .is it possible to do so as we are using boolean expression to do so .

Thanks
Vineet

mwilliams

So, you want to do 2 rows white then 2 gray or whatever colors you're using? If so, yes, you can do that. It will just involve some changes in the script. Let me know if I'm understanding correctly or not.

Vineet Joshi

Exactly but i want 1 gray and 2 white ....

Thanks
Vineet

Yogesh Maharwade

hi Mike,
What changes i have to do in the script to show one gray and two white rows.

Thanks

piwya

mwilliams

There are several ways you could arrange to keep track of the sequence. Here's one way. It uses numerical values in the PGV's, rather than true/false, to keep track of the order. Hope this helps.

Yogesh Maharwade

Thanks a lot Mike.

piwya