How to add a line return in my SQL Query that Crystal Reports will recognize
Posted on 2006-06-08
Hi, I'm fairly new to Crystal Reports and cannot figure this out. I've got my report running fine and collecting the data I want from my SQL Server database. The only issue is that I need to force it to do a line return under certain conditions from data returned back from my SQL query. I can't set a 'reflow text' property in the field on Crystal report to solve this b/c I need to specify where the line return is. I've tried using vbCrLf and Chr(10) returned in my sql query, but both just write out that text when exported to Crystal reports. I am using the version that came with my VB.NET 2003.
How can I tell crystal reports from my SQL query results to have a line return when I need it to?