Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Is it possible to create a web part page with a dynamic data view source in SharePoint Designer 2007?

Posted on 2013-01-08
8
402 Views
Last Modified: 2013-01-25
Hello.  I have a few lists that contain the same columns because they are associated with the same content type.  I have created a few lists instead of one due to permissions requirements.  I have created a custom Web Part Page with a data view on it as per project requirements.  I have noticed that the GUID for the underlying data source appears as the default value for the ListId property a few times in the page's code view.  Is there a way to pass the data source's GUID in as a parameter?  If it's possible, I'd like to have one Web Part Page where I pass the GUID in as a parameter and the Data View dynamically binds to the proper List instead of having to create a Web Part Page for each list.

Thanks.
0
Comment
Question by:BLEIP
  • 5
  • 3
8 Comments
 
LVL 15

Accepted Solution

by:
sharepointguru14 earned 500 total points
ID: 38757705
couldn't you put a list view of each list on the same page and then just audience target the webparts to the appropriate groups?
0
 

Author Comment

by:BLEIP
ID: 38759435
sharepointguru14:

Thanks for the reply.   The page displays two data form web parts linked to each other.  I have 8 functional work units so I have a parent and child list for each of the 8 units.  If I use audience targeting, I would have to place 16 data view web parts on the same page.  I'm not sure how that would affect performance.  It would still require a bit of redundancy, although it would save some time.  If I cannot figure out a way to dynamically pass the GUIDs of the 2 lists, I will use your approach.

Thank you
0
 

Author Comment

by:BLEIP
ID: 38760789
sharepointguru14:

I just realized that the audience approach won't work for me because there are a few managers in a "Final Approvers" group that will need access to the data for all 8 units so the "Final Approvers" group would be an audience for all 16 web parts which would all display instead of just 2 when someone from that group viewed the page.  Any way that you know of to pass querystring parameters to the page to display only the appropriate data form web parts?

Thanks
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 15

Expert Comment

by:sharepointguru14
ID: 38761464
In the case of your final approvers group wouldn't you have the same problem even if you were passing the parameter?
0
 

Author Comment

by:BLEIP
ID: 38774564
No because the parameters I would be passing would be the GUIDs for the 2 appropriate lists.  Basically, what I have is 8 custom lists (1 for each functional work unit).  Each custom list uses a secondary list (as a 1 to many child list) for storing details.  On the EditItem.aspx page for each custom list, I have a button that will redirect to the page containing the Data Form Web parts.  In the redirect URL on each EditItem.aspx page, I'd like to pass the appropriate parameters so the page knows what lists to retrieve data from.
0
 
LVL 15

Expert Comment

by:sharepointguru14
ID: 38776613
I haven't ever tried passing the listIDs as URL parameters. Only items within that list that the dataview was connected to. I'll have to do some digging. I'm fairly sure it can't be done with the OOTB dataviews but possibly could be done with some custom code. Would that be an option?
0
 

Author Comment

by:BLEIP
ID: 38778568
We currently do not have Visual Studio set up with SharePoint 2007 but it is on its way. I think you're right.  Now that I think about it, any parameter passed in would have to be read and code would have to be executed before the page was rendered.  I don't believe you can add any code with SharePoint Designer 2007.  I have been developing in .NET for the last 10+ years but haven't tried any .NET SharePoint development.  What I'd ultimately like to do is create a re-usable workflow with a custom collect-data-from-user screen that I could apply to several different lists (with the same columns) and have one dynamic page for displaying the parent and child list items for each list set.  If you wouldn't mind leading me in the right direction or posting a few helpful links on how to do that with Visual Studio.NET , I'd appreciate it.  

Thank you
0
 

Author Closing Comment

by:BLEIP
ID: 38818951
In most cases, audience targeting would probably suffice.  However, in my case, some users will be in a group that needs to have access to all web parts, but not at the same time.  Input parameters would be the only way to resolve this issue and may require Visual Studio and custom code.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question