am having trouble with some modifications I am trying to make to a memorized report's QRP file. I am trying to replace:
i am trying to use " Distinct [Order].ID" in fieldname
when i try to generate the report it gives me the error invalid syntax near the keyword distinct. if i take out "distinct" it generates the report but with too much repitetion. Error only comes when i generate from memorize report window. if i generate the report regularly it does not give me any error. any help will be much appreciated.