Tuesday, March 20, 2012

Problem on report designer

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-

You say you are using textboxes... Are these textboxes in a List control or the Details section of a Table control?

BobP

|||

its on the list control. I only used table in EDUCATIONAL BACKGROUND.... Is it possible to show all the records in textboxes(on the list control)? If not, any suggestion of how could I design this report...

thanks.

-Ron-

|||

I think you should put all the information in your table.

You will have a detail row for each row on your page. For example:

Detail Row 1: EMPLOYEES PERSONAL INFORMATION
Detail Row 2:
Detail Row 3: Employee Name : __
Detail Row 4: Age : __
...
...
Detail Row v: EDUCATIONAL BACKGROUND
Detail Row w: EDUCATIONAL LEVEL.......SCHOOL.....FROM-TO......DEGREE
Detail Row x: Elementary..............Harvard....1990-1992
Detail Row y: High School.............LaSalle....1992-1995
Detail Row z: College.................UP.........1995-2000

Instead of putting spaces in there to make them align, I would have the SCHOOL, FROM-TO, and DEGREE in their own columns.

Hope this helps.

Jarret

|||

If table is the only solution for this. Ok, i have to use it... If there is any suggestion please tell me.

Thanks.

-Ron-

|||

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 BSCS
High School LaSalle 1992-1995 BSIT
College UP 1995-2000 BSIT

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

The report above is my expected result of my report. Until now dont get it yet. Could someone help me please. I have the problem on displaying the EDUCATIONAL BACKGRUND. EDUCATIONAL BACKGRUND of a person is dynamically created.

My table in EDUCATIONAL BACKGRUND

empno educlevel school fromto degree

1 elementary UP 2001-2002 BSCS
1 high school UP 2001-2002 BSCS
1 college UP 2001-2002 BSCS
2 elemntary UP 2001-2002 BSCS
2 college UP 2001-2002 BSCS
3 elem UP 2001-2002 BSCS
3 high UP 2001-2002 BSCS
3 college UP 2001-2002 BSCS
3 master UP 2001-2002 BSCS

I tried to use only 1 table for my whole report but i need to group the EDUCATION BACKGROUND. and the group appears in the first row of the table. How could i set the group to the last row? please guide me of what i am doing if it is correct or not. Thanks.

2nd option i tried. I used different table for EDUCATION but it will occur vry bad output.

-Ron-

|||

Hello Ron,

You will need to setup your report to group by empno, then the detail row would show the educlevel, school, fromto, and degree. The group header section is where you will need to place all of the 'static' report information (everything down to where the education levels are listed). You can then right-click on your group header and select 'Insert Row Below' and keep doing this for every row in your report (up to the education levels). It should look something like this:

Group Header Row 1: EMPLOYEES PERSONAL INFORMATION
Group Header Row 2:
Group Header Row 3: Employee Name : __
Group Header Row 4: Age : __
...
...
Group Header Row y: EDUCATIONAL BACKGROUND
Group Header Row z: EDUCATIONAL LEVEL.......SCHOOL.....FROM-TO......DEGREE
Detail Row 1: Fields!educlevel.Value...Fields!school.Value...Fields!fromto.Value...Fields!degree.Value

Hope this helps.

Jarret

|||

Thanks Jarret...i appreciate your help... :)

-Ron-

No comments:

Post a Comment