#1 2017-02-16 14:18:51

skosmas
Member
Registered: 2017-02-16

Url parameters and Report image/logo customization

1) Is it possible to hide the parameters passed for the execution of the report, maybe provide them with a different way?
For the time being I have created a query for the database that gets as a parameter the ID of certain user and exports only information concerning him.
But this parameter is sensitive and I don't want to be known.


2) In dynamic lists pdf report is it possible to replace the default ReportSever logo image with an image provided through a query to the database?
It shall be different for each user/ID as described above.


Also, I think there is a bug when embedding the Report Execution View.
If user is connected with the credentials provided for the demo at the following link: http://demo.raas.datenwerke.net/ReportS … rt/id:5601
and click on "Configure list" and then select "Edit format" or "Subtotals", an overlay is created that keeps on displaying even when the popup windows are closed,
thus disabling further operations on the Report Execution View.
The same happens as well on the Community edition that I have tested.

Offline

#2 2017-03-02 11:47:01

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Url parameters and Report image/logo customization

Hi skosmas,

1) You can set the parameter to "hidden" in the parameter properties.

2) The configuration can be found under dynamiclists/pdfexport.cf, take a look there
We are taking a look at how to pass parameters to the conf file, and will let you know

Yes, this seems to be a bug, we will take a look.

Cheers,
Eduardo

Offline

#3 2017-03-02 12:51:36

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Url parameters and Report image/logo customization

Hi skosmas,

for 2) you can change the dynamiclists/pdfexport.cf (this is for PDF export, analog to this you can change dynamiclists/htmlexport.cf for html export. This is easier to test).

You can call a script from within your template, which delivers the image for the logo depending on the userID passed as an argument. Refer to https://reportserver.net/en/guides/admi … Scripting/ for calling scripts from the url.
Remember to call "config reload" from the terminal to reload changes to your configuration.

So you can replace the template with something similar as:

<div class="wrap">
<div class="header">
<span class="logo">
<img src="http://SERVER/APPLICATIONFOLDER/reportserver/scriptAccess?id=1234&args=${parameterMap.get('userID')}" alt="logo" />
</span>

You need the parameter "userID", where your userID is passed. The script with id=1234 would then deliver the logo depending on the userID passed.

Cheers,
Eduardo

Offline

#4 2017-03-07 12:40:17

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Url parameters and Report image/logo customization

skosmas wrote:

Also, I think there is a bug when embedding the Report Execution View.
If user is connected with the credentials provided for the demo at the following link: http://demo.raas.datenwerke.net/ReportS … rt/id:5601
and click on "Configure list" and then select "Edit format" or "Subtotals", an overlay is created that keeps on displaying even when the popup windows are closed,
thus disabling further operations on the Report Execution View.
The same happens as well on the Community edition that I have tested.

This bug has been fixed for the next reportserver version.

Cheers,
Eduardo

Offline

Board footer

Powered by FluxBB