Displaying Multiple SubReports Vertically
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21753
Printed Date: 04 May 2024 at 5:03am
Topic: Displaying Multiple SubReports Vertically
Posted By: Alb2tead
Subject: Displaying Multiple SubReports Vertically
Date Posted: 29 Oct 2015 at 10:52am
|
I have a report that has 10 subreports in it listed horizontally in the details. The data is used to show the productivity from each of the 10 areas in a count and the subreport is suppressed to just show the total for the user. When I export the data in excel, it lists the data vertically instead of horizontally. How do I get it to show columns, instead of rows. In the detail section it looks like:
Name Unit SR1 SR2 SR3 SR4 SR5 etc When I export to excel for better formatting it displays like: Name Unit SR1 SR2 SR3...etc. It pulls the data as intended, but the data is not displaying how I envisioned. Please Help 
|
Replies:
Posted By: hilfy
Date Posted: 30 Oct 2015 at 7:59am
|
Unfortunately, you can't. That's just how Crystal does the subreport export.
However, there may be a way to do this using a single command (SQL Select statement) in the main report instead of the subreports. If you don't have good SQL skills to do this, you can go to "Show Query" in one of the subreports and post here the query that it displays plus the selection criteria for each of the subreports and the query from the main report, I should be able to put something together for you. -Dell ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics |