Getting filter in Single quotes like '1000..1005'

srinict
srinict Member Posts: 58
edited 2009-04-07 in NAV/Navision Classic Client
Hi,
I am facing a problem while generating report. I have to generate a report by filtering the accounts. The user will select the range from which account to which account he wants report.
based on the filter i have to do the report. Every thing is working fine but i am getting the filter in single quotes, if i remove the quotes and run the report its working fine. the filter is a code field. How can i get the value with out quotes
If any One have solution please provide me.

Thanks in Advance.

Regards,
Srinivas

Answers

  • matttrax
    matttrax Member Posts: 2,309
    Well, you can always do a DELCHR or a COPYSTR to remove the characters you don't want, but it's better to figure out why they are there in the first place.

    So the user is just inputting the filter on the request form of the report? As 100..999? Not '100..999'?

    If you're typing in quotes in the actual filter you shouldn't have to. That's only in code to identify some text as a string. If you're typing it directly into a code field it already knows it's a string.
    Matt Traxinger - ArcherPoint
  • srinict
    srinict Member Posts: 58
    Thanks a lot for your reply.

    Regards,
    Srinivas

Categories