Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can this table be created using Cross-Tab?

Status
Not open for further replies.

marc79

Programmer
Apr 5, 2005
18
PH
Hi Guys,
I need to find a way to implement the following table but i'm not sure on how to go about this since i'm still very new to Crystal Reports.

For example:

NUM_CASES | JAN | FEB | MAR |
------------------------------
8 | TN1 | TN1 | |
------------------------------
7 | | | |
------------------------------
| TN1 | | |
| TN2 | TN1 | TN2 |
6 | TN3 | TN3 | TN3 |
------------------------------

The NUM_CASES column always is fixed, ie, 6, 7, 8 should always be displayed even if they don't contain any telephone numbers. I've been looking at using a cross-tab but ran into some problems. Is using a cross-tab the right approach since i read that it's just used for summarizing and calculating totals. However, i don't need to summarize anything, i just need to list the telephone numbers by Number of Cases and do that for each month.
Thanks for any insight into this.
 
I'd manually create it.

To get proper assistance, post your software version, the database, and example data that comprises this *table*.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top