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 TouchToneTommy 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: *

  1. RobReynolds

    Impromptu UDF LAG

    I have an Impromptu report off an Oracle database that uses direct SQL to retrieve a value from the previous row. Ex this query: select c1, lag(c1,1) over (order by c1) c2 from table; will return: c1 c2 row1 row2 row1 row3 row2 I would like to be able to use an Impromptu user...
  2. RobReynolds

    Number of Weekdays in Time Period

    Is there a way to determine the number of weekdays between 2 dates? Ex. Start Date End Date Weekdays 5-01-04 5-15-04 10 5-16-04 5-31-04 11 6-01-04 6-15-04 11
  3. RobReynolds

    Recreate Hotfile Report

    I've been using 2 hotfile reports to get billing rates from a billing database into a time tracking database. I am now trying to use Access to eliminate the first hotfile. I have rewritten the 2nd hotfile report using Access to combine the 2 databases. My problem is that if I save the new...
  4. RobReynolds

    Dynamically sizing a word wrap column

    Nagrajm, I've followed your suggestion. If I understood you correctly the height sizing will only apply to the comments field not to the header itself. The header row will only accept a specified height size not a dynamic size. So I would need to make sure my header row height as least as...
  5. RobReynolds

    Dynamically sizing a word wrap column

    I have an Accounts Revceivable report with a column for comments that is associated to the customer id. The comments column is a long datatype. I set the Layout of the comments field to multi-line with word wrap. The height size of the cell is set to dynamic. the report looks like: Cust Id...

Part and Inventory Search

Back
Top