Conditionally suppressing fields

Hi peter
yes, I tryed that but unfortunately no luck.
I check the appropriate boxes and select Suppress if duplicated but nothing changes.
I am doing this in group footer 3 as that is where we set up my SZ[x]array to print.

Any ideas what to try next?

Thanks

well im getting 3 group footer lines (as above) from this array you helped me set up

peter57r:The actions need to do this are:
create a group on Widget and a second group on Colour.

In the Colour group header you need a formula field to initialise an array:
whileprintingrecords;
numbervar array sz;

redim sz[7];
//sz(1) xs;
//sz(2) s;
//sz(3) m;
//sz(4) l;
//sz(5) xl;
//sz(6) xxl;
""
In the detail line you have a formula field to accumulate the quantities:

whileprintingrecords;
numbervar array sz;

//sz(1) xs;
//sz(2) s;
//sz(3) m;
//sz(4) l;
//sz(5) xl;
//sz(6) xxl;
select{history.size}
case "xs":
    (sz[1]:=sz[1]+{history.Quantity})
case "s":
   (sz[2]:=sz[2]+{history.Quantity})
case "m":
   (sz[3]:=sz[3]+{history.Quantity})
case "l":
    (sz[4]:=sz[4]+{history.Quantity})
case "xl":
    (sz[5]:=sz[5]+{history.Quantity})
case "xxl":
   (sz[6]:=sz[6]+{history.Quantity});
""

In the Colour group footer you show the results:
whileprintingrecords;
numbervar array sz;
//sz(1) xs;
//sz(2) s;
//sz(3) m;
//sz(4) l;
//sz(5) xl;
//sz(6) xxl;
numbervar x;
stringvar tmp;
for x:=1 to 6 do
(tmp:=tmp &  right("     " & totext(sz[x],0),5) & "   ");
tmp


Add headings to the results and suppress all the sections you don't want to see.



This is the result, which is perfect
-----------------------------

Widget    Description   RRP        COLOUR        SIZERANGE
                                                                       S    M   L   XL   XXl
001         teeshirt         10.00       RED             1    0    0    0      0
001         teeshirt         10.00       BLUE           0    1    0    0      0
001         teeshirt         10.00       GREEN        1     0    0    0      0



THe next step is to suppress the dups

this is what i need


Widget    Description   RRP        COLOUR        SIZERANGE
                                                                       S    M   L   XL   XXl
001         teeshirt         10.00       RED             1    0    0    0      0
                                                    BLUE           0    1    0    0      0
                                                    GREEN        1     0    0    0      0



Does that make any sence

I think It's because I'm puttin the details in group footer #3{history.colour} and I have, in some cases, 3 colours for the same stylecode. so its printing 3 lines in group footer 3 (for say red, blue and, green)


Widget    Description   RRP        COLOUR        SIZERANGE
                                                                       S    M   L   XL   XXl
001         teeshirt         10.00       RED             1    0    0    0      0
001         teeshirt         10.00       BLUE           0    1    0    0      0
001         teeshirt         10.00       GREEN        1     0    0    0      0

Does taht make sence?

Morning Experts

I can't post it as the extension is not supported.
What an abosolute pain.

Is there a way to do as mark suggests and post it with the data?!
 

Perfect
Can I give you points for answering the question above. 250pts =)

Please excuse my messyness it's only half finished and I'm learning as i go and im certainly not clever

Any criticisms or suggestions please feel free as i have had no guidance and only started Crystal reports this year.

Here are the parameters to enter

BREAK BY:                        1
STORES TO INCLUDE  :   CITY
BRAND :                       >> ALL    
DEPARTMENT              >>ALL  
SUBDEPART                >> ALL
PRODUCT                      >>ALL
CATEGORY                    >>ALL
ENTER TAX                     NO
Tdate                           2008.03.31   and    2008.03.31
Show TOtals Only           NO

If you scroll to page 4 and look at the stylcode  "MTE5125"  it has 3 records



SOrry and Thanks !

Any suggestions would be great!

Aww thank you and what do you suggest if i cant suppress the fields? a subreport ? No I haven't really tryed any sub reports, would that mean i have to start again?  Its all abit cluttered isn't it. I have about 8 other things i can't seem to get to function on this report but i'll post them individually. I need to get this report out coz the companies are getting a bit upset. THis is the first of many reports Intergrated with OSIPOS Softwear i am re-doing from DOS to Crystals. we do all the major surf labels and retailors around Australia and NZ. Its Overwelming since im the only one here to do them all. BUt one step at a time .. as i said any suggestions would be big heads up for me

Thanks heaps!

Hi Mark
             Yes i Put totals in group 1 so they end user can see totals first, we can leave that for now, and change it if i need later.

Okay
The heading in GF2 needs to be a heading, i know its in the footer( i can't work out how else to do it... err I am feeling very silly at this point coz obvioulsy a heading goes in the header not the footer BUT ...)

  if i put it in Group header #1 , the matrix only shows once on the top of the page, when there may be 10 different sizes ranges on one page. so i jsut leave it in the footer, an i was gona try fix that later(HOW i DON"T KNOW !)

NO you are right, it's printing upside down.. i do need the matrix to print first(as a header!! supprisingly not a footer) and then the relevent size details underneath.


Describing the report- NO you have it right!!  there is no special reason why the heading is printing at the bottom of the group.. i just know it sort off works like this, and i've got this far so i dont wana go changing things and break it!! i can see the problem im just affraid now to move things around to fix it!!

yep Group Header #1 is a summary of all the items below for 'xxx' group (we can change that later)


DO you know how i can get the header "size matrix" to print first? and yes i need the quantities to add up!!

Thanks  you so much for your patients and persistance

It's fantastic!

Okay, i unsuppressed Group header #2. Suppressed the the Stylecode group header and moved the matrix header to group header #2. it works sweet.

was so simple, im a dufas.

any other suggestions?