A
alfred_62
Guest
Hi can anyone help me here. I have a project to do and i have no idea.
This project basically is a directory listing. I have sort the data according to the data. Also i have to change the fonts, size, spacing etc according to the data. I will give some of the requirements below. Is there any software that i can do all these? Please advise. I will try to learn the software.
Sample requirement as below.
Do i need to use crystall report?
Do i need to learn programming?
Database Structure – Religious Section
Religious database is a flat file. This contains five fields namely:
1. Religion – Text(50) – Contains the religion.
2. ListingName – Text(50) – Contains the religious place or organization name.
3. Incumbent – Text(50) – Contains the incumbents name or designation or empty.
4. Address – Text(250) – Contains the address.
5. Telephone – Text(50) – Contains the formatted telephone number.
All 5 fields will appear in the directory.
When converting the table into image format following instructions have to be considered:
1. By Religion records should be grouped.
2. Religion should be sorted according to the following order (Not in the alphabetical order).
BUDDHIST SECTION
HINDU SECTION
CHRISTIAN SECTION
ISLAMIC SECTION
OTHERS
3. Religion should be printed before the record information using 18 point bold uppercase lettering. If it cannot be accommodated into one line 2 lines can be used.
4. Religion should be centered within the column.
5. Religion should not be printed at the bottom of a column.
6. ListingName should be sorted in alphabetical order inside each religion.
7. If there are several equal ListingNames those records should be sorted by the Address.
8. If both ListingName and the Address are same those records should be grouped and all telephone numbers from the second should be printed with “Do ….” As the Address.
9. Incumbent and Address will follow in new lines with a two space tab (right indentation). If the Address is equal or less than three characters and the incumbent field is not null both field should be concatenated to Address field. If there are two or more numbers to be printed with same address this concatenation should not be done.
10. If the Incumbent field is empty there should not be empty new line.
11. If the Incumbent or Address is too long to fit into one column it should be printed in two or more lines appropriately. Breaking the line should be done from a space (Immediately before the maximum line length is preferred).
12. Telephone should be printed with the Address with the right alignment.
13. In between Telephone and Address there should be doted line to connect the two.
14. One record should lie within a one column.
15. Each page (Left page – left upper corner and right page – right upper corner) should contain the starting word of starting ListingName and the starting word of the finishing ListingName with the page number.
16. Each right hand page should contain the Religion in that page. This should appear vertically in the right hand corner of the paper in bold size in a black box in paper colour. Box with ‘BUDDHIST SECTION’ prints top of the image area and next box (with ‘HINDU SECTION’) should print down and next box (with next Religion) should print down and so on. 5 Religious should be positioned vertically right-hand corner. The gap between two boxes should be 1mm. If two or more religions come to one page all relevant boxes should appear in the same page. Use 50% gradation for the box.
This project basically is a directory listing. I have sort the data according to the data. Also i have to change the fonts, size, spacing etc according to the data. I will give some of the requirements below. Is there any software that i can do all these? Please advise. I will try to learn the software.
Sample requirement as below.
Do i need to use crystall report?
Do i need to learn programming?
Database Structure – Religious Section
Religious database is a flat file. This contains five fields namely:
1. Religion – Text(50) – Contains the religion.
2. ListingName – Text(50) – Contains the religious place or organization name.
3. Incumbent – Text(50) – Contains the incumbents name or designation or empty.
4. Address – Text(250) – Contains the address.
5. Telephone – Text(50) – Contains the formatted telephone number.
All 5 fields will appear in the directory.
When converting the table into image format following instructions have to be considered:
1. By Religion records should be grouped.
2. Religion should be sorted according to the following order (Not in the alphabetical order).
BUDDHIST SECTION
HINDU SECTION
CHRISTIAN SECTION
ISLAMIC SECTION
OTHERS
3. Religion should be printed before the record information using 18 point bold uppercase lettering. If it cannot be accommodated into one line 2 lines can be used.
4. Religion should be centered within the column.
5. Religion should not be printed at the bottom of a column.
6. ListingName should be sorted in alphabetical order inside each religion.
7. If there are several equal ListingNames those records should be sorted by the Address.
8. If both ListingName and the Address are same those records should be grouped and all telephone numbers from the second should be printed with “Do ….” As the Address.
9. Incumbent and Address will follow in new lines with a two space tab (right indentation). If the Address is equal or less than three characters and the incumbent field is not null both field should be concatenated to Address field. If there are two or more numbers to be printed with same address this concatenation should not be done.
10. If the Incumbent field is empty there should not be empty new line.
11. If the Incumbent or Address is too long to fit into one column it should be printed in two or more lines appropriately. Breaking the line should be done from a space (Immediately before the maximum line length is preferred).
12. Telephone should be printed with the Address with the right alignment.
13. In between Telephone and Address there should be doted line to connect the two.
14. One record should lie within a one column.
15. Each page (Left page – left upper corner and right page – right upper corner) should contain the starting word of starting ListingName and the starting word of the finishing ListingName with the page number.
16. Each right hand page should contain the Religion in that page. This should appear vertically in the right hand corner of the paper in bold size in a black box in paper colour. Box with ‘BUDDHIST SECTION’ prints top of the image area and next box (with ‘HINDU SECTION’) should print down and next box (with next Religion) should print down and so on. 5 Religious should be positioned vertically right-hand corner. The gap between two boxes should be 1mm. If two or more religions come to one page all relevant boxes should appear in the same page. Use 50% gradation for the box.
Last edited: