Results 1 to 3 of 3

Thread: Crystal Report Design Problem.

  1. Sep 18th, 2003, 09:31 PM #1
    solar115
    solar115 is offline

    Thread Starter
    Hyperactive Member solar115's Avatar
    Join Date
    Apr 2002
    Location
    Thailand
    Posts
    268

    Crystal Report Design Problem.

    I have some problem when I try to design some report by use Crystal Report. My problem is happen on Detail Section. I will tell about information first.

    My Database is contain some data like this

    ProductId/Amount/Members
    A00001/350/N
    A00001/350/Y
    A00002/500/N
    A00003/125/N
    A00004/300/N
    A00004/300/Y
    A00005/75/Y

    I want to report something like this

    Non-Member
    A00001 350
    A00002 500
    A00003 125
    A00004 300
    TOTAL 1275

    Member
    A00001 350
    A00004 300
    A00005 75
    TOTAL 725
    DISCOUNT 72.5


    GRAND TOTAL 1927.5

    How can I do it?
    ^solaris^
    Reply With Quote Reply With Quote
  2. Sep 19th, 2003, 08:36 AM #2
    Ken Bradford
    Ken Bradford is offline
    Addicted Member
    Join Date
    Apr 1999
    Posts
    178
    Insert a group, group on Members.

    Insert a formula in the group header to replace the 'Y' and 'N' with "Member" and Non-Member".

    Add a subtotal on Amount in the group footer.

    Also search crystal help using "Group" as the keyword.
    Reply With Quote Reply With Quote
  3. Sep 19th, 2003, 09:19 PM #3
    solar115
    solar115 is offline

    Thread Starter
    Hyperactive Member solar115's Avatar
    Join Date
    Apr 2002
    Location
    Thailand
    Posts
    268
    Thank you.
    ^solaris^
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width