Help, this is emergency. been developing too much with rs. cant turn my back now. too late. but im stuck. damn. issue is in master report contain subreport. since i cant get subreport footer to show up in master. i find tricky way by using summary dataset in master report. but there is one problem, i need to display function display number as words. should have 2 parameters, money, and the currency, got this from report item. the problem is one expression cant contain more than 1 report item. and when i try in custom code, cant do that also since i cant access report item there. i cant use parameter since I really have to access report item. the report item is field in dataset of list in master table that group accounts and display their banking account statement. i think its stupid, why in the world i couldnt use more than 1 report item in one expression.

i really cant separate the words of money and the currency in different text box because it would be awkward in display. i need continuous flow of the text of the money. ($ 1450=one thousand four hundred and fifty dollar). the function would be like Code.GetWordsOfMoney(amount, currency).

i need to use Code.GetWordsOfMoney(reportitems("amount").value,reportitems(" currency") .value). and i cant do this in one expression? how im i supposed to do? help.

funny, its twice here when i posted my question, the solution just pop up in my head. for now i combine the money and currency in one field in dataset, and parse them in the GetWordsOfMoney function. anyway, seriously, its ridiculous rs cant have more than 1 report item in one expression. silly.