Recent content by tbear6602

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