Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2008
    Posts
    3

    Unanswered: Join function in a group header

    Hi,

    I'm creating a report which contains stock information and it is grouped as followed:

    Item
    - Color

    For example, an item (99999) contains three colors: 01, 02 and 03. Then the report is build up as followed:

    99999
    - 01
    - 02
    - 03

    I want the following information in the item group header:

    "01, 02, 03"

    So the group header tells you which colors there are for that item. The Join() function only works for parameter fields. Is there a way to create the above field with another function????

    Thanks in advance!

    Robert

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    Create 2nd group of the colour of the product?

  3. #3
    Join Date
    Apr 2008
    Posts
    3
    Hi,

    Do you mean I have to create a formula like this: join([GroupName ({Group 2 Colour})], ',')? If you do, then it doesn't work. It is still showing only the first colour (01). Do you have any other ideas??

    Thank you for helping!

    Robert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •