Post reply

I want to develop a SSRS report which shows the employees in respective departments.

  • February 5, 2013 at 6:18 am

    #288705

    Hi,

    I do not want to use report wizard. I am using 2008 R2

    I want to create a report eg

    Deptno 10

    EMPID Name Dept Sal

    ----------------------------

    empid Ashish CC 1000

    empid Raj TC 2000

    total 3000

    Dept no 20

    EMPID Name Dept Sal

    empid Ashish2 CC 100

    empid Raj 2 TC 2001

    total 2101

    Please provide me the steps

    The EMP table will contain : EMPID, NAME, DEPTNO, SAL

    The DEPT table will contain: DEPTNO , DEPTNAME and LOC

  • February 5, 2013 at 6:29 am

    #1584349

    The way I like to do it in SSRS is start first with the tsql that will create your report dataset. So in this case, what is the tsql that will create the results you are looking for?

    Then use that tsql to create a stored procedure. Create a new dataset in your report and specify your stored procedure as the source for the dataset.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply