I had posted a thread in this forum earlier for converting a number to word in Impromptu (thread401-240219)
I have been successfully using this fuction in Impromptu since I got the answer. Now I have noticed that this function does not work for summary values e.g. Total. I can convert the number at the individual row level, but not on any totals.
In fact, in the query dialog box, it does not show the total column under 'Report Columns' when I select this function. The possible reason could be that the summary functions are not part of the SQL that impromptu forms ?
Does anybody have a solution for this.
I have been successfully using this fuction in Impromptu since I got the answer. Now I have noticed that this function does not work for summary values e.g. Total. I can convert the number at the individual row level, but not on any totals.
In fact, in the query dialog box, it does not show the total column under 'Report Columns' when I select this function. The possible reason could be that the summary functions are not part of the SQL that impromptu forms ?
Does anybody have a solution for this.