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

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