I'm struggling to add a table to an RDD, and could use some help.
I'm trying to add the OrderHed table to the ARForm RDD. Where's what I've done:
1. Duplicated RDD ARForm to ARForm01
2. Add DataTable OrderHed
3. Leave all fields of OrderHed included.
4. I make a Relationship as follows:
4.1 Parent Table: InvDtl
4.2 Key: OrderIndex (none of the tables available in Parent Table have OrderNum as a choice for Key)
4.3 Child table: OrderHed
4.4 Field Relationships Company<->Company, and OrderNum<->OrderNum. Both SysFlag checkboxes clearded)
5. No Excluded Fields, Calculated Fields, Criteria, or Linked Tables are created for the newly added OrderHed table
6. Updated an ARForm Report Style to use the new ARForm01 RDD
7. Launch Invoice Tracker and Print Preview an invoice using the style from #6 above. The invoice displays as expected.
8. I Open CR Developer, opening the ARForm Report Style from #6.
9. Use the Set Data Source Location to update the CR's ReportDataSet to the XML that was generated by step #7.
I'm presented with several Map Fields Dialogs. I hit OK on each without making changes.
10. I run the Verify Database in CR - which requires me to re-enter the XML file to use, and hit OK on several Verifying/Fixing up database dialogs.
After updating the data source and the verifying the DB, I see that the added table OrderHed table is not listed in in the database fields pane of the Field Explorer. And it's not just the table I added that's missing. Tables OrderDtl and OrderRel are native to RDD ARForm, but neither shows up in the data fields in CR Dev.
When I go to the Database Expert, the Selected Tables pane (on the right) only shows 10 of the 15 tables in the RDD. Among t the missing are OrderDtl and OrderRel.
If I expand the "My Connections\ReportDataSet" in the left pane, I see all 15 tables. I can add the missing one I want (OrderHed), but it adds with no links. Creating the links I get "Cannot change join types If tables are already linked" But they werent.
Did I miss something?