pass sql command to crystal report

See more:

VB

SELECT        folioid, quantity, foodorder, price, total, totalamount, totalpaid, change
FROM            foodordertbl
WHERE        (folioid ={?folio_id})
ORDER BY folioid

my folio_id parameter has a default value of 0,when i preview my report, it only display blank.i want to see the folioid increment by 1 on every transaction i made in my form. thanks ^^