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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Development » I want to develop a SSRS report which shows...

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

Rate Topic

Display Mode

Topic Options

Author

Message

ashish_sun123

Posted Tuesday, February 05, 2013 6:18 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 05, 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

SQLRNNR

Posted Tuesday, February 05, 2013 6:29 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

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 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1415799

« Prev Topic | Next Topic »

Permissions