Report Execution Error using German Language

jnario
jnario Member Posts: 21
edited 2006-12-02 in Navision Attain
Hello All,

I have created a Navision report and the output is Excel format, when I run the report using English Language, it works fine, but using the German Language, I'm getting below error message. Can anyone please advise how to fix below error. Also I apologize, I can't read the error message.

"Die Wahlmöglichkeit 'No' ist nicht vorhanden.
Die Wahlmöglichkeiten sind:
Nein, Ja"

On the program code, I have included the below statement for validation for cancelled flag. I'm suspecting that it's coming from this code, since it's and English word.

SalesHeader.SETFILTER(SalesHeader.Cancelled, 'No');

How do I set filter for other languages?

Thanks

Joel Nario
Manager, Application Development and System Operations
IT Department
IDEC Corporation
Sunnyvale, CA. 94080

Comments

  • ara3n
    ara3n Member Posts: 9,258
    Apparently in your code you are setting a value to No. and the options in german is Nein, which no, and Ja for yes.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • kine
    kine Member Posts: 12,562
    edited 2006-12-01
    I assume that the field is boolean type. In this case the filter must be in format: 
     SalesHeader.SETRANGE(SalesHeader.Cancelled, False);

    Using string to filter for boolean is not clean and should be permitted. It is same as filtering option type to string and not the Field::Value...

    //edited 1.12.2006 - SETFILTER replaced by SETRANGE
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Waldo
    Waldo Member Posts: 3,412
    Doesn't it has to be: 
    SalesHeader.SETFILTER(SalesHeader.Cancelled,'%1',False);
    :?:

    ... I could be mistaken ... :-k

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • kine
    kine Member Posts: 12,562
    No, you do not need setfilter if you are filtering for one value...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Waldo
    Waldo Member Posts: 3,412
    kine wrote:
    I assume that the field is boolean type. In this case the filter must be in format:

    SalesHeader.SETFILTER(SalesHeader.Cancelled, False);

    Using string to filter for boolean is not clean and should be permitted. It is same as filtering option type to string and not the Field::Value...

    OK, then I get it ... you meant SETRANGE ...

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • kine
    kine Member Posts: 12,562
    Ah, yes, my mistake... I have overlooked that... :-) you are correct, I mean SETRANGE... :oops:
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Waldo
    Waldo Member Posts: 3,412
    kine wrote:
    Ah, yes, my mistake... I have overlooked that... :-) you are correct, I mean SETRANGE... :oops:

    I forgive you O:)

    :lol:

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • jnario
    jnario Member Posts: 21
    Thank you very much guys,

    Yes, the below command works.

    SalesHeader.SETFILTER(SalesHeader.Cancelled,'%1',False);

    In addition to the above command, I found out that below command also works the same way. It provided me the same result.

    IF Cancelled THEN CurrReport.SKIP;

    I'm pretty new to this programming C/AL Code in Navision.

    We are Oracle Shop, but most of our subsidiaries, we decided to implement Navision.

    This is a great Web Site to het help..
  • Waldo
    Waldo Member Posts: 3,412
    jnario wrote:
    Thank you very much guys,

    Yes, the below command works.

    SalesHeader.SETFILTER(SalesHeader.Cancelled,'%1',False);

    In addition to the above command, I found out that below command also works the same way. It provided me the same result.

    IF Cancelled THEN CurrReport.SKIP;

    I'm pretty new to this programming C/AL Code in Navision.

    We are Oracle Shop, but most of our subsidiaries, we decided to implement Navision.

    This is a great Web Site to het help..

    Go for the
    SalesHeader.SETFILTER(SalesHeader.Cancelled,'%1',False);
    Like Kine mentioned.

    If you go for the
    IF Cancelled THEN CurrReport.SKIP;
    your code wil have to go through much more lines then wether you filter the lines on Canceled = FALSE. This will make your report slower.

    On the other hand, keep in mind that when you're working on a NATIVE, you'll have to set the key on Cancelled.
    Something like: SalesHeader.SETCURRENTKEY(Cancelled)
    Filtering a sorted set will result in much better performance.

    On SQL it's a whole other story, but I only have a textbox for 2Gb of Text, so that's not enough :wink:

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • snahta
    snahta Member Posts: 2
    We've effectively talked about the French educational program exhaustively in our past article, and likewise the benefits of contemplating in the French language stream. Presently, we should discuss the upsides of learning German.
    German language Classes in Pune

Categories