Solved

crystal report horizontal data with title on left

Posted on 2014-03-06
5
1,578 Views
Last Modified: 2014-03-12
In crystal reports 2011 I need to display data horizontally with the  row titles on the left.

I can display the data horizontality by using the Section Expert for the detailed section and selecting Format with “Multiple Columns”, then in the layout the size and direction are specified.

The problem is how to display the title on the left and have the data aligned correctly.


Data presentation
SEE the enclosed word document for the data,examples, screen shots.

-------------------------------------------------------------------------------------------------------
Crystal-horizontal.doc

--------------------------------------------------------------------------------------------------------
Thank You
Paul
0
Comment
Question by:fpkeegan
  • 2
  • 2
5 Comments
 
LVL 22

Expert Comment

by:Ido Millet
ID: 39910932
Use a Subreport or a Crosstab.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39911005
I agree a crosstab would be the way to go.

Row would be the title field
Columns would be the a field in the record that separates the data into the appropriate columns
The summary would be the value field

mlmcc
0
 

Author Comment

by:fpkeegan
ID: 39912144
This is a subreport. Subreports can not have subreports. I haVe never done a cross tab report. Detailed directions with screen shots would be helpful.
0
 
LVL 22

Accepted Solution

by:
Ido Millet earned 500 total points
ID: 39912270
If it's a subreport, you can place the desired legend on the main report (to the left of the subreport in your case) to create the desired effect.
To learn how to create a CrossTab, one option is to google: youtube Crystal crosstab
You would find several video tutorials.
0
 

Author Closing Comment

by:fpkeegan
ID: 39923948
nned a more detailed answer.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

832 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