Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

BDC with inner join returning multiple values (as expected). How to consolidate on a business d

Asked By: Andrea Green Date: Mar 20, 2009 Category: Sharepoint Views: 300

I have created a Business Data Catalog and am using a Web Part w/ Business Data List

to display the data.

The data displayed is joined with other tables. This example, simplified to show my

problem, shows what I am trying to achieve. The default output in the business data

list is (notify the unique identifier ID, this is what I want to group on):

Id,Name,City,Hobbies

--------------------
1,Mike,Toronto,Baseball

1,Mike,Toronto,Hockey

2,Anna,Miami,Basketball

In this example, a person can participate in many sports. Is there anyway in SharePoint

to group data in a column for a unique identifier? So that in the example output,

"Mike" would have both "Baseball" and "Hockey" under a single row and not two

separate rows?

I know it would be possible to use a UDF and create a comma delimited list but I was

hoping SharePoint Server would have some other way to handle this nativly and provide

filtering on the individual values and not the comma delimited list.

Tagged:bdc with inner join returning multiple values as expected how to consolidate on business

1 Answer Found

Answer #1 Answered By: Liana Alston Answered On: Mar 20, 2009

You can replace the default XSLT. To generate an XSLT which groups the results, you can take some help from Data View Webpart.

- Create a Data View Webpart using sharepoint designer.
- Use your BDC as its Data Source.
- In DVWP we have various templates and options to group the columns and filter the results. Select the one you feel is best for you.
- Now copy its XSLT from its xsl tag.
- Open your BDC webpart and in its properties, open XSl Editor.
- Replace XSLT in this with the one you copied.

Didn't find what you were looking for? Find more on BDC with inner join returning multiple values (as expected). How to consolidate on a business d Or get search suggestion and latest updates.