Talk with the Author
 Crystal Reports Forum : General Information : Talk with the Author
Message Icon Topic: Report Design Post Reply Post New Topic
Author Message

Joined: 05 Sep 2020
Location: Bangladesh
Online Status: Offline
Posts: 1
Quote shafiq Replybullet Topic: Report Design
    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??

Edited by shafiq - 09 Sep 2020 at 1:49am
IP IP Logged
Admin Group
Admin Group

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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.
IP IP Logged
Admin Group
Admin Group

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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".

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.