Use alias in the query but no report displaying

Hi,

Suppose I have a stored procedure which has a temp table

Code:

---

create table #TmpRptData(
        DeptNum            varchar(50)    null,
        DeptName          varchar(50)    null,
        NetAmt            money          null
}

---

So in the report there are corresponding fields "DeptNum","DeptName" and "NetAmt".
However if in the stored procedure

Finally I use alias like

Code:

---

select DeptNum as DepartmentNumber, DeptName as DepartmentName, sum(NetAmt) as NetItemSalesAmount from #TmpRptData

---

The report displays nothing.
Why?
What should I do?

Thanks for help.

Thanks