Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Admire genius but beware - when genius is around everything is at risk
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

04
August

How Do I Create a Banded Report with Grouped Tables

During a recent training course a delegate asked "How do I create a banded report in a grouped table?"

If one creates a banded report in a Tablix using the usual formula everything is fine, however if there is a grouping in that table, things tend to get a little bit interesting!

Solution:

To get around this one can apply this formula to the details row od the Tablix:

=IIF(RunningValue(Fields!Category.Value,CountDistinctNothingMOD 2 = 1, "Colour1""Colour2")


If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us
1

Bob

08
October
Heya i am for the primary time here. I found this board and I in finding It really helpful & it helped me out a lot. I hope to provide one thing again and help others like you aided me.
2

uv lampa for naglar

08
March
wonderful submit, very informative. I wonder why the opposite specialists of this sector do not realize this. You should continue your writing. I am confident, you have a great readers' base already! uv lampa for naglar ropar.amelduab.se/map2.php uv lampa for naglar
3

billig bra ansiktskram

26
March
I'm gone to tell my little brother, that he should also pay a quick visit this weblog on regular basis to take updated from most recent gossip. billig bra ansiktskram exym.interestinghere.be/beautiful-things/billig-bra-ansiktskraem.php billig bra ansiktskram
4

langst bak pa tungan

30
March
Today, while I was at work, my sister stole my iPad and tested to see if it can survive a twenty five foot drop, just so she can be a youtube sensation. My iPad is now destroyed and she has 83 views. I know this is completely off topic but I had to share it with someone! langst bak pa tungan tersc.interestinghere.be/decorations/laengst-bak-p-tungan.php langst bak pa tungan
5

braun oral b tandborste

31
March
Pretty! This has been an incredibly wonderful post. Thank you for providing this information. braun oral b tandborste tivin.interestinghere.be/beautiful-things/braun-oral-b-tandborste.php braun oral b tandborste
6

jatte tappt i nasan

31
March
We're a group of volunteers and opening a new scheme in our community. Your site provided us with helpful info to work on. You have done an impressive task and our whole community will likely be thankful to you. bobzo.interestinghere.be/advice-girlfriends/jaette-taeppt-i-naesan.php jatte tappt i nasan
7

plocka ut linser

01
April
I'd like to find out more? I'd like to find out more details. nocal.interestinghere.be/sport/plocka-ut-linser.php plocka ut linser
8

saret vatskar sig

01
April
This is the right webpage for anyone who wants to understand this topic. You know a whole lot its almost tough to argue with you (not that I personally will need to…HaHa). You certainly put a new spin on a topic that has been written about for a long time. Wonderful stuff, just wonderful! lispi.interestinghere.be/useful-tips/sret-vaetskar-sig.php saret vatskar sig
9

gora om vigselring

01
April
Good day! This post couldn't be written any better! Reading this post reminds me of my good old room mate! He always kept talking about this. I will forward this post to him. Fairly certain he will have a good read. Thanks for sharing! lispi.interestinghere.be/useful-tips/goera-om-vigselring.php gora om vigselring
10

lussebullar utan mjolkprotein

02
April
This blog was... how do I say it? Relevant!! Finally I've found something that helped me. Thank you! pinkl.interestinghere.be/relaxation/lussebullar-utan-mjoelkprotein.php lussebullar utan mjolkprotein
11

blabar vid diarre

03
April
Good article! We are linking to this particularly great post on our site. Keep up the great writing. trumk.interestinghere.be/music/blbaer-vid-diarre.php blabar vid diarre
12

blabarspaj allt om mat

03
April
Good info. Lucky me I recently found your blog by accident (stumbleupon). I have book marked it for later! ranch.interestinghere.be/travels/blbaerspaj-allt-om-mat.php blabarspaj allt om mat
13

side by side kyl och frys svart

04
April
I blog often and I genuinely thank you for your content. Your article has truly peaked my interest. I'm going to book mark your site and keep checking for new details about once a week. I opted in for your RSS feed as well. tapu.interestinghere.be/beautiful-things/side-by-side-kyl-och-frys-svart.php side by side kyl och frys svart
14

hur manga kalorier innehaller sallad

05
April
Greetings from Idaho! I'm bored at work so I decided to check out your blog on my iphone during lunch break. I really like the knowledge you present here and can't wait to take a look when I get home. I'm surprised at how fast your blog loaded on my mobile .. I'm not even using WIFI, just 3G .. Anyways, good site! inob.interestinghere.be/relaxation/hur-mnga-kalorier-innehller-sallad.php hur manga kalorier innehaller sallad
15

ecuniphi.se

05
April
Hey there this is kind of of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually code with HTML. I'm starting a blog soon but have no coding knowledge so I wanted to get guidance from someone with experience. Any help would be greatly appreciated! ecuniphi.se/decorations/bloedning-en-vecka-efter-mens-gravid.php blodning en vecka efter mens gravid
16

ecuniphi.se

06
April
When someone writes an post he/she retains the thought of a user in his/her mind that how a user can understand it. So that's why this post is perfect. Thanks! ecuniphi.se/skin-care/vers-begravning-vaen.php vers begravning van
17

ecuniphi.se

06
April
Hi there to all, how is all, I think every one is getting more from this website, and your views are fastidious in support of new viewers. ecuniphi.se/useful-tips/svart-overall-baby.php svart overall baby
18

ecuniphi.se

07
April
Hi my friend! I wish to say that this article is amazing, great written and come with approximately all important infos. I'd like to see more posts like this . ecuniphi.se/useful-tips/medicament-pour-digestion-difficile-et-ballonnement.php medicament pour digestion difficile et ballonnement
19

ecuniphi.se

07
April
My partner and I stumbled over here coming from a different page and thought I might as well check things out. I like what I see so now i am following you. Look forward to checking out your web page yet again. ecuniphi.se/trends/sveriges-billigaste-pool.php sveriges billigaste pool
20

ecuniphi.se

08
April
This site truly has all of the information and facts I needed concerning this subject and didn't know who to ask. ecuniphi.se/decorations/mini-rodini-kpse-gul.php mini rodini akpase gul
21

ecuniphi.se

09
April
Have you ever considered writing an e-book or guest authoring on other websites? I have a blog based on the same topics you discuss and would love to have you share some stories/information. I know my subscribers would enjoy your work. If you're even remotely interested, feel free to send me an e mail. ecuniphi.se/decorations/nerv-i-klaem-i-foten.php nerv i klam i foten

MAKE A COMMENT

Name *

Email Address *

Comment *