Creating reports and dashboards | Stimulsoft community forum

Posted: **Sun May 11, 2014 3:15 am**

Hi,
How do i replace part of a text with a value from a data source. I am trying to replace a part of a text/string with a value from a datasource. I want to use IIF to check whether the user has a picture, if no, i show the default picture if yes i show the user picture by replacing or appending the user id(picture name) within the file path. Example below:

{IIF((DataSource1.PIC_STATUS ==1),"/abcde/files/pictures/"DataSource1.User_ID".jpeg", "/abcde/files/icons/default_picture.jpeg")}

Posted: **Mon May 12, 2014 10:06 am**

Hello.

Please, try to use next expression:

Code: Select all

{IIF((DataSource1.PIC_STATUS ==1),"/abcde/files/pictures/"+DataSource1.User_ID+".jpeg", "/abcde/files/icons/default_picture.jpeg")}

Thank you.

Posted: **Mon May 12, 2014 11:40 am**

Hi,
thanks a lot, it works perfectly as i wanted.
Regards.

Posted: **Tue May 13, 2014 6:12 am**

Great! Thank you for letting us know about this.

Creating reports and dashboards | Stimulsoft community forum

How do i insert a database value within a string in designer

How do i insert a database value within a string in designer

Re: How do i insert a database value within a string in desi

Re: How do i insert a database value within a string in desi

Re: How do i insert a database value within a string in desi