Strange result of @prompt function!

[fernanda]

Hello,

i am using @prompt function in the select clause, but the value in the corresponding column that appears in my report is weird. I mean, i ask the user for a month (1 to 12) and a value like 256 appears in the column. It´s not always the same number but i don´t have idea how it´s being calculated... Can someone help me? Do i have a way of not showing the column.. just ask the user the question but not show the column??

Thanks you

Fernanda

 

[PAULSGS]

I don't know why the number appears but you can certainly delete the column from the report without removing it from the query.

Put your mouse cursor at the top of the column, over the edge until a thick arrow pointing down appears. Then left click to highlight the whole column including the heading then Click Edit-> delete from the menu bar