INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

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.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Your site is one of the cleanest and BEST forums that I have seen. I have sent quite a few people your way. Keep up the good work!!!"

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Reporting Solutions > Business Objects: Crystal Reports 4 Other topics Forum

Cross tab with 2 unrelated rows

Read More Threads Like This One

lalous33 (IS/IT--Management)

20 Jun 12 11:00

Hello,

I am new to Crystal Reports and I am trying to create a cross tab with 2 unrelated rows. To be more precise, I have a DB in which every entry represents a problem or an issue. Every issue has an open date and a closure date. I would like a table that would count the number of opened and closed issues each month....Any ideas of how I can achieve this??

Thank you!!

Madawc (Programmer)

26 Jun 12 6:58

Two different quantities? Depending on your version of Crystal, you can sum two different fields in your crosstab.

yinyang Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP yinyang

Madawc (Programmer)

26 Jun 12 7:02

To sum occurances of a date, you'll probably need first to do a formula field with a value that can be summed. Something like

Quote:
if not isnull ({open.date})
and {open.date} >= {@StartDate
and {open.date} <= @EndDate]
then 1
else 0

Something similar for closed.

It always helps to give your Crystal version - 8, 8.5, 9, 10, 11, 2008 or whatever. Methods sometimes change between versions, and higher versions have extra options.

I've used two posts and Quote rather than Code because it was unexpectedly failing. I'll be reporting it as a technical problem with the site.

yinyang Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP yinyang

lalous33 (IS/IT--Management)

26 Jun 12 10:53

Thanks for you reply! I have tried something similar but my problem is that I can't manage to put "created issues" and "closed issues" on the same level. I want to display the created and closed issues in 2 separate cells. So the first row of the table would be the months of the year (e.g. May 2012, April 2012,...), the second row would be number of created issues, and the third row would be number of closed issues. (I am using Crystal 11)

Thanks again!!

Madawc (Programmer)

27 Jun 12 4:39

When asking a question, you should explain what you've already tried. Saves time for everyone.

If you can't associate the two sets of data, you'll have to do a Mock Crosstab, use SEARCH to get details. Or if you use SQL and can write and run your own, create an SQL Command that will collect the data and present it ordered as you need it.

yinyang Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP yinyang

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!

Back To Forum

Back To Business Objects: Crystal Reports 4 Other topics

Member Login

Come Join Us!

LINK TO THIS FORUM!

Tek-Tips LinkedIn® Group

Partner With Us!

Feedback

Geography

Tek-Tips Shirts!

Cross tab with 2 unrelated rows

Quote:

Reply To This Thread

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

Back To Forum

Join Tek-Tips® Today!

Tek-Tips LinkedIn^® Group

Join Tek-Tips^® Today!