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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

rdlc report list inside another list

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :ASP.Net
 
HiI created a list that will show several lines of data in a report, but each of those lines have between 1 to 5 records of another table in the DB. So, what i would like to know if it is possible to add a list inside another list. And if it is, how can the child list get the correspondent id from the mother list.Small example of what i want to do:Can anyone help me?


View Complete Post


More Related Resource Links

Crystal report with dataset and list - please help

  

Hi Guys;

i'm new in reporting so thanks to be patient with me,

here is my problem, i have created a report then a report viewer,, i passed some parameters to the report it goes well.

i'm working with local data stored in List<object>, i tried to fill my dataset (data) with those local data stored in the list, i filed Cry

looking for yor help

thanks!


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

set the Report URL property to a specific report dynamically based on the selection in the list.

  
Hi I want to use  embedding the Report Viewer Web Part in a Web page, and I know we  should set the Report URL property to a specific report. but  is there a way by which we can set the url  dynamically based on the selection of the report  from  the list How can I customize this  feature Any Help on this is appreciated. Thanks

Report that list what reports have been run

  
Using SQL Server 2008 R2 Is it possible to run a report that lists (1) What reports have been run, (2) who has run the report, (3) number of times a given report has been run, and (4) when was the last time the report was run. Thanks for your help. I look forward to hearing your comments!

how to access items inside Sharepoint List Folder

  
hi all i have a list with structure as below  QuckList(List)                A(Folder)                       1(List Items)                       2(List Items)                B(Folder)                        1(List Items)   i have to display the List items inside the folder in drop down   i am able to access the folder as Splistitem, but not able to access the items inside the folder   any ideas how to access the items inside the List Folder   ragava_28

Cannot send List inside of Dictionary

  
List<string> receivers = new List<string>(); foreach (object item in listBoxControl1.SelectedItems) receivers.Add((string)item); Dictionary<string, object> inArgs = new Dictionary<string, object>(); inArgs.Add("Receivers", receivers); inArgs.Add("Sender", client.name); inArgs.Add("Message", memoEdit2.Text); inArgs.Add("IsGuaranteedDelivery", true); inArgs.Add("DataType", TransmitToClientDataType.ChatMessage); if (service != null) service.AddTask("orion_send", inArgs); There is an error with serialization at last string because List<string> object. I tryed to send List<T> object via WCF, it's succesfull. But why there are problems with List<T> included to Dictionary?

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?  

Folder inside the List shows Access Denied when try to open using Manage Content Structure

  
Hi All, We are facing this issue in one of our site, when accessing the folder from Manage content structure. Folder is inside a list which uses a folder content type. When we try to open this folder use manage content and structure it throws access denied. any idea how we can check this as we the permissions are properly inherited and all the folders are checked in . Please update what else we can check.   Thanks, Jasjeet SIngh

how to add html inside a asp.net list item

  
Hello there,I was working with asp.net list item. There came a situation when I need to add html inside the listitem. But its causing compile error and saying html inside the listitem is not allowed. How overcome this situation? Anybody got any alternative solution for that. if yes, please show me an example. thx in advance

Show value from Lookup List inside a view

  
I've got a Categories list, a Product list with a Category field defined as lookup value. The Product list is used in an OrderLine List. How can i show the category value from the selected Product in the OrderLine view? I tried calculcated columns, but they don't work on lookup columns. Would this be possible by creating a custom FieldType? (without performance problems, i assume there's a reason why calculated values don't work on lookup columns) Thanks Marco

Report Parameter type for a list of Employees to prompt like AJAX Textbox intellisence when the user

  

Hi All,

I have around 300 employees report to run for a specific employee, I cannot have a Dropdown as it would be too long for the report user to choose from. Is it possible in SSRS 2008 to have a text box that would provide intellisence like AJAX textbox and provides user with Employee name to choose from database or is there any other better way to select the right mployee name to run this kind of report. being a newbie to SSRS I am unable to go furthur on this. All help is great help. Thanks in advance for responding.


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.


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