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

SP 2007: Is it possible to click on a customer name on a splash page and have various report templates populate with only their data?

Posted on 2011-09-06
2
274 Views
Last Modified: 2013-11-05
Hi! Please let me preface this with the fact that I am extremely new to SharePoint, so any answers will need to be in very basic terms.

My company has 80 customers. We have lists with their scores in for each month. For example, List A has scores for Cust 1, 2, & 3 for the last year. Lists B-L have the same.

I have a splash page with each Customer listed. I know I can set up a page for each customer with personalized views that will only show them their own data. What I would like to have is a template for a Scorecard that combines data from each of my score lists just for that customer.

For example: If customer 1 goes to their page and clicks on a quick launch for the Scorecard (which I currently have set up in a table with web parts pulling their scores in) it will open the Scorecard with all of their scores on it, which they could then filter to whatever month's scorecard they need to see. I absolutely cannot have them able to see any other customer's information. I would prefer not to have to set up a Scorecard for each of these 80 customers.

My question is: Is this sort ofthing even possible with Sharepoint? And, if so, what sort of processes in SharePoint do I need to educate myself on to accomplish this.
0
Comment
Question by:McQMom
2 Comments
 
LVL 11

Accepted Solution

by:
svetaye earned 500 total points
ID: 36491493
Hello,
Yes, it's possible.
You can use a Data View Web Part to show the Customer list and edit the Customer URL to add a URL parameter to the URL.
The customers page need to redirect a user on click to a customer name to URL like this:
http://hostname/site/customerData.aspx?Customer=CustomerName

On the target page you will need to place a couple of Data View Web Parts show data related to current customer. You can filter data in a Data View by using query parameter(URL Parameter: Customer=Customername).
Please take a look at these articles:
http://support.microsoft.com/kb/831093

http://www.sharepoint911.com/blogs/laura/Lists/Posts/Post.aspx?List=676af157-7d96-4e15-a987-54b8a3e4d948&ID=81

0
 

Author Closing Comment

by:McQMom
ID: 36492073
AWesome! Thanks so much...I'll start reading up on ll of those....
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Some time ago I faced the need to use a uniform folder structure that spanned across numerous sites of an enterprise to be used as a common repository for the Software packages of the Configuration Manager 2007 infrastructure. Because the procedu…
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…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…

839 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