Hi, Using Impromptu Administrator 7.3 to create a reasonably simple report.
I have 7 columns in it, I prepared an SQL statement by hand which contains GROUP BY and ORDER BY clauses. I need to replicate it exactly in Impromptu Admin.
Here is part of the raw SQL query I developed:
......
GROUP BY
CategoryCode, Category,
ReasonCode, Reason,
OutcomeCode, Outcome
order by
Category,
Reason,
Outcome;
I created the Query in Administrator (I did not employ raw SQL). The generated SQL code is like this:
group by T1."CategoryCode", T1."Category", T1."ReasonCode", T1."Reason", T1."OutcomeCode", T1."Outcome"
order by 1 asc , 2 asc , 3 asc , 4 asc, 5 asc , 6 asc
So this has the correct columns in the correct order for the GROUP BY clause, but how do I force the ORDER BY columns to be like this:
order by 2 asc, 4 asc, 6 asc
?????????????
Please let me know if anyone knows how to do this!
Thanks heaps....
I have 7 columns in it, I prepared an SQL statement by hand which contains GROUP BY and ORDER BY clauses. I need to replicate it exactly in Impromptu Admin.
Here is part of the raw SQL query I developed:
......
GROUP BY
CategoryCode, Category,
ReasonCode, Reason,
OutcomeCode, Outcome
order by
Category,
Reason,
Outcome;
I created the Query in Administrator (I did not employ raw SQL). The generated SQL code is like this:
group by T1."CategoryCode", T1."Category", T1."ReasonCode", T1."Reason", T1."OutcomeCode", T1."Outcome"
order by 1 asc , 2 asc , 3 asc , 4 asc, 5 asc , 6 asc
So this has the correct columns in the correct order for the GROUP BY clause, but how do I force the ORDER BY columns to be like this:
order by 2 asc, 4 asc, 6 asc
?????????????
Please let me know if anyone knows how to do this!
Thanks heaps....