Page 1 of 2
Load expression from database field
Posted: Wed Jun 22, 2016 11:24 pm
by ecpmiranda
Can I load an expression from a database field?
I want to save this expression in a varchar field on a SqlServer database
{"The person " + DataSet1.NamePerson + " is nice"}
and set DataColumn property of a textBox with the name of the database field.
I tried but it´s not working. Is there a way to do this?
Re: Load expression from database field
Posted: Thu Jun 23, 2016 7:42 am
by HighAley
Hello.
You could use next expression to show expression from the data column:
Code: Select all
{Stimulsoft.Report.Engine.StiParser.ParseTextValue(Data, sender as StiComponent)}
Thank you.
Re: Load expression from database field
Posted: Fri Jun 24, 2016 12:34 am
by ecpmiranda
This is very powerful!! This report tool is really great! Thanks!
Re: Load expression from database field
Posted: Fri Jun 24, 2016 1:35 pm
by Alex K.
Hello
Let us know if you need any additional help.
Thank you.
Re: Load expression from database field
Posted: Thu Jun 30, 2016 8:27 pm
by ecpmiranda
Can I also use this expression to parse a RichText stored in a database field?
Code: Select all
{Stimulsoft.Report.Engine.StiParser.ParseTextValue(Data, sender as StiComponent)}
Re: Load expression from database field
Posted: Fri Jul 01, 2016 1:21 pm
by HighAley
Hello.
You don't need to parse Rich Text. Just specify the column and set the Full Convert Expression property to True.
Thank you.
Re: Load expression from database field
Posted: Fri Jul 01, 2016 2:05 pm
by ecpmiranda
Did not work.
I tried a simple expression.
First, using the rtf editor in designer like this, and works fine!
My name is {DataSet1.PersonName}
The result in report viewer: My name is Edson
Then I save this rtf expression in a database field like this and set FUll Convert Express = true:
{\rtf1\ansi\ansicpg1252\deff0\deflang1046{\fonttbl{\f0\fswiss\fprq2\fcharset0 Century Gothic;}}
{\colortbl ;\red0\green0\blue0;}
\viewkind4\uc1\pard\li720\qc\cf1\b\f0\fs24 My name is \{DataSet1.PersonName\}\par}
The result in report viewer: My name is {DataSet1.PersonName}
The expression was not evaluated.
Re: Load expression from database field
Posted: Mon Jul 04, 2016 11:10 am
by HighAley
Hello.
We have reproduced the issue.
We need some time for analyzing of it.
We will let you know about results.
Thank you.
Re: Load expression from database field
Posted: Wed Jul 13, 2016 12:48 pm
by edsonmiranda
Hello,
I am having the same problem and I need to load RTF expressions from database field. I tried to set FullConvert Express = true but is not working.
Do you have a fix for this issue?
Thanks!
Re: Load expression from database field
Posted: Fri Jul 15, 2016 8:34 am
by HighAley
Hello.
Unfortunately, we can't change this behavior but we are working on a workaround.
We need more time to prepare an answer for you.
Thank you.