I’m trying to print data from the Part table on my Job travelers. The data is in a UD field (datafield01_c) on the Part_UD table. I’ve successfully created a traveler that will correctly print datafield01_c on every material row, and I’ve successfully created a traveler where datafield01_c correctly prints in the Job Header, but I cannot get the report to correctly print both. Depending on which table I start with in Pick List in the RDD, either the datafield01_c from the top level part gets printed on every material line, or the datafield01_c from the first material line gets printed in the header. The assembly part and the parts that make it up can all have different values of datafield01_c, so I need both to print correctly.
I assume this must be because SSRS does not understand using the same field name, even if aliased from different tables, but I’m not sure how to fix it. I tried manually updating the report using an AS statement (t1.datafield01_c AS datafield012), but it had no effect and also didn’t error out, which seems strange. Is there a way to rename fields in the RDD editor in Epicor? If not, what is the proper way to do so manually?
It seems that when using “Sync Dataset”, Epicor only updates the pick link for one table and ignores other tables if the pick link description fields are identical. Which table is synced seems to depend on the order in which the pick link descriptions fields are chosen. In my case datafield01_c was displaying the correct data for the JobHead table, so I manually updated the following:
and make sure that the text boxes in the report reference the new name with =Fields!PartNum_datafield01_c2.Value
When I tried before I had mistakenly used T1.[PartNum_datafield01_c] as… , so I was pulling from JobHead where I wanted to pull from JobMtl, which was T2 in the subreport.
I have a follow-up question for you concerning “different datasets of an SSRS report in E10”. If I understood correctly, you were able to pull in more than one dataset into your report solution. Are your datasets Epicor BAQ based, or are they derived from physically writing the SQL directly into in the query textbox, or perhaps from a stored procedure?
I had recently asked EpicCare about using two separate BAQs to define separate datasets on the same RDL and they said (for v10.1.400.14) that it cannot be done:
Assuming you are using v10.2.XXX in your environment, does that version allow a developer to pull in more than one BAQ, or is your situation more accurately described as creating multiple datasets from SQL statements being entered directly into the RDL? Or, did I not receive accurate information, perhaps, from EpicCare?
I’m on 10.2.300.5. The report I was referring to was actually the canned Job Traveler report (JobTrav) that I copied and modified. I added the Part table to the Report Data Definition and then added the appropriate pick links (all done inside Epicor), and then modified the RDL with Notepad++ to suit my needs. The Pick Links functionality is actually pretty useful, though as usual the “Sync Dataset” feature in Report Style maintenance is buggy.
With regards to BAQ reports in 10.2.300.5: the BAQ report designer doesn’t allow selecting more than one query. You can modify BAQ reports through Report Data Definitions, however, and there is a “New BAQ” option. I tested it and the system did allow me to add two different reports. While I’m not sure that it will actually work, the functionality does appear to be there.
