I've got a simple report that has an SQL command, joins a couple of tables, groups, and prints. Now I want to add an SQL function call from the group. (E.g. call a scalar function from SQL with two parameters, display the result in each group.)
Seems simple enough, right? Well try as I might, I can't figure it out. The one option that might be able to do this for me, "SQL expression builder", disappears as soon as you add an SQL command in the database expert. WTF? Is it punishment for not wanting to use the lame Crystal reports database linkup system?
Any suggestions appreciated! I read to try a subreport, although have been resisting so far (I'm going to want to subtotal on this function call, etc). What I really want is a crystal reports function where I enter
"run my SQL function with parameters @go, @team", that I can use like any other Crystal function.