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


Post New Web Links

how to add report parameters to filter list data in a ssrs report for a SharePoint List

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#
 

Hi,

i am using SQl Server 2005 reporting services to generate reports from MOSS 2007 Lists.

I need to define a parameter in the report to filter the data repective to that parameter dynamically.

like: in moss list there are three fileds A, B and C and i want to define field A as the report parameter, whenever i select the value of field A then on "View report" value of field B and C pertaining to field A should be display in report.

I am able to add report parameters but not able to attach to the report so that filtering can work.

Please guide me with solution




View Complete Post


More Related Resource Links

Sharepoint list as Report Data Source

  
My current environment is Sharepoint 2007 with SSRS 2008 in Sharepoint Integrated Mode. SSRS 2008 uses trusted authentication to communicate to Sharepoint 2007. Sharepoint 2007 is configured to use NTLM authentication (configured with a domain account). My settings within Central Admin are Authentication Type: Windows IIS authentication settings: Integrated windows authentication with NTLM. My question is: Do I need to configure Sharepoint to use kerberos to use Sharepoint Lists as a Report Data Source?  

How to prepare a report using Sharepoint List data in Reporting Services

  

Hi,

I have to prepare a report using the data in sharepoint list i.e., data which would be exported to excel when we click in action tab of sharepoint list. I found most the websites answering how to prepare a report using sharepoint list as datasource. But I want to use the data "IN" sharepoint list as my datasource. I really appreciate your quick response..!!

Thanks,

Sandy

 

 

 


Filter items with a date column with parameters start date and end date on a sharepoint list?

  
If I have alist with a view that has the columns Title, Status and Status Date and the view has some items. How Can I add a filter with two parameters, start date and end date, to only show records with status date equal to or greater than parameter start date and status date is less than or equal to parameter end date? This is a sharepoint online site and I can't create and deploy custom code, can use SPD though. Do I need to use SPD or is this something I can do in the list settings? Thanks in advance.   Edit: I had a look here http://www.endusersharepoint.com/2009/09/29/sharepoint-date-filter-filtering-a-list-by-greater-than-or-equal-to-date/ but I don't have the Date Filter web part.

SharePoint 2010 Reporting Services report on sharepoint list rsExecutionNotFound

  
I cannot get SQL Reporting Services 2008 R2 to work with a datasource that is a sharepoint list.  Reporting services seems to work fine setup in SharePoint 2010 Integrated mode. When I try and run a report that is based on a sharepoint list, I immediatly get the following error: The report execution tp15sp4515l3seqqo4do3e45 has expired or cannot be found. (rsExecutionNotFound) This seems to be something I am doing wrong with the sharepoint configuration, I would guess.  I haven't tried a regular database query, but they used to work when reporting services was configured for native mode.  So I assume this is just a problem connecting to sharepoint 2010 lists, with the new SharePoint 2010 List connection type. Edit This has got to have something to do with a permission setting for the app pool account of sharepoint.  I read something once where it said you had to grant it permissions, but every guide I've found since then doesn't mention anything about it. This log entry is where the problem seems to be occuring, I just don't know what permissions to give TESTDOMAIN\spweb which is the app pool account. library!ReportServer_0-3!1bdc!09/01/2010-09:58:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, tim

Problem in parameter list while executing the report in sharepoint

  

Hi,

I have created one SSRS 2005 report with 3 dependent parameters ,they are BusinessUnit,Account,Project.In SSRS solution file when i click a specific BU name ,then at the same time Account parametr refreshes and shows the corresponding account names and the same for project.

I deployed the report in to sharepoint 2007,that time the account parameter filed is not refreshing paralleling when i click a BU and it shown as inactive.Only when i click the apply parameter acoount fild shows the corresponding account names.Please help me to avoid the issue.Thanks in advance.

 neesa


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>
  <ViewFields>
    <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" />

List of Month and Year in SSRS report parameter?

  
Hi, I have two parameters in my SSRS Report i.e. Month and Year. I want to show the list of all Months in dropdown and years for a particular range say 1995-Current Year.
Can any one suggest me the query for how to get it to work.
Thanks!! MCP

report from sharepoint list

  

hi

i want to create report for sharepoint 2010 list. I create "New Report" in Sql Server Business Intelligence Development Studio & deploy it to sharepoint site. In sharepoint site ,in web part i can see it. but i want to filter this report by "start date" & "end date" that user enter it.

Note:we can connect to sharepoint list directly in sql server 2008 R2,

how i can define "start date" & "end date" in Sql Server Business Intelligence Development Studio & how i can  filter report depend on value that users enter it in  "start date" & "end date" ?!

 I would really appreciate if anyone can help me out with this.

Thanks.


report from sharepoint list

  

 

hi

i want to create report for sharepoint 2010 list. I create "New Report" in Sql Server Business Intelligence Development Studio & deploy it to sharepoint site. In sharepoint site ,in web part i can see it. but i want to filter this report by "start date" & "end date" that user enter it.

Note:we can connect to sharepoint list directly in sql server 2008 R2,

how i can define "start date" & "end date" in Sql Server Business Intelligence Development Studio & how i can  filter report depend on value that users enter it in  "start date" & "end date" ?!

 I would really appreciate if anyone can help me out with this.

Thanks.


report from multiple list in sharepoint 2010

  

hi

I want to create report from multiple list in sharepoint 2010. In general Sql Server Business Intelligence,allow create report from 1 list.

how i can create report from multiple list with Sql Server Business Intelligence?

thanx.


Getting SSRS Report DataSet Field list from C#

  

Hi All,

Scenario:

1. We have requirement where users can build there own SSRS Reports and integrate it with the existing system dynamically.

2. We have an Existing Application (Called APP1), our approach is user will build the report as per there requirement and from APP1 we have report configuration screen when user will select the report file to import to our system.

3. While doing importing, we have special requirement like

3.1 Retrieve the all fields from the Report DataSource and display to the user

3.2 User configures that what values they want to filter when the report is shown from the application. ex: employee information is      displayed in the report, DataSet query is "select empid,empname,..... * from employee" 

        3.3 from APP1 when user gives the report we have to dynamically load the report and get the fields from the dataset, so user can                configure like this, when the report is shown report must ask for parameter value for empid .

     &n

Help pulling data from Sharepoint List in SSRS

  
Hi there, hoping somebody can help me out here.

I'm using SSRS and trying to connect to a sharepoint list.

I followed the steps here:
http://www.codeproject.com/KB/reporting-services/ReportFromSharePoint.aspx

But I'm still getting an error. I'll give as much info as I can.

For the shared datasource, I'm using a link that when I plug it into a browser it brings back "Lists Web Service," so I think that part is fine.

When I try to enter the "SOAP CALL" into the Query string of my data set I get an error.
Soap Call:
<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
<Parameters>
<Parameter Name="listName">
<DefaultValue>{338D5EA1-CAA3-42D9-8D71-369A5B874219}</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="True">*</ElementPath>
</Query>


Error Message:

===================================

Could not generate a list of fields for the query.

SQL Report Service List data into columns

  

HI,

I showing my data in Report builder in LIST control. e.g I have 3 fields to show data in field (Name, Country, Age). currently its show data in one column I want to break data into newsletter column style.Is their any option in list two show data columns wise also

Currently:                                             but I want show data in Newsletter-style columns Like

-----------page---------------                     ------------------------------------page------------------------------

name,country,age                                     name,country,age                        name,country,age

-----------page---------------                 &n

Urgent!!!How can we sort the parameter list in report created using report model in ssrs 2008 r2?

  

How can we sort the parameter list in report created using report model in ssrs 2008 r2? Do I need to change some property in Model or elsewhere?

 


Connectiong String For SharePoint List Using with Report Builder 3.0 ?

  

Hai Friends,

     I am Ali, I need to retrive the all lists in to Report Builder and need to prepare Report and need to deploy in Sharepoint Library.

1. I Configured Reporting Services in Sharepoint Integrated mode and Credentials are in Windows Integrated Mode not in Trusted acount. 

2. In Report Builder 3.0 Connection Type "Microsoft Sharepoint List"

3. Connection String 'http://<server name>/sites/<site name>' like this, when i test the connectinons getting this error (The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified.)

Please anybody help me to proceed next steps.

Thanks,

Ali.  


MD.Liakath ali

Image not displaying in SSRS Report from moss 2007 list

  

Hi, I am generating SSRS report for one of sharepoint list, In this list one filed is picture type for KPI Indicators. After generating report i added picture field by using the below procedure:

http://msdn.microsoft.com/en-us/library/ms156342.aspx

http://msdn.microsoft.com/en-us/library/ms189720.aspx

Then it is displaying an image holder with RED CROSS image in it.

I tried a lot of things but not able to rectify this as Images for my report is mendatory.

Thanks


Can't see any data after publish SSRS report to Sharepoint 2007

  

Hi,

I'm using SSRS 2008 R2 , MOSS 2007 and report Builder 3.0 To generate cascading reports with sharepoint 2007 lists.

I'm able to filter and see the data correctly within report builder .

But if i upload the same RDL file to Sharepoint library and then tries to view the report,i'm not getting any data.(absolutely zero records) 

I'm using Report builder 3.0 and sharepoint list as connection string.

Interestingly, if i'm ising XML as a connection string to pull sharepoint list data and then publish the report to sharepoint, i'm able to see the data within sharepoint correctly and i'm able to use the cascading filter and can view the correct data.

Please advice on why i'm not able to see the data if i'm using the connection string" sharepoint list "

This issue is same even if i'm using BIDS 2008 and sharepoint list as connection string.

i would like to use sharepoint list as connection string because of the ease of using it.

Thanks in advance!!

 


Best Regards, Ashok Yadala | Senior SharePoint Consultant
Categories: 
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