Welcome!

You will be redirected in 30 seconds or close now.

ColdFusion Authors: Yakov Fain, Jeremy Geelan, Maureen O'Gara, Nancy Y. Nee, Tad Anderson

Related Topics: ColdFusion, Adobe Flex

ColdFusion: Article

CFDJ Feature: Creating Subreports with the Report Builder in ColdFusion MX 7

With ColdFusion MX 7, you can use subreports to show more detailed reporting

  1. Double-click the following fields: Emp_ID, FirstName, LastName, Dept_ID, Salary, and Contract.
  2. For Dept_ID, deselect the Output check box so that this field will not actually be displayed as part of the report. It will, however, be part of the SQL Where clause.
  3. In the Dept_ID row, under the Condition column, select Where from the pop-up menu. From the Criteria column, select = #CFvariable#. Note that this is the unquoted option, not the "#CFvariable#" option. Selecting these options creates or changes the SQL query in the panel below.
  4. In the SQL query panel, modify the Where clause. Replace the value, CFvariable, in the Where clause with param.DeptID. Do not delete the pound signs around the variable. By changing the variable, the query references the input parameter for the report that you will create later. Your query appears like that shown in Figure 5.
  5. Click the Test Query button, enter a test value of 1 and click Run. The query will return seven results. Close the results window.
  6. Click Save. Click Next on the Define Group Reporting dialog box.
  7. On the Report Layout dialog box, make sure that you have only selected the Grid option. Click Next.
  8. On the Report Layout page, select the Only Detail Band option. Deselect the Create Totals for Numerical Fields option. Click Next.

    Note: The report will run properly if you select the Default option at this point.

  9. Click Next on the Report Theme dialog box.
  10. Enter Employees by Dept for all three title fields on the Report Name dialog box. Click Next.
  11. Click Next on the Subreport Binding dialog box.
  12. For the Subreport Filename, save it in the same directory as the main report. Name this report Employees. Click Next.
  13. Click Finish.
  14. Save the Employees report.
  15. In the Employees report, open the Fields and Parameters panel. If it isn't open already in the lower right corner of the Report Builder, select Window > Fields and Parameters.
  16. In the Fields and Parameters panel, click the Input Parameters option once and click the plus (+) button to add an input parameter. The Add Input Parameter dialog box appears.
  17. Enter DeptID for Name. Select Integer for the data type. This parameter corresponds to the param.DeptID referenced in the Where clause of your SQL statement you typed in earlier. Click OK.
  18. Save the Employee.cfr report and preview by pressing F12. Enter 1 for the DeptID parameter; your report appears.
  19. Toggle to the Company-Departments_v2.cfr report.
  20. Click the Subreport component once to select it. In the Properties inspector, click the plus (+) sign to expand the Data property. Click Subreport Parameters once to select it.
  21. Click the ellipses to add a parameter. The Subreports Parameters dialog box appears. Click Add.
  22. Enter DeptID for Name and select #query.Dept_ID# from the pop-up list (see Figure 6).
  23. Click OK, and then click OK again to close the Subreport Parameters dialog box.
  24. Save the Company-Departments_v2 report.
  25. Preview your report (press F12). It appears similar to the report in Figure 7.
Congratulations! You have successfully created a subreport from the main report.

Where to Go from Here
This article described two different techniques for linking subreports to main reports. You can bind the parameters property in the subreport component, which will match the input parameters of the subreport itself to link reports. I have found that creating the subreport through the Subreport Wizard, the second example, has proven to be easier and reduced the guesswork in formatting the subreport with the main report.

I hope that after following the sample reports and creating subreports you can appreciate how easy it is to develop and link subreports to a main report. I believe this will help you get up and running with the ColdFusion Report Builder so you can create reports and link subreports with little trouble.

For more information about creating reports with ColdFusion, see:

More Stories By Jim Bambrough

Jim Bambrough taught high school mathematics and computer programming in the Phoenix area for three years. Jim currently works as a Web application developer for Amkor Technology in Chandler, Arizona. He has worked in IT since 2000 and has been developing Web-based reports at the corporate level since 2003.

Comments (2) View Comments

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


Most Recent Comments
SYS-CON Italy News Desk 01/19/06 03:10:43 PM EST

With Adobe ColdFusion MX 7, you can use subreports to show more detailed reporting. A subreport is simply a report embedded or nested inside another report. I refer to the report that contains the subreport as the main report from this point forward. The subreport and main report are typically related by the nature of their content.

SYS-CON India News Desk 01/19/06 02:44:52 PM EST

With Adobe ColdFusion MX 7, you can use subreports to show more detailed reporting. A subreport is simply a report embedded or nested inside another report. I refer to the report that contains the subreport as the main report from this point forward. The subreport and main report are typically related by the nature of their content.

IoT & Smart Cities Stories
SYS-CON Events announced today that IoT Global Network has been named “Media Sponsor” of SYS-CON's @ThingsExpo, which will take place on June 6–8, 2017, at the Javits Center in New York City, NY. The IoT Global Network is a platform where you can connect with industry experts and network across the IoT community to build the successful IoT business of the future.
CloudEXPO New York 2018, colocated with DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.
Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life settlement products to hedge funds and investment banks. After, he co-founded a revenue cycle management company where he learned about Bitcoin and eventually Ethereal. Andrew's role at ConsenSys Enterprise is a mul...
The best way to leverage your Cloud Expo presence as a sponsor and exhibitor is to plan your news announcements around our events. The press covering Cloud Expo and @ThingsExpo will have access to these releases and will amplify your news announcements. More than two dozen Cloud companies either set deals at our shows or have announced their mergers and acquisitions at Cloud Expo. Product announcements during our show provide your company with the most reach through our targeted audiences.
DXWorldEXPO | CloudEXPO are the world's most influential, independent events where Cloud Computing was coined and where technology buyers and vendors meet to experience and discuss the big picture of Digital Transformation and all of the strategies, tactics, and tools they need to realize their goals. Sponsors of DXWorldEXPO | CloudEXPO benefit from unmatched branding, profile building and lead generation opportunities.
Disruption, Innovation, Artificial Intelligence and Machine Learning, Leadership and Management hear these words all day every day... lofty goals but how do we make it real? Add to that, that simply put, people don't like change. But what if we could implement and utilize these enterprise tools in a fast and "Non-Disruptive" way, enabling us to glean insights about our business, identify and reduce exposure, risk and liability, and secure business continuity?
DXWorldEXPO LLC announced today that Telecom Reseller has been named "Media Sponsor" of CloudEXPO | DXWorldEXPO 2018 New York, which will take place on November 11-13, 2018 in New York City, NY. Telecom Reseller reports on Unified Communications, UCaaS, BPaaS for enterprise and SMBs. They report extensively on both customer premises based solutions such as IP-PBX as well as cloud based and hosted platforms.
Digital Transformation: Preparing Cloud & IoT Security for the Age of Artificial Intelligence. As automation and artificial intelligence (AI) power solution development and delivery, many businesses need to build backend cloud capabilities. Well-poised organizations, marketing smart devices with AI and BlockChain capabilities prepare to refine compliance and regulatory capabilities in 2018. Volumes of health, financial, technical and privacy data, along with tightening compliance requirements by...
In this Women in Technology Power Panel at 15th Cloud Expo, moderated by Anne Plese, Senior Consultant, Cloud Product Marketing at Verizon Enterprise, Esmeralda Swartz, CMO at MetraTech; Evelyn de Souza, Data Privacy and Compliance Strategy Leader at Cisco Systems; Seema Jethani, Director of Product Management at Basho Technologies; Victoria Livschitz, CEO of Qubell Inc.; Anne Hungate, Senior Director of Software Quality at DIRECTV, discussed what path they took to find their spot within the tec...
To Really Work for Enterprises, MultiCloud Adoption Requires Far Better and Inclusive Cloud Monitoring and Cost Management … But How? Overwhelmingly, even as enterprises have adopted cloud computing and are expanding to multi-cloud computing, IT leaders remain concerned about how to monitor, manage and control costs across hybrid and multi-cloud deployments. It’s clear that traditional IT monitoring and management approaches, designed after all for on-premises data centers, are falling short in ...