SSRS report

sajusathish@gmail.com

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 ..?

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

Duikmeester

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);