Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    39

    Unanswered: Urgent help for report required

    1)Table Sectype.Name
    CPA
    CPE
    CPAU
    CPEU
    Note: First Group by sectype name.

    2)Table Entity.name
    Rock
    COM
    GEM
    Pla
    SLA
    Ven
    apol
    Note: Second Group by entity name.

    Now each entity has different Deals in which some deals belongs to bank1 ,some belong to bank2 like that


    Sectype.Name ---> Entity.name -----> Deal1--->Bank1
    Deal2---->Bank1
    Deal3---->Bank1
    Deal4---->Bank2
    Deal5---->Bank3
    Deal6---->Bank4

    I had to create a report which looks like format

    CPA Bank1 Bank2 Bank3 BAnk4
    Rock 9999 9999 9999 9999
    Com 9999 9999 9999 9999
    Gem 9999 9999 9999 9999
    Pla 9999 9999 9999 9999
    Sla 9999 9999 9999 9999
    Ven 9999 9999 9999 9999
    Apol 9999 9999 9999 9999
    TOTAL

    Can you help, as to how can I do this and everything needs to be done in Crystal Reports.

  2. #2
    Join Date
    Dec 2004
    Location
    gujarat, india
    Posts
    32
    cross tab report will help you.

    Regards
    Zenil

Posting Permissions

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