Skip to Content
author's profile photo Former Member
Former Member

How to display notes in reports?

Dear community,

my customer wants to have a report listing all CRM activities (ActivityTasks, phone calls, emails, letters, appointments, etc.) with the notes.

I searched for suitable data sources but did not find any that includes the notes...

My second approach was to create my own business object, that is linked to the activity object and has one field as data type "LANGUAGEINDEPENDENT_Note" which holds the notes of the actual activity object. I then created a data source, joined it with another data source and tried to display the data in a report. Unfortunately, the report only shows the first 60 characters of notes...

Is there a way to show all contents of the field in a report?

Do you have another solution on how to display CRM activity notes in reports?

Thanks for your help and best regards,

Georg

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 22, 2016 at 10:36 PM

    Hello Georg,

    A bit late...🤪

    In reports, you can enable showing of extended text in report settings. See the attached image here. This shows up to 1024 characters but if you download the report, I guess it shows the entire text.

    Hope this helps.

    - Mahesh Tatini


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I am not sure which report you are trying to update, but see in "Add fields" you find "Notes". If not, you need to modify the report itself to add Notes. If you cannot find the field in report wizard in Silverlight, you need to update the data source to add Notes, and then modify the report in wizard and then create the report view.

      The screen shot I attached in my earlier reply is from HTML5 view. In table characterstics, you can control the field length.

      Hope this helps.

      thanks

      Mahesh

  • Posted on Mar 05, 2014 at 10:07 PM

    Hello there,

    I am not sure at all, but I think there is a problem with the length of your text string, so your notes.


    Try to change your field data type with LANGUAGEINDEPENDENT_EXTENDED_Note

    Normally, the extended type is a 255 characters string, which I hope is enough for your notes.


    Hope that can help.

    Regards,

    Jacques-Antoine

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 06, 2014 at 07:36 AM

    Hi Georg,

    Do you want to display the Activity and the Notes content in the activity in report?

    If this is the requirement you can use the FM : "CRM_DNO_READ_ORDER_TEXT" which gives the notes in the particular transaction in an internal table.

    Check this one.

    Regards,

    Rajya lakshmi.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Rajya Lakshmi,

      I'm afraid I don't know how to do this. I'm a partner and only have access to either the ByDesign system frontend as administrator or via the Cloud Applications Studio as developer user.

      As far as I know I can't Access database tables or ABAP code in ByDesign directly. Could you tell / show me how to do this?

      Thanks for your help!

      Best regards,

      Georg

  • Posted on Jan 24, 2016 at 03:05 PM

    I would like to use LanguageIndependent_Extended_Note, as an experiment initially.

    The studio is requiring me to import a namespace. Does anyone know the name of the namespace needed to support this data type?

    Thanks, David Kramer

    Message was edited by: E. David Kramer

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 15, 2016 at 10:30 AM

    Hi Georg,

    Please check in the current version 1608, you can export more characters.

    Thanks

    Arunkumar Kannan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.