I have created everything I need to print a report. I have based my report on a data source called datainvoice and a datamember called currentinvoice.


Currentinvoice is defined on a SQL statement (select invoice.* from invoice where invoiceno = ?)


I have defined a parameter in the parameter tab and now need a way to pass an invoiceno to the report before it prints (to print just one invoice that the user selects to print)


How do I pass this parameter to the data report writer so that the sql statement will read (select invoice.* from invoice where invoiceno = 3001) (the invoice that I currently want to print) If I fill in the Value prompt in the Parameter tab all works fine but the report will only print that invoice.


All help docs seem to relate to creating a new query but I want to use my nice report that I created.


Can anyone please help?