Sorry to be confusing I did make an error in my example, my apologies I will try again.
Item Category
1 A
2 B
3 AB
4 CA
Expected output
Group A
Item 1
Item 3
Item 4
Group B
Item 2
Item 3
Group C
Item 4
Once again...
Madawc
Thanks for your assistance , I tried using formula in detail section , but again as soon condtion is false
eg {category} string begins with "B" or is "AB" I get no result.
Thanks
Matt
Tried using
if Category like "A" then "A"
else if Category like "B" then "B"
but if condtion is false
eg {category} string begins with "B" or is "AB" it does not get grouped.
Any further help would be appreciated.
Matt
After searching through many posts I am unable to work out how to do the following.
I would like to group items by a value in a string(category) this item may belong to more than one group.
Eg
Item Category
1 A
2 B
3 AB
4...
firstly thank you for previous help
i used
//{@reset} for the group header:
whileprintingrecords;
stringvar colors := "";
//{@colors} for the detail section:
whileprintingrecords;
stringvar colors := colors + {table.color} + ", ";
//{@displaycolors} for the group footer...
I would be most grateful if anyone could help me with the following which try as i might i can not work out.
I would like to combine the data of multiple records to a new field to enable me to print across the page. eg
9001 red
9001 blue
9001 green
I would like to print as 9001...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.