Author |
Message |
Annec
Newbie
Joined: 17 Feb 2017
Online Status: Offline
Posts: 6
|
Topic: how suppress group header when not data on detail Posted: 21 Feb 2017 at 12:01pm |
hi, How can I suppress a group header when I have a condition that suppress the detail in section expert. if I put the same formula in group header section expert . this suppress the the group header for every thing. the formula work well suppressing on detail all what I don't need. But I need to keep the group header when it have detail show on the report.
The problem is that my condition formula depend of the summary of a running total. because of that i cannot make a total of that summary and put it on the group header.
also I've create another formula : If previous({vwDocument.DocumentNumber})=({vwDocument.DocumentNumber}) Then 1 Else 0
but crystal see that as a summary also. and I cannot insert a summary of this and insert in the group header.
I will appreciate if any body can help me
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 22 Feb 2017 at 2:49am |
what is your suppression criteria and your RT set up?
|
IP Logged |
|
Annec
Newbie
Joined: 17 Feb 2017
Online Status: Offline
Posts: 6
|
Posted: 22 Feb 2017 at 3:43am |
My Detail section expert formula is: IF ISNULL({#count3}) OR {#count3} = 1 THEN TRUE ELSE FALSE. -------------------------------------------------
I have a formula where I get the first character on a document Number ex: my documentNumber is SO2-0004567 but on the line SO2-0004567-23456 SO2-0004567-36782 SO2-0004567-23189 so this invoice have 3 item line. the only way for my to know how many line an invoice number have is getting the first 11 character of the invoice . because I have group for customer number .
I have a formula named:fist11-character: left({vwFedEx.DocumentNumber},instr(strreverse({vwFedEx.DocumentNumber}),"*")+11) base on that, I have a running total as follow: Running total name: count3 field to summarize: @fist11-character Evaluate for each reacord reset on change of field @fist11-character
on my suppression I only need customer with invoice that have more than one line. Invoice with only 1 line I don't need it.
thanks
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 22 Feb 2017 at 4:37am |
This is a bit confusing as I am not understanding your raw data set from your view.
It looks like you are over complicating it though.
If you can grab the left 11 characters from DocumentNumber and group on that and then do a group count of that field (not a RT just a summary) and you can suppress the entire group if the group count<=1
Edited by DBlank - 22 Feb 2017 at 4:45am
|
IP Logged |
|
Annec
Newbie
Joined: 17 Feb 2017
Online Status: Offline
Posts: 6
|
Posted: 22 Feb 2017 at 4:55am |
the problem i can't count that field because when the document number change example: Customer Pedro Pablo SO2-0050836-150567 SO2-0050836-150568 SO2-0050836-150569 SO2-0050864-150669 SO2-0050864-150671 SO2-0049753-146599
on this example this customer have 3 different Document number , SO2-0050836 with 3 line SO2-0050864 with 2 line SO2-0049753 with 1 line
that's why I had to make a running total to count and diferenciate when the document number change. If I count in the way you said , It will take total as only 1 document number.
thanks
|
IP Logged |
|
Annec
Newbie
Joined: 17 Feb 2017
Online Status: Offline
Posts: 6
|
Posted: 22 Feb 2017 at 5:12am |
ok,
I did what you said, and It work!!!!!!!
thanks you !!! thank you !!!
|
IP Logged |
|
Annec
Newbie
Joined: 17 Feb 2017
Online Status: Offline
Posts: 6
|
Posted: 24 Feb 2017 at 11:37am |
Well, today I realize that it doesn't work at all. Becuse if the customer Group at least it have one invoice number with total count <=1 , it suppress the complete group header. exam: Group Header Customer Pedro Pablo Group by Invoice@fist11-character SO2-0050864 SO2-0050864-150669 Count 1 SO2-0050836 SO2-0050836-150567 SO2-0050836-150568 SO2-0050836-150569 Count 3 Because at least one of the count is equal to 1 , it remove the customer header.
but the suppression on detail work fine.
the problem is I have detail without customer name. I have tried different think on the suppress for Customer group but without any luck.
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 27 Feb 2017 at 2:59am |
If I understand your need correctly for the customer group header use a comparison do a distinct count compared to a count
DISTINCTCOUNT(@formula,customer)=COUNT(@formula,customer)
|
IP Logged |
|
Annec
Newbie
Joined: 17 Feb 2017
Online Status: Offline
Posts: 6
|
Posted: 27 Feb 2017 at 5:52am |
That's was the part that was missing.
It work. Thank you!! Thank you!! You saved me.
|
IP Logged |
|
|