.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

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

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server

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.



View Complete Post

More Related Resource Links

Three subreports in a main report(RDLC file)

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.

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,      

Creating Dynamic Group Fields for a Crystal Report?

I have a VB.Net application which generates quite a few Crystal Reports. One report in particular has a Group Section. What I am trying to do with my VB.Net app is pass a value (a sql server column name used in the report). This value is represented by radio buttons. For example, the user may check either "ZipCode" or "State" or "Category" or "Type" or "Vendor". Each of these options represent a column in the database table used in the report. I simply want to be able to write the "SelectionFormula" using one of these options but not sure how to go about it. Thanks, Blake

SSRS Report Group Total

I am trying to make a report in SSRS with Data source CUBE. I have a column which is calculated and inside the group. I could not take group total for that item. Please any guide my calculated column expression is =(Fields!Count_of_Passengers.Value/Sum(Fields!Count_of_Passengers.Value, "LHSH"))*100  

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

group headers are not displaying

I am new to Sql Server Reporting Services. I am using SQL Server Reporting Services 2005. I have a report with multiple groups and in detail section I have a subreport. The subreport has only one field. Some times the length of the field can be more than 30000 or 40000 chars. I have kept the group header to repeat in all pages. When the sub report extends to more than 1 page the group header is not displaying in all the other pages for that particular group. Can any one help me to resolve this issue? Thanks, Paul

Page 1 of Report has Headers Only

As the topic says I have a report where I have 3 groups, 1 for the entire report, 1 for ColumnA, 1 for ColumnB.  Column A is set to page break.  In trying to get the page headers to print on each page I somehow managed to do something so that the page headers only show up on page 1 of the report (i.e. no detail)   Also, the Grand Total is appearing below the last group break (same page) and I want the Grand Total to be on a separate page.

Reporting Services 2008 - Repeating Headers when Headers are in a rectangle in header cell

Hello,I had the same problem as others where the tablix header will not repeat on multiple pages of the report.  I followed the instructions here http://blogs.msdn.com/robertbruckner/archive/2008/10/13/Repeat-Header-And-Visible-Fixed-Header-Table.aspx and it did not solve the problem.  After trying several scenarios, I found that it was not repeating because I have each header value in a rectangle which spans one column, rather than having each header value in it's own tablix column.For instance, if we have fields CompanyID and CompanyName on the report, the repeating headers work if I have them in separate columns like this:                              Tablix Column 1  |  Tablix Column 2Tablix Header row    Company ID        |  CompanyNameTablix Detail row      [CompanyID]      |  [CompanyName]It DOES NOT work when it is designed like this:                             Tablix Column 1Tablix Header Row   Company ID    Company Name  (tw

Sub report query based on main report (Microsoft Report Viewer)



I searched the forum but couldn't find anyone with the same problem with me.  They were close but didn't help me solve my issue.

I'm trying to learn how to make the sub-report get data from SQL Server based on a primary key passed from the main-report.

An example:
Main report displays all student names and the sub-report would display all their contact phone numbers.

A visual:
Bobby Smith

Home Phone: 555-1212
Cell Phone: 555-2323
Work Phone: 555-3434

Jane Doe

Home Phone: 555-2020
Cell Phone: 555-3030
Work Phone: Null

Ginger Doe

Home Phone: 555-5062
Cell Phone: 555-9586
Work Phone: 555-2356

Student ID   |   Name
1                | Bobby Smith
2                 | Jane Doe
3                 | Ginger Doe

Phone ID &n

links to data view group by headers

I have a content editor webpart with some image links,now my requirement is that some images on clicking should go to a dataview web part group header.how can this be done with just one data view webpart ,the way I am doing right now is create few data view webparts from the same list and group them but again filter them by each group,so instead of using just one DVWP I am using as many number as my group headers are there and then edit page to add a hidden CEWP on top of each DVWP and add a div tag to CEWP so that it can reference from other page with image links,I just want to use one DVWP for performance reasons.

SSRS 2005 Report with 7 subreports


I've SSRS 2005 Report with 7 subreports.
Toplevel report runs the query and returns recordset.

RegionID  CustID orderID  OBID     State      City       Name
69            1230    4565      75855    NY         NYC       Sam

Now i need to pass these values in subreports's query as parameter
something like
select * from Region where regionID = @RegionId (in my case it shud get 69 from upper record set.)
Likewise there are 6 more subreports where i need to pass above values as parameter.

Any suggestions would be very helpful.

Thank you,

in crystal report i need to print each group in new page



i have one problem in crystal reports

i want print  group details ,for each group it should print in new page.

some thing like this




Transaction Number                Date                           Amount                           Remarks

   1111                                   10/1/2007                    300.00                                 JE999

   2222               &nb

report and domain group


Good day.

Is it possible to make a report parameter, which get his values from Domain Group?

Best Regards,


Exporting in PDF or Excel for a main report and the related sub report



I have created a main SSRS 2005 report from what it is possible to call some subreports. Is it possible export in PDF or Excel also the subreports when I require the export inside the main report?

Many thanks

report not visible in chrome/safari if row group is used


I am just getting started with SSRS (using 2008R2), and find that my reports, after deployment, show up empty (blank) when viewed in chrome or safari (windows). IE(8), FF and Opera work fine.

A simple table report (no grouping, etc) displays fine in all browsers, but if I add a row group, the data disppears from Chrome and Safari. The report page navigation is still present and has the right number of pages, but all display blank. Saving the report as PDF or Word file still works, so this appears to be an HTML or Javascript problem.

Is this a known problem and if so, is there a work around?



Fixed Headers and Document Map behavior on Report Manager



We have created a simple SSRS 2008 R2 report with document map on it. Also the report has the 'Repeat header rows on each page' and 'Header should remain visible while scrolling' features on.

When this report is deployed to report manager, we are seeing some unexpected behaviour that we would like to fix.

Basically, when you click on different items on the document map - the first few records in the report got hidden behind the  "fixed header data". Then we have to scroll up to see all the records. (The same question was asked back in 2006 by someone.. But no answers.. http://www.bigresource.com/Tracker/Track-ms_sql-ErXx27Zc/)

Please help us out. Thank you!


Error processing report with embedded subreport while leveraging interactive sorting in main report.


This error only occurs with the Report Viewer v10 control...fine with v9 and occurs on both SQL Server 2008 SP1 CU9 and 2008 R2.  I have a report that has an embedded subreport object, and the subreport renders properly until I click on any textbox with interactive sort enabled in the main report...at which time I receive the following error message in the subreport object:


reportrendering!ReportServer_0-2!d98!10/06/2010-11:38:22:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'FilterList', located at: Common_SubReport_FilterList., ;

 Info: Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'FilterList', located at: Common_SubReport_FilterList.

processing!ReportServer_0-2!d98!10/06/2010-11:38:22:: e ERROR: An error has occurred while processing a sub-report. Details: One or more parameters were not specified for the subreport, 'FilterList', located at: Common_SubReport_FilterList. Stack trace:

   at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.CheckRetrievalStatus(Status status)

   at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.RetrieveSubreport()


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