I know that I didn't phrase that title exactly correct, but here's the concept: This piece of code will allow you to create an .rdlc file (an SSRS report) in your Visual Studio project and then call that report from code; the SSRS report server will not be called. This is all Visual Studio and .NET, but produces a report.
This is a step by step guide to creating the report, it includes screen shots and code samples