SmartForm ListView - only show repeating data once

  • 6 November 2015
  • 2 replies
  • 0 views

Badge +3

In a ListView, is it possible to only have a repeating field display once?  For example this list has 3 rows with the same Customer Name.

 

Customer       Order Amount

ACME              $10

ACME              $50

ACME              $75

 

I want to show it like this:

Customer       Order Amount

ACME              $10

                          $50

                          $75 

 

I want to do this on an Editable List.  So I want the Customer to have a value on all 3 lines.  But only be displayed the 1st time.  Is this possible?


2 replies

Userlevel 5
Badge +16

Hi,

 

I don't think you can do that in Editable list, but I belive its possible in a list view by creating Stored Procedure.

 

Please check the following link:

 

http://raresql.com/tag/merge-or-combine-multiple-rows-records-to-single-column-record-with-comma-delimiters/

Badge +2

Hi,

 

Out of box feature is not available but yo can create a stored procedure which will display multiple values for differnt item (',' saperated)

and use that stored procdure in the list view.

I also have the same requirement once and have implemented like that.

 

Hope this helps.

 

Rahul

Reply