Jan/08
9
Crystal Reports: Array_PushEx() Function
2 Comments · Posted by Craig Buchanan in Crystal Reports, Functions, Programming
Add a unique string value to an array of string values. Uses the delimiter to convert the value into an array.
Function (Stringvar Array Items, Stringvar Values, Stringvar Delimiter)
Stringvar Array Temp:=Split(Values,Delimiter);
Numbervar i;
For i := 1 To Ubound(Temp) Do (
If Array_Contains (Items, Temp[i]) = False Then (
Redim Preserve Items[Ubound(Items)+1];
Items[Ubound(Items)]:=Temp[i];
);
);
Items;
skiabox · January 23, 2008 at 10:47 am
I entered the following sql expression field to calculate a grand total for each account but I get the sum of all arrangements for all accounts.Any idea how to link the sql expression with the specific account?
(
SELECT SUM(“bedaposo”)
FROM “ErmisUser”.”QBEPROK” JOIN “ErmisUser”.”bereg” ON “ErmisUser”.”QBEPROK”.”bedalog” = “ErmisUser”.”bereg”.”berelog”
WHERE “ErmisUser”.”QBEPROK”.”bedaflarr” = ‘1′
AND LEFT((“ErmisUser”.”QBEPROK”.”bedakind”), 1) ‘P’
)
See what I mean here :
http://i31.tinypic.com/2i05biw.gif
Craig Buchanan · October 30, 2008 at 3:45 pm
You need to link the account’s key in the SQL expression to a value in the report.