After upgrading from 10.1.400 to 10.1.600 a few months ago, I experienced some issues with my Report Data Definitions. I opened the non-working .600 RDDs and looked at an old copy of the same .400 RDD and noticed my .600 RDD was missing a couple of table relationships. I mapped them and it worked again.
I no longer have my old backup of .400, so I’m wondering if someone on .400-.600 could look at their CshREdit RDD and tell me what Table Relationship maps they have. If this is the same problem, maybe I can recreate manually and get it to work like I did a while back when I discovered the other errors.
LeeB - When I get to work tomorrow I’ll see if I can dig up the .400 version. If you dont get a response from me by noon CST, I forgot and you should msg me and remind me.
Thanks for that! I imported it and compared the two side by side. Nothing major missing from the table relationships like the other ones that had an issue. I don’t suppose you also have a .600 RDD for CshREdit that you could export for me, do you?
No worries, thanks for your help. I put in a ticket with Epicor Support. Unfortunately, of the 30 tickets I’ve put in, I’ve solved 28 of them before they could, so I’m not going to hold my breath.
Thank you so much! This helps narrow the culprit down. My .600 RDD matches this one exactly. Now I’m going to turn my sights to the RDL files on the Report Server. Given the RDD is in tact, I’m willing to bet the RDL file I have on my report server has the .400 schema and is calling the .600 RDD. The RDD files are definitely different between the versions, so I’ll bet that’s where I’ll find the root of my cause.
I’ll have to see if I can find an updated copy of the CshREdit.rdl, CshREdit_Invoices.rdl, and CshREdit_Recap.rdl report files from a working report server somewhere. Do you think Support would be able to send me those? Thanks so much for your help!
When we upgraded from 10.0.700 to 10.1.600, many of our RDD got broken. I was told the Sync Dataset button on the Report Style Maintenance screen would fix it. That button did not always work for our issues, but it is worth a try.
That button fixed all of my custom report issues after upgrading, but this particular one was with an out of the box report. I made a copy of this particular report style (since you can’t sync the standard) and tried synching and it didn’t work.
Thank you for taking the time to offer this suggestion–I’m sure it will help someone in the future that lands here down the line, as it’s a very valid fix to a related problem.
I have a hunch that once I get my hands on the CshREdit RDL files for .600 my problem will be solved. I’m guessing I still have the .400 RDL files in place–for some reason they weren’t updated when I did the server update
Here’s the RDLs directly from the …\E10.1.600.0\supplementalinstals\SSRS\Reports.zip.
The CashRececeiptsEditList folder has CashREdit.rdl and CashREit_Recap.rdl, but not CshREdit_Invoices.rdl.
One last comment before I close this one out in case someone comes across this in the future:
*I uploaded the RDL files to the proper report server folder as called out by the Report Style
*I synched the Dataset from the Report Style
*I then had to reupload the RDL files before it worked
It doesn’t make a lot of sense, unless synching the Dataset corrupted the newly uploaded RDL files–I’m not sure how that whole process works, but after doing the steps above, it’s working.
