How to make this kind of resume details?

[aldrean]

The image above is part of a resume that I was suppose to accomplish.Problem is I had a hard time figuring it out on how can I make the Crew Documents and Crew Training Certificates looks like that, I mean, as you can see these two fields are suppose to be details since a certain crew can have just one document and yet many certificates and vice versa.

I tried using Grouping but seems that it won't work for me.By the way, I am using Crystal Reports version included in Visual Studio 2005, and my data comes from SQL 2005.Thanks.

 

[khawar]

You can use sub reports

 

[aldrean]

thanks khawar, may i ask if where should i put the subreports, is it in details section?

 

[khawar]

You can use at the report footer or detail try both and use which gives you the most appropriate result according to your requirements

 

[jepoysaipan]

Kabayan,

This is just my analysis based on the data presented:

1. Make your master table which holds the personal info (Name, Address.....Education) just be sure you have a unique identifier.

2. Create another table that will hold Crew Documents, and another one for Crew Training Certificates. Both of which will be linked to the master.

3. To show the info. for the 3 tables created, create a tab control that has the following labels Personal Info., Crew Documents & Crew Training Cert.

If you want you can post the DB so everyone can take a look and help you in your problem.

Hope that helps.

Saan ka sa Pinas?

Jepoy

 

[aldrean]

Thanks Jepoy!

I successfully accomplished this task merely as khawar had stated, using subreports.I know that your suggested way of doing this will also do good since its almost the same in concept.

Moreover, thank you for your suggestions guys.

Anyway, dito ako sa Project 4 Q.C.

Regards

~Aldrean