Search results for query: *

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?

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?

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

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

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

Hi! Can anyone offer assistance? I'm using Crystal 10 connecting to an Oracle database. I need to create a month to date report, grouped by week. Each week the report runs would add an additional week of data to the report until the end of the month. I've been unsuccessful getting it to work as...

Hi All! Hope someone can help... I'm using Crystal 10. I have a report I'd like to schedule so I can't use parameters. When the report runs it needs to pull in data from the previous Thursday, 8PM to the current Thursday, 8PM. For instance, if the report runs Friday(6/10), it's pulls in data...

Hi All! I really hope someone can help me. I need to develop a report based on year-to-date data, grouped by week. For each week I need to count the number of open problem tickets. For instance, if the report runs today and includes a problem ticket that's still open that was originally opened...

Hi! I'm hoping some of you will share your experience with me. QUESTION - What kind of background is most beneficial to get the most out of writing the more complex Crystal Reports? I'm specifically interested in learning if a programming background is needed what languages, etc. I've been...

I thought this would be simple but I can not get this to work at all. I'm trying to graph on a formula that results in a percentage. I'd like to have - Y axis - 0 - 100% (0, 10%, 20%, etc) X axis - percent values How can I do this or is this even possible? Thanks in advance.