Skip to Content
0

Two data filed in detail section

May 02 at 06:33 AM

16

avatar image

Hi,

I added product section in header and detail section of Crystal Report from one data table and now I want to add expenses column from another data table. When I added expenses data table in detail section, it creates a duplicate values and product automatically and also only one row of expenses data table or vice versa. Kindly help me to solve this problem. Regards,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Dell Stinnett-Christy May 02 at 02:39 PM
0

Also, if you have multiple expenses per product, you may want to group on Product, put the Product data in the group header and then put the expenses in the detail. Or if you want a single expense value per product, you'll sum the expense number by product and just put your data in the group header.

-Dell

Share
10 |10000 characters needed characters left characters exceeded
Rashid Mahmood May 02 at 07:16 AM
0

Also find screen shot of reports.


2018-05-02-3.png (163.6 kB)
Share
10 |10000 characters needed characters left characters exceeded
Rashid Mahmood May 02 at 07:18 AM
0

another screen shot


2018-05-02.png (174.4 kB)
Share
10 |10000 characters needed characters left characters exceeded
Rashid Mahmood May 02 at 07:19 AM
0

Last one


2018-05-02-2.png (169.2 kB)
Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
May 02 at 07:32 AM
0

Hi Rashid,

You'd need to verify the Joins between these tables.

Take a look at the SQL that CR generates and see if you're missing any joins or need to correct the existing join.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded