cancel
Showing results for 
Search instead for 
Did you mean: 

How to pass a parameter into a sql expression?

Former Member
0 Kudos

How to pass a report parameter into a sql expression?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Donald,

The functionality of using a parameter in a function is only available in the formula editor and not in SQL Expression. Parameters cannot be passed to the SQL Expression, the main purpose of the SQL Expression is to make use of Database functions to make calculations at the database level but the current functionality of the product only allows you to use Database fields.

There is an article that talks on SQL Expressions and can be useful http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&ext...

Regards,

Vinay

Answers (0)