INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Question about a Cross Tab

Question about a Cross Tab

(OP)
I'm using Crystal 2011 and the report I'm writing is going to show the number of pieces shipped for a given part number. I wanted to insert a Cross Tab in the footer to show the part number and the total quantity shipped for that month. It works fine but the issue I have is the number of different part numbers shipped each month is pretty long so, I end up with a very long list at the end of each month. What I was wondering is can the Cross Tab be limited to the number of part numbers displayed? If yes then I could create a few Cross Tab's, one for each range. Something like 1 to 2, 3 to 4 and so on.

Thanks for all your help!

RE: Question about a Cross Tab

One approach would be to take advantage of Specified Order and Discard All Others which cam be used in a crosstab.
Lets say you wanted 4 cross tabs and weren't too fussy about the cross tabs having the same number of rows you could use the following technique.

Create four idential crosstabs with the part number on the row field and then your summary field.
(Copy and paste your first crosstab three times to save time.)
These crosstabs would be in the Group footer/header for each month.

Create four formulas.

So one first formula would look something like this:
if {table.partnumberfield} in 1 to 5 then 'include' else 'exclude'

Next formula would be
if {table.partnumberfield} in 6 to 10 then 'include' else 'exclude'

etc.

You will add the first formula to the first cross tab as the main row field (so you will need to move it up and use specified order choosing Include from the drop down. On the others tab you would choose Discard all others.
You need to then play around with suppressing and formatting to make it look presentable.

If there aren't any part numbers for 6 to 10 for Feb you will have a missing crosstab so this method can lead to ugly results.

Gordon BOCP
Crystalize

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close