In framework manager, can I create a simple function which takes a passed paramter. The function is to basically take a string and extract certain elements of it and return them rearranged. The passed parameter will be a string which will come from various fields from various tables.
Hi,
The idea generally is to create your function in your database, then import its definition into Framework Manager. It should then appear as a function that can be called both from within FM and from within Report Studio (if you include it in your published packages).
Regards,
MF.
I thought as much. The reason I wanted to do it this way was that we are accessing our data over a odbc link and I would have to create a stored procedure to do it. It just seemed a bit of overkill just to rearrange a string.