Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Alternate Shading of Rows in Group 2

Status
Not open for further replies.

mynameant

Programmer
Oct 19, 2005
64
US
Hi all, I am using CR XI Release 2 and have a report [summarized to Group] that I need to shade it grey or white alternatively. Unforutnately I do not want this on Details but it's on group level itself.
Let me explain:
I have grouped all the rows I am getting from my query and summarized like this:
----------Group header G1
Name1:
Name2:
Name3:
------Details [Suppressed]
------
----------Group Footer G1

I am pulling all the information from details into Group and I want to show row Name1: in Grey and Row Name2: in white and Row Name3: in grey etc..

I checked this thread thread767-1396229 but did not work using Groupnumber. Can you help me with any ideas?

Thanks,
 
Groupnumber would have worked if you only had one group, so what is your group structure?

-LB
 
Thanks for your response. I have only one Group in my report, G1.


 
You should be able to go into the section expert->select Group Header#1->color tab->background->x+2 and enter:

if remainder(groupnumber,2) = 0 then
crWhite else
crGray

What happens when you do that?

-LB
 
When I do that, it's putting crWhite [or whichever color] on the entire group. It's not changing based on lines inside the group header.
 
Exactly what is name1 through name3? Are these separate data fields than your group names or are they the groups themselves.
 
Is it that you are trying to color separate GH_a, GH_b, and GH_c sections?

-LB
 
Actually, there is one Group. In that I have put some text objects Name1:
Name2:
Name3:

and some of my computations are group level and I put them for each Name. So, for those lines [My details are suppressed for this report], I need to alter the background just to make them clearly visible to users. Since there are bunch of lines within that group, If I don't put alternate colors for alternate lines, it'll be difficult for them to view thru the report.

Thanks for all your help.

 
If you manually added these to the group header, then you just need to manually color the objects as well, alternating the "lines".

-LB
 
That's what I am trying to avoid :)
But if there is no other way , then that's what I have to do.
So, how do I color the objects for each line? I mean there are four - five fields placed for each text object in each line. So, should I just select all then pick a color? ifso, how does it put same color in between the objects?

Thanks for the quick response.
 
I could put a box around all those objects and fill with color. Should have tried before putting the question.

Thanks for your help though. If you have a different soluiton that would be great.
 
If you want the entire "line" to be the same, then insert separate group header sections a,b,c,d,e and move the text boxes/calculations from each line into their own group header section. Then go into the section expert and select each group header section->color tab and select a background color.

-LB
 
Ummm.. that would be a bunch of groups I need to be creating [a lot]. I'll just draw empty boxes around each line and fill it with different BGColors.

But, thanks for all the help.
 
No, these would NOT be additional groups. If you right click on the gray area to the left of the group header, there is an option to insert section below. This just inserts another GH1 Section, so that you now have GH1a, and Gh1b, etc. There is still only one group. These sections can be colored as I indicated. No need for text boxes.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top