• You design your report using Report Designer in Visual Studio. Try SSDT

    In order to do this you could use the BI template for generating reports as you can get the help of report wizard. Once you make sure it works in SSDT you deploy it to the Report Server (I will assume you would have configured Reporting Services in Native Mode). Once it is on the server you can see your report on the report server which will appear automatically in Report Manager.

    You could also create reports using Report Builder. Here is an example although it is for different product. The links in the article give you more details.

    http://jayaramkrishnaswamy.sys-con.com/node/2777798

    The articles are also on my blog. Kindly search for 'Report builder' in my blog.

    http://hodentek.blogspot.com