How to convert nullable integer to strnig

[a.ebbini]

I need to cross tab row a condition for two field to like this {DataSourceName.Field1}{DataSourceName.Field2} and Field 1 is string and Field 2 in Nullable integer ,so how can i do this in addition to that the condition must check Field 2 if null then condition will be {DataSourceName.Field1}

[HighAley]

Hello.

We need more information about the issue to give you exact answer. What type of data source you use and so on.
But you could try to use next expression:

Code: Select all

DataSourceName["Field2"]==DBNull.Value?"":DataSourceName.Field2.ToString()

Thank you.

[a.ebbini]

thanks

[HighAley]

Hello.

We are always glad to help you.
Let us know if you need any additional help.

Thank you.