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
275 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
[X]
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
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
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…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

696 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