Thanks for all the help everyone. The problem was in my Report Relationship for the PartXRefMfg table. I had the Relation Type set to Definition Only when it should have been set to output. I recopied the standard Report Data Definition from POForm into a new user defined one and changed the relation Type. I did not press the Sync Dataset button this time and just added the fields directly thru SSRS and all worked out just fine. So the key is if you want data from the file the Relation Type needs to be set to output.
Thanks Joe, I will start over again and not press the sync dataset button. Good to know!
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.