TerryBurger
asked on
Why is the Crystal Reports 11 SQL expression system so retarded?
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
does anyone know if calling functions (as requested in the original question) has gotten any easier in Crystal 2008?
As far as I know it hasn't.
mlmcc
mlmcc