Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sitadba
  • Content: Threads
  • Order by date
  1. sitadba

    Date fields not exporting blank from middle structure

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

    Problem view Tasks from the Change record

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

    Conditional Formatting on a heading

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

    Vertical Elasticity

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

    Grouping in Reports Builder

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

    How to limit qbe results based on a field value

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

    Macro Evaluating Expression Question

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

    Link Record Expression

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

    Sequence Numbering Question

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

    Passing 2 parameters in a url to call 2nd report

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

    Help with Groupings

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

    Calculating Time Difference in Oracle

    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)...
  13. sitadba

    I need to add a Balloon Help on a field in a report

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

    Quick 'Go To' link within a report

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

    Reporting Summary Data

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

    Automatic field update

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

    Macro Condition Question

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

Part and Inventory Search

Back
Top