Hi man,
Pass Datatable instead of Dataset to report object
Example,
report.SetDataSource(dataTable);
or
report.SetDataSource(dataset.tables[0]);
then i'm sure it needs login information
report.SetDatabaseLogon(DBUserID, DBPwd);
let me know if still trouble
Regards,
thatraja