Question

Cross-Tab, matrix, or some other format

Rating9.6Excellent

I am trying to create a cross-tab or matrix report that looks like:
Agency/Division        Primary contact                                  Second contract
Agency1/Division1    Mickey Mouse (555-555-5555)         Donald Duck (555-555-5555)
Agency1/Division2    Santa (555-555-5555)                         Mrs. Claus (555-555-5555)

For each request for an FltID, display the State_agencies.agencyName, requests.division, contacts.firstname, contacts.lastname and contacts.phone in columns delimited by contacttypes.typedescription.

My database structure is:
Requests:
Name                                      Null?    Type
 ----------------------------------------- -------- ---------------
 REQID                                     NOT NULL NUMBER(10)
 FLTID                                     NOT NULL NUMBER(10)
 AGENCY_NUMID                              NOT NULL NUMBER(3)
 DIVISION                                           VARCHAR2(50)
 TOTALPAX                                  NOT NULL NUMBER(2)
 PAYLOAD                                            NUMBER(4)
 NOTES                                              VARCHAR2(250)
 SGUID                                     NOT NULL CHAR(32)
 NOLONGERGOING                             NOT NULL NUMBER(1)

Contacts:
Name                                      Null?    Type
 ----------------------------------------- -------- ---------------
 CONTACTID                                 NOT NULL NUMBER(10)
 REQID                                     NOT NULL NUMBER(10)
 TYPESID                                   NOT NULL NUMBER(1)
 FIRSTNAME                                 NOT NULL VARCHAR2(30)
 LASTNAME                                  NOT NULL VARCHAR2(30)
 PHONE                                     NOT NULL VARCHAR2(12)
 EMAIL                                              VARCHAR2(50)

Contact Types:
Name                                      Null?    Type
----------------------------------------- -------- -------------
TYPESID                                   NOT NULL NUMBER(10)
TYPEDESCRIPTION                           NOT NULL VARCHAR2(25)

State_agencies
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------
 AGENCY_NUMID                              NOT NULL NUMBER(3)
 AGENCY_CHARID                                      VARCHAR2(3)
 AGENCY_NAME                               NOT NULL VARCHAR2(40)

How do I display the information in a cross-tab or matrix format?

See More

Solution

Access this solution immediately by signing up as a member of CrystalReportsExperts.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.

About this Solution

Sign up Now to View This Solution
Zone
general
Tags
Participating Experts
1
Solution Grade
A

Replies

 
by:

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: wykzimme

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Log In

Forgot your password?Sign up

Stay Connected

Top Experts

  1. mlmcc

    354,274

    Wizard

    0 points yesterday

    Profile
  2. James0628

    78,896

    Master

    0 points yesterday

    Profile
  3. LinInDenver

    4,800

    0 points yesterday

    Profile
  4. peter57r

    4,000

    0 points yesterday

    Profile
  5. 13598

    3,520

    0 points yesterday

    Profile
  6. PCIIain

    1,700

    0 points yesterday

    Profile
  7. RickIsWright

    400

    0 points yesterday

    Profile
  8. Dan3D

    300

    0 points yesterday

    Profile

BrowseAre you an Expert?