Ok...I have a new problem now. The SQL query is accepted thanks to your help. Just a reminder. I am doing
SELECT
... . ...
&lex_var my_alias
... ...
FROM
...
GROUBY
my_alias;
Also, my_alias is likend to a column for display in the report. Now, essentially the new problem is that Nothing is displayed in the column corresponding to my_alias. My guess is that for some reason or another my_alias remains at null.
Also, if it helps, in the Data Model in the reports builder. When I look at the my_alias variable, it is the only one without a yellow arrow next to it.
I would apreciate any imput.
SELECT
... . ...
&lex_var my_alias
... ...
FROM
...
GROUBY
my_alias;
Also, my_alias is likend to a column for display in the report. Now, essentially the new problem is that Nothing is displayed in the column corresponding to my_alias. My guess is that for some reason or another my_alias remains at null.
Also, if it helps, in the Data Model in the reports builder. When I look at the my_alias variable, it is the only one without a yellow arrow next to it.
I would apreciate any imput.