Results 1 to 4 of 4
  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
    Posts
    11

    Cross-Tab

    u can accomplish this usnig Cross-Tab in crystal reports

  3. #3
    Join Date
    Dec 2004
    Posts
    11

    cross tab

    use cross tab in crystal reports

  4. #4
    Join Date
    Jun 2004
    Posts
    39
    I completed the above problem by cross tab .
    But I want add a Percentage formula Like this

    CPA Bank1 Bank2 Bank3 BAnk4 Total
    Rock 9999 9999 9999 9999 t1
    Com 9999 9999 9999 9999 t2
    Gem 9999 9999 9999 9999 t3
    Pla 9999 9999 9999 9999 t4
    Sla 9999 9999 9999 9999 t5
    TOTAL a1 a2 a3 a4 TOT a,t or number(int) only
    Per a1/TOT a2/Tot a3/Tot a4/TOT

    I wrote the formala but it is giving for each row or column
    Even when I kept the formula in summary field.
    Pls. help

Posting Permissions

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