As you may know, Epicor creates a set of transient tables in the reporting database - each table matching the tables defined in the RDD and each table having it’s own name which is then suffixed with the GUID that identifies the instance of the report. If the RDD has a definition for Company and Part, when you run a report the Reporting database will have a table named CompanySomeGuid and PartSomeGuid with the SomeGuid being the same Guid for each table associated with that instance of the report.
In addition to the Tables defined in the RDD, Epicor also creates several other tables associated with the instance of the report. One of those is CallContextBPMDataSomeGuid and it is populated with all the columns found in the CallContextBPMData table - all columns, one row.
So… in the RDL data source section, you need to define a new table for BPMData and then add the columns you are interested in - in this case Character01. Your query for that table should go after the CallContextBPMData table with the table name function that Epicor uses in the RDL to add the Guid to the table name.
For all of you SSRS RDL experts, that information should be enough for you to get the data from the CallContextBPMDataSomeGuid table. For all of you SSRS RDL wanna-be experts, I have requested steps to follow in the Report Designer from the Report Development team - stay tuned…