SSRS report

Hi Experts..!

In a field there are multiple vales (like a1|a2|b1|b2 etc)
I have to take the description of each record in a single variable (output like a1’s Description, a2’s Description, b1’s Description, b2’s Description, )

And get the output in report in a single text box.

How can I do it ..?

Answers

  • krikikriki Posts: 8,570Member, Moderator
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2018: 22 & 23 November 2018, Antwerp (Belgium)
  • DuikmeesterDuikmeester Posts: 193Member
    MyTable.SETFILTER(Code,FieldWithValues); //A1|A2|B1|B2
    
    IF MyTable.FINDSET THEN
      REPEAT
        IF MyText = '' THEN
          MyText := MyTable.Description
        ELSE
          MyText += ', ' + MyTable.Description;
      UNTIL MyTable.NEXT = 0;
    
    MESSAGE(MyText);
    
Sign In or Register to comment.