This article addresses following topics:
- Basic idea about SharePoint list view web part and converting it to XSLT data form web part
- Displaying files recursively inside folders of any document library or form library
- Create reports using share point designer.
Background:
Imagine you have form library and you want to create report page using xslt data form webpart using sharepoint designer. You may face this situation where only folders of document library will show up. How to show file inside those folders of form library or document library?
Let’s see it in action with quick steps.
Note: this article can be pre-requisites for next article of creating column using Today’s date. That’s the issue lot of people facing right now.
Steps:
1. Open SharePoint designer and navigate to page you want to edit and add XSLT data form web part for report.
2. You will see something like image below. If web part zone is not already added then you can add one from “web part” pane on right side
3. Click on “click to insert web part” and web part pane will open on right side of designer window.
4. Using next and previous buttons find your form library in list and drag drop on web part zone of the page.
5. That’s list view web part on page now.
6. Right click on the list view web part and click “convert to XSLT data view”
7. Now, you can see label on top of web part that says “webpartpages:Dataformwebpart”
8. Right click on web part and click data source details (image above). On right pane, data source details of your form library will populate (image below).
Click on the link of your form library below current data source label.
9. Change item and scope option in dropdown to recursive all. You can select columns, filter and sorting options from here.
10. Selecting recursive all will display folders and files of that library. Click on “Filter...” and add one filter as shown below.
Finally, Add conditional formatting, filtering and you are all set. View page in browser and you can see only files are being shown.
Thanks.