Print Page | Close Window

Report Design

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22896
Printed Date: 29 Mar 2024 at 1:50am


Topic: Report Design
Posted By: shafiq
Subject: Report Design
Date Posted: 09 Sep 2020 at 1:49am
my table data are below

Head Dr Cr
1010 100 0
1011 200 0
1012 100 0
1013 0   200
1014 300 0
1015 0   100
1016 0   60

but i want to a crystal report design like as below

Head Dr    Head   Cr
1010 100   1013   200
1011 200   1015   100
1012 100   1016   60
1014 300

can any help??





Replies:
Posted By: kevlray
Date Posted: 09 Sep 2020 at 4:38am
So you want two columns?  Setting columns is slightly different depending on the version of Crystal Reports. For Crystal Reports 2016,   In the Section Expert for the details.  There is a check box for Format with Multiple Columns.  When you check that box, a new tab appears in the Section Expert called Layout, from there you can adjust the size of the columns.


Posted By: hilfy
Date Posted: 13 Sep 2022 at 12:28pm
Looking at this, it appears that you want one set of columns for the DR values and another for the CR values. If that's correct, here's what you'll need to do:

1. In the main report, add something like the following to the Select Expert: And {MyTable.DR} > 0

2. If you don't have a group in the report, group on something that has a single value throughout the report. Frequently, I'll create a formula that just calls CurrentDate and use it for this. The point is that we need a group header section for the subreport that I describe below.

3. Insert an additional group header section below the first one and put the column headers for your data in it.

5. Create a subreport that has the same data and Select Expert criteria as the main report but replace the reference to {MyTable.DR} with {MyTable.CR} and put the subreport in the first group header section to the right of the columns you've already configured. If you're using parameters in the Select Expert, be sure to create them in the subreport as well. Put the second set of columns in the subreport.   

6. Link the subreport to the main report based on the parameters - For each parameter you move to the top-right of the screen, select the corresponding parameter in the drop-down in the bottom left of the screen. This should automatically uncheck the "Select data in subreport based on field" checkbox, which is ok. This will make sure that you only get prompted for each parameter once.

7. Go to the Section Expert for the section where the subreport is located. Turn on "Underlay Following".

-Dell

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics



Print Page | Close Window