Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

I want to develop a SSRS report which shows the employees in respective departments. Expand / Collapse
Author
Message
Posted Tuesday, February 5, 2013 6:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 3:08 PM
Points: 1, Visits: 3
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


Post #1415789
Posted Tuesday, February 5, 2013 6:29 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:20 PM
Points: 18,064, Visits: 16,099
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
Post #1415799
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse