Trouble with Data Sync in Report Data Definition

[Asz0ka (Adam Szoka)]

Apparently that sync data set button causes more problems than it fixes. There are several posts on it. Rather than syncing the data set, I’ve always just modified the SSRS data set query in the report builder after setting up the new RDD. I would probably make a new RDD, don’t click sync dataset, and edit the query in report builder.

Here’s a good’n

The truth about Report Style "Synch Dataset"

The 2nd way seems to be what Epicor intended. I feel that just adding fields in the RDL is “cleaner” than adding tables via joins too. The PackSlip RDD already includes the table OrderHed (although it appears to have no table relationships). And the OrderNum was already in the Picked Links. So I all have to do in the RDD is make sure the fields are in the Description Fields. Just curious … Since the OrderHed table was already included and the linked to the ShipDtl, why can’t I just make sur…