need expression help/guidance

Do all expressions have to be on one line?
Can you declare variables in them like in Crystal Reports Formulas?
Can you use other formulas as values? As in you set up a textbox that
will give you a value with an expression, then in another expression
you reference the value of that text box?
Is there a decent guide out there for expressions? Why
can'texpressions just behave similar to a function?
The answers to this post will certainly help determine whether or not
we stick with Crystal or go with this.You can use GlobalVariables in RS :
In Report Properties, go in Custom Code and Declare typed Variables
Exemple : Public Test As String = "100"
You can reference this variables in any expression in your report :
=Code.Test
In any expression formula you can call Custom Code variables or functions.
As well as reference other Report Items:
=ReportItems!textbox4.Value (to use a textbox named textbox4 value).
Let me know if this helps.
Regards,
Davy Ramirez
Winsight - Paris.
"RickB" <rbinns@.nationaldiabetic.com> wrote in message
news:7f3528da.0410150525.60ae7975@.posting.google.com...
> Do all expressions have to be on one line?
> Can you declare variables in them like in Crystal Reports Formulas?
> Can you use other formulas as values? As in you set up a textbox that
> will give you a value with an expression, then in another expression
> you reference the value of that text box?
> Is there a decent guide out there for expressions? Why
> can'texpressions just behave similar to a function?
> The answers to this post will certainly help determine whether or not
> we stick with Crystal or go with this.|||You may want to read this MSDN article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ERSCstCode.asp?frame=true
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"RickB" <rbinns@.nationaldiabetic.com> wrote in message
news:7f3528da.0410150525.60ae7975@.posting.google.com...
> Do all expressions have to be on one line?
> Can you declare variables in them like in Crystal Reports Formulas?
> Can you use other formulas as values? As in you set up a textbox that
> will give you a value with an expression, then in another expression
> you reference the value of that text box?
> Is there a decent guide out there for expressions? Why
> can'texpressions just behave similar to a function?
> The answers to this post will certainly help determine whether or not
> we stick with Crystal or go with this.

Need a "Replace" sp with rugular expressions

Hi all,
I need a more powerfull function (or stored proc) to make string replacement
(like the REPLACE SQL function) but with regular expressions (like the
wildcard characters used with the LIKE).
Who has this function ?
Thanks.
Lilian.Hi Lilian,
I have a tool that does that. You can dowload your free copy at:
http://www.nobhillsoft.com/EnterCus...prod_name=diana
"Lilian Pigallio" <lpigallio@.nospam.com> wrote in message
news:u62RFrXSEHA.240@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> I need a more powerfull function (or stored proc) to make string
replacement
> (like the REPLACE SQL function) but with regular expressions (like the
> wildcard characters used with the LIKE).
> Who has this function ?
> Thanks.
> Lilian.
>|||Thanks, but finally I've found by myself (thanks google): a good and FREE
solution: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=27205
"Yoni Sion" <yoni@.nobhillsoft.com> wrote in message
news:O1D7E0XSEHA.972@.tk2msftngp13.phx.gbl...
> Hi Lilian,
> I have a tool that does that. You can dowload your free copy at:
>
http://www.nobhillsoft.com/EnterCus...prod_name=diana
>
> "Lilian Pigallio" <lpigallio@.nospam.com> wrote in message
> news:u62RFrXSEHA.240@.TK2MSFTNGP11.phx.gbl...
> replacement
>

Need a "Replace" sp with rugular expressions

Hi all,
I need a more powerfull function (or stored proc) to make string replacement
(like the REPLACE SQL function) but with regular expressions (like the
wildcard characters used with the LIKE).
Who has this function ?
Thanks.
Lilian.Hi Lilian,
I have a tool that does that. You can dowload your free copy at:
http://www.nobhillsoft.com/EnterCust_download.php?prod_id=1&prod_name=diana
"Lilian Pigallio" <lpigallio@.nospam.com> wrote in message
news:u62RFrXSEHA.240@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> I need a more powerfull function (or stored proc) to make string
replacement
> (like the REPLACE SQL function) but with regular expressions (like the
> wildcard characters used with the LIKE).
> Who has this function ?
> Thanks.
> Lilian.
>|||Thanks, but finally I've found by myself (thanks google): a good and FREE
solution: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=27205
"Yoni Sion" <yoni@.nobhillsoft.com> wrote in message
news:O1D7E0XSEHA.972@.tk2msftngp13.phx.gbl...
> Hi Lilian,
> I have a tool that does that. You can dowload your free copy at:
>
http://www.nobhillsoft.com/EnterCust_download.php?prod_id=1&prod_name=diana
>
> "Lilian Pigallio" <lpigallio@.nospam.com> wrote in message
> news:u62RFrXSEHA.240@.TK2MSFTNGP11.phx.gbl...
> > Hi all,
> >
> > I need a more powerfull function (or stored proc) to make string
> replacement
> > (like the REPLACE SQL function) but with regular expressions (like the
> > wildcard characters used with the LIKE).
> >
> > Who has this function ?
> >
> > Thanks.
> >
> > Lilian.
> >
> >
>

Need a "Replace" sp with rugular expressions

Hi all,
I need a more powerfull function (or stored proc) to make string replacement
(like the REPLACE SQL function) but with regular expressions (like the
wildcard characters used with the LIKE).
Who has this function ?
Thanks.
Lilian.
Hi Lilian,
I have a tool that does that. You can dowload your free copy at:
http://www.nobhillsoft.com/EnterCust...rod_name=diana
"Lilian Pigallio" <lpigallio@.nospam.com> wrote in message
news:u62RFrXSEHA.240@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> I need a more powerfull function (or stored proc) to make string
replacement
> (like the REPLACE SQL function) but with regular expressions (like the
> wildcard characters used with the LIKE).
> Who has this function ?
> Thanks.
> Lilian.
>
|||Thanks, but finally I've found by myself (thanks google): a good and FREE
solution: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=27205
"Yoni Sion" <yoni@.nobhillsoft.com> wrote in message
news:O1D7E0XSEHA.972@.tk2msftngp13.phx.gbl...
> Hi Lilian,
> I have a tool that does that. You can dowload your free copy at:
>
http://www.nobhillsoft.com/EnterCust...rod_name=diana
>
> "Lilian Pigallio" <lpigallio@.nospam.com> wrote in message
> news:u62RFrXSEHA.240@.TK2MSFTNGP11.phx.gbl...
> replacement
>