Results 1 to 4 of 4

Thread: CR9 - Design Problem

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Angry CR9 - Design Problem

    I have the Data in access like this:

    custID phoneNo PhoneType
    1 -----11236 ---LandLineOffice
    1 ------98685 ---Mobile
    2 ------98675 ---Mobile
    2 ------22357 ---LandlineResi
    3 ------22567 ---LandLineOffice
    3 ------223554 --LandlineResi
    etc.. (dotted lines dont exist)

    In the report I want in this format

    CustID Mobile Land Line Office Land Line Residence

    There is more if the LLOff/LLRes/mob is empty no line must be left empty.
    so in the above eg I should get:

    CustID Mobile Land Line Office Land Line Residence
    1 -----98685 --11236
    2 -----98675 -----------------22357
    3 -----------22567 -----------223554
    dotted lines not reqd
    could somebody help me find a solution

  2. #2

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Question Re: CR9 - Design Problem

    folks you haven't got a solution yet

  3. #3
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: CR9 - Design Problem

    Add 3 Detail Sections.
    1) Place the CustId, Phone # field. Suppress If PhoneType <> Mobile
    2) Place the Phone # field at the appropriate place, Suppress if PhoneType <> LandLineOffice
    3) Place the Phone # field at the appropriate place, Suppress if PhoneType <> LandLineResi

    For Detail Section 1 and 2, set the section option Underlay Following Sections.

  4. #4

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Re: CR9 - Design Problem

    Thanks Bruce but the problem continues...
    eg. A customer has both LLR & Mob then the data comes out as
    custID LLR LLO MOB
    1------123
    ---------------555
    see the second phone is printed in the next line
    But the requirement is..

    custID LLR LLO MOB
    1------123----555
    All phones must come in the same line

    Note:
    1. I put the custID only in the details a section and set it to supress if duplicated.
    2. phone LLR is in details a with necessary suppress as suggested by you
    3. phone LLO is in details b with necessary suppress as suggested by you
    4. phone MOB is in details c with necessary suppress as suggested by you
    Underlays of a & b done

Posting Permissions

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



Click Here to Expand Forum to Full Width