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 Chriss Miller 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. asrinath

    Calculating Percentages

    Hello All, I have a report which is grouped by a database column. The report calculates a count() for some items in the <field>Group:After Frame and also a Grand Total in the Report:After Frame. What I want to show with the report is a calculated percentage column of each <field> items over...
  2. asrinath

    Count of Rows

    Hello All, I have the following data in a table: Hours DOW ====== ==== 2307 Wednesday Group CreatedDate ===== =========== <GroupName> 2003-01-01 23:07:54.000 As you can see the Hours column is nothing but the Time in 24-hr format got from the Actuate function...
  3. asrinath

    Check for Duplicates

    Hello All, I am querying the S_SRV_REQ table and I need to eliminated duplicates from it i.e. if a SR_NUM has already been displayed then to not display the duplicate. How is this possible in Actuate? Thanks
  4. asrinath

    Check for nulls

    Hello All, I want to check for the existence of nulls in a database column and display Not Found if it is null. How do I do that using Actuate programming? TIA
  5. asrinath

    Format$(Date) in Actuate

    Hi, Can someone show me an example of the Format$(Date) command in Actuate? Can I assign the value returned to a variable? If so what should be the datatype? Please let me know. Thanks
  6. asrinath

    Daywise Hourly report

    Hello All, I need to created a report by each hour of the day for each day of the week (starting Monday). The hours will be the Page header and I need to calculate something by each day of the week. Is it possible to get the hour, day of the week from data somehow? If anybody has done anything...
  7. asrinath

    Problem with Actuate String

    Hello All, I am trying to execute this insert statement and I keep getting an error when I compile the report. What am I missing? <code> &quot;Insert into <tbname> (<col>,<col>,<col>,<col>,<col>, <col>,<col>,<col>,<col>,<col>,<col>,<col>,<col>,<col>, <col>,<col>,<col>,<col>,<col>) values...
  8. asrinath

    Inserting Report Details Into Another Database

    Hello All, Is it possible through Actuate to insert into another database the records generated by the report. I mean having 2 connections in the same report, one for getting records and the other for inserting records. Both Db's are SQL Server. TIA

Part and Inventory Search

Back
Top