Crystal Reports- Count of Data in Field 1

[oxygen101]

Crystal Reports 9

I am evaulating how many days a work order is open for. I have a field of data called Days Open. In Days Open there are a number of values that can be possible(ie. 1-2 Days, 3-7 Days, 8-15 Days and etc.) I need to be able to count each of these instances. I tried using Count(Days_Open) but of course it give me the total amount and not the individual counts.

Anyone have any ideas?

Thanks much.

 

[solmskid]

oxygen101,

********************************
*****I need to show this-

Total
1-2 Days 43
3-7 Days 6
8-15 Days 1
Under 1 Day 64
Pending Resolution 33
Total 147
********************************

You could create a group for {views.days-open}, insert a summary(count) of wo-number and place it on the group header,suppress the detail section and the group footer, insert a summary(count) of wo-number for the report placed on the report footer, suppress page footer. The results should look like your example. Good Luck.

 

[lbass]

I suggested the running totals because not all instances of the field necessarily existed in the data.

-LB

 

[solmskid]

The group count thing was just a suggestion, as usual I misinterpreted the request. Reporting on null sets would require a bit more logic.

 

[oxygen101]

Both the running total and the group count are great ideas and are partly working for me. My big problem is the null values. They are still not showing up and I need to account for them. I am trying to figure out a way to alter the view to add a value to cleared_date when null but not change the database. I am not sure if that is possible. This way-the logic is already in the view and when Crystal runs the report it thinks that there is a value there- I just need to count them. Any ideas? Thanks again to everyone.

 

[oxygen101]

I could really get upset with my self right now. :-D The cross tabs are excellent and work great. I had an issue with my parameter dates that I was using which caused the null values not to show up. Wierd but that was the problem. Everything shows up great, see attached. Thank you again and have a wonderful weekend!!!

Total Days Count
0-1 Days 58
1-2 Days 44
3-7 Days 8
Over 16 Days 3
Pending Resolution 54
Total TT Count 167

 

[oxygen101]

Okay- so one more issue. I am getting a few errors now: 1. Failed to open a rowset, 2. ORA-03114: not connected to ORACLE, and 3. Not Supported, Details: Fail to execute SQL statment errors when I try to Preview my report now. This is what I believe caused this. I modified my view through the database and then I went to Database, Log On or Off server to update the view into Crystal. This worked for me the other day and now I don't know what happened. Now I can't get it back. I even closed down Crystal and started fresh with a new view and I am still unable to connect. What happened? Any ideas? I tried Log On or Off server and logged back in but it still is not working. I also tried to view another report and that one does not work either... what have I done? ahhhh....

 

[oxygen101]

Okay. I figured out that using Max(complete_date) is causing a few issues for me. Now onto new issues.