Multiple Headers in crystal reports

Posted on 2009-02-16
Last Modified: 2012-05-06
Hi guys,

I have done basic work with crystal reports but now have come across a problem. What i am desigining for the crystal report document is two tables one below the other. The data will not exceed over one page and for both tables i have created a bordered box with the column names in it to give it a datagrid look. The issue is that everytime it repeats the data from my stored procedure it also repeats the box with the column names in it. How do i prevent this?

I thought to put it in the page header but i dont see how that would work as i have two tables one below the other? I then tried Group headers but that repeats the column headers just the same as if i put it in the details section
Question by:_versus_
    LVL 77

    Accepted Solution

    You need to use a subreport for your second table.
    Anything you put in the Detail section will be repeated for every record so that's a non-starter.
    You should be able to use a group header for the first table if you restrict the data to what is required for that table.
    Build a siimilar report for the second table and add it as a subreport to the first report.

    Author Closing Comment

    Thanks for the response. I had spent most of yesterday researching and read up on subreports so thanks for the response anyway. I used a subreport for both tables in two different detail sections and works fine. Thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
    Hi, In my previous Article  ( discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now