2
votes
2answers
3k views

Data View Web Part Calculated Column Total (Sum)

I have created a data view web part (grouped based on different criteria). I added a footer and I would like to generate a total for all the columns. I was able to calculate a total for basic columns ...
2
votes
1answer
41 views

Dataview get data from same List type with same content type from different sub sites

I have a site collection with different sub sites: A (Root) B (Program Site) B (Program Site) C(Projects Site) D(Projects Site) ...
2
votes
1answer
514 views

In a DVWP my Multilookup column is not returning IDs, only column values

I've added a DVWP to a page. The DVWP shows data from a list with a multi value lookup column. The value returned for this column is in the form: value1;value2;value3. Now I want to render this ...
1
vote
1answer
141 views

Hyperlink text to another list xslt

Anyone have ideas how I can link a text in another list. I have a one list(A) which contains items i want to display. I want to link to an article in list (B) Pages library using xslt dataview. Any ...
1
vote
1answer
760 views

Help xsl formatting help needed

I am creating this http://demo.webdeveloperplus.com/featured-content-slider/, image rotator in where data will be pulled automatically from a custom list. Need help with markup, as current markup ...
1
vote
1answer
979 views

Data View Web Part column header filtering

On a SharePoint 2007 environment I have a Data View Web Part that merges the contents of 2 document libraries. The "Enable sorting and filtering on column headers" is set to yes. However when I go to ...
0
votes
1answer
40 views

XSLT filter for Yes/No Column/Field in SharePoint Custom List for SharePoint Designer DataView WebPart

I'm trying this with no luck: [@ActiveStatus='Yes'] also tried 1, '1', 'True' .. get no rows back.. If I remove the filter I get back all rows. full line in code view looks like this: ...
0
votes
1answer
71 views

DVWP Error Grouping

I have a data view web part which was migrated to a SharePoint 2010 environment. It had a query parameter to group by month(calculated column) and filter by year. Since the migration it has been ...
0
votes
1answer
734 views

DVWP Wrong Group Count

I desperately need help with this...I have searched and tried everything I know. I have come across a group count error. I have created a data view web part using a linked source. The DVWP has only ...
0
votes
1answer
226 views

DVWP MaximumRows ParameterBinding not working

Is it possible to use ParamaterBinding for MaximumRows? The following does not work. Following set in SelectParmaters <webpartpages:DataFormParameter ParameterKey="MaximumRows" ...
0
votes
1answer
280 views

Customized Data View Forms with Content Types

I have a list with 2 content types attached. I need to customize the new item form for both content types using SharePoint Designer customizations. The default content type works great and submits the ...
2
votes
0answers
295 views

Webpart connection filter with Term Store metadata

I'm editing a list's dispform.aspx by adding a document library and trying to filter this one. I created a web part connection between the item ('Provide Row to') and the document library according a ...
1
vote
0answers
18 views

Connect form web part to DVWP to allow searching

Have an .aspx page with a DVWP that is connected to a list containing 700+ records. I would like to drop a search on this page (HTML Form webpart?) to allow keyword/freeform search criteria that would ...
1
vote
0answers
62 views

How to get KPIs to show when KPI List is Linked to a Custom List Using Linked Data Sources in SharePoint Designer 2007?

So I've found multiple sources on how to linked data sources in the designer. I get the data sources to link up by Title -> Great! But I can't get the value of the KPI or the formatted indicator to ...
1
vote
0answers
117 views

Make Webpart connections to work when a dropdown value is changed

I have a simple newform.aspx which has Employee as a textbox. During onload of the page, I assign this with currentuser. On the same page, I have a webpart created using sharepoint designer that ...
1
vote
0answers
38 views

How would I show empty group headers in the DVWP in SharePoint 2007?

I have a DVWP that I wish to model after a physical binder-based file system. I have a column named 'Title' and a column named 'Tab'. I have the view filtered by a column named 'Facility' and it is ...
1
vote
0answers
87 views

Data Source Library error: the web cannot be opened

Version of sharepoint: WSS 3.0 I opened a site, Home, in SharePoint Designer 2007. When I tried to insert the data view, it only show the greyed "+ Current Site". When I clicked "Connect to another ...
1
vote
0answers
232 views

Dropdown menu with XML data source gives web part error

I am using SharePoint designer to build a page with a data view web part that displays the contents of a 6,000 record XML file that is structured like the example below with each "Details" element ...
1
vote
0answers
447 views

How to pass parameter to Dataview Webpart without refersh

I would like to pass spme parameters using QueryString asper normal to a a listview or DWP. But i don't want the page to refersh.I tried using hash which works but no idea i can pass the parameter to ...
1
vote
0answers
221 views

Problem with 2 column layout in DVWP

MOSS 2007. I have a joined list with mutliple categories. I have a two column layout where the category is the header for each section with a group of subcategories. The categories are filtered based ...
1
vote
0answers
113 views

Dataview Web Part only works when pulling 110 lines or less of SQL

I recently started playing with the data view web part in SharePoint Designer. I've added a new data source and added a custom query. Unfortunately my queries appear to be limited to returning 110 ...
0
votes
0answers
23 views

Expand one item & collapse another in data view

I'm working with a data view in sharepoint designer, and I have the list grouped on the title field and collapsed by default - expandable with a click. This works great. Because there are a lot of ...
0
votes
0answers
11 views

is a different database connection required for every Data Filter Web Form?

I'm basically setting up a new .aspx page which includes some data form web parts (DFWP). Those web parts are connected to one SQL Server database backend and each one shows data from a different ...
0
votes
0answers
44 views

DatviewWebpart - MultiFilter on LinkedDatasources

I have a todo list. I have created a LinkedDatasource in Sharepoint Designer. I have created an aspx page with a DataView Webpart and inserted the Data Source, then I checked the "Sort & Filter ...
0
votes
0answers
74 views

Paging disappears after changing columns in web part listview

I have a web part page open in sharepoint designer, i have added a web part using the ribbon insert option and selecting dataview and choosing my custom list. I have then When you then view the page ...
0
votes
0answers
54 views

Have problem to display the SOAP data connection to a our Sharepoint site

I am using the SOAP data connection and i retreive data from my Web server but when i insert the SOAP data connection in the new page zone it's give me the display as HTML Code not as Text content : ...
0
votes
0answers
682 views

Sharepoint designer XSLT sum() field

I have a list with 7 items in it. The list has a value column and I would like to sum up the value column and display it in a textbox called "totalValue" that I created in sharepoint designer 2010. ...
0
votes
0answers
256 views

SOAP QueryEx requests cause errors 401 and 500

I have two web apps running on my SharePoint 2010 server. one called Intranet.company.com and one called Search.company.com Authenticated users have read permissions on both web apps, and I am logged ...
0
votes
0answers
49 views

data view: how to get column values back if I erased by mistake in SPD

So this is real silly but I accidentally erased the values from the data view in one of my columns while i was applying conditional formatting (i actually selected the column and deleted the values), ...
0
votes
0answers
170 views

Using Person field in Data View Web Part

I have a SP 2010 site with some data view web parts (built in SP Designer 2010) that roll up data from subsites (based on a listtemplate id). They work fine, but whenever I add a field of type ...