Friday, March 23, 2012

How to create charts and graphs on reports?

Hi to all,

I am newbie to Reporting Services technology

I am trying to develop some reports in Reporting Services using Visual Studio Management Express.

Is there a way to create some charts and graphs inside a report?

Have I to use Report Builder?

Thanks a lot

Bye

Sure, it's quite simple actually. The trick is to get the right SQL query.

Personally, I wouldn't use report builder.

Here are the steps:

1. Create a Report Server Project from Business Intelligence Studio

2. Add a new report to the project. This can be done by opening solution explorer (View -> solution explorer). Next, right click the name of your project then Add -> New Item. Click on Report then click OK.

3. On the Data tab, you want to create a new dataset and form your SQL statement there. This can be a stored procedure or textual.

4. From the toolbox (view -> toolbox), drag and drop a chart to the grid area of the layout tab.

5. Now, you can select the type of chart and play with whatever kind of formatting you want the chart or graph to have.

6. The important thing to do next is click view -> datasets. You want to drag and drop the field(s) to the Y or X-axis as appropriate.

If you have any more questions, let us know but that should get you started.

|||

Thanks for the reply.

I will try and I will post here news about develop

thanks a lot

bye

No comments:

Post a Comment