Skip to Content

Two data filed in detail section

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • May 02 at 02:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 02 at 07:16 AM

    Also find screen shot of reports.

    Add comment
    10|10000 characters needed characters exceeded

  • May 02 at 07:18 AM

    another screen shot

    Add comment
    10|10000 characters needed characters exceeded

  • May 02 at 07:19 AM

    Last one

    Add comment
    10|10000 characters needed characters exceeded

  • May 02 at 07:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded