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

SAP B1 Report Selection criteria presentation

I have created a crystal report for bank reconciliation. One parameter is the account code for which the OACT table field OACT.FormatCode is used as the parameter value. Originally the parameter was shown as Prompt with description Only - True. The parameter appeared in SAP as

Account Code Bank Number 1

I changed the report to Prompt with description Only - False. The parameter appeared in SAP as

Account Code 0000001234 - Bank Number 1

I now need to change the displayed information back to the original form, but nothing seems to work. The report has been changed back to the original, I have tried deleting the report from SAP, logging out then logging back in, then reloading the report, but it seems once a format for a field has been changed SAP retains that format forever.

Can anyone please help me. This information must be stored in a table, but I have been unable to find it anywhere.


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on May 24, 2013 at 06:25 AM

    Hi Simon,

    Its look really strange.

    For a work around, try re-creating the parameter after deleting it instead of deleting the whole crystal report in SAP. 😊



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 24, 2013 at 06:37 AM

    Hi Simon

    Can you paste your query here



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Jenny, I'm not sure what query you are talking about. I load the crystal report into SAP using the path Modules->Administration->Setup->General->Report and Layout Manager. I then import the the report as a report not a layout.

      The actual parameter in the report is called 'Account Code' type string and list of values static. Value field is OACT.FormatCode, Description field is (none)

      There are 2 values in the value list

      Value Description

      12345 Bank 1 - 12345

      45678 Bank 2 - 45678

      Value options: Setting

      Shown on (Viewer) Panel Do not Show

      Prompt Text Account Code

      Prompt with description only True

      Optional Prompt False

      Default Value 500000

      Allow Custom Values False

      Allow Multiple values False

      Allow discrete values True

      Allow range values False

      Min length

      Max length

      Edit mask

      Show Value or Description I have tried both Show value and show description

      When I run the report the parameter always now shows

      Account code: 12345 Bank 1 - 12345 this is displying both value and description

      45678 Bank 2 - 45678

      what I need it to show is

      Account code: Bank 1 - 12345 this is the description only

      Bank 2 - 45678

      From what I can see SAP has stored somwhere for OACT.FormatCode the layout of any parameter using this field and once this is loaded you can't change it.

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.