Use alias in the query but no report displaying

[zhshqzyc]

Hi,

Suppose I have a stored procedure which has a temp table

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

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