Tagged Questions
1
vote
0answers
16 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 ...
0
votes
0answers
20 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 ...
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
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 ...
0
votes
0answers
258 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
273 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
780 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
511 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
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 ...
1
vote
1answer
307 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 ...
0
votes
4answers
407 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
126 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
285 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 ...
