I added a customization to map Customer.Number01 to a field we're calling Insured Amount. Added it to Customer entry form, all is well.
Now, I want to add this field to the AR Aging report. I go into report defs, and copy the ARAgng definition to wARAgng. I then go to New > Table, and start to browse to the Customer table, but then I notice that when I look at the ARPrnt table (already in the report def) I notice one column says DataBase ID and it lists Customer. So I'm thinking great, that table is already there, I can just add my field. No joy. That is some kind of temp table (I assume) and all the fields are calculated, but I can't see where to modify them. Even if I do add the Customer table, There are no keys listed for ARDtls or ARPrnt. How can I do this join? Am I going down the wrong path? Is this going to be a BAQ to a custom crystal .rpt? or can I change the Report Def and modify the existing crystal .rpt?
Now, I want to add this field to the AR Aging report. I go into report defs, and copy the ARAgng definition to wARAgng. I then go to New > Table, and start to browse to the Customer table, but then I notice that when I look at the ARPrnt table (already in the report def) I notice one column says DataBase ID and it lists Customer. So I'm thinking great, that table is already there, I can just add my field. No joy. That is some kind of temp table (I assume) and all the fields are calculated, but I can't see where to modify them. Even if I do add the Customer table, There are no keys listed for ARDtls or ARPrnt. How can I do this join? Am I going down the wrong path? Is this going to be a BAQ to a custom crystal .rpt? or can I change the Report Def and modify the existing crystal .rpt?