Hello, we have just started testing our Kinetic Upgrade however we have 100 custom SSRS reports in 10.2.700 I was told to zip the reports and upload them to kinetic one by one but I get an error
There are threads on here about the common database and how custom reports work in that now. I can’t speak to it myself because I haven’t experienced it yet. But there may be something trivial about the way you have to create and upload custom reports now.
@aosemwengie1 may know.
I have never once been able to get this to work lol. I always put classic report style maintenance on the menu and upload the reports the normal way.
The new thing where its supposed to be in the common database doesn’t work. Support accepted the bug but I don’t know when its getting fixed.
2 Likes
Well you heard it here first @pompe4040 … create a menu for the classic report style program and then use that to upload reports… that seems to work based on what I understand from @aosemwengie1 's post.
@aosemwengie1 , can you tell @pompe4040 what PRB number it is?
And @pompe4040 can you also create an Epicor ticket referencing that PRB so that it shows one more person is being affected by this?
Thanks for any consideration.
Respectfully,
Utah
1 Like
This is literally all the information I have:
“seems there is a bug! Rich Riley is working with his team….”
4 Likes
No PRB???
1 Like
Not that I was given.
Would the Solution Workbench work to move both the Report Style and RDD, if needed?
1 Like
Yes, but the RDDs will lose all your valid/default checkboxes. It’s obnoxious.
This may not be correct, but it’s been my experience (and I did this a LOT last week).
- Your zip file MUST be named “reports.zip”
- Inside your zip file, you MUST replicate the path to the SSRS Reports exactly.
Example 1: I want to upload an SSRS report to the base ARForm folder on the reports server.
My zip file is called “reports.zip” and inside is the following:
reports > ARInvoiceForm > ARForm.rdl
Example 2: I want to upload to my customized SOAck report.
Zip file named “reports.zip”. Inside:
reports > CustomReports > SalesOrderAcknowledgement > SOAck.rdl
You can include everything from the directory, so in the same example 2, I could include the SOForm_KitComponents.rdl as well.
If you’re uploading from report style maintenance, it will fail if the RDL named in your “Report Location” field isn’t present in your zip file with the same path. The upload will also ignore any .rdl files that aren’t added as a subreport.
If there are issues with the RDL, it won’t give you any details, just a generic error. If you go directly to the reports server and try to upload it, it will give you a better error message.
2 Likes
Solution workbench should handle this just fine. I’m pretty sure the functionality has been there since prior to 10.2.700.
2 Likes
Can you bring the actual reports (*.rdl) in with solutions? I know you can bring in Data Defs and Report Styles. Can’t remember if it works with the actual RDLs.
If you don’t mind pulling up every single report style one by one and fixing the default and valid settings for each and every company then it works great.
I came here to say the same thing about just using Classic Mode because it actually works. With that said, even if this new method DOES work, it’s still, arguably, a bad design (imo). It’s super tedious and no where near as efficient as it used to be. It sure feels like a step backwards.
You’re much better off to use Classic or Solution Workbench.
2 Likes
Yeah in classic you can just upload the RDL file and it goes directly to the path specified in the Report Location field. I can’t remember if it renames the RDL to the file name you specified or not.
Arguably is extremely generous. It’s awful.
1 Like
Agree that this part is annoying. Once you’ve set the default, it doesn’t seem to overwrite it if you install another CAB containing the same report style.
