mariej
May 15th, 2001, 05:34 AM
hi.
i need serieous help with regards to using the parameters tab in data environment. right now i have a form that calls the datareport once i press a commandbutton.
the data report is populated using data environment. the source of my data is a sql statement with parameterized query (because i need to know the month and year entered on the form to generate the report). i created parameters on the commandbutton that has the value of the month and year. my problem is this: how do i pass that parameter which i created on the form to the data environment?
on my sql statement i used the question mark on my where condition, example:
where table.year = ?
and table.month = ?
but i don't know how to use the parameters tab. please help. also, is my where condition ok?
please help.
thanks in advance
i need serieous help with regards to using the parameters tab in data environment. right now i have a form that calls the datareport once i press a commandbutton.
the data report is populated using data environment. the source of my data is a sql statement with parameterized query (because i need to know the month and year entered on the form to generate the report). i created parameters on the commandbutton that has the value of the month and year. my problem is this: how do i pass that parameter which i created on the form to the data environment?
on my sql statement i used the question mark on my where condition, example:
where table.year = ?
and table.month = ?
but i don't know how to use the parameters tab. please help. also, is my where condition ok?
please help.
thanks in advance