Can I create custom SQL functions and use them for creating reports? If Yes how can I call them(example of using)? (I thought it is possible to create custom SQL functions in Designer-Base Data-Advanced-Predefined SQL, however I can’t understand how to use them)
Unfortunately, I can’t use simple SQL query, because I calculate names of tables and columns from where I need to get info in my query.
For example:
Select Column_name(param1) from Table_name(param2)
*Where Column_name is predefined function which calculate column name for my query.
*Table_name is predefined function which calculate table name for my query.
