Concat userresponse data with related object from database

[ssudha]

Hi All,
REquirement is to concat userresponse data with related object from database. Is looks like this.

=UserResponse("Query 1 with efashion" ,"SKU") + (If IsNull(<SKU desc>) Then " " Else <SKU desc>)

The header row gets suppressed or no data is displayed when for an sku no sku desc is present.

For eg: If user enters 115 for SKU when record is present in database the header shows 115 with its description. Like this.....
115 Leather
For some junk number say 100000 the cell totally gets blank where as it should show me ......
100000
Can sombody help me in this regard.

 

[blom0344]

My wild guess would be to format the Userresponse part to a string format using the Format_Number function to see if that works any better?

I fear though that this is related to the validation function IsNull() that works differently than you may expect..

T. Blom
Information analyst
tbl@shimano-eu.com

 

[BrianTyler]

I would be surprised if the SKU desc can be evaluated if there was no row returned from the query, there probably wouldn't even be a null value to work with.

Perhaps you could try working with the number of result rows in the data provider.