1- Create the . To. Click on the Reporting Services and then Report Server Project . 4- Open the subreport . @BegRoute - int. To do this, right-click on the subreport and select "Subreport Properties". For example, in SSRS, we may add a multi-value parameter having additional values (all) to disable the parameter and (blank) to pick blanks and NULLs. If you can get a list of services from your database then create a dataset. The body would be a separate subreport. For example, you can edit reports that are created and deployed by using Report Designer in SQL Server Data Tools (SSDT). One example I remember quite well involved a sub-report that, on the Report Manager site, was located in a different folder than the main report. (Note: A subreport also need to define its datasource in the main report's page. The toggle settings then allow the end user to click the +/- sign to drill down to further detail within the same report. Couple that to a dataset containing all your invoicenumbers. In this example, we will export the SSRS report to CSV file. Creating a SSRS subreport Create one report for each detail table, you can create it as you like, as any normal report, but after creating it (via blank report or template), create a. rdlc file. To avoid having to maintain both an master report and multiple individual reports, you have a couple of options: Create a master report and insert the individual reports as sub-reports. Hi, I managed to pass parameter by setting from Main Report clicked on the SubReport Properties -> Parameter -> Set "Test1" as Parameter Name and "Test1234" as Parameter Value. Applies to: Microsoft Report Builder (SSRS) Power BI Report Builder Report Designer in SQL Server Data Tools You specify paths in paginated report item properties to reference items such as drillthrough reports, subreports, and image files that are external to the report definition file and are stored on a report server. If the Properties option is disabled, verify you ran SQL Server Management Studio with administrative. Figure 6. In real-time, we may see. Value, ", ")Conceptually, a subreport is similar to a frame in a Web page. g. . If a required parameter is missing, the subreport is not displayed correctly in the main report. Drillthrough reports differ from subreports in. The second option in the list, "Specify Values" will allow. 2. 0 . Value) 'Second Cell =Sum (Fields!AdjustedBillings. What is the best practice for displaying SSRS reports on the web in ASP. I want each subreport's data to be housed on a separate tab when the user exports the report as Excel. SetParameters (new ReportParameters [] { rp }); In this video of SSRS Tutorial, You will learnHow to Create Tabular Report with ParameterCall Tabular Report in Main Report by using SubReport Item and Map p. Here is an example of my main report page with grouping on the ClerkNo The header i. So, for example, a detail list for a product might show 2 order with quantities of 100 and 20 and should show a subtotal of 120, but instead shows a subtotal of say 40,000, which would be. Or in SSRS use this syntax for the rowcount: =CountRows("DataSet1") Where DataSet1 is the name of your dataset in SSRS. The first thing to do is to create a report server project because we will need this later for saving report definition files and any other files that you need for creating SSRS reports. For this example, I have chosen "rptProducts". For those of you who aren’t sure what subreports are, they are a report item that displays another report inside the body of a main report. Reporting. Point on its cell, Right Click, Insert Subreport 3. WHERE EMPID =. Let's first write two new report templates, one being subreport and the other Master report. There are two ways to set defaults for a multiselect parameter. For example, When we have a sub-report to fetch the customer information based on the customer id, the sub-report will result with only one row and this section should be. Add Dataset. Document maps create a separate windows pane with a set of hyperlinks which can be used to navigate around a report, a. Aggregate, rownumber, runningvalue, previous or lookup function. In this rectangle, right-click and do Insert => TextBox. 3)Insert a Rectangle object into the List object. Use subreports to nest groups of data from different data sources within a single data region, reuse a subreport in multiple parent reports, or display a standalone report inside of another report. II. For example, unable to find the . To work around this issue, we can use the ReportViewer Control. For the example i have added two DataSet with the name Customers and Orders and two Reports with name CustomerReport and OrdersReport and configured as in the above article. there could be 4 parameters which represent the names of 4 reports. Would need to see some sample data layout to give a more detailed reply –1 Answer. Saturday, July 27, 2013 1:28 AM. Thanks in advance MikeIn the blank cell, right-click and do Insert => Rectangle . Typically the subreport is parameterized . In the simplest example I could do say I have a dataset with just one field 'Name' and it has two values 'Brett' and 'Sean'. 4. As you know we want to implement a tab navigational structure in SSRS, so we have to hide these two parameters. Here is an overview: There are five parameters in this Main report: @BegDate - date/time. Click the cell that contains [SalesDate]. 2. Following is a short SSRS report tutorial-. Adding the SSRS Subreport. When trying to render it, it provides weird behavior: By rendering the report with different dataset (number of records), sometimes it rendered properly as: Group A Header Group B Header & content Group Detail - subreport Group B Footer & content Group A Footer. 20. It also has another textbox which will be visible only if the dataset Items has rows. From the Toolbox, choose the subreport object and drag it to the top of the layout section. Fill(ds, "DataTable4") e. to rewrite your Business Objects expression in SSRS you would do: =SUM (IIF (Date = "Date 3",Value,0), "DataSetName") This expression works because if the Date field does not equal "Date 3" it will return zero and not add anything to your SUM. In SSRS I have created two tables, a parent and a subreport. Set the visibility property of the the subreports based on the parameter so only one is visible. more. In the Subreport Properties dialog box, click Parameters. Add a second dataset to the report and call it AvailableColors. Reporting. Data source : random sample data Data set for the Sub report: SELECT Year([OrderDate]) SaleDate ,[Region] ,[Representant] ,[Category]. It allows the report developer to set which data is shown and which data is hidden when the report is initially run. RDL file, insert the Sub Report. was to add a subquery/CTE to my main report query that got a count of the number of rows that would be present in the sub-report data. Go to Parameters and set the Name field as ID and select the ID from the dropdown in the Value field. In this video of SSRS Tutorial, You will be learning How to add a Sub-report and Parameters in the main report in SSRS to organise and summarise your data in. Add another report file and name it Rdlc. Settings. 2- In the main report . The Dataset Properties dialog box opens. [dbo]. For example right-click the Management Studio icon and click 'Run as administrator'. In the Subreport Properties dialog choose AddressSubReport from the subreport dropdown. A subreport is processed as part of the main report. The report also contains a data region that contains a subreport. There are quite a few ways to do this. =IIF(Fields!Department. This opens the Report Data Sources dialog and it should look something like this. 3] Right click on the field, in the textbox, go to 'Placeholder Properties'. jrxml) template is as given below. One subreport summarizes sales by employee. This subreport is the part we’ll be interested in for the rest of this article. For example, you can create a "briefing book" by placing multiple subreports inside the body of another report. Still in the subreport properties, click the parameters tab, add a new parameter. Then go to " Group Properties -> Page Breaks -> and check Between each instance of a group ". For example, if the RDL for the subreport states that the subreport body is 5 inches wide, then the subreport will be 5 inches wide within the parent report. In this article. rdl so it has this type of format: What I have looks like this: SUBREPORT_1: MIAMI SUBREPORT_2: MIAMI ----- page break ------ SUBREPORT_1: ORLANDO SUBREPORT_2: ORLANDO ----- page break ------ SUBREPORT_1: TAMPA SUBREPORT_2: TAMPA If you want the sub report display the corresponding content when the main report have group . I would like to set up a dashboard report in SSRS that contains a bunch of sub reports, but have the reports that are displayed be configurable at run time. Value, "DataSet1") BegDate [@BegDate] EndDate [@EndDate] Where CurEmp is used in the where clause of DataSet1/sql query i. On the Insert tab, click Subreport. SQL Server Reporting Services (SSRS) 2012 includes many drilldown / drillthrough features. 1 I have a lot of SQL Server Reporting Services (SSRS) reports (*. The subreports are then added to the main report which is then rendered into a report viewer element on the . check the box display can be toggled by Report ITEm- (TerritoryID1)--This text is same which we added after adding Group by TerritoryiD Group. You might wonder what could be so bad in a dashboard as to make me cringe. 1. 8. ); rv. A subreport with the specified name doesn't exist in the same workspace or app as the main report. Answers. In the Subreport. Drag two Subreport controls into the tablix cells in Report1 designer surface (I suspect you are using tablix in Report1). In the Number group > Date. aspx page. For this SSRS subreports example, we are going to use the below-shown report. The Report will have Territory ID as Expanded and collapsed column . Step-by-step process: SSRS 2008 R2. This tutorilas gives you an overview of how to create an SSRS subreport. Data source : random sample data Data set for the Sub report: SELECT Year([OrderDate]) SaleDate ,[Region] ,[Representant] ,[Category] ,[Total] FROM [Test]. Document Map in SSRS at Tablix level. 3) Now, Click File, Add, New Project (ctrl+shift+N) from the top-level menu –. In Reporting Services, Catalog table within report server database stores the master data about all the objects related to SSRS. Specific example: I pick Pittsburgh West and Pittsburgh East, and export. Typically the subreport is parameterized . You can use a text box to insert HTML-formatted text that you have retrieved from a field in your dataset into a paginated report. Additionally, you can specify the end time to stop the subscription. 2. To specify drillthrough reports, include the URL in an expression. Value = 1,False,True) For subreport 2 change the formula to: =IIf (Parameters!ShowReport. SSRS SubReport Anna 21 Nov 9, 2021, 6:32 AM I have a report where the main report have several detail resord and would like to display a subreport that have. Go to visibility Property - Report is intially Run-Change in to Hide. Add alternate row background color Parameters in SSRS. TechBrothersIT is the blog spot and a video (Youtube) Channel to learn and share Information, scenarios, real time examples about SQL Server, Transact-SQL (TSQL), SQL Server Database Administration (SQL DBA), Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Warehouse. Finally, I’ll link the child report to the main report’s subreport items. Trigger example in sql (2) Trigger on delete with Example in SQL (1) Trigger on Insert with Example in SQL (1) triggers with example in sql (2) Try and Catch in SQL (1) two column in stack in SSRS (1) two values after decimal in sql (1) U. rdl) by providing own Dataset/datatable with values. In the parameters tab click Add. You could also explore using rectangles to control the page break locations. Add expression on the textbox "Subreport Page Header" if you want only the page include the subreport to display the page header and footer: example: page1:main report information Page2 and page3 will display subreport's information Expression: =switch(Globals!PageNumber=1,true,Globals!PageNumber=2 or. You will need to use the Height/Width property of the report inside BIDS. LocalReport. This demo will explain how to create a simple sub report which will be displayed in the main report. Choose a data source and create a query for employeedataset as in Figure 6. Here are two: In your TSQL query, just do a count like so: select count(*) from table A. RDL file on the server for the sub report. rdl, with a single Parm: T9_FK) Set the Subreport properties => Parameters: Name: T9_PK Value: [T9_PK] NOTE: the Parameter for this sub-report is the one that is coming from the dataset for the Main report. Create the subreport. WhilePrintingRecords; shared Numbervar myTotal; myTotal := myTotal + 200; //or any formula or field. I found an answer. I have added thre detailed band and in each detailed band I have added the three sub reports. 2. Note the upper control is for Project data sources and the lower control is for Report data sources. Like most values in SSRS, the parameters can be set to expressions which use the fields in the table. In Report Builder, you can use a table to display detail data or grouped data, or a combination of both in a paginated report. Right-click the list, and then click Properties. so only the Name column. The main report displays summary information, for example, in a matrix or chat. I am trying to create a report where, as an example, it would look like: I have been able to get this to work with subreports however there are two problems with this approach: Subreports are extremely inefficient. . We have a report at our office that is similar to what you describe and there are two ways of (semi) achieving what you want. For this sample I have used of NorthWind database that you can download using the link given below. To add a subreport first design the subreport separately. 7 Rating. SO Subreport->RightClick->Proprties->Visibility->Show/hide based on expression. Step 2 - The Data Source. Select “Report” from the drop-down list in Properties window. Once you have a working URL example, create a textbox in your report that spits out the URL string you are trying create. For example, you can resize the report body to reduce the whitespace or resize the tablix rows and columns. Technique #3 - Conditional Initial Visibility. For a general overview of using Report Parts, take a look at the tip Getting Started with Report Parts in SQL Server Report Builder 3. Well, apart from the factor that the dashboard was openly flouting all the best practices for visualizations and that it would have misled. Net using C# and VB. Main Features in This Sample. The main report displays summary information, for example in a matrix or chart. Right after the subreport I have a rectangle (for page header) which RepeatWith is set to an object below the rectangle. The first step is to open SQL Server Data Tools. Steps Used for Call SSRS Report are : -You don't need a subreport. If you don't see an example currency value, in the Numbers group, click Placeholder Styles > Sample Values. Drillthrough reports are standard reports that are accessed through a hyperlink on a text box in the original report. A subreport is a report that is included in another report (the main report). To add a subreport . Set the Subreport name as EmployeeDetails, as shown below. "CLERK 1 Scott" Is just on the Sub Report, this was added to each sub report so i could identify if it was aligning up correctly The subreports are a MasterData to a query, Each sub report is using a different query (Although the column responses are the same. When E10 makes a dataset (with the GUID), the data is fixed and never changes. To make a simple SSRS report, follow these steps. I. If you want to repeat a set of items under each Project ID , you need to put sub report inside the group. I inserted subreport on main and subreport parameters as follows: Name Value CurEmp =First (Fields!EMPID. The basic idea is replace this subreport with customizations per customer. Data sample and dataset query : Report structure. sysmanagement_shared_registered_servers s. Use a Rectangle at the bottom of each SubReport after all Tablixes and other rendering Objects. After you save both reports to the same workspace, you can add one to the other as a subreport. The child report or sub report can accept parameters from the master report and will execute its work. Create a SSRS Tabular Report / Detail Report. End users who work with the data, first send the Report Request to the SSRS server. 2] Then from the 'Report Data' pane on the left side, drag any field from the dataset into the text box {this is to create a 'placeholder' rather than a plain 'textbox'. RDL file on the server for the sub report. Here you can hide Subreport and prevent SSRS from arranging empty sheet for it. Step 3: Create another report which is Subreport with Contact details. Download the script from the GitHub site Reporting Services RS. Step 2: Below is the dataset used for the MainReport. ( Note that #2 is the DB of the source data, not a report DB) Back in Datasource Props, Test Connection , then OK. Right-click on the orders cell and choose the Add total option to get the SSRS Drill Down Table Report subtotals. For a general overview of. Right click on Datasets in the Report Data window and select Add Dataset. Please check the log files for more information. To specify parameters to pass to a subreport. you could pass the group instance name to sub report . From the menus select Report-->Data Sources. Now go to Visibility tab and select Hide radio button, next check the Display can be toggled by this report item option. The trick is that each subreport has multiple records with multiple dates. We look at passing parameters from a main report to a sub-report Dynamic subreport in SSRS 2008. @PickTick - int (multivalue) Each report has a carbon copy of the parameters and only one of these parameters is multivalue (PickTick). Use Report Designer to create full-featured Reporting Services paginated reports and reporting solutions. I have a report wherein combination of Portrait and Landscape are in one report. Value it breaks. The trick is that each subreport has multiple records with multiple dates. Subreports are commonly used to implement master-detail reports. This article covers a little more than half of a Baker's Dozen this time around, with the following SSRS tips: Implementing a tab-style interface for navigation to report page/sections. The solution is to create a dummy parameter in the subreport, which you then need to bind to a field in the tablix dataset. So for example I have tablix on main report, that passes @Number value to sub report to fetch some child records and I want the sum of total values back. The subreport will appear as a gray box with the name of the report it contains—in our case, CoverPage. An SSRS report subscription is a request to deliver the subscribed one to an Email or File System location at a specific time. Click Report Manager URL to see the URL for viewing and managing reports, as shown in Figure 7. II. Before we start deploying reports in SSRS Project, we have to configure the Reporting Server properties. The subreport uses each database name in its connection string via the following: ="Data Source=sql-server-name;" & "Initial Catalog=" &. public void SetSubDataSource (object sender, SubreportProcessingEventArgs e) { // Reload the data required SqlConnection conn = null; SqlCommand cmd. 2. 5. create two datasets. In the Query string section, type Select 1. I want to know which of these reports are using subreports. So, the subreport has to run for each and every project ID . The subreport has 4 columns. In order to Open a SSRS Drill through Report in a New Tab or window we have to use Javascript. Choose a field that works for you. If you just need a map entry to point to your subreport then you can set this by simply clicking on the subreport from your main report and setting the DocumentMapLabel property. The default behavior as I recall was that SSRS won't show the subreport if the datasets in the subreport return no rows. There are three lookup functions in SQL Server Reporting Services: Lookup, LookupSet and MultiLookup. In order to make this works both reports, the main and sub report must be deployed to services. In Data Source Props. There are two common ways of doing this. Clicking on any Territory ID will expand other Records. Add a subreport and parameters to a paginated report (Report Builder) [!INCLUDEssrs-appliesto] [!INCLUDE ssrs-appliesto-ssrs-rb] [!INCLUDE ssrs-appliesto-pbi-rb] [!INCLUDE ssrb-applies-to-ssdt-yes] . Street, Address. This is where you connect the subreport to the main report, by. This displays the. I found rc:LinkTarget=_blank parameter that should fix the issue changing a. There's only 1 dataset in the main report. But more likely you'd like to hide it based on some logical conditionIt looks like this: where @pNomActif is a report parameter: =Parameters!pNomActif. In your scenario, you can use the query below to get a list of reports that reference subreports, including the path of those subreports: USE ReportServer /* declare and populate temp table */ DECLARE @tab TABLE (Path. On the General tab, click Edit details group. Hide the parameters. I am dealing learning SSRS 2008. Step 3 is the core of the data driven subscription. RDL and setup the parameters passed from the main report. The master report is configured to pass one or more of it's fields (e. Add another report file and name it Rdlc. Id = Address. Add a subreport to the main report. create a dataset in that. I would like to have a row with information about "Object": name, id, description, etc. Over the past 16+ years, many articles and blog posts have been written about passing multi-value parameters between reports using a combination of the JOIN and SPLIT. Configure permissions. In this tip I will review each function and provide a simple report to show how it is used. 1. When the SubReport is finished with the Tablix and/or other data objects, the Rectangle forces a page break. I believe that I can do this by creating a sub-report for Table B. [@Month1]In the web portal, navigate to the desired report, right-click on it and select Manage from the drop down menu. Execute the Linked Report to see if the change is reflected. Download All Sample Source Files Browse Sample Source Files on Git. TotalPages () This solution DOES NOT work with SSRS 2008 R2. The arguments passed to the SubreportProcessing event handler include an object encapsulating the subreport. Lesson 1: Creating a Report Server Project (Reporting Services) Lesson 2: Specifying Connection Information (Reporting Services) Lesson 3: Defining a Dataset for the Table Report (Reporting Services) Lesson 4: Adding a Table to the Report (Reporting Services) Lesson 5: Formatting a Report (Reporting Services)Border properties are used to add or customize the border around a subreport item to visually separate items in the report design. However, in the. To work around the issue, we can change the data type of the parameter to XML type. First you have to Select the Drill through values textbox. A subreport is a report that is included in another report (the main report). Every report we create using SSRS technology is based on the Tablix data region. 3- Still in the main report . Moreover, it can be executed independently. Start SQL Server Management Studio with administrative privileges. Group by id or name. If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link single Reporting Services paginated report can have characteristics from more than one type; for example, a report can be, at the same time, a stand-alone report, a subreport referenced by a main report, the target of a drillthrough report in a different main report, and a linked report. In my example I just used "Collapsed Header". If your dataset is embedded in your report, then I think the simplest way is: Add your parameter, let's call it GroupingOrder, and hardcode your options: say set the Value to 1 for label of Country > City > Department and value of 2 for Country > Department > City. A single Reporting Services paginated report can have characteristics from more than one type; for example, a report can be, at the same time, a stand-alone. Repeat and add another textbox (It must be within the rectangle again). The SSRS Report Parameters allows the users to enter a specific value in the textBox, and then it will filter the Report data using the user-specified value. I have a main report which internally calls three sub report. I will use the following tables from the AdventureWorksDW2008R2 database in my sample report: 7 Answers. Below are the ways I tried to get it done: Added another column in tablix and try to get the subreport as ReportItems! Subreport2, didn't work. Follow the steps below to pass parameters into subreports: Create main report parameter, such as DATE_PARAM. . Add Action and Select "Go to Report" and select this main report (kind of recursive action), click add parameter button and select SelectedCustID. Create two linked reports based on a. If you pass a val4 from main report to call the sub report, it will prompt the Error: Subreport could not be shown. These parameters can then be passed to the subreport via. Add(New ReportDataSource("DataSet1", ds. . The subreport has a page break after. In SSRS it is working fine in (the BIDS) editor but when calling from C# it is giving error:1. For more information, see Drillthrough, Drilldown, Subreports, and Nested Data Regions (Report Builder and SSRS). In the following example,. Drag a SubReport control into the detail cell for the column labeled Address. (Optional) On the Home tab, in the Number group, click the Decrease Decimals button twice to display dollar figures with no cents. SSRS report: "Error: Subreport could not be shown" ERP 10. Still in the subreport properties, click the parameters tab, add a new parameter. In this example I am running a SELECT statement to assign the first day of the current year to startdate and the current date to enddate. I would pass that value to a multi-valued parameter in the sub report, using the SSRS Split function in the Subreport. Fill the value field with the below expression: 1. Settings. In the subreport control properties, select "Sub1" as the "Use this report as a subreport". This tutorilas gives you an overview of how to create an SSRS subreport. Use the text-based view to type, paste, or view an existing query, typically used for a complex query that cannot be displayed in a graphical query designer. Open a shared dataset in shared dataset mode. Unlike executing a report manually, you can automate the process by scheduling the Date, Time, Report type, and location (Email or Hard drive). Add a report as in Figures 2 and 3. The fifth question is a simple Yes/No. When selecting this, you will see the BackgroundColor option. Open the main report and drag & drop the CoverPage report into the report header (to make a report header, just drag the data region down a bit; the space above it is the report header). 2) SQL Server Data Tools will open as –. If a required parameter is missing, the subreport is not displayed correctly in the main report. SSRS stands for SQL Server Reporting Services is a reporting software that allows you to produce formatted reports with tables in the form of data, graph, images, and charts. Two subreport components will be displayed in the report, and employee information will be displayed in the child report. 1. Technical Support Response: Yes, it is possible to choose the SubReports from the Parent Report based on some condition. . It looks like the only difference is changing the version of SSRS in XMLNAMESPACES part of the CTE. . Annotating parameters correctly. For example. . In Report Builder, you can open a report from a report server that includes references to custom assemblies. In this issue, to modify the rendering size of the subreports in the main report, you need to rearrange the original subreports individually. That is there will be two reports one the Master and the other the child where the master will invoke the child report. For a practical example of how to use Subreports, take a look at the tip Create Centralized Report Headers Using Subreports in Reporting Services. 1. If the tablix width or the body width> page width it will got the incorrect layout. Above this detail row (the header you added) you can write the following expressions: 'First Cell =Sum (Fields!LineItem. 4) Now go back to BIDS and select the Image control. Create a parameter named ID in the subreport. how to show the header and footer in the subreport in SSRS report. Under Basic Settings, click the browse button in the Report field. When E10 makes a dataset (with the GUID), the data is fixed and never changes. Also, a cool feature, if the SubReport returns no. . For more information, see Drillthrough, Drilldown, Subreports, and Nested Data Regions (Report Builder and SSRS). example:Sub1 width +Sub2 width+ sum of all the other column with<=8. DataSources. Test the subreport stand alone and make sure it works. For instance, you can use the Visible property of SubReport control in the Detail's. SQL Server Reporting Services (SSRS) provides two main options to serve this objective: bookmarks and document maps. I. Make sure the report designer is open with your new report showing in the designer. Right-click on the SubReport control and select Subreport Properties. Go to Report layout è first tablixè right click on left most of the row è Insert rowè Insert Group below: It will add a new row to tablix within the same grouping: IX. 7. Click Web Service URL to find the URL of the report server to which you will deploy your reports. Name, Address. 1. rdlc. My question is really this. NOTE I rarely use subreports in standard scenarios to produce master/detail reports. To add a filter to a shared dataset . SSRS Lookup Function. Every row contains a SubReport reference and passes current Col1 value to it. The SSRS Drill Through Action is the most commonly used Action in real-time reporting. You need to pass in the value form the dataset of the tablix that you click on. Select Report with. You cannot use a data source expression in a shared data source. We’ll have two reports to go over. /. I have a subreport in SSRS. 9302 Reader (s) SQL Server Reporting Services (SSRS) is a versatile reporting platform that provides a comprehensive solution for creating, managing, and delivering reports from various data sources. /. Our sample report has two report parameters Year and Report. PageNumber () + " of " + Code. In your scenario, you can add a parameter in the subport, and then in the main report you can add parameter to run the subreport. there could be 4 parameters which represent the names of 4 reports. Step 1: Create a new report which is Mainreport with Account details. Right-click on the Subreport and select Properties. Merge the new row, and the drap your subreport into this merged textbox.