Search results for query: *

In the count summary, first summary,I right clicked on the field- count of tablename.days_opened, clicked format field, in the common tab, in the x-2 button under Suppress if duplicate area, and entered this formula. (I did not check the checkbox for this) whileprintingrecords; numbervar curr...

lbass, This is what I did. The first summary-separate from the 2nd, which still contains the count of days_open with the formula you provided, whileprintingrecords; numbervar curr := currentfieldvalue; false The second summary-which is completely separate from the first one, which...

I have tried to use decimals but it reverts back to Decimals being at 1 instead of 1.0000. I just don't understand.

I have a cross tab report in CR 9 that shows the following data including percentage symbol and position -123%. Turnaround Time Total Days Percentage # of Days 45 8% # of Days 215 40% # of Days 108...

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

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...

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...

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...

I wonder if you can modify the view to add a value to the specific Days Open field "Pending Resolution" but not change the database?? I tried this but I am getting an inconsistent datatype error. Case when wo.cleared_datetime is null then '0' else wo.cleared_datetime end...

Hmm..I tried this before but I put the formula in the Group Footer before. See above. I tried this now in the report footer and it shows False. That's also what happened before. I tried an individual formula's for one of the totals that I need and it still shows up False. I also used the same...

I am sure am but it only shows up with a fresh report(without groups, parameter dates, etc.--(Of course the items I need have to are not allowing it from showing up.)) See below. These amounts are for every work order- I need to be able to group by Creation Date and have date parameters so my...

Thanks. I tried this and I still get the same result. I also tried not to have the Cross Tab show up in the Group 1 Footer where I need it and allowed it to show up in the Report Footer. It all shows up but of course I need it to be for the group and not for everything. I have it grouped by...

I just noticed that in the Browse Data button in the Cross Tab Expert it shows all the fields in Days Open but I am just not sure why its not showing it when it gets to the report. I know that March has Pending Resolution in it. AHHH...

Here is an example of the logic used in the view for Days Open. CASE WHEN ROUND (wo.CLEARED_DATETIME - wo.created_datetime, 0) < 1 THEN 'Under 1 Day' WHEN ROUND (wo.CLEARED_DATETIME - wo.created_datetime, 0) >= 1 AND ROUND (wo.CLEARED_DATETIME -...

I sure did- that's why I figured that it would show up fine. The database hasn't been changed and the view appears to be correct(it gives me everything I want to see). I started off with a new view, validated the code, ran the view(that's how I got the example data), and created a new Crystal...

Soo.....now- I had to add another field in the Days Open field called Pending Resolution. In the view, I had to change the logic of Days Open to compare the Cleared Date to Created Datetime. Since this field accounts for work orders that are still open, it shows that there are some work orders...

I believe this is exactly what I need. Thank you all so much. I may have more questions but so far so good. [2thumbsup]

*******I tried this but I get a False result when I put the formula in the Group Footer. {RPT_TT_DTPARA.DAYS_OPEN} = 'Under 1 Day' and {RPT_TT_DTPARA.DAYS_OPEN} = '1-2 Days' and {RPT_TT_DTPARA.DAYS_OPEN} = '3-7 Days' and {RPT_TT_DTPARA.DAYS_OPEN} = '8-15 Days' and {RPT_TT_DTPARA.DAYS_OPEN} =...

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...

Thank you for indicating to me where I need to go. I was not aware that you could get the SQL query that way. SELECT "UNM_RPT_WK_ORDS_TUTI"."PREORD_NUMBER", "UNM_RPT_WK_ORDS_TUTI"."COMPLETE_DATE", "UNM_RPT_WK_ORDS_TUTI"."CREATED_DATE" FROM "PINN_CUSTOM"."UNM_RPT_WK_ORDS_TUTI"...