One of the coolest things that comes along with MOSS 2007 is that we can now acquire data via a web service or a database with Business Data Catalog and publish it on Sharepoint portal. Let's say you've created your Application Defition File and you acquired the data over your Business Data List and viewed it on the portal. But you've noticed that unlike the other list web parts, there is no grouping, sorting interface in business data list web part that you can apply these particular operations. At this point, you can edit web part's xsl by clicking the XSL Editor button that you can see in the edit window of the web part. But if you don't want to deal with xsl, Sharepoint Designer comes to your assistance. In order to edit your business data list web part with Sharepoint Designer, open the site that contains the web part from the File menu by clicking Open Site. After that, open the page where the web part is located by double clicking. Select the Business Data List web part that you want to edit. You'll see the > button on the top right corner of the web part. Click it and the menu below will open:

In the menu, click the Dataview Properties link. In the General tab, check the Show toolbar with options for: checkbox and among Filter, Sort, Group actions, check whichever ones you want to apply:



That's it! Thanks to this menu that is opened by clicking the top right corner of the web part, you can not only arrange grouping, filtering etc, but also change things like web part content and table style, paging settings and conditional formatting.