Recent content by johnberchmans

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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