.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to genrate custom reports based on the sharepoint 2010 list coloumns ?

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :SharePoint

Hello Friends,

       I am MD.Liakath ali i want create report based on the shaepoint lists.

1. My Report Server Configuration for SharePoint Integrated mode is done.

Please  any body suggest me how to create reports


Liakath ali

View Complete Post

More Related Resource Links

Quick Note: Create Custom List Definitions in SharePoint 2010

In this exercise, you create a custom list definition in Microsoft SharePoint 2010 and then create an event receiver that is triggered when the list is used.

Sharepoint 2010 Standard Edition Custom List Reporting Using Report Builder 3.0


hi, i'm making this report from a sharepoint list. i want to add some of the fields as the parameters for the report. (e.g : Category, Department)

i tried to run the report, the parameters were shown as expected

but the problem is when i create a query in the dataset.

i'm using caml query builder for the query expression. it goes like this :

<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ListName>IT Helpdesk</ListName>
    <FieldRef Name="Employee_x0020_Number" />
    <FieldRef Name="Title" />
    <FieldRef Name="Department" />
    <FieldRef Name="Category" />
    <FieldRef Name="Time_x0020_Spent" />
    <FieldRef Name="INT_x0020_Time_x0020_Spent" />
    <FieldRef Name="Severity_x0020_Level" />
    <FieldRef Name="Ticket_x0020_Source" />

Create Lookup Site Column based on External List (SharePoint 2010)


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

SharePoint 2010 Approval workflow based on list criteria


Hello All

I have been requested to create an Approval workflow for a list with 3 columns - Title, Category and Price. The Category field has 3 options - Minor, Moderate and Major.

If the Category is Minor the approval is sent to the Project Manager, and after approval it is sent to the Manager for approval.

How can I accomplish this using SharePoint Designer 2010? Can I modify the OOTB approval workflow, if yes how?

What other options do I have? This is really urgent.

Thank you for any responses.




SharePoint 2010 Custom List default overriding selection


We are finding that the second list using a field name from the first list that is defaulted does not take the field entry but uses the default when the record is created.  The First list field does take the change and populate the record.  We need the second list to accept the field change in creating a new record.

sharepoint 2010 user information list custom property



i added a custom property to the user list and wish to display it. when i go to "user info list" > "list settings" > "edit view" i see 39 properties to choose from. how can i remove these default values and add my own properties to the view.




Custom Discussion Board List Definition in SharePoint 2010


Hi All,

I have created a custom discussion list definition using Visual Studio 2010 in SharePoint 2010. I had an issue, since by default, Visual Studio creates the custom discussion list definition as custom list. So, I have modified the my own Schema.xml with the standard SharePoint discussion Schema.xml by adding views section.

After deploying successfully, when i looked at the Threaded view, it gives a javascript error. I cannot open "Show Quoted Messages" link.

Could anybody face this problem? Please suggest on how to resolve this issue.


Chandrasekaran C N

Default Value for 'Person or Group' column in a Sharepoint 2010 Custom List



In Sharepoint 2010 I have a Custom List with a column of the type 'Person or Group'.
I would like to have a default name for this 'Person or group' column.
So when a user creates a new list entry and leves the 'Person or Group' column value blank the list entry should be created with the default value für the 'Person or Group' column.

Is there a way to schieve this?

Many thanks in advance.

Roberto Rocco.



How to enable "Custom Report" automatically for Web Analytics Reports on SharePoint 2010?

<!-- /* Font Definitions */ @font-face {font-family:??; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-alt:SimSun; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-alt:"Calisto MT"; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-536870145 1107305727 0 0 415 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-alt:"Arial Rounded MT Bold"; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520092929 1073786111 9 0 415 0;} @font-face {font-family:"\@??"; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-alt:???????????????????????????????; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:??; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:C

How to add custom list entries to mysite's calendar in Sharepoint 2007 site?


I would like to know below things

(1) How to create MySite for one specific member with other or administrator's access?

(2) Scenario : Administrator have created one SP2007 site. now Administrator have created one calendar (Sample calendar). Administrator have added some entries in calendar. now one user entered in portal site ansd view the calendar and he click on MySite menu. so this sample calendar entries should enter in that user's mysite calendar. How this can be achieved?

Thanks in advance.
Regards, Praful Udade

Unable to search Custom User Property Created in User Profiles in SharePoint 2010


Hi ,

I have created a custom user property,and created metadata property and added mapping to it, still i m not able to Search in People,Please advise

SharePoint Designer: insert custom list not working anymore



Suddenly sharepoint designer decided today that it doesn't want to insert a custom list form anymore...
To be more specific, it doesn't work anymore in a site that uses the Microsoft budgeting and tracking template. In a website that uses an out of the box template, it still works.

It did work before, because I did it in other websites using the same template (it's broken there as well now).

Why oh why does SharePoint refuse to do this now?
I searched google and here on the forums, but all I could find was some issues after installing SP1, but we did that already long time ago and it was still working after that. I checked with our infrastructure guys and they didn't install new updates they say.

I also tried the solutions listed here: http://blogs.msdn.com/spdsupport/archive/2008/07/03/how-to-fix-custom-list-forms-will-not-insert-or-show-up-on-the-design-surface-of-sharepoint-designer.aspx
But they don't fix the problem.

So my problem is, I can go to Insert > SharePoint Controls > Custom List Form
I pick my list, content type and form type, I hit OK and... nothing happens.

how to hide/display controls in NewForm.aspx based on dropdown value in SharePoint list



I have 1 dropdown in my sharepoint list with other columns. If dropdown value equal to 'xyz' i need to display some other controls, otherwise these controls should be hidden.

I know we can achieve this with javascript. If any one can provide code or sample then it will be appreciated. or is there any other alternative methods to do this ........

Thanks & Regards, Neerubee

Creating Custom SharePoint 2010 Field Types and Controls with Visual Studio 2010 and Silverlight 3

Learn how developers can create rich experiences in SharePoint Server 2010 publishing sites using Microsoft Silverlight 3.

Video: Creating Custom SharePoint 2010 Field Types and Controls with Visual Studio 2010 and Silverli

Watch the video that accompanies the MSDN article and learn how developers can create rich experiences in SharePoint Server 2010 publishing sites using Microsoft Silverlight 3.

Quick Note: Create Custom Content Types in SharePoint 2010

Learn how to create a custom content type. Then you add two fields to the content type: a new text field and a field that already exists in web site.

Quick Note: Create Lists with Custom Content Types in SharePoint 2010

Learn how to create a list in SharePoint Server 2010 and associate it with a new content type. Next, you disassociate the list from the content type and then delete the list.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend