Hi All,
Is it possible to create my own custom functions in Web Intelligence so that I can reuse the functions in different reports?
For instance, I have a measure that represents a duration in seconds. I’d like to format this to hh:mm:ss. I understand that I can create a SQL function to format the value. However, If I do this, I won’t be able to apply aggregation to the field because the numeric value has been converted to char value.
I also know that I can use a formula in the report to do this, but this is still not as convenient as using a reusable function. And I also don’t think Alert is suitable for this because it’s tied a particular column.
I did a search on this, looks like the only way is creating a custom dll that contains this function. Is this the only way? Actually, is there a good link that explains the dll in details?
Please correct me if I’m wrong.
Thanks,
Steve
rainmasterrr (BOB member since 2009-07-24)