Discussion

Reporting - SQL Function with a True False parameter

I've created a function with a True False type input parameter,  but it's impossible to use it in a report definition.

I always get the following message when trying to use it in the reports:

  • ** .pySQLFunction: ** Parameter 'Bool' of function 'booltoOuiNon' is the wrong data type; it must be a 'TrueFalse' value

The properties i try to transform are True False type and I have one parameter with data type "True or False".

 

Thanks in advance for your help.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

December 10, 2014 - 5:09am
Do you know what is the data type of the column that is being passed to the function?
Can you let us know what exactly are u trying to perform in the function. If the function doesnt work, and if it's a simple data transformation, you can also use the format option to specify a control to format the values if the number of record count is not very huge.
Alternatively you may also create a view and do the data transformation in the view and map it to class and your report definition can query the view class and not the table.

December 11, 2014 - 3:17am

in prpc: Property Type: TrueFalse

 

I want to transform in some reports some properties stored as TrueFalse type into values "Yes" or "No", because displaying "True" or "False" is confusing end users in some cases.

 

 

 

December 11, 2014 - 4:35am

Do you know what is the data type of column for that property in the DB? As an alternative, you may write a control or use existing control DisplayYesNo to transform the values from true/false to Yes/No and refer in the Format Values in the report definition. 

December 11, 2014 - 5:04am

The data type is a varchar2(5) in database.

 

I tried the DisplayYesNo, it works but not displaying a localized value.

So Yes/No is better than Vrai/Faux but I still need Oui/Non :-)

Thanks anyways for you help.

 

 

December 11, 2014 - 5:12am

It should be possible to get the localized text if you write a custom control in place of DisplayYesNo. Thanks:)