Another bit of info on SP reports. I found that the SQL Cognos created from our prompts didn't run very well (WHERE col IN ___, ____, ____), so I tried creating the SQL dynamically in the SP and it works. I use IF statements to analyze the prompt values that are passed into the SP and build...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.