I ran across an issue with modifying Epicor forms in Report Builder. Report Builder has a character limit ( I think it is around the 32,000 mark) and Epicor’s datasets are larger than 32000. Evidently Epicor has some back end way to force it into SSRS but leaves the user stranded to modify in Report Builder. The only work around I have found it moving it to a stored procedure and let the report call the stored procedure.
I an new to SSRS and haven’t run across this before so not sure if other do something different and have not run across this…but it was very frustrating.