Cross tab with 2 unrelated rows

[lalous33]

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]

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

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

 

[Madawc]

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

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.

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

 

[lalous33]

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]

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.

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