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
273 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

Suggested Solutions

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
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…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

806 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