SSRS Server Report Variants

Hey,

I would not recommend modifying any IAM tables, that aren’t accessible through the UI, via post-sync scripts etc.

Can you provide some more information about how you envisioned setting this up for different clients? E.g. is this the development environment and are you using a single reporting server for convenience or is it meant to work this way in production as well. Are clients separated by different IAMs or by applications inside the same IAM etc.

I think there used to be a way to change the path of the report being executed through binding a parameter to one of the selectable properties but I know that at least Indicium dropped support for that when all the “local” report types ended up in its file cache because you have to upload the report file itself to the model in the SF these days.

I guess for SSRS reports managed by a server this could still be a valid use case since Indicium doesn’t manage the report files by itself but as I said that doesn’t work at the moment so it would need to be a feature request.

Hi Tim,

For testing/dev environment I would use 1 IAM and 1 reporting service. But for production these may be different IAM and reporting services.

I added a `ssrsssrsreportserver` extended property like advised in the previous topic.

But when I want to print, I get the following error:
2023-07-11T15:00:44.2699967-03:00 40000061-000b-fa00-b63f-84710c7967bb [ERR] An unhandled exception occurred while processing the request. (ffba027a)
Prockees.Bootstrapper.ExecutionException: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.”

Any ideas?

Not that I have any experience in this, but I have to say that could this may be an spelling error? Shouldn't this spell “http://”?:

I edited the url and forgot the extra “/”. But the original url does not has typos. I verified this by copying the link to another tab and it worked perfectly.

The error mentions that the request was unauthorized which indicates the user identity that Indicium is running as does not have access to the SSRS reporting server.

If you are running Indicium on IIS this corresponds to the application pool user that was set.

Have a look at https://learn.microsoft.com/en-us/sql/reporting-services/security/authentication-with-the-report-server?view=sql-server-ver15#authentication-types for some more information about SSRS server authentication types.

By default it is set to RSWindowsNegotiate and RSWindowsNTLM which is why the current user of Indicium is used. RSWindowsKerberos would probably work as well but requires more setup. The other two (RSWindowsBasic/Custom) are currently not supported.

Another thing to consider is that credentials for data sources might be overwritten by the user credentials set in Indicium’s MetaSourceConnection or via the pool user credentials that can be set per application since 2023.1: https://docs.thinkwisesoftware.com/blog/2023_1#deployment---pool-user-credentials

As for the URL for the ssrsreportserver setting, that needs to be set to the “Web Service URL” that was configured while setting up de reporting server.

By default the virtual directory for this is set to “ReportServer”:

And “Reports” is the default location for the web view.

So if you would be using the default settings your example URL should have been:

http://reportservice.domain.com/reportserver

Going back to the original issue. If I understand you correctly the desire for having all the different client reports on the same server is mostly for testing/development purposes? If so I guess the easiest way to do this would be to bind a hidden parameter to the “File path” property like I suggested earlier and then select the relative report path on the server based on which application you are currently in (based on the alias or something).

This might still work in the Windows or Web GUI but like I said it probably doesn’t in the Universal GUI at the moment since Indicium doesn’t support that property anymore. So we would have to re-implement it for SSRS server reports, which is the only one it actually makes sense for in my opinion since Indicium manages the report files itself when using the other report types.

Allright, I will try this out and get back to you. Thanks!

@kensonlatchmansing Any updates on this topic? Do you still require support?

Hi @Jeroen van den Belt,

I unfortunately have not had enough time to try out the solution suggested by Tim.

But, I did come across one issue.

I tried changing the credentials in IIS pool for Indicium (client) but since the login requires the domain of the user. It seems impossible to register the same user (with same domain) for the SSRS server on my side.

And what if I host the GUI & Indicium on an App Service?

Hi @kensonlatchmansing, did the answer of @Tim Waalewijn help you out? If so could you please select it as best answer?