Recent content by khdavis

Hello All! I need to create a crosstab report with output as follows: JAN 2013 FEB 2013 ETC... Tickets Opened in Month 500 400 Tickets Closed in Month 650 300 Simple enough, except my problem arises as Tickets Opened in Month is based on the...

I have a zip archive with XML files that appears to be from Excel. I need to convert this to CSV, ...pronto. Can you tell me how to open this archive with Excel or another tool so that I may convert it to *.CSV?

Yes there are BLOBs in the fact tables. Don't know why the database was set up that way. I am using database only processing. I did try using limited local previously but that didn't resolve the issue. I will try using the cast.

In FM 8.2, I have 6 tables in a database view. I've created my joins there also. Tbl1 (Fact table) Tbl2 (Fact table) Tbl3 (Fact table) Tbl4 Tbl5 Tbl6 Tbl1 joins to each of the other 5 tables. When I create a business layer and try to add query items I get the following error: BMT-MD-0003...

I have 2 date/time fields that I'd like to subtract and have the output displayed in hours. Any suggestions would be greatly appreciated?

Thanks to all for the help! I was able to get the solution by just modifying the formula lbass had provided for a previous earlier issue. =============== stringvar array x := split({T3450_1.C536870923},chr(03)); x[ubound(x)-1] ===============

I posted a string splitting issue earlier today that lbass was able to assist me with (thanks again lbass!) and am hoping someone can help me again with this new one. Below is an example of the type of string I need to split. I need to extract the last entry which would be everything after the...

Thank's lbass. That worked for me!

Hi All, I'm using CR10/Oracle database and trying to extract the last part of a string that looks something like this -- C:\Documents and Settings\bha\My Documents\Problem Management\FINAL\2763213 AIG Europe AIU PARSEXC2 FailedArray.pdf I need to get everything after the last "\" (basically...

Hi, I'm using CR10 with an Oracle database. I need to split a field where the elements are separated by a carriage return (Chr(13)). I'd like to be able to split this field into it's individual elements and then group by each element. The field can have any number of elements by probably not...

HI! I using Crystal 10. Database is Oracle. (My Crystal is not very advanced so please bear with me.) I'm creating a chart that's needs to include a line that would reflect the daily average for the entire reporting period. My data includes the following: Ticket# Criticality Start Date The...

lbass, thanks for responding. You're right for the part based just on the counts as I discribed in the original post. In my haste (and I apolize) I forget the second part of the equation... Name # Avg Repair Time Server 1 10 72.12 Server 2 15 63.99 Server 3...

Hi All! I'm using CR10 and have a Top 10 question that has me totally stumped! I'm doing a Top 10 report based on a group summary count. That part's easy enough. However the client has now asked to only include groups where the sum is greater than 1 AND still give a Top 10 count. I'm able to...

Thanks for your help! I was able to use the crosstab. I also used the info you provided in another thread to add the row labels and it worked great! Thanks again!!

Additional information: I'm querying an incident management database (Help Desk tickets.) Total SEV1s = Count of tickets opened in week (field) Total Users = Sum of Users Affected (field) Total Bus Impact = Sum of Bus Impact (field) Total Impact Dur = (Calculation) I need these numbers for...