The report writer appears to have a problem with the expression.

I fixed the problem by creating a new column called ReportID in each of the report cursors. The ReportID column is the expression:

ALLTRIM(STR(tooltypeid))+"-"+ALLTRIM(STR(moldid))+"-"+ALLTRIM(STR(dieid))+"-"+ALLTRIM(STR(insertid))

I set the relationship between the cursor on the reportID column and changed the report Data Group expression to reportID and the report now works as expected.


>Hi All,
>
>I've read both of Cathy Pountney's MSDN acticles and searched here for an anwser with no luck.
>
>Using the VFP 9 "Target Alias" feature in the detail band. I've got two tables - Base_Tooling and Tool_Inventory. I've set a relationship between the two on the following expression:
>
>ALLTRIM(STR(tooltypeid))+"-"+ALLTRIM(STR(moldid))+"-"+ALLTRIM(STR(dieid))+"-"+ALLTRIM(STR(insertid))
>
>When I browse both tables and walk through the Base_Tooling the Tool_Inventory records show as expected.
>
>Not using the Data Environment and it is empty.
>I created a Data Group with the same expression.
>I added "Tool_Inventory" as the target alias.
>The Base_Tooling table is selected when the report is run.
>
>In the Group Header I created a field control with the expression Base_Tooling.Tooling_Name
>In the Detail I created a field control with the expression tool_inventory.location
>
>The report ONLY displays the first tool_inventory record.
>
>I created another report - Base Products. The only difference is the relationship and data group expression which is productid. This report works as expected.
>
>Could the expression - ALLTRIM(STR(tooltypeid))+"-"+ALLTRIM(STR(moldid))+"-"+ALLTRIM(STR(dieid))+"-"+ALLTRIM(STR(insertid)) somehow be confusing the report writer engine?
>
>These are very similar, simple reports so I can't figure out why one works and the other doesn't.
>
>Any ideas?
>
>Thanks!