.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

Three subreports in a main report(RDLC file)

Posted By:      Posted Date: September 17, 2010    Points: 0   Category :ASP.Net
Hi All, I have one main report(rdlc file) which contains three subreports(mapped to three different rdlc files). The functionality am working in is that in a button click(with parameter passing) the main report loads. The main report contains three columns which is of type link. Each column is mapped to a subreport. Once the link in a column is clicked the main report along with the respective subreport should get displayed. Again, if the link field of another column of the main report is clicked, the main report and its respective subreport should open and the previously opened subreport for the other column should not show. The visibility of the Subreports must change according to the click of the link in the main report. I have declared SubReportProcessingEvent as a sub report processing handler shown below. AddHandler rvCompareLabels.LocalReport.SubreportProcessing, AddressOf SubReportProcessingEvent Public Sub SubReportProcessingEvent(ByVal sender As Object, ByVal e As SubreportProcessingEventArgs) End Sub I understand that in this method i have to do the code behind for displaying the subreports. But am confused as to how can i identify which link is being clicked and how am i supposed to add the datasource  for the subreport that should open. How will i give the condition such that  for the link that is clicked only the subreport mapped to that link opens.

View Complete Post

More Related Resource Links

Group headers of the main report are not repeating when used with subreports


Hi all,

  I have a SQL server 2008 report which has a main report and 2 subreports embedded. Each of the subreports are placed under a main group and the group headers of the main header are made to repeat with RONP property and Keep together properties set to true. If the subreport's data fits in one page the group headers are repeated. But when the subreport's data spans to more than one page the group headrs of the main report are not repeated. Please let me know if there is a workaround to achieve the same. I have tried putting the group headers in the page header, but this approach does not work fine. Please let me know if this can be achieved using coding.



Access to report file denied. Another program may be using it.


Migrated from Windows 2000 ASP.NET 1.1 to Windows 2003, ASP.NET 2.0 and had this error. All the forums/MSDN/Blogs says to give Read/Write Access to C:\Windows\Temp folder. Why should we give Full Access to some folder in Production server?? In windows 2000, ASP.NET 2.0 development machine, no files are created when we run crystal reports from aspx pages. Then why in Windows 2003 servers, we need to give rights to temp folder?? It is a simple code


And the code is not storing anything on the disk. Then why should it store the GUID.rpt file in Temp file in Windows 2003 server?? Any alternative is there not to store anything on the disk when Crystal Reports are opened in aspx page??


RDLC Report Hide Export Option

The article RDLC Report Hide Export Option was added by mandandeo on Sunday, August 15, 2010.

protected void ReportViewer1_PreRender(object sender, EventArgs e) {DisableFormat(ReportViewer1, "Pdf"); }protected void DisableFormat(ReportViewer viewer, string formatName) {const System.Reflection.BindingFlags Flags =System.Reflection.BindingFlags

Unwanted page breaks in rdlc report



I hav a report that has a table group =Fields!Location.Value

and in the cells I do this

=Avg(IIF(Fields!Contaminant.Value = "Element1", cDbl(Fields!Value.Value), cDbl(0)))

what I am getting is 1 row for each location then there is a pagebreak! what i want is the next location right below the  first I looked through for all the page breaks with no luck. Any ideas?

Struggling to assign the parameter value for the RDLC report, VS2010

 Struggling to assign the parameter value for the report, I saw so many helps in this forum. seems i have the same error comes again after i click the button. pls help what i miss in the below?   Following is my .XSD (DataSet) SELECT     [Order Details].OrderID, [Order Details].ProductID, Products.ProductName, [Order Details].UnitPrice, [Order Details].Quantity, [Order Details].Discount,                       CONVERT(money, ([Order Details].UnitPrice * [Order Details].Quantity) * (1 - [Order Details].Discount) / 100) * 100 AS ExtendedPriceFROM         Products INNER JOIN                      [Order Details] ON Products.ProductID = [Order Details].ProductID <div> <asp:Label ID="lblMessage" runat="server" Text="Label"></asp:Label> <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1" DataTextField="OrderID" DataValueField="OrderID"> </asp:DropDownList> <asp:Button ID="Button1" runat="s

RDLC Report Viewer

I want to Export Rdlc Report into PDF format, programmatically. How can i do that, Please help me Thanks in advance Bheemidi.  

How to put text from an external text file into a text box on a report.

Hi all, We're moving from our legacy reporting app to SQL Server Reporting Services 2008 and I'm converting our reports slowly but surely.  In our organization, one of our departments sends out letters that have standard marketing messages and disclaimers that they put into .rtf files.  Currently, our reporting application has an RTF box control that can do that fairly easily.  I've not found a similar control in SSRS 2008.  My thought, then, was to use a piece of embedded code in the report to grab the necessary text from the file and reference it in the Value of a Placeholder (using a Code.<FunctionName>.ToString() statement) - using HTML tags for the necessary formatting for those files. I don't care if I have to convert the existing RTF files to HTML files to do this, that's not an issue.  The code I'd come up with is this:  Public Function GetTextFile(ByVal strFileName as String) As String Dim oFile as System.IO.File Dim oRead as System.IO.StreamReader oRead = oFile.OpenText(strFileName) GetTextFile = oRead.ReadToEnd() End Function And the Expression I was using to get the text from the file is:  =Code.GetTextFile("HTMLTest.txt").ToString() Where "HTMLTest.txt" is the file name that I'm using.  The text itself is just a line of text with some HTML tags included for formatting - bold, color,

Formula on Main Report Using a Field from Subreport

Hi, I try to use a value coming from a cell which contain a subreport. I need to create a formula using this value. So I tried : =Code.CalcPct(CountDistinct(Fields!s_contactsvisited.Value), Globals!CALL_SubReport) But I've an error: [rsRuntimeErrorInExpression] The Value expression for the textbox textbox9 contains an error: Specified argument was out of the range of valid values. Thanks for you help,      

Embed Video File in Crystal Report

Hi to All I am new to crystal reports. I need to embed Video file in crystal report. Help will be appreciated.Rajeev Singh Chibrajeev16mca2k5@gmail.com

How to pass value from main report to sub report

I need pass sub report calculated  value in main report  using crystal report please help me

Multiple Rdlc report in one reportviewer.

Hi, I have multiple reports that take the same parameters. Need to create a master report with all the reports merged together. I dont want to copy paste the rdlc files into one large file. found a control by Telerik called ReportBook but it costs money!! http://www.telerik.com/help/reporting/designing-reports-general-explanation.html anyone knows something similar? or am i missing something very obvious? using visual studio 2005... Cheers will subreports solve my problem? not sure how these work. so say i have a report that lists employers and i create a subreport that lists all employees for a particular empoyer. is it then possible on one rdlc to have the list of employers and a bunch of subreports for each employer's employees?

.RDLC report layout...huge problem!!

 Hi!I'm designing a layout for a report in VS2008 using SSRS/RDLC format. And every time I setup a part of that report i test it on my workstation to see if everything is ok. But, today, i finished the first page of that report and uploaded it to my hosting server (were it's going to be used), and when i press the button to convert the report to .pdf and download it the layout is completely ruined :-/When i do the same thing in my workstation every thing 'comes out' beautifully, but up on the server it doesn't :(Why is that happening? Can anyone help me?

rdlc report parameter passing

hi i am working on report project i am new in .net will some one help how to pass parameters in rdlc reports . the options for reprt parameter is not available in visual studio 2010 .Please help someone ..

rdlc report list inside another list

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?

How to display middle value in a RDLC report where count equals 3?

I'm currently using an RDLC report and ReportViewer control to display a report to the user. The report needs to be formatted in a certain way so just creating a table and iterating through won't work. My database is set up to be pretty normalized. For example, two tables I have are a "PersonalData" table with a ID and a "PhoneNumbers" table with a ContractorID that relate to the first table. The "PhoneNumbers" table has essentially two columns of data: Number and Type. Each contractor in the PersonalData table can have multiple phone numbers (home, cell, work, etc.). I'm also passing the ContractorID into the report so I know which records to grab. On the report, I need to display each phone number in a separate text box layed out like so:Home Phone: (555) 555-5555             Cell Phone: (444) 444-4444    Daytime/Local Phone: (333) 333-3333   E-Mail Address: me@somewhere.com  The records are inserted in the database in the following order: Home, Cell, Daytime/Local. I can grab the home phone since I know it will always be the first record in the database (required field) by using:=First(Fields!Number.Value, "DataSet1_PhoneInformation")  And either the Daytime/Local or Cell depending on the element count by using the Last() function. The problem is grabbing and displayi

Displaying Rich text with formatting in RDLC file

Hi, I want to display my rich text with formatting in RDLC file. Can anyone please help me with the way out for that? Thanks & Regards, Subalakshmi Vijayarajan.

It is possible Html Formatted Textbox in RDLC (microsoft Report Viewer)

I am trying to create a rdlc report.   One of the fields in the report contains HTML formatted information. e.g. (It's a text field which is populated from a Rich Text Editor similar to one we have here).   When I put the content of this, in a text box of RDLC file, it shows HTML instead of formatted output.   I have been doing this in Crystal Reports using Text Format tag in there.   Is there some similar option available for RDLC text box too? I could not find any.  
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