Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 problem on report designer

Author  Topic 

cwtriguns2002
Constraint Violating Yak Guru

272 Posts

Posted - 2007-03-09 : 00:27:04
Hi all.

I have the problem on showing the records in my report.
I explain how i designed the report. I made the report in Business Intelligence Project. The report I am achieving is the Personal Information of all employees.
After creating a query/dataset, I dragged the fields to the textboxes. I am trying to show 1 employees' record in each page.
My report looks like this...

EMPLOYEES PERSONAL INFORMATION

Employee Name : _______________ <There is a photo Image here>
Age : _________________________
Address: ______________________
Telephone #:___________________
Province:______________________
BirthPlace:____________________
Birthdate:_____________________

Gender:_______________________WEIGHT:____
Civil Status:_________________Height:____
Relgion:______________________Hair Color:____
Nationality:__________________Eye Color:_____


IN CASE OF EMERGENCY PLEASE CONTACT
Name:__________
Address:_______
telephone:_____

EDUCATIONAL BACKGROUND
EDUCATIONAL LEVEL.......SCHOOL.....FROM-TO......DEGREE
Elementary..............Harvard....1990-1992
High School.............LaSalle....1992-1995
College.................UP.........1995-2000

_______________________________________________
Run Time: 2/3/2007
Page No. : 1


I used dot above just for spacing and alignment but not included in my actual report.

I used table for EDUCATIONAL BACKGROUD.

My problem is: when i ran the report, it can't automatically creates report for all employees. It only shows the first employee in the database.

Any suggestions and guidance please.

Thanks.
-Ron-


   

- Advertisement -