On Cadence Kinetic Cloud and SSRS

Kinetic ERP
1

For us on cadence folks, do we currently have any working method to make a change to an existing SSRS report?

1 Like
2

I have tickets for 3 customers in the pipeline - no solutions are being offered or promised. We are back to the ZIP Export/Import - which is a nightmare for me - especially trying to do Labels.

Don’t complain too loud here or your thread will be removed.
DaveO

4 Likes
3

I was under the impression even the zip/export/import didn’t work. It doesn’t seem to in Pilot (2025.2.4). No errors it just doesn’t seem to actually update the rdl when you upload your edited version.

1 Like
4

So…we aren’t allowed to talk about the elephant in the room? :face_with_raised_eyebrow:

2 Likes
5

So far i have been able to stitch together different options to get it to work. Try Classi, Kinetic, download/upload Zip, “Design SSRS Report” manual copy from local cache, Duplicate report style to new location, Etc. I have not “failed” yet - but you have to be creative about how upload.

Sorry, that is the best I can do. The silver lining (for me at least) is I can get it to work.

6

I’ve found it’s OK to talk about everything! Complaining isn’t the issue, it’s when nothing more is being added to the conversation and we’re just beating a dead horse, that’s when a thread is generally closed. Threads are rarely removed unless there are issues of protecting IP, personal attacks, active selling, etc.

6 Likes
7

Sounds like the short answer is no.

1 Like
8

I haven’t experienced any of the issues folks are referring to here, the .zip download/upload works perfectly for me. Here’s how I do it, not sure if others are doing it differently:

  1. Navigate to the report style and click the three dots → Download SSRS Report
  2. Rename the downloaded .zip file descriptively, like “PO Update.zip” for example
  3. Extract the .zip file
  4. Open the extracted folder and navigate to the .rdl you want to change
  5. Make your changes
  6. Return to the first level of the extracted folder that just has the “reports” folder in it
  7. Zip the “reports” folder and use Upload SSRS Report to upload reports.zip
2 Likes
9

I have this hypothesis that if you started in cloud on an early version, say 2021 or 2022, these problems crop up. @DaveOlender you consult for various companies right? Are you seeing the same amount of problems with SSRS for the newer customers as you are the older ones?

10

We started on 2024.1 FWIW.

11

Good to know. That’s what I am trying to ascertain, like is it because of upgrades that it’s breaking or if you create a brand new report on the new version is the change process working just fine?

1 Like
12

Mr. @utaylor - interesting question - Have not noticed that new or old makes any difference I have a customer that is not even Live yet and they are having SSRS and Kinetic App issues that are taxing our patience.

Another customer went live 2014 and they have been solid - minus the typical occasional interruption (expected).

That said my 2014 customer has an open ticket in Pilot where i am unable to copy the standard Pack Slip RDD to a new name without it failing. We are stressing about this since the Pack Slip is a “Critical” document to do business.

DaveO

2 Likes
13

2014 customer like they became your customer in 2014? or did you mean to type 2024 (version)?

14

But that’s my question, yes you’re copying a base report, but were they live in a previous version when that report style/rdl was originally created in 2021.1 or whatever.

15

Thanks for the walkthrough, but this does not work for me.

I get no error, everything ‘works’ but printing the report style results in the unmodified version, my changes aren’t reflected.

2 Likes
16

Mr. @utah - sorry for the confusion - The reports they are running were created in 2014 - no typo. I see what you are saying and yes these are OLD reports that have run consistently for years.

1 Like
17

That’s just something I’m observing on these threads. The people having issues with SSRS are people that have been in Kinetic Cloud for some years or started on a previous version. I don’t see many new people who are saying that they are having any issues.

18

People who just got on cloud can’t come up for air long enough to think about modifying an SSRS report until about month 6.

4 Likes
19

I must be out of the loop, what exactly is occurring? I haven’t noticed any changes. I still use the classic screen to download the reports from the report style. Make any changes and reupload.

I just tested and this method still works fine. This is on a custom BAQ report.

20

I’m just writing out what I’m observing here.