Catch-22 Custom Report

Kinetic ERP
1

I’m having a bit of a chicken/egg issue going on. I’ve got a custom report that I’m trying to update on our upgrade test.

  1. I cannot run the report. I get invalid columns error.
  2. I cannot generate for design … See #1
  3. Of course if I download the RDL and update it and upload it (through Report Style), it just gets overwritten by what’s in the database.
  4. I tried to update it and run Conversion program #410 again, but it said it was already there … skipping.

How does one get out of this Groundhog Day scenario.

2

Why not create a new Report Style and make that the new one?

1 Like
3

If you update it through report style, it should replace the RDL on the report server. I’ve never seen it be overwritten by an existing RDL.

4

With the new Ice.CustomReportStore method, what’s on the SSRS server doesn’t matter except when you run the Conversion program #410. That’s when it imports it.

I was able to clear out the report in that table, upload the RDL to SSRS, and then run #410. It works now, and I know the correct report will be imported when I refresh the database at month end for the test. I am spot checking the most important reports before we do our UAT so we don’t have a lot of remediation time.

1 Like
5

I might have taken a slightly different approach. Copied the broken report style to a new SSRS folder, when you copy the report style you will be prompted with the Report Copy Location dialog:

image
Before image:

Then change it to something like:

image

Then you can download v1 and mess with as much as you like, when you know it is working, then download the original, and on your PC or wherever you have downloaded and modified the V1, copy it to the path of the original and upload. This is of course you just download the SSRS Report to the default locations which is typically My Documents/reports.

Apologies if I’m telling you how to suck eggs there, It may be useful for people new people playing along at home.

2 Likes
6

Yeah, that would work too. Since this is a test environment, I wanted to find a quick way to remediate issues in the UAT.

1 Like