Crystal Reports Line Break

Posted on 2005-05-10
Last Modified: 2008-01-09
I setup a web app using VB.NET and ASP.NET to auto generate a PDF file using crystal reports. This works exactly as intended except for in some places I have to have a line break (<br />) for display purposes but Crystal isn't doing a line break and instead prints the HTML out in the form. Is/Are there a special character(s) that symbolize a line break in data that Crystal recognizes? I'm getting the <br /> by replacing any instances of System.Environment.NewLine with it.

Any help would be greatly appreciated!!
Question by:goconcepts
    LVL 100

    Accepted Solution

    Check the interpretation set for the field.

    Open Crystal
    Select the field
    Right Click and select FORMAT
    There is an option on one of the tabs (don't have Crystal here)
       that allows you to interpret the field as RF or HTML.  Select HTML.

    You may also need to use <br/>


    Author Comment

    That gave me a good place to look but unfortunately the only options available are RTF or None and None was selected. I tried switching to RTF just to see what would happen and it didn't work either (figured it wouldn't though).

    I'm using VS.NET 2003 and Crystal Reports 9 (the integrated one).

    Author Comment

    I found HTML text but it is inside the Format Editor so it looks like I have to do it in some form of code. But I'm a new CR developer so I don't know how to use this syntax. Any help? The fields are varchar if that helps.

    Author Comment

    OK, I figured that out. Thanks for the help!!!!
    LVL 100

    Expert Comment

    Glad i could help


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Introduction While answering a recent question ( in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
    Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now