Hi guys,
I have trouble compiling a SQL= command. I wish to sort it by descending order of sum of charge, which is based on certain numbers from the field 'legANumber'. The db used is 'sghighmin_201120'.
For Navision, it would have looked like this:
=NL("Rows","sghighmin_201120","legANumber","-=NL(""Sum"",""sghighmin_201120"",""charge"",""legAnumber"",NF(,""legANumber""))","*") for the first columm
and
=NL("Sum","sghighmin_201120","charge","legAnumber","@@"&$F9) for the second column
But for Universal connectors, calculated fields would not have worked hence a need to delve in to the SQL= command, which I had found the Help section & some articles around slightly useful with many failed attempts, hence I would like some help in constructing a SQL= command for this.
Thank you very much.
Date
Votes
2 comments
-
-
Jet Reports Historic Posts Hi,
I tried with:
=NL("Rows", "SQL=SELECT legANumber, SUM(""charge"") FROM ""sghighmin_201120"" WHERE %FILTER1% GROUP BY legANumber ORDER BY SUM(""charge"") DESC", "sghighmin_201120")
but it gave me an error syntax message near '"sghighmin_201120" WHERE %FILTER1% GROUP BY legANumber ORDER BY SUM(""charge"") DESC'. Anything I've done wrong above?
Please sign in to leave a comment.