Grouping 1

[ganjass]

CE10

Hi all.

I've got a report that is grouped on Code, all the codes have to be diplayed with a count of those group members in the group header. Trouble is though is that all the group memebrs are not always evident based on the record selection criteria. Is there a way that i can get the group to display the other entries in the group that dont meet the criteria.

eg
currently expected
Code count Code count

X 5 X 5
y 10 y 10
z 15 z 15
a 0
b 0
c 0
etc..

Thanks in advance

 

[bdreed35]

Do you have a full list of the codes in another table in your database? The idea here is to have one table return the full list of codes that you want to see, and then join it to the table that has the transaction information using a left outer join.

You need to add the table with the full list to your report.
When you set up the linking, join the tables on code, then change the linking option to left outer rather than equal.

~Brian

 

[lbass]

If your report is based on fields from one table, then remove the condition from your record selection formula, and instead use it in a formula:

if {table.code} in ["x","y","z"] then 1 else 0

Group on {table.code}, and then right click on the formula and insert a summary (SUM, not count) on it and suppress the details. This should give you all your code groups, with those not meeting the criterion = 0.

-LB