when adding a description field in a linked table in a RDD is there something special I have to do to be able to query it in the report? I made a copy of the RDD and assigned it to the style, I updated the query in the RDL and added the field but I keep getting this error.
- Query execution failed for dataset ‘OrderHed’. (rsErrorExecutingCommand)
I tested ones that were already there in this case it’s OrderAck and I can see Customer_Name, Customer_CustID. But if I added something like Address1 no good.
To verify everything is updating the way it should I just removed Name from the description fields and verified it would break the report which it did, then I added it back and the report works again. So I really can’t figure out why it doesn’t like the added picked fields.
I am sure I am just missing a step. Any help would be appreciated!