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

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

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

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

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 am streamlining a daily report that shows a rolling weekly snapshot. When I initally created it I was getting the following (abbreviated for clarity) @Day1 @Day2 @Day3 Ticket1 Ticket2 Ticket3 Ticket4 Ticket5 Ticket6 Ticket7 Ticket8 Ticket9 Ticket10 Ticket11...