We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Multiple Headers in crystal reports

Medium Priority
313 Views
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
Comment
Watch Question

CERTIFIED EXPERT
Commented:
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
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
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.