Sounds like you need to do some general research. You can start with
Code Project Articles[
^].
Which options have you seen that don't "feel cool"?
There are lots of ways to connect the data, but as far as I know there is only one way to setup the report. Connect your data to the report, then design the report using the columns from your tables and the different report sections. You should find plenty of examples in the articles above that illustrate this.
This article[
^] looks like a good place to start.