Post reply

SQL Data - Crystal Report

  • July 5, 2004 at 3:14 am

    #83265

    I want to print special mathematics characters like =, = in a crystal report. The data is saved in SQL tables . Field Data Type is NText.

    Can Anybody help me please?

  • July 5, 2004 at 3:39 am

    #513266

    Hi

    Can you provide some sample data ? I cannot understand what exactly you want

    /Jeswanth

    --------------------------------

  • July 5, 2004 at 4:10 am

    #513269

    Hi

    Actually this text control in which I am typing the reply is too not supporting these characters!! It is mathematical Greater than equal to / less than equal to (but not '>=' way or '<=' way!)... or exponential like 10 raised to 5 (but not 10 ^ 5 way...)

    We can enter it in Microsoft Word using Insert > symbols...

    Nishigandha.

  • July 5, 2004 at 11:13 pm

    #513383

    Ok I got a vague idea of what you are trying to show in Crystl Report. I feel you are trying to print some special characters in CR . Right ? of if the field data is only special charcters then you try to set the font of the field to the same font what you used in the front end. in work i found its using the font symbol. so the crystal report text field font also should be symbol. if its stored with a alphabet then the above method will make the alphabets in the field not recognizable. so try to split the data using a formula and combine later using another formula. its bit tricky just try.

    --Jeswanth

    --------------------------------

  • July 6, 2004 at 1:02 am

    #513402

    Hi Jeswanth,

    Thats absolutely right! I am not able to change the font of the field on CR, because of my other data like chars n nos... Well ur suggesion is little tricky in the sence, I will not know for how any times my special chars will repeat? Even if I make an Image of it.. I will never know how many times.. neither will I know at what postions... in my string...

    Any Suggestion?

    Nishigandha.

  • July 6, 2004 at 4:23 am

    #513423

    Hi,

    I think i have a solution for you.

    Check the properties of the text field and goto paragraph formatting tab in CR.

    You can select the RTF format in Combo Box and it will show the RTF Content as it is. i tested with SQL server Memo Field and it was working. Hope it will work for NVarchar also.

    Pls let me know if its working

    --Jeswanth

    --------------------------------

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply