Record selection

[crystalize]

I am working on a report that uses a file called userfield.description. It is organized by userfield.row_ID numbers and userfield.fieldposition numbers. By selecting the right userfield.row_id and a range of userfield.fieldpostions, I am able to get the data I need.

However, I need to select this by matter.name which I am having a problem relating it to the userfield.row_ID.
Matter.name is in another file. I have tried going in to database expert and linking userfield.row_ID to matter.name but the data types are incompatible.

 

[lbass]

I don't think we can help unless we know what other fields are available and how these fields display. Does {matter.name} display the same as {userfield.row_id} if placed in the detail section? What are the datatypes of each? Is there an ID field in the matter table that might match? Then you would link on that, but display the name field.

-LB

 

[crystalize]

I failed to mention, I needed to link the matternumber_ID to userfield.row_ID to access the data in the userfield.description field.

Matter.name is a string, userfield.row_ID is a number.

When I put both of these fields into the detail section I get no data. I can only put one of these fields at a time in the details section to display anything.



How would I link on the matternumber_ID and display the matter.name?

 

[lbass]

If you have linked the tables by the ID fields, then you should only have to place the matter name on the detail section. If one table has all records and the other has only some matching records, do a left join FROM the first table to the second.

-LB

 

[crystalize]

Thank you for your reply.

I tried both a left and a right join. Actually I tried all the combinations including reversing the direction of the link. When I do it one way the matter.number shows and the
user.role_ID disappears. And when I do it the other way the user.role_ID appears and the matter.number disappears (as well as other fields). I can't get both to show at the same time.

 

[lbass]

It sounds like they are not the appropriate fields to link on. Are they of the same datatype? Do they display exactly the same in the report? Please show some samples of your data.

-LB

 

[crystalize]

They are the same datatype but they will not display in the same report.

 

[lbass]

If you try them one at a time can you confirm that they appear exactly the same? Please show samples as requested. What IS the datatype?

-LB

 

[crystalize]

I have changed my direction some. I want to be able to select records by matter.number.

The row.id and the matter.number.id are both number data type. Examples of both would be from 10,019.00 to 16,693.00.
I need to select records based on the matter number which is a string, for example PLR-00691, which relates to matter.number.id 16,096.00 and to row.id number 16,096.00.

 

[lbass]

You should then link the matter number ID to the row ID number. Then use a record selection formula like:

{matter.number}in ["PLR-00691","PRT-00356"]

Or set it equal to a parameter.

-LB