Can I use two different SPs for the same
report? When I tried to add fields from
the second sp i get an error.

thanks

Insure u can, just collapse the SP tree & add ur SPs.
if u got error It bc of ur CR. I got it in CR 9. but its ok in Cr for VS.NET.

Always:),
Hovik Melkomian.

Yes it is possible, I use 2 SP's in a single rpt; 1 in Main rpt, 1 in Subreport, and 2nd Subreport uses 2 std tables (Oracle Backend w/ ASP.Net in VS 2003 and CR 10 loaded after VS.Net 2003).

The only funky issue was setting the login credentials via code. I had to switch to the ReportDocument object model instead of the crViewer object model after applying SP2 to my CR10 embedded in VS.Net 2003.

HTH

ThotWorks