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!

  • Congratulations bkrike 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: umag
  • Content: Threads
  • Order by date
  1. umag

    Saving output into multiple excel sheets

    Hi I am trying to explore different option available for my question. I have a report which runs every month on a scheduled time and saves the output into pdf and excel formats. This report has page break on primary item say company name. The pdf format is fine as I am giving page break on...
  2. umag

    suppressing rows

    Hi Gurus I have a question. I have a table which stores data like this. I receive entry for the same loan with all information same with latest effdt. loannum acctnum dbt_crt_cd amount effdt 300015360 132206 10 110500.00 08/22/2003 300015360 176294...
  3. umag

    database udf's

    Hi I want one database(informix) function to appear in impromptu to be used in preparing reports. It is not showing up. Can someone please tell me where am I doing wrong. I have done the following steps 1.created the function in informix database 2.added this function name and definition in...
  4. umag

    sub report with cross tab

    Hi Can someone please tell me why I am experiancing this problem. I am preparing a cross tab report and including list frame sub report into it. I am done with the development and getting the result what I want but PROBLEM is when I am saving it as pdf IMP application is crashing meaning imp...
  5. umag

    corresponding types must be compatible in CASE expr

    Hi I am using ImpAdmin 7.0 with informix DB. I have a problem here with if statement in one of the field of my report. Calculated field definition in report look like this if (flag = 'S') then (loanamt) else (0) impromptu throwing error as 'corresponding types must be compatible in CASE expr'...
  6. umag

    problem when change in datatype/data length

    Hi I have a catalog which was prepared sometime back but recently there are changes in database and some field lengths were changed and some datatypes were changed and my reports starts complaining. when I went into tables and verified them, those specific columns were invalid. how to deal with...
  7. umag

    stored procedure submitting as a database job

    Hi I am very new to sybase sql server and exploring things for doing some work on this. Can someone please tell me how can I submit a database stored procedure as database job. I have a stored procedure in database and I want to run that on database once in a hour. Thanks in advance Uma
  8. umag

    Hi I have a situation where I need

    Hi I have a situation where I need to prepare a report with sub-reports. Each sub-report is prepared from different table(preparing sub reports because these 2 tables cannot be joined). what I want is the elements of sub reports to talk each other like I need a calcuation which uses the element...
  9. umag

    joins

    Hi I am using Impromptu Adminstrator 7.0.702.0 I have a problem the way the impromptu parsing the joins. I am looking do I have any control about editing the join strategy? The situation is like this. I have 3 tables Table 1 key1 key3 Table2 key1 key2 Table3 key2,key3 is primary MY Join...

Part and Inventory Search

Back
Top