I am working on a report that has several HOLD files, defines, etc... I have developed it 100% in the GUI with no editing of the CODE. Now, no matter what I do on the very last Report it will not open and gives ne a "Error parsing report request" >BY< BY Q11, there is no "BY Q11" in the code. I have even deleted the report and recreated it using a different way and I get the same error. Is this a bug or am I doing something wrong. I would think I should be able to open it in the GUI if I have not went in and changed the actual code in text view.

This message has been edited. Last edited by: neuro,

Does the same thing in version 7.1.4 as well

You will need to change the top line.
i.e. -Edit

This is the top of my code, I do not understand what I am supposed to change on the top line:


TABLE FILE LMS_PROFILE_DATA
BY LAST_NAME NOPRINT
BY FULLNAME
BY TOTAL
BY Q1
BY Q2
BY Q3
BY Q4
BY Q5
BY Q6
BY Q7
BY Q8
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *


neuro,

I agree that this should not happen and I urge you to raise a case with your local branch so that it gets a fix.

However, and this is a shot in the dark, try adding a print field (using the GUI) and set it to NOPRINT to see if this overcomes the 'feature' (aka bug).

T

Try removing the "BY TOTAL". Your fieldname TOTAL may be conflicting with the TABLE feature BY TOTAL.

I agree with Emma's comment, avoid key word if it is a defined field if you mean to use the BY TOTAL option, what are you BY TOTAL 'ing'?

I know if I forget the 'end' when coding scratch some of the weirdest messages show up that make no sense at all.

RESOLVED -- Thank you to everyone to posted. It was the "BY TOTAL", I went in and changed my hold files and such to reflecting a different name an now the GUI works fine. Hate those darn reserved words, like I do not have enough of them to remember in other languages.

Thank you everyone!