I have two tables that I am drawing information from. A client table and an appointment table. I have the tables linked by unique client ID numbers. Basically what I need is to select the earliest date from the appointment table for the particular ID and have it appear with the rest of the client record.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Selecting a single date from a record
- Thread starter bettaa
- Start date
- Thread starter
- #2
synapsevampire
Programmer
Group by the ID.
In the Report->Selection Formulas->Group place:
{table.date} = minimum({table.date},{table.id})
-k
In the Report->Selection Formulas->Group place:
{table.date} = minimum({table.date},{table.id})
-k
- Thread starter
- #4
Unfortunatly this data is going to be put onto a filled out form. So using a seperate group isn't going to work. :-\.
What I have is, is a word document pasted into CR and I am basically having CR spit out data that is related to the form. One of the fields is "Date of First Appointment". So I am trying to figure out how to pull JUST the first date in the appointment table for the particular client number.
What I have is, is a word document pasted into CR and I am basically having CR spit out data that is related to the form. One of the fields is "Date of First Appointment". So I am trying to figure out how to pull JUST the first date in the appointment table for the particular client number.
synapsevampire
Programmer
A group deson't preclude doing that, and if you intend to describe the layout of a report, try using technical terms, such as the sections used, etc.
Crystal doesn't have filled out forms, nor will it allow you to insert values into a Word document, so none of this shed any light on your dilema.
-k
Crystal doesn't have filled out forms, nor will it allow you to insert values into a Word document, so none of this shed any light on your dilema.
-k
- Thread starter
- #6
here is an image of the report that i am working on.
The 6th line down is the line I am trying to populate. Basically the design of the 'report' so to speak is one giant detail box. I tried the formula you gave me, but it turned out as a boolean field.
The 6th line down is the line I am trying to populate. Basically the design of the 'report' so to speak is one giant detail box. I tried the formula you gave me, but it turned out as a boolean field.
synapsevampire
Programmer
Perhaps you should have read the post, it stated:
In the Report->Selection Formulas->Group place:
{table.date} = minimum({table.date},{table.id})
Not to place it in the report.
-k
In the Report->Selection Formulas->Group place:
{table.date} = minimum({table.date},{table.id})
Not to place it in the report.
-k
I think you can just create a formula:
minimum({table.date},{table.id})
Place this on the form where you want it. This assumes that you have a group on {table.id} as SV suggested. You can suppress the group header and footer though so it doesn't display.
-LB
minimum({table.date},{table.id})
Place this on the form where you want it. This assumes that you have a group on {table.id} as SV suggested. You can suppress the group header and footer though so it doesn't display.
-LB
- Thread starter
- #9
- Status
Similar threads
- Question
- Locked
- Question