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 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
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...
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
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
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.