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

    Single SQL for Multiple Squential Reports

    The sample report in the C:\Program Files\Actuate7SP2\ErdPro\Examples\DataAccess\ReuseQuery folder might help you. -- JB
  2. johnberchmans

    Supressing Content Rows

    Please try this to see the BuildFromRow in the Methods list: 1.Double click the frame in the structure pane, to open Component Editor. 2.Click Methods tab. 3.Click Filter (at the bottom). 4.Select 'Show all methods' and click OK. Now you will be able to see BuildFromRow in the list. -- JB
  3. johnberchmans

    Supressing Content Rows

    You can override the BuildFromRow method of the frame and based on the condition set the height of the frame to zero. I hope this helps. -- JB
  4. johnberchmans

    Populating the Report Sideways:

    You have to override MakeContents() method of the frame(s) and create controls dynamically. A sample report from Actuate can be found at C:\Program Files\Actuate7\eRDPro\Examples\Programming\DynamicContent\DynamicLeftToRightFlow. I hope this helps. -- JB
  5. johnberchmans

    Conditional Page Breaking:

    You can try this: 1. Create a local variable in the group section component to hold the value of Portfolio. 2. Override OnRow() method of the group section and assign the value of Portfolio from the datarow to the local variable created in step (1). 3. Override PageBreakAfter() method of the...
  6. johnberchmans

    Maximum Value of Computed field

    You can try this: 1. Create a double control in the After Slot frame to hold the Max value. 2. Create a static variable called MaxCount in that control Name: MaxCount Type: Integer Storage: Static Visibility: Public 3. Specify Count() in the ValueExp property, to find the number...
  7. johnberchmans

    Grand Total IntegerControl

    You can try this: 1. Create a double control in the After Slot frame to hold the average value. 2. Create a static variable called NullCount in that control Name: NullCount Type: Integer Storage: Static Visibility: Public 3. Specify Count() in the ValueExp property, to find the...
  8. johnberchmans

    Count Null Column

    You can use the following Actuate Basic functions or Component methods to count the number of NULL datarow variables. 1. GetVariableCount(DataRow) -- to find the number of datarow variables. 2. Function GetValue( index As Integer ) As Variant of the datarow. 3. IsNull(<expr>). ***** Dim i as...
  9. johnberchmans

    Top N results

    Since you get the data from the query already ordered, assign N (Top N) to the FetchLimit property of the datastream. i.e. if you want to show Top 10, assign 10 to the FetchLimit. To make it better, you can create a parameter for Top N, then use that parameter in the FetchLimit property...
  10. johnberchmans

    Linking Parameter to Where Clause

    Sorry I did not locate it earlier. When the statement WhereClause = WhereClause & "glacct like" & "66" & "*" is processed, the line will look like glacct like66* I think it should look like and glacct like '66*' i.e. 'and', some blank spaces and single quotes are missing. -- JB
  11. johnberchmans

    Linking Parameter to Where Clause

    If Location is the name of the parameter then the statement If ("Location"="CA") Then should be If (Location="CA") Then without the double quotes surrounding Location. I hope this helps. -- JB
  12. johnberchmans

    Barcode in actuate

    You can google to find where the Code 128 fonts are available. -- JB
  13. johnberchmans

    Regarding Actuate APIs

    There is RSAPI (Report Server API, written in C/C++) and IDAPI (Information Delivery API, SOAP based). Actuate recommends the users to use IDAPI. If you install ServerIntTech from Actuate Server CD, you can find all the documentation. I hope this helps. -- JB
  14. johnberchmans

    Barcode in actuate

    You have to specify a BarCode font name for the Font.FaceName property of that label control. Then specify the text that will be shown as BarCode. I hope this helps. -- JB
  15. johnberchmans

    Hyperlinks

    If the link expression contains hyphen (-), then the link will not work correctly, because hyphen (-) is treated as a range operator. You can try this: 1. Use Actuate Basic StrSubst function, or any other custom function, to replace the hyphen with any other character. It can be done in the...
  16. johnberchmans

    Formatting Dates from parameter values

    I assume data type of param_start_period is date. You can use format function as follows: format(param_start_period,"dd-mmm-yyyy") I hope this helps. -- JB
  17. johnberchmans

    SUM DISTINCT

    Yes, there is. The expression should be of the form: Sum( <DataRow Variable> ) Distinct( <DataRow Variable> ) I hope this helps. -- JB
  18. johnberchmans

    Use of Null Instance Handle

    You have declared outputRow with Dim statement. You have to initialize it with Set outputRow = New DataRow1 Place the above statement wherever it will be correct logically. I hope this helps. -- JB
  19. johnberchmans

    Actuate eReporting version 6

    You can use format function to add the date to the filename as follows: sFilename = "C:\cheque " & format(Date, "MM-DD-YYYY HH:NN") & ".txt" I hope this helps. -- JB
  20. johnberchmans

    bound variable error

    Use an alias for the aggregate function as follows: SUM(PRTIMEENTRY.PRACTSUM/3600) as PRACTSUM I assume that PRACTSUM is the column name in the datarow that corresponds to the aggregate column in the query. If you have defined another name, use that name as alias. I hope this helps. -- JB

Part and Inventory Search

Back
Top