Search results for query: *

Hi! I'm running CE10, and I'm trying to connect to an Oracle 9 database via a secure SSH tunnel, but I'm having severe performance impacts (i.e. 3 of 4 connection attempts time out) and my SSH guy has offered to set me up with a connection via a HTTP proxy server instead of SSH tunnel proxy to...

I am running CR10 against an Oracle 9i database. I am trying to convert a report from excel that uses pivot tables into CR10 to produce a chart. Basically, I have data as follows: CloseDate TicketCount 1/2/2006 2 1/3/2006 3 1/5/2006 1 etc..... The pivot in excel is used...

I'm using a comma as a delimiter. But the wierd thing is that if I make the changes and hit update then tell it to run now,it'll work with the changes. However, If I just let it run for the normal scheduled run (most of these are 1x daily reports), the changes don't appear. Does the system cache...

Hello! I'm Running CE10 on W2k3 standard whic is using IIS to send the mails. I have created several reports that are emailed out using CE10's settings. The problem is that when I make a change to a scheduled report's email destinations, it doesn't always take. Sometimes, it'll work with the...

Hello! Using CR10 with Oracle 9i. I'm trying to create what I call a combo-chart. It basically has an X-axis that is common to two sets of data (i.e. month) and then on the left hand axis is on set of data and on the right is another. However, I need the data for the left axis to be...

Thanks for all your help, SantaMufasa and Wholesea. Got it working finally. I guess that I am in SEVERE need of the further training I have scheduled next month.... Thanks & Kudos!

Ok. Expanded my data set for clairification: sample data: SYSTEMID RESPONSIBLEENTITY FAILUREENDDATE TICKETNUMBER SYSTEM11 CENTERID 12/01/2004 111111 SYSTEM12 CENTERID 12/01/2004 111112 SYSTEM11 CENTERID...

Actually, you're relatively close. Maybe I can clarify better: Senario System11 has an incident on December 15. I then need to go back 30 days from December 30 and count the number of incidents (tickets). The result is 3 ( December 1, 15, and 30). Then System11 has another incident on January...

Well, you have a vaild point. I kinda got my point lost in everything. I apologize. My question is really, do I need to convert this to PL/SQL to get the result set I want? I do not know PL/SQL at all, and neither does my DBA. (Our original one left with no notice and we were just dumped into...

Hi! I'm a VERY junior DBA running 9i. I need to create a query that loops through a table and based on a condition returns the record. My scenario is I need take an ID and it's date (starting Jan 1 of each year) then goes back through the table again and searches the prior 30 days for other...

This is a sample of the table data: FAILUREENDDATETIME TICKETNUMBER TID 12/31/2004 19:39 026567A System A 12/31/2004 21:07 026589 System A 01/01/2005 06:45 008101 System A 01/01/2005 07:30 008102 System A 01/01/2005 08:17 026580B System B 01/01/2005 12:00 026560A System C 01/01/2005 13:05...

Well, the reason I'm doing this way is kinda hashed. Basically, we have a definition of a chronic problem: 3 or more incidents occurring in a rolling 30 day window. Once a system crosses the 3 incidents it is to be counted into a monthly total, so to simplify things, I'm trying to go back 30...

The following options work in crystal 10. Don't know what version you are running. Sometimes that is helpful. Have you tried going into the section expert and tell it to print the group 1 footer at the bottom of the page? Your other option is to go to the group 1 footer in the section expert...

Using Crystal Reports 10 on Oracle 9i. I have created a report that passes a date and a system ID to a subreport to for processing. In the subreport, I have created a (clumbsy I admit) record select formula that basically searches 30 prior to the record and to the end of the month the record...

Found the problem - good old google! The problem was Norton Anti-virus 2005. It thought the VPN client was a worm because it uses the same port as many of the email worms. So I went into Norton and turned off the worm protection (temporarily - until I reboot) and told norton to specifically...

Hi! Running Crystal 10 and Oracle 9i. I've created a subreport that pulls a record selection based on parameters from the main. Basically, what I'm doing is pulling a system name from the main and passing it to the subreport. The subreport then pulls other records for a different period of time...

Hi! Running Reports 10 against Oracle9i. I'm trying to find the most efficient way to calculate the following: 1)Pull the system ID for the systems that had outages yesterday 2) go back 30 days from yesterday and see how many of those systems had prior tickets during that time period. 3) if...

I'm having a similar problem to SamMoore. I'm installing a corporate pre-compiled version V04_60.51. I'm running it on Windows 2000 and XP. I've been trying to get it working again for the past year. The problem I'm having is I get the message "Waiting for Banner Message Text" then it times out...

Have you tried going to Database -> Select Distinct Records? This sometimes works.

Correction to above post: I am running crystal 10 on 9i via ODBC. I have now created the parameters listed in the paper by business objects and linked them into my subreport. However, now I hit the problem that the subreport isn't looping through the array. I do not need any new records in the...