I’ve seen other posts on here for adding a field to an SSRS report but the ones marked with solutions didn’t quite resolve my issue.
I need to add a field to a sub report on the Job Traveler (RawMaterialComponets). The Code on the native query calls out JobMtl as a left join aliased table, “T2” .
LEFT OUTER JOIN JobMtl_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.JobNum = T2.JobNum
The field I need to add is on the JobMtl table however, when I add T2.Direct to the code (and add query field on report) The SubReport section shows up blank after I upload and do a print preview.
Its as if the SubReport is breaking when I add a field thats belongs to a native table on the report. I dont get any errors when I upload via Report Style.
I’m not seeing that option in the Report Builder Client. I should have mentioned in my original post that I’m working in a SaaS environment, don’t know if that makes a difference to your previous question.
The RDD controls what is written to the temp tables (the ones with the GUID suffix). The RDD will need to be modified. But you can’t mod the original, so you’ll have to make a copy of it, and update the copy. Then update the Report Style to use the new RDD.
edit
I’m not sure how much of that you’re allowed to do in a SaaS environment.
Hi Calvin, thats exactly what I did here in terms of copying, modifying and reuploading the rdl. I should also mention, I’ve made other revisions to this new report style before and uploaded them with no issues.
The RDD (Report Data Definition) is what selects the data to put in the temp files that the RDL will pull from. This is a program (like Report Style) in Epicor. If you go into Report Style, you’ll see that each style refers to an RDD (might be labeled Data Definition).
Okay I see what you & Kyle are saying now. I made a copy on RDD but still unclear on what to update within it. I know how to update the Report Style to use the new RDD.
Thanks @kylepbsps & thanks @ckrusen ! I do wish I could mark both of your responses as solutions as I applied both suggestions to get the correct outcome (Maybe a feature that can be added in the future?).
