Hey guys I modified the ARForm SSRS report to include the SO Number and a sum of the Material shipped. I copied the report folder pasted it within my custom reports folder and made the mod there. Within epicor nothing much changed. I un-excluded the SO Number in the RDD and I added it to the report by adding it to the dataset expression and adding the additional field. The SO number is coming is just fine but the sum goes crazy when a Credit card charge is present as a Miscellaneous Charge. I have no idea why its doing this. Also for some reason I get an Error: Subreport could not be show. Pictures of original vs modified are shown below. in tis case the quantity shipped shown is 2250 vs an actual 1500. Any help is appreciated.
Guessing your supreports are erroring because the paths to the subreport RDL locations broke when you copied everything over to the custom reports folder.
On the material shipped sum – sums can get tricky in SSRS due to how Groups are set up in the RDLs (particularly the “details” section). Sometimes it is easier to handle sums and whatnot inside the SQL select statements of dataset queries (instead of doing calculations on the “report” level).
That was my next approach. Unfortunately I’ve been sidetracked with other projects. I will reach back out if I have trouble modifying the expression by adding the sum in the code. My assumption is that the group by clause may give me some trouble.