Hi Francis,
Both Prathamesh and Samuel have suggested the right approaches. Here is another way to do this:
1) Create two array variables. Each array variable will hold custom values. In this case, the formula can look like this:
stringvar array grp1 := ["Debenhams-ACCESSORIES","Debenhams-LINGERIE","Debenhams-HOME"];
stringvar array grp2 := ["Debenhams Cosmetics-JUICY COUTURE", "Debenhams Cosmetics-LOEWE", "Debenhams Cosmetics-BOGART"];
""
So, array variable grp1 will hold names in the order that you wish to be shown at the beginning. Similarly array variable grp2 contains values in the order that you want them to appear towards the end.
2) Create a formula that will put the Brand Names in separate groups:
if {Brand_Category} in ["Debenhams-ACCESSORIES","Debenhams-LINGERIE","Debenhams-HOME"] then
"A"
else if {Brand_Category} in ["Debenhams Cosmetics-JUICY COUTURE", "Debenhams Cosmetics-LOEWE", "Debenhams Cosmetics-BOGART"] then
"C"
else
"B"
3) Insert a group on the above formula from the Group Expert. You should see three Groups - A, B and C on the report
4) Insert a 2nd group on the Brand Category field. While in the same window,select the 2nd group and click the Options button > Choose "Original Order" as the Sort Order
5) The report now shows Brand Categories lined up as per the database order. This also re-organizes the records under Group A and C in the database order, however you want these records to be shown in the same order as it appears in the array variable, right?
6) Create another formula that displays the values in the array and place this on the Group Header 2:
WhilePrintingRecords;
stringvar array grp1;
stringvar array grp2;
numbervar x;
if GroupName ({@Name_of_the_formula_created_in_step2}) = "A" then
(
x := x + 1;
grp1[x];
)
else if GroupName ({@Name_of_the_formula_created_in_step2}) = "C" then
(
x := x + 1;
grp2[x];
)
else
{Brand_Category}
7) One last formula to reset a variable. Place this formula on the Group Header 1:
WhilePrintingRecords;
numbervar x := 0;
😎 You can then go ahead and delete the "Group #2 Name" text object from Group Header 2 and just have the display formula created in Step 6 show the Group Name. You will also need to Suppress Group Header 1, Group Footer 1 and Group Footer 2
This will now show up as a combination of both Specified Order and Original Order grouping.
Let me know how this goes.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.