I found out the data I need for my SQL Report is already defined in a dynamic dataset on another web service. Is there a way to use web services to call another web service to get the dataset I need to generate a report? Examples would help if you have any, thanks for looking :)

I don't know the details of working with reporting services, but as far as web services go:

Yes you can call one web service from another. A .NET web service is just .NET code like any other so you can create a web service proxy and call it from within a web method. Just set up a web reference to the other service from your web service project.

-Peter