Problem with filter expression "*.."

Ronin666
Ronin666 Member Posts: 14
edited 2004-06-25 in Navision Attain
Hello, i got a problem with a filter expression:
I want to start a report about invoices and filter that report for special invoice-id´s.
For example there is an invoice with the number D1503999, another with D1504000, and so on.
and i wanted to filter some invoices, so i set a filter like this: D1503*..

And whats the result: The report shows me all invoices from D1504000 on.
But it leaves out the number D15039999....
why that???
I thought that the filter should show me all invoices beginning with no. D15030000

Anyone knows if my filter is wrong? or is this a known problem in MBS ?

thx for help

Comments

  • Savatage
    Savatage Member Posts: 7,142
    Does it also give you a problem if your filter is set to:
    >D1503000

    I don't know how many invoices appear when you type in :
    D1503*..

    But maybe invoice # D1503999 does appear but it's not being sorted descending by inv# but by some other field that puts this invoice in another position in the list and your missing it?

    Just a thought..
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Ronin666
    Ronin666 Member Posts: 14
    That is the funny thing:

    if i set the filter to 'D15030000..' it works...

    so i don´t think that this i a sorting problem...

    i forgot to post that i had this problem with Attain 3.10.

    i think i will try it again with MBS 3.70 and see what happens
  • StephenG
    StephenG Member Posts: 99
    The result is correct.

    The '*' is a legitimate character for a CODE datatype.
    So your filter is in theory filtering >='D1503*' which in a list would look like this
    D1503002
    D1503003
    D15039999
    D1503*
    D1504000
    D1504001
    Answer the question and wait for the answer.
  • Ronin666
    Ronin666 Member Posts: 14
    thx Stephen !

    maybe this doesn´t solve my problem,
    but now i understand why this "error" occured.

    henning

    good luck to england at the Euro2004 ... hopefully more luck than germany :cry:
  • RobertMo
    RobertMo Member Posts: 484
    understanding means a lot and it helps you setting correct filter you want:
    set D1503.. if you want to show what is alphabetically >= 'D1503'.
    set D1503* if you want to show everything that begins with D1503.
    (the same as D1503..D1504, but the upper margin is excluded)

    and yes, D1503 doesn't have to exist, if setting filter D1503.. it will find the first one that is larger than D1503.
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯

Categories