Hi All,
Can we include a ‘Function’ in Derived table which will take the input parameters through PROMPTS and pass the output parameter which can be used in a column of the report?
If yes can any one please give me a syntax of how to include the function in the derived table’s sql query and how to define the PROMPTS that accepts the input parameters?
Thanks
MSR_BO (BOB member since 2009-05-01)
Hi,
Give us an example of your query (your real query) that uses a function and we can try to help yo how with adding prompt(s) into the function parameters.
Marek Chladny 
(BOB member since 2003-11-27)
A derived table isn’t really much more than a SQL statement that returns a set of rows. If your function can be called in a standard SELECT statement you should be able to use the same syntax in a derived table. Adding prompts is also fine.
Dave Rathbun 
(BOB member since 2002-06-06)
are you looking for dynamic columns from database?
sorry for not understanding your requirement.
Rakesh_K 
(BOB member since 2007-12-11)