Boolean fields in keys

calvinhfx
calvinhfx Member Posts: 6
edited 2003-09-04 in Navision Financials
I have a report using a key and filter on the dataitem on two boolean fields in the table. When I run the report it only fetches the first record and ends the iteration of the report. If I do not use this key it takes up to 10 minutes to run the report as the table is large.

ANY help would be greatly appreciated

Comments

  • Sbhat
    Sbhat Member Posts: 301
    Hi,

    Use both the boolean fields as part of your key and then create the report. If you have a key with one boolean field and filter the table with other boolean field obviously the report will be slow.

    Thanks
    Best regards
    Suresh
    New York.