none
SSRS,SSIS,SSAS

    Question

  • Hello everyone!

    Can we represent the database data in the form of charts(same as using asp.net charts eg line,bar,column charts)

    by using any of from ssrs,ssis,ssas.as am new bee  in the reporting services so please suggest me for building chart application.

    Tuesday, March 19, 2013 7:45 AM

Answers

All replies

  • Do you need to represent a rows per tables?

    SELECT
    t.name,
    [RowCount] = SUM
    (
    CASE
    WHEN (p.index_id < 2) AND (a.type = 1) THEN p.rows
    ELSE 0
    END
    )
    FROM
    sys.tables t
    INNER JOIN sys.partitions p
    ON t.object_id = p.object_id
    INNER JOIN sys.allocation_units a
    ON p.partition_id = a.container_id
    GROUP BY
    t.name
    ORDER BY [RowCount]  DESC


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance

    Tuesday, March 19, 2013 8:17 AM
  • \Am asking about the chart Representation like bar charts in the x axis one column data,and on y axis  the column data.

    eg:

    select student id,student name from studentdata.

    on x axis:student name

    on y axis :student id

    in the chart form.

    i hope this can be understand,but how to do by using ssrs,ssas??/


    • Edited by sravanis Tuesday, March 19, 2013 9:11 AM
    Tuesday, March 19, 2013 8:31 AM
  • Hi Sravanis,

    You can achieve your goal by using the Chart data region provided by Reporting Services. To create a chart report, we need to :

    1. Define a data source and add a dataset to the report.
    2. Add a bar chart to the report.
    3. Format the axis labels, title, and legend of the chart.

    For more information about charts and the step-by-step guidance on how to create a chart report, please see:

    Regards,


    Mike Yin
    TechNet Community Support

    Thursday, March 21, 2013 2:29 AM
    Moderator