0
votes
0answers
96 views

SharePoint 2007 data view web part - using datetime from querystring in CAML

I have a SharePoint list, with a Start Date (internal:StartDate) and End Date (internal:_EndDate) that I am displaying with a data form web part. I have a static version of the part working perfect. ...
1
vote
0answers
68 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
127 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
2answers
112 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 ...
0
votes
0answers
366 views

Passing parameters to stored procedure in data view web part

I have a stored procedure which accepts 2 parameters. The stored proc is executed as EXEC MySP N'Val1, Val2', N'A,B,C' I inserted a Data View Web-Part and tried to get data from stored procedure. ...
0
votes
2answers
421 views

DVWP Display of Multiple Lists Results in “Unable to display this Web Part” Error in Production Environment

I used SharePoint Designer 2007 to create a joined view of two lists and changed the 'ListID' parameters to 'ListName'. The list is grouped and sorted. Update: When the joined subview is in the ...
0
votes
3answers
1k views

Dataview Web part and SQL - Way to use trusted connection?

As I'm sure you're already aware one of the biggest weaknesses of the data view web part is that it exposes connection strings for SQL Server connections. Instead of using a web service to pass my ...
2
votes
1answer
677 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
0answers
126 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 ...
2
votes
1answer
528 views

Using custom parameter with a form control as source in Data view Webpart

On a page, I have a dataview webpart to enter a new item in a list. It has just one text-box to enter data in a list field.On submit, the form is redirected to a custom page. I want to grab the text ...
1
vote
4answers
696 views

SQL Data Display and Edit in Sharepoint

I want to load data from SQL Table and edit the same and save in SQL DB. The tables has many records and all the records should be displayed and should be edited a single record at a time and should ...
4
votes
1answer
2k views

Dynamically setting Default Value in ParameterBinding through Javascript

To make a long story short (too late), we have a dropdownlist that is populated through a list of items. We want to use this dropdownlist to filter the list in a data view web part. This works ...
0
votes
1answer
153 views

Create a template from Data View web part

I have displayed some SQL data in MOSS 2007 with the help of Data View web part. However I wish to create a template sort of from this web part so that going forward I can just go ahead and change the ...
0
votes
1answer
347 views

How to implement a cascading lookup on a dataview new form connected to an external database

I have a requirement to develop a new entry form for a database that drives a reporting services report. I set up SSO and created a new item dataview webpart with a table on the database as the ...
0
votes
1answer
156 views

Can I make calendar items link to data view page?

We currently upgraded from 2007 to 2010 and I'm having problems with the calendar. In 2007 I was able to change that the calendar items would link to a custom data view I created. Here is our 2007 ...
1
vote
2answers
1k 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
122 views

Strange issue with DVWP in sharepoint 2007

I have created a DVWP using sharepoint designer 2007, it renders fine. However, it throws "unable to display the webpart, troubleshoot with sharepoint designer" when I check-out and save the page ...
1
vote
1answer
2k views

Solutions for Error: “The Datasheet view is attempting to retrieve data from a different domain”?

A couple users of our SP2007 site have received this error while accessing datasheet views. They are able to view/edit lists in 'standard view' without any issues and their PCs are configured with XP ...
3
votes
2answers
755 views

Evaluating dates in a DVWP

I'm trying to evaluate 2 dates in my DVWP, @StartDate (date and time field) and ddwrt:Today(). My expression looks like this: <xsl:when> <xsl:choose> <xsl:when ...
0
votes
3answers
253 views

Removing GUID from linked datasource

I'm deploying a DVWP and I'm looking to remove GUIDs references from the datasource. This is fine for standard single satasources, but I'm having troubles with joined datasources. Here's (a portion ...
7
votes
3answers
2k views

Data View Web Part and Custom List Form show Attachments

I have found a few ways to add attachments to a Data View Web Part, but I can only get this to work when the SharePoint:AttachmentsField is not being used anywhere else on the page. Currently my ...
1
vote
1answer
609 views

How do I use a javascript variable in the Filter Criteria for a DVWP?

I am converting some numbers using Javascript and need to filter a list using these conversions. I cannot do the conversions within SharePoint itself, so I had to use Designer and some Javascript. I ...
0
votes
1answer
248 views

How do I set up a greater than filter by using a Form Web Part?

I have a list that needs filters of greater than and lesser than an entered date. I can connect the form web part to return the same date, but I need it to return the dates greater than or equal to ...
1
vote
3answers
2k views

DataViews and Query String Parameter

I've used a parameter in the query string to filter a dataview. The parameter is declared in "SelectParameters" tag and used in the "selectcommand" parameter as a filter in the query. Now, is there a ...
0
votes
1answer
74 views

Order dataviews on different columns and paging with Sharepoint 2007

Is it possible to order a paged dataview on different columns (using a query string parameter)? Sharepoint 2007.
1
vote
1answer
532 views

How to Group DVWP Rows by a Joined Source Field?

I have a joined data source of 2 sharepoint lists and am trying to group by category and setup conditional formatting, yadda yadda yadda, in a DVWP using various fields within these lists. I'm able ...
0
votes
1answer
412 views

Complex DVWP Display of Multiple Lists

I've been asked to recreate an html table of links as SharePoint List data. It's a long list, with sometimes overlapping column data, and sometimes missing column data. The final result is a complex ...
2
votes
0answers
682 views

Search Core Results Webpart and Data View Webpart [closed]

We know that Search core results(SCR-WP) webpart can return a max of 50 results per page. Is there any way to increase this number to 2000 or so ? The reason for point no. 1 is that, I've modified ...
1
vote
1answer
877 views

Is it possible to pass a parameter from a form web part to a data view web part?

Is it possible to pass a value from a Form Web Part to a Data View Web Part? The value from the Form Web Part needs to be passed to a column field in the Data View Web Part for a calculation. The ...
1
vote
1answer
488 views

SharePoint Dropdown Vaue not updating in to Dataview webpart with SQL backend

I have a data view webpart and its source is a sql server database table(2005). I have the data view setup to be able to edit some of the fields inside the dataview. Instead of providing the user ...
0
votes
3answers
2k views

Filtering in Linked Sources using the QueryString as paramters in CAML(Select Command) and not XSLT filtering

Did anybody tried Filtering Linked Data Sources using the QueryString as paramters in CAML (Select Command) and not XSLT filters AggregateDataSource with Parameter ...
0
votes
1answer
2k views

DataForm webpart generated by Collect data from user action

Hello I really need help with this... , I am using Sharepoint 2007. I have the 'collect data from user' action in a workflow - which generates a custom form within the workflow folder. The form uses ...
1
vote
3answers
2k views

Deploy a Data View Web Part to any SharePoint site

I followed this url to create webpart that reads list from the top site. How to use SharePoint Designer to display list data from subwebs It worked great. I can even export the custom web parts (wp ...
1
vote
1answer
530 views

Using a Recursive DVWP query, can I retrieve the site name?

I have successfully created a DVWP which queries all lists in my subsites and returns the correct columns using the following selectcommand: <View> <Webs ...