Feel free to ask tough questions relating to Crystal Reports / SQL Reporting Services / SQL and get answers from Collective intelligence
Wednesday February 8th 2012

ToText formula example

Totext is a formula in Crystal reports used to convert numeric value to text for example you want to write
Your Salary is {StoredProcedure3_1;1.Salary} you will receive an error stating that string missing.

So to write the same you need to use totext function as follows;

“your salary is RS” + Totext({StoredProcedure3_1;1.Salary})

Leave a Reply