We are creating a BI dashboard using SharePoint Portal Server 2007 and have following requirements and could you please tell us it is possible to without creating custom web parts. 1) When user clicks on a row in list web part, is it possible to refresh another web part based on the selection in first web part. 2) Can we connect KPI and KPI detailed webpart so that when your cliecks on measure (ex: Gross Margin%) then KPI detailed refreshed with data based on selection (ex: Details about Gross Margin calculation in KPI detailed web part)
Thanks Bipin