Web Development

Ask something
Discussion Locked

vb 6 report

0 helpful
2 replies

by clesafe

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like to develop a report that asks for parameters at run time. The data is in access 2000. other reports are coming out okey except when i add a parameter in the SQL statement. please assist.

2 replies

by chavdaraju

Reports never ask for parameter value.
But you can set the value of the parameter if it is exist in report query.

in datareport, create a query that generates your result. specify "?" where you want to provide a value at runtime. So, when you execute "report.show" command the parameters will be shown as it showes in function.

If you require I can send u a small demo.

This discussion is closed to new replies.