Hi ,

If it s neccessary to use two dataset,then Use the concept of Subreports

Place a subreport in the table of ur First report

Create another Report with the Invoice Details Dataset with Invoice No as ur Parameter (Inv Detail report)

Link the Subreport in First report with the second report (Inv detail Report)

Define Parameter as InvoiceNo in first report.

But the problem with subreports in reporting services is that once u export to excel,Only the main table is exported. !!!

:ermm: