Validing Report Fails

[Cynthia]

Hi.. we are upgrading from 8.1 to 8.4.  One of the reports, when I run the validate, gives me this error message:

QE-DEF-0469 QE Message
RQP-DEF-0258 The Order By command in nested SQL is not allowed.

I have removed all Order By's that I can possibly find in the Queries, but still I'm getting this error.  Is anyone familiar with this?

The XML message gives this:

Code Select Expand

<message severity="warning"title="QE-DEF-0469 QE Message"type="general">RQP-DEF-0258 The Order By command in nested SQL is not allowed.

</message>

Thanks for any help!

[MFGF]

Hi Cynthia,

Sorry - more details are required, I'm afraid.  How is the report constructed?  Is it a single query, or multiple queries joined/unioned/linked via Master-Detail, or...?  Does the report use hard-coded SQL?

MF.

[Cynthia]

Oh boy... hard questions!  :)  I am not quite that advanced.... but I'll try. We don't have any hard coded SQL... it's only what the report builds on it's own. 

I think there are multiple queries but they were built for prompts.  Hrm... we might just rebuild the package and see if that helps. :)

[MFGF]

Hi,

One thing you could try is to go to Query explorer, go into each query in turn, then go to Run -> View Tabular Data.  You may find the error is coming from just one particular query, which will help narrow things down a bit.

MF.