Using the DataViewWebPart (DVWP) in SP Designer 2007. It can even be used to show data from other subsites. Below are some notes I made for myself.
Data View – Display content from one site on another site
Data View - Filter Data
1. Open the page in SharePoint Designer
a. Open the site where you want to display the list
b. Copy the URL
c. Open SharePoint Designer
d. Click File and click Open Site...
e. Paste the URL in the Site name: field and remove the file identifier (ex.pravahaminfo.com/Environment/default.aspx – delete the default.aspx)
f. Click Open
g. Double click on the appropriate page in the Folder list (lower left-hand pane)
2. Insert Data View
a. Click where you want the list to go on the page
b. Click Data View
c. Click Insert Data View (you can then drag and drop the web part if you want to move it around)
3. Assign Data Source
a. Open the site where you want to pull the list
b. Copy the URL
c. In SharePoint Designer, click Connect to another library... at the very bottom of the Data Source Library Task Pane
d. Click Add
e. Type the Display name:
f. Paste the URL in the Location: (once again remove the file identifier)
g. Click OK
h. Click OK
i. Click + to the left of the location you just added to the Data Source Library Task Pane to expand it (this may take a few seconds to finish)
j. Click + to the type of file you want to connect to (ex. SharePoint Lists)
k. Hover over the appropriate list and click the drop-down arrow
l. Click Show Data
m. Select the Rows you want to display by holding down the Ctrl key on your keyboard and clicking on the appropriate Row names
n. Click Insert Selected Fields as... button
o. Click Multiple Item View
p. Save the page (click the X to close the page and click Yes and click Yes)
Data View – Display content from one site on another site
Data View - Filter Data
1. Create the appropriate Data View by following the steps in the Data View – Display content from one site on another site
2. Click the Data View and then click the arrow in the upper-right corner to show the Common Data View Tasks list
3. Click Filter in the Common Data View Tasks list
4. Click here to add a new clause in the Filter Criteria dialog box
5. Click Field Name box and then click the field that contains the values that you want
6. Click Comparison box and then click the operator that you want (ex. Contains, Equals, etc.)
7. Click Value box and then type or select the criteria that you want
9. Click OK
1. Open the page in SharePoint Designer
a. Open the site where you want to display the list
b. Copy the URL
c. Open SharePoint Designer
d. Click File and click Open Site...
e. Paste the URL in the Site name: field and remove the file identifier (ex.pravahaminfo.com/Environment/default.aspx – delete the default.aspx)
f. Click Open
g. Double click on the appropriate page in the Folder list (lower left-hand pane)
2. Insert Data View
a. Click where you want the list to go on the page
b. Click Data View
c. Click Insert Data View (you can then drag and drop the web part if you want to move it around)
3. Assign Data Source
a. Open the site where you want to pull the list
b. Copy the URL
c. In SharePoint Designer, click Connect to another library... at the very bottom of the Data Source Library Task Pane
d. Click Add
e. Type the Display name:
f. Paste the URL in the Location: (once again remove the file identifier)
g. Click OK
h. Click OK
i. Click + to the left of the location you just added to the Data Source Library Task Pane to expand it (this may take a few seconds to finish)
j. Click + to the type of file you want to connect to (ex. SharePoint Lists)
k. Hover over the appropriate list and click the drop-down arrow
l. Click Show Data
m. Select the Rows you want to display by holding down the Ctrl key on your keyboard and clicking on the appropriate Row names
n. Click Insert Selected Fields as... button
o. Click Multiple Item View
p. Save the page (click the X to close the page and click Yes and click Yes)
No comments:
Post a Comment