Skip to Content

In crystal report -Displaying text continuously that are coming from different rows of same object.

Hi ,

I have a requirement in crystal report and find details below.

In the report, we see data in below fashion.You can see text in the report is not continuous.

Now the requirement is end user wants to see data in a continuous manner. They don’t want to see blank spaces between.

We see data in sections because data is coming from CRM and stored in below fashion

Here in CRM data stored in chunks of 30,000 characters. If data is more than 30,000 then stored in next chunk of 30,000. But data is stored in single object TDLINE.

If you see crystal report structure, we are printing data from TDLINE.

Kindly help in resolving this issue. Looking forward for suggestions.

Regards,

Mrinal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 20, 2017 at 08:15 AM

    You probably have Carriage return or Line Feed characters in text. ASCII characters 13 & 10 respectively

    You can use Replace(TDLINE, chrw(13))

    However, I am not sure if Crystal formula will handle such big sets of text. You might have to use a command and remove in SQL.

    Ian

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 20, 2017 at 09:38 AM

    This will never be true

    right({zbwcrm_ltextraction.T_ET_TEXT36.TDLINE},1)='≤≤≠≥≥'

    you are comparing a single character to a string of 5 characters.

    You are introducing Carriage returns and thus causing white space. Why?

    If you want to remove '≤≤≠≥≥' use replace

    replace({zbwcrm_ltextraction.T_ET_TEXT36.TDLINE},'≤≤≠≥≥', '')//'' = two single speech marks and replaces '≤≤≠≥≥' with nothing

    you can replace with a space if that is better.

    Ian

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 21, 2017 at 09:31 AM

    Please suggest some workarounds in joining the text coming from the different chunks

    Add comment
    10|10000 characters needed characters exceeded