How to avoid uid/pwd prompts for subreport?

[Guest_imported]

Hi, I have written a report which contain many subreports,
every subreports uses some tables in the same SQL Server7
databse as the main report users. But when I call this
report from HTML page, if I want to refresh data,I was asked to input username/password for every subreports,that
make my report is unacceptable by my customers.Can you help
me on how to avoid that? Thank you very much!

 

[dlkraft]

Are you setting the user name as "sa" in your code?
Dave