Search results for query: *

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

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

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

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

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

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

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

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