I’m working on a job traveler report. We want to add some Part Attributes to the traveler for QC purposes. It started easy enough. I added the Pick Link ‘PartNum’ then added the fields ‘PartLength’, ‘PartWidth’, & ‘PartHeight’ to the picked side and saved.
I added the fields in the data set properties.
When I try to run the report I get the error the PartWidth and PartHeight columns are invalid but the PartLength column is fine. If I only add the PartLength field the report runs fine. I can’t find a difference anywhere in either the RDD or the report.
I also made sure the 3 fields were checked to be included in the RDD.
Has anyone had this happen?
You probably don’t need linked tables, those are probably excluded on Part, just uncheck the exclusions and then your select statement in the rdl will just look like T3.PartLength, T3.PartWidth, etc. Same for the columns in the data set, drop the “PartNum_”
Yes, the fields have the 'exclude column and exclude label boxes unchecked. I even went so far as to regenerate the data model on our server and restarted the app servers to see if that made a difference. No change.
I don’t have a relationship with the Part table to the JobHead table. I have it connected to the JobMtl table as we a pulling paint colors from the Part.CommercialColor field for the BOM parts. I just used the table linking like I described above to pull the other Part fields into the JobHead data set.
Yes, its a normal part number. We are wanting to use data in the Attributes tab to populate on the job traveler.
Like I said I can get the field PartLength (which is shown as “Hub to Hub Length”) on the traveler but the other 2 fields keep erroring out.
If I remove the other 2 fields (PartWidth and PartHeight) from the report it runs. If I add either or both of them it gives the error those fields are invalid. I can’t find anything different between the 3 fields.
