Resume report problem.

[rajrev]

Hi,
I posted my resume report problem on Nov. 20.2003, where
"MJRBIM" answered for that query, that works fine.

I'll give the discription about that previous post.
how to display the list of states for each emp.?

parameter : EmpId
tables :
1. EmpInfo (which contains all the info about emp)
2. Mobility (which contains Empid and State)

In Mobility table - datas like,
444 - OH
444 - MI
444 - IL
555 - IL
555 - OH
If the end user enter empid as 555, then the states IL, OH have to print on that page.
report output:
name : xxx
empid : 555
mobility : IL, OH

MJRBIM suggesed the following steps:
1.) Link the two tables on the common EmpID field.
2.) Group the records on the EmpID field
3.) Insert this formula in the GROUP HEADER.
Name : {@ResetStateList}
Formula : WhilePrintingRecords;
Global stringVar StateList := "";
4.) Insert this formula in the DETAIL.
Name : {@AddStateList}
Formula : WhilePrintingRecords;
Global stringVar StateList := StateList + {Mobility.STATE} + ", ";
5.) Insert this formula in the GROUP FOOTER.
Name : {@DisplayStateList}
Formula : WhilePrintingRecords;
Global stringVar StateList := Left (StateList,(Length (StateList)-2))

This one is working good. I got the output for Mobility as: IL,NY.. like this.

My next step on this is I've to list the
School Major Year in the next line
(ie)
Name:
...
Mobility:AL.XX

School Major Year
s1 m1 1995
s2 m2 1992
s3 m3 1989

school is in a diff. table called ESchool
555 s1 ....
555 s2
555 s3
111 s2
111 s5
If you need more detial pl. let me know.

Thanks
MK

 

[bdreed35]

Have you added the ESchool table to the report yet? Did you link EmpID between ESchool and EmpInfo?

You really haven't stated what the problem is now that you want to expand the report.

~Brian

 

[MJRBIM]

You could insert a sub-report of your data from the Eschool table into a section below the mobility data.

You would want to link it on a unique ID - probably employee ID.

 

[rajrev]

Thanks MJRBIM, it'll work. I'll let u know if i get into any trouble.