How to restrict the data showed in a column?

building reports crystal reports
1

Hi,

I’m new in Crystal, I have the data from the database as:

APP_ID, STATUS, DATE
011 NEW 01/01/2009
022 NEW 02/01/2009
033 OLD 03/01/2009

I want to show in the report a cross-tab table but without using the cross-tab option from Crystal:

Date # of APPS by STATUS for example

Date | NEW | OLD
01/01/2009 | 1 |0
02/01/2009 | 1 |0
03/01/2009 | 0 | 1

Is there any way to use a where clause in the column like in WebIntelligence. For example, in the column new use a Count(APP_ID) where STATUS = ‘New’?

Thanks,
Luigi

luigif :australia: (BOB member since 2006-09-07)

2

That looks like just two formulas:

New Data: If <command.Status> = ‘NEW’ Then 1 Else 0
Old Data: If <command.Status> = ‘OLD’ Then 1 Else 0

Then use New Data and Old Data on the report.

BDeLong (BOB member since 2008-01-15)

3

Hi BDeLong,

Maybe I didn’t explain myself properly. I have several rows in the data containing dates, application codes and status. I need to create a cross-tab table that shows how many application I have by dates and status. Dates as rows and status as columns, how ever I need to create and extra column at the end to calculate a % between values of an expecific status against the total. Because the body of the cross-table is a count, I can’t see decimals in the new calculation (coutn of application for a specific status/total count of applications). Additionaly I need and extra row at the bottom of the table to calculate the daily average. The data will be grouped by months and I need to calculate the total count of calculation in a month / number of dates in that month. I can’t get the report to show me the number of dates in every month. If I use distinctcount(dates) I get the total number fo dates even if the cell is in the group.

Hope you can help me with this.
Luigi

luigif :australia: (BOB member since 2006-09-07)