Search results for query: *

When doing an export of the problem file, the data/time fields within the middle structure are coming across blank. I have no ideas as to what is causing this. Our version is old. It's SC5.01 with A9901. Any ideas or suggestions would be greatly appreciated.

We are using SC5.01 with A9901, it's old, I know. We are having a problem where we cannot view the task record from within the Change record or from the task queue. If I click on the task from the change record or the task queue, I get an error that says " There is no task record to satisfy...

I have a report which consists of 3 queries. I have 1 repeating frame with 2 other repeating frames inside it, 1 on top of the other. On top and outside of each of the 2 repeating frames is a label/heading from each group. What happens is, if there is not data from either group only the label...

We are using Reports 6i. I have a report for contact information which shows the address in below format. The problem is that if the value of any of the fields is null I do not want a blank line. The fields are all in the R_CONTACTS repeating frame. I set the conditional format for each...

I am creating a report that needs 3 sections. For each airline ,I need to show the contacts & their information and then the airports the airline is operating. AA American Airline Contact Information Marie Smith 555-1212 123 Main St John Doe 765-4321 456 South St...

First we are using Service Center V5.01 with A9901. When at the apm.quick form opening a problem ticket, we have a field called 'site'. We open problem tickets for sites and not contacts. There is a link record from the 'site' field to 'site.code' field in the 'siteinfo' file. For each site...

Does anyone know how to remove the carriage return from the evaluating expression in the macro. I have the below expression to create my message. The problem is that the 'GMT' is showing on the next line. $message={"SNS/SMS system test, opening "+tod(), "GMT"} Thank you in advance. Denise

Hello.. We are running Service Center V5.01 on A9901. On our apm.quick form for opening a problem ticket we have a link record from the 'site' field to a 'site' field in a 'siteinfo' file. In that 'site' file there is an array field called 'products' which stores all the product services used...

All, I am using TOAD on and Oracle 8i database. I have created a sequence called seq_loc_id. Now I need to implement that sequence into an existing table. I'm not sure how. My table is ops_locations. There is a column called pk_loc_id. There is currently no data in this table. Can I...

Hello.. We are using reports 6i with an 8i database. I have 1 report that when you click on a link on the report it calls a 2nd report. I'm trying to pass 2 parameters in the url but I cannot seem to get the syntax correct. What I have is: srw.set_hyperlink...

Hi.. We use Reports 6i on an 8.1.7 database on Windows. I have to write a report for the following; For each airport I need to show airport code, airport name, contract type, phone number, technician names. There is multiple site types and multiple technicans for each airport. I want the...

Hello All, I'm trying to calculate the time difference between 2 datetime fields. Field 1 is open_time Field 2 is close_time, both are datetime fields. I need to calculate the time difference between close_time and open_time in days and minutes. If I do: select (close_time-open_time)...

Hi.. I have a report that when you click on one of the fields it calls a drill down report using the srw.set_hyperlink in a format trigger. I need to add a balloon help on that field to say 'Click here to see customer information'. Can anyone tell me how to do that? Thank you & Brgds, Denise

I have an Oracle Report that is displayed on our web page. 1 particular report is sorted by customer and it is a long report because it shows all customers. Is it possible to ad an alphabetical listing on the bottom of the report, so that the end user can click on the letter and go directly to...

Hi All, I need to write a summary report that includes only summary information regarding the trouble tickets handled in our support department. I am able to write a query for each separate total I need but I'm not sure how to get it all together on 1 report. For example, 1 report I need is...

All, Is there a way that I can have a field update automatically when the status changes. I added 4 new logical fields to the problem file, (alert1.flag, alert2.flag, alert3.flag and deadline.flag) When a problem ticket reaches alert stage1 I want the alert1.flag field to become 'T'if it's...

I send emails from macros for certain problem tickets based on the category type and length of time they are open. I now need to break it down further and send the emails to different people based on the region the customer is located. My macro is now not working after my changes. Working...