If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: How to show data item horizontally using Repeater  (Read 4129 times)

dragonfire

  • Guest
How to show data item horizontally using Repeater
« on: 14 Aug 2006 06:27:35 am »
I would like to show data item in myreport with seperator in between:

E.g.
Fruit
Apple, Orange, Lemon

I tried to use Repeater and embedded with a comma. But I can't think of way to remove the last comma. I can only show the report like that.

E.g.
Fruit
Apple, Orange, Lemon,

Any hints on how to remove the last seperator?

Offline ClintSAP

  • Associate
  • **
  • Join Date: Apr 2022
  • Posts: 3
  • Forum Citizenship: +0/-0
Re: How to show data item horizontally using Repeater
« Reply #1 on: 12 Aug 2022 10:31:18 am »
Set items to repeat to have the comma at the beginning rather than the end and unless it is the first record. You can put a rank data item in the query and use that to check whether it is the first record or not.

Offline dougp

  • Statesman
  • ******
  • Join Date: Jul 2014
  • Posts: 788
  • Forum Citizenship: +29/-1
Re: How to show data item horizontally using Repeater
« Reply #2 on: 15 Aug 2022 10:50:42 am »
I make the comma its own data item:

Code: [Select]
case when running-count (distinct [Fruit]) < count (distinct [Fruit] for report) then ', ' end