Reports

[yalebulldog]

I want to create a report that print a list based on the rank order inputted by the user. Okay, simple enough, but I want the report to show blank spaces for the rank even if there is no text entered for that field.

example:

1. blank

2. Joe Doe

3. Smith John

4. Blank

[LeCates]

Hi there,

I'm inferring that your problem is that some ranks are not entered, yet you want a continuous list of all possible ranks for the report, right?

Create a separate file with one record for each rank. Then build a relationship from rank to rank and pull over the data you'd like to show on the report. Simply sort the new file by rank and print the records - it will be your report.

Good luck

[yalebulldog]

Okay I tried it and it did not work, but I was a bit vague before. I have records in one database that is sorted by a field called "sport." Every record has a name(athlete) and their sport. Each athlete is given a rank from 1-20 (20 being the maximum for this particular report). So what I want to do is a print a report that does a find/sort based on sport(got that part), then sort based on the rank given to them. The tricky part is having the script recognize it needs to list all 20 variable in order 1,2,3...., even if rank #4 is blank and to include that blank record in the list. This is either very complicated or so simple I can see it. Thanks for the help.

[Garry Claridge]

Here is a 'round-about' type of solution I have come up with after too many strong coffees.

1. Create a table/file called rankings.fp5; have a field called 'sport'; which has a single entry for each sport.

2. Have twenty calculated fields (one for each ranking; e.g. rank1), they being 'sport & "1"' etc.

3. Create a calculated field in the main table/file called 'sport_rank'; being 'sport & NumToText(rank)'

4. Create a relationship and portal in the rankings.fp5 file for each 'rankn' field.

5. Construct a layout which shows the Sport name followed by each ranking (1 to 20) with the relevent portal containg the names (or lack of) for each rank.

Hope this is of interest.

Garry