Home » Sharepoint

Create dashboard using sharepoint list.

Hi everyone,
I'm testing sharepoint 2010 and like all the new features but mostly interested in BI Dashboard.
We are using web based infopath form that the users fills out and save in sharepoint. In MOSS 2007 we are using third party charts that represents the data logged in the list that contains infopath forms.
I've tested sharepoint2010 chart web parts with the list and it works fine but because infopath forms collects so much data we want to use drill down charts. I've started using PerformancePoint Dashboard designer but as you know it only allows to create chart for Analysis services.
so my questions are:
1. Is there a way to create drill down charts using list as a data source?
2. Is there a way to export data from list to analysis services? (This needs to be automatic task)
3. Are there any third party tools that I could use to create drill down charts in sharepoint2010?

Thank you


1 Answer Found


Answer 1

1. Is there a way to create drill down charts using list  as a data source?

you can look at the chart web part in sharepoint  2010. you can also look at building a master-detail style web part.  check out Using Web Part Connections to build a Master/Detail View.




Please, I need to create surveies in one list with more options not like the one bulit in sharepoint 2007.  Please i need the best practice.




I need to create a sharepoint designer workflow on Calender List.The functionality is that, Workflow on Calendar list that sends an e-mail notification each time new event is created along with event details.

Any help appriciated..



Srikanth Reddy




I have built a list template. But how create with the SharePoint 2010 list service a list from this template?


To create a normal documentbibliothek I use the following code:

  Int32 spDocLibraryListType = 101;


  //Call the SharePoint Web Service to create a document library

  Lists listService = newLists();



  listService.Url = "http://Server/_vti_bin/lists.asmx";


  listService.Credentials = System.Net.CredentialCache.DefaultCredentials;


  System.Xml.XmlNode SPresult = listService.AddList(this.sender2,this.sender3,



  //grab the return xml

  string returnXml = SPresult.InnerXml.ToString();



But what can I change to crate not a normal documentbibliothek?


Thank you for helping me.



I am trying to create a dashboard and I am following the steps shown in a MS video.  The first step is to create a data source (Analysis Services).  After entering the server name, I need to select the Database from a drop down list, I click on the drop arrow, it indicates loading, but the list is empty.

Is there a special setup required for having this working?  Note that MSProject visual reports and the Business Intelligence center reports are working fine.  So my security setup seems OK.



I'm new to Dashboard Designer and want to use it to analyze data stored in SharePoint lists. I'm having trouble even getting started, however, and was wondering if you folks could forward on some links to good introductory tutorials creating dashboards and what not based on SharePoint list data.


I want to know if we can generate dashboards in SharePoint Designer directly, with the Cube data instead of Excel Services.

if yes, how can we connect SharePoint Designer to Cube?



I have created a report in SSRS and this report is integrated within a dashboard created using performance point services in sharepoint 2010.

The report is a simple tabular report with 5 coulmns and interactive sorting is enabled on each of them.

Sorting works when the report is viewed separately but gives "Report Server Error" when I try to sort (on any column) inside the dashboard.

I have user IP instead of host name in the report server url.

Please help.



In Sharepoint Server 2010 Cannot create new List using saved List template. I have saved multiple list templates in the template gallery, but when I click on site actions -> More options. I do not see the list templates that are in the template gallery.


I want to add a task of a outlook whenever a task is assinged to user,depending upon that user email Id (assignee) a task has to be created in that assigned user's calender in outlook and in sharepoint task list

it is urgent.

pls post your idea if you have done this.

Thanks in Advance.


I'm trying to follow Mark Rackley excellent description of how to set up a Parent/Child Relationship in SP2010 but for some reason I cannot set a column "issueID" to 1 in his instructions using ../lists/Time/NewForm.aspx?IssueID=1 works ok for the Title i.e. ../lists/Time/NewForm.aspx?Title=1 but will not work for any new column created by the user (text box) . This is critical to the solution provided my Mark - Any ideas ???

Marks site is







In the Dashboard Designer I have created a Dashboard. I right click on the Dashboard in the workspace browser, then select Deploy to SharePoint, I select the Library called “Dashboards”, and then click deploy. However, every time I get the same error “Cannot deploy dashboard – (null) MySite/Dashboards/MyDashboard”. I have tried creating documents and subfolders under the “Dashboards” section in the left pane of our SharePoint site, but each and every time I get the same error, and for the life of me I can’t seem to fix it. Can someone tell me what I am doing wrong?


Hi All,

I have a requirement to create a  Custon List template.one way is VS already has a list definition project template..and all necessary files gets created automatically like schema, template.xm, allitems.aspx, dispform.aspx, editform.aspx and newform.aspx, and we can also directly deploy to the site by giving the site url.

Now my question is can this be deployed as a solution package(wsp)?

Any pointers on creating a solution package for List templates (created using VS) will really be helpful.



I work for a school district.  Each school has a SharePoint calendar.  We set up each school as its own site collection.  I would like to create a workflow that would send their calendar events to a district calendar, which is also its own site collection.

Example,  School A enters creates a new item on their personal school calendar.  They click YES in the column called SendToDistrictCalendar.  The workflow would be triggered to create this same item in the district calendar (which is in a different site collection) when SendToDistrictCalendar is checked YES.

We're using Windows Server 2003 with Windows SharePoint Services 3.0

I am a mid-level SharePoint user.  I would appreciate ANY and ALL help to make this work!!


Query [User Information List] in SharePoint 2007

I am looking for a way to query the [User Information List] via SharePoint Web Service but amd running into issues. Apparently this list is hidden but for some reason when I use Access 2007 and linked tables it shows up and allows me to query and pull the records down. When doing it the Access 2007 way I can just use a datareader and get the list. Of course this doesn't work well in a web application because in order to get live list data credentials have to be passed through Access 2007 onto SharePoint and there isn't a way I know that works in doing that. You can query the database while it is in OFFLINE MODE but we want live updated data. So I started pulling things via SharePoint web services. It works well but I am having issues with the [User Information List].

User list is supposed to be accessible at this location:

If I browse to that location on the SharePoint Portal I will get the error:
Go back to site
Error: Access Denied

? Access is denied here but in Access 2007 linked I can view it fine with the same credentials???

Loading the same URL in the following programs results in:

This gets a 401 Un-Authorized.

CAML Builder:
This connects up fine with the user and pass specified but shows no list.

Not sure how the security is working here. I also have a Access 2007 database that links to the [User Information List] with the user and pass specified and I can view all the fields. So if the username and password lets me have full access that way then what is the issue with the other options above?

I can pull up other lists easily and output them to an HTML display with SharePoint web services but this one I cannot as it seems to be invisible. Here is an example of some code that works:

[CODE] ------------------------------------------------

ResumeDatabaseLists.Lists myservice = new ResumeDatabaseLists.Lists();

myservice.Credentials = new NetworkCredential("user", "pass", "domain");

myservice.Url = "http://thewebsite/HR/_vti_bin/lists.asmx";

string listName = "{1111111111-2066-49F8-B783-6ADCC7EC27D3}";
string viewName = "{1111111111-1F85-42BB-AF0A-224DBAC5D40A}";
string rowLimit = "100";

// Instantiate an XmlDocument object
System.Xml.XmlDocument xmlDoc = new System.Xml.XmlDocument();
System.Xml.XmlElement query = xmlDoc.CreateElement("Query");
System.Xml.XmlElement viewFields = xmlDoc.CreateElement("ViewFields");
System.Xml.XmlElement queryOptions = xmlDoc.CreateElement("QueryOptions");

 strCAMLquery = strCAMLquery + "<Query>";
strCAMLquery += "<Where>";

// maybe if it is null there is a way to substitute a value for it.
strCAMLquery += "<And>";
strCAMLquery += "<IsNotNull>";
strCAMLquery += "<FieldRef Name='Person' />";
strCAMLquery += "</IsNotNull>";
strCAMLquery += "<IsNotNull>";
strCAMLquery += "<FieldRef Name='ows_Title' />";
strCAMLquery += "</IsNotNull>";
strCAMLquery += "</And>";

strCAMLquery += "</Where>";
strCAMLquery += "<OrderBy>";
strCAMLquery += "<FieldRef Name='Person' Ascending='False' />";
strCAMLquery += "</OrderBy>";
strCAMLquery += "</Query>";

LiteralCAMLquery.Text = ("CAMLquery = :" + strCAMLquery + "<br>");

strCAMLviewFields = "";

/*Use CAML query*/
query.InnerXml = strCAMLquery;

viewFields.InnerXml = "<FieldRef Name='Person' /><FieldRef Name='ows_Title' /><FieldRef Name='Biographical_x0020_Sketch' /><FieldRef Name='Modified' /><OrderBy><FieldRef Name='Person' Ascending='False' /></OrderBy>";
queryOptions.InnerXml = "";

System.Xml.XmlNode nodes = myservice.GetListItems(listName, viewName, query, viewFields, rowLimit, null, null);

foreach (System.Xml.XmlNode node in nodes)
if (node.Name == "rs:data")
for (int i = 0; i < node.ChildNodes.Count; i++)

if (node.ChildNodes[i].Name == "z:row")

if (node.ChildNodes[i].Attributes["ows_ID"] == null)
str_ows_ID = "ID Missing";
str_ows_ID = node.ChildNodes[i].Attributes["ows_ID"].Value;

if (node.ChildNodes[i].Attributes["ows_Person"] == null)
str_ows_Person = "Person Missing";
str_ows_Person = node.ChildNodes[i].Attributes["ows_Person"].Value;
strClean = str_ows_Person.Substring(str_ows_Person.IndexOf("#") + 1);
str_ows_Person = strClean;

if (node.ChildNodes[i].Attributes["ows_Title"] == null)
str_ows_Position_x0020_Category = "Title Missing";
str_ows_Position_x0020_Category = node.ChildNodes[i].Attributes["ows_Title"].Value;
strClean = str_ows_Position_x0020_Category.Substring(str_ows_Position_x0020_Category.IndexOf("#") + 1);
str_ows_Position_x0020_Category = strClean;

if (node.ChildNodes[i].Attributes["ows_Modified"] == null)
str_ows_Modified = "Modified Missing";
str_ows_Modified = node.ChildNodes[i].Attributes["ows_Modified"].Value;
strClean = str_ows_Modified;
str_ows_Modified = strClean;

if (node.ChildNodes[i].Attributes["ows_Biographical_x0020_Sketch"] == null)
str_ows_Biographical_x0020_Sketch = "Bio Missing";
str_ows_Biographical_x0020_Sketch = node.ChildNodes[i].Attributes["ows_Biographical_x0020_Sketch"].Value;
//strClean = str_ows_Modified;
//str_ows_Modified = strClean;

strSharepointListsXML += "<div align='center'>" + strNL;
strSharepointListsXML += "<table border='1' width='770' cellspacing='5' cellpadding='5'>" + strNL;
strSharepointListsXML += "<tr>" + strNL;
strSharepointListsXML += "<td align='center' width='20'><b><font color='#000080'>" + str_ows_ID + "</font></b></td>" + strNL;
strSharepointListsXML += "<td align='center' width='225'><b><font color='#000080'>" + str_ows_Person + "</font></b></td>" + strNL;
strSharepointListsXML += "<td align='center' width='269'><b><font color='#000080'>" + str_ows_Position_x0020_Category + "</font></b></td>" + strNL;
strSharepointListsXML += "<td align='center' width='181'><font color='#000080'>" + str_ows_Modified + "</b></font></td>" + strNL;
strSharepointListsXML += "</tr>" + strNL;
strSharepointListsXML += "<tr>" + strNL;
strSharepointListsXML += "<td align='left' colspan='4'>" + strNL;
strSharepointListsXML += "<b><font color='#000080'>BIOLOGICAL SKETCH:</font></b><br>" + strNL;
strSharepointListsXML += str_ows_Biographical_x0020_Sketch + strNL; ;
strSharepointListsXML += "</td>" + strNL;
strSharepointListsXML += "</tr>" + strNL;
strSharepointListsXML += "</table>" + strNL;

strSharepointListsXML += "<br>" + strNL;
strSharepointListsXML += "<br>" + strNL;

strSharepointListsXML += "</div>" + strNL;



LiteralSharepointListsTest.Text = LiteralSharepointListsTest.Text + "<b>User Information List: ID, PERSON, POSITION TITLE, MODIFIED, BIO</b><br><br>";
LiteralSharepointListsTest.Text = LiteralSharepointListsTest.Text + strSharepointListsXML;

------------------------------------------------ [/CODE]

How to Query the [User information List] in the same way?

Thanks in advance.
I'm currently using MOSS 2007 with Outlook 2007.  I created a ContactList within Sharepoint and copied my contacts into the list, I then linked the list to my Outlook, but when I do this Sharepoint creates 3, 4 or even 5 duplicates of every entry and while synchronizing it slows down my Outlook heavily.  Any ideas to what might be causing the duplicatecontacts in the list and how to prevent this from happening again?

Hi, I am trying to use excel services to make a chart with values of sharepoint list.

I am using udf to get the values of athe sharepoint list, and i tried to use this values (UDF) as series in the chart but i have no sucess....

If i do the normal process the chart is showing no values...

Is there some trick or someting I need to do, in order to use values returned by udf in chart of Excel services?

 I can't create and associate the custom forms with the external list in SharePoint Designer. Giving error "Could not save the list changes to the Server"..Any idea?

Hi All,

I am facing problem in Sharepoint LIsts and document library, i had changed subsite master page by going to site settings --->look and feel --> master page---> system master page

After applying new master page ..i get error "Unexpected Error Occured" whenever i try to create new item(like new folder )

This new master page is working fine on other subsites...

Pls advise what could be the problem..






I've got an External List and I want to create a Site Column, which is Lookup to a column in my external list. If I tick any of the columns in 'Add a column to show each of these additional fields' and click OK i get the following error message:

[NullReferenceException: Object reference not set to an instance of an object.]
  Microsoft.SharePoint.SPBusinessDataField.IsInDefaultView() +58
  Microsoft.SharePoint.SPBusinessDataField.CreateSpFieldForBdcType(String bdcName, Boolean hidden, Boolean readOnly, Boolean idField, SPAddFieldOptions op) +809
  Microsoft.SharePoint.SPBusinessDataField.AddNeededSecondaryFields(String wssNames, String[] oldNames, String[] newNames, SPAddFieldOptions op) +315
  Microsoft.SharePoint.SPBusinessDataField.OnAdded(SPAddFieldOptions op) +240
  Microsoft.SharePoint.SPFieldCollection.AddFieldAsXmlInternal(String schemaXml, Boolean addToDefaultView, SPAddFieldOptions op, Boolean isMigration, Boolean fResetCTCol) +759
  Microsoft.SharePoint.SPFieldCollection.Add(SPField field) +61
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.Save() +513
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.BtnOk_Click(Object sender, EventArgs e) +46
  System.Web.UI.WebControls.Button.OnClick(EventArgs e) +114
  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +139
  System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +28
  System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2980

Is this a bug or (more likely) am I doing something wrong / missing the point?

Also, does anyone know if there will be support for mutlivalue lookups to external lists?

I have several users that have an intermittent problem where tasks created via Outlook in a Sharepoint Task List disappear from the list of tasks as soon as they are created.  It doesn't happen to every task.  They can be assigned to the same user but still one will not show up on the list when it is saved and the next one will show up.  It has happened to three users so far.  Unfortunately two of them are the CEO and COO.

We are using MOSS2007 and Outlook 2007.  I have searched the web for several hours with no hits related to this specific issue.  I know it is a very vague description but it's all I have to go with.  The users are outside the office using RPC over HTTP for their Outlook connection into the network.  The Sharepoint site is also available internally and externally.  Any thoughts or recommendations would be appreciated.

<< Previous      Next >>

Microsoft   |   Windows   |   Visual Studio   |   Sharepoint   |   Azure