Results 1 to 5 of 5

Thread: reports builder

  1. #1
    Join Date
    Jan 2005
    Posts
    362

    Unanswered: reports builder

    I have a query at reports builder 6i, and an column "something" in that, I want to put at a text item the concat ("something value 1 ","something value 2 " etc) of values of column "something".
    How can I do that?
    Thanks
    Dimis

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I believe you know what's the problem, but - to me - "something value 1" isn't very descriptive. Could you post what you have at the moment and expected result?

    What are, for example, "1", and "2"? Sequence numbers?

    Or do you, for example, currently have
    Code:
    NAME
    ---------------
    Dimis2500
    Littlefoot
    Registered User
    but would like to have
    Code:
    Dimis2500, Littlefoot, Retistered User
    If so, perhaps the STRAGG function (which can be found at Ask Tom) is the solution for your problem.

  3. #3
    Join Date
    Jan 2005
    Posts
    362

    Reports

    Yes is some text like that.I find a solution to take the "Dimis2500, Littlefoot, Retistered User" but I did not found how to take it at a text item,it must be a trigger there but I do not know so...
    For now i let them so

    Code:
    NAME
    ---------------
    Dimis2500
    Littlefoot
    Registered User
    Thank you.
    Dimis
    Last edited by dimis2500; 02-26-07 at 10:09.

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    BUt Bill, it IS a STRAGG function there, isn't it? (i.e. see the very last line of post #2).

Posting Permissions

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