Search results for query: *

Is there a way to use Crystal's native drag and drop functionality with CLOB data? We are beginning an upgrade to a newer version of software our company uses. The upgraded software will store the data in xml Clobs. Much of the original datastructure will remain the same but our custom fields...

That's amazing! I fought with that formula all day yesterday. It never crossed my mind to concatenate. Thanks for your help!

Further clarification... From the example above, I'm trying to get the following to show up: YTD Employee Average Total Charges Submitted:$296 (1480/5) This is with Crystal 10, Oracale 9i

I have YTD total, but cannot seem to get YTD avg from the MTD avgs. Groupings: Month>Supervisor>Employee Purpose of report is to show 1. Employee total $'s submitted for charges, 2. The supervisor's total $'s & Avg for all their employees and 3. Overall company total/avg per emp. The average...

I replaced CurrentDate with DataDate and it looks like it fixed it. Thanks for the help!

I grouped by CurrentDate -1, MTD and YTD - scheduled to run daily. When I look at the report that ran today it's good - showing all 3 groups. When I try to look at any previous day's report it only shows MTD and YTD. It no longer displays the single day group(it did when it was originally ran)...

I'm having a similar CurrentDate problem: I have a report that is grouped by CurrentDay-1, MTD and YTD. It runs fine for the day that its scheduled but when you go back to look at a previous day's report it only show MTD and YTD - the old CurrentDate -1 no longer shows up - but you can find that...