#1 2017-11-28 20:10:08

shahidkapoor
Member
Registered: 2017-11-20

Reportserver url for Asp.Net MVC

Hello, I am accessing the report server via URL below, as mentioned in section 6.11.2. on this page - https://reportserver.net/en/guides/admi … a-the-URL/

URL - http://127.0.0.1/reportserver/ReportSer … xec/key:xx

How can update the PORT & reportserverbasedir if there is a need? Can someone please help me with the config file name/location?

My goal is to embed the report execution view via URL (without login). If I use the apikey, user parameters in the url, it doesn't bypass the login screen. Can someone please let me know the url?
I am using - http://127.0.0.1/reportserver/ReportSer … PKXGScP8r8

I also need to embed this to ASP.Net MVC web application page. Is there a recommended way to do that? Like using an iframe or some tags?


Please suggest

Last edited by shahidkapoor (2017-11-29 06:31:01)

Offline

#2 2017-11-29 09:03:32

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Reportserver url for Asp.Net MVC

Hi shahidkapoor,

how did you install reportserver? Manual installation or bitnami? I suppose using bitnami. Please have in mind that we don't recommend using the bitnami installation out-of-the-box for any production environment without securing the environment appropriately. Please check  https://forum.reportserver.net/viewtopic.php?id=993 for some security issues.

- Anyway, for configuring the port tomcat is listening on, you have to configure your tomcat by changing the "Connector port" in your server.xml file.
- The reportserverbasedir is just the directory where you installed your reportserver. You can change it by renaming the directory in your tomcat installation. If you installed tomcat over apache you also have to configure your apache. For example, in bitnami, you can change the file httpd-app.conf
- The URL you are using is incorrect. In order to access a report without login via url you need an URL as this:

http://SERVER:PORT/reportserverbasedir/reportserver/httpauthexport?id=5000&user=exportuser&apikey=79PKXGScP8r8&format=HTML&download=false

.. should execute the report with id 5000 and user exportuser.

So your URL should contain "httpauthexport" for URLS without login.
Please check again here: https://reportserver.net/en/guides/admi … a-the-URL/
6.11.3. Embedding Reports Without Login

- You can embed the URL as you would embed any URL into your page. An iframe should work, yes.

Regards,
Eduardo

Offline

#3 2017-11-29 13:49:35

shahidkapoor
Member
Registered: 2017-11-20

Re: Reportserver url for Asp.Net MVC

Thanks Eduardo! I will review the installation instructions you have mentioned.

In my report I have defined datasource parameter, how can I show parameters using the URL you have provided? The reason I was trying to use another URL because I thought I will be able to use the interactive version of the report where users shall use parameters and perform adhoc reporting as they like. Can we expose that kind of the URL without login (something like described in 6.11.4, but without login)?

In the URL that you have mentioned, can you please let me know how do I include a datasource parameter (that gets the data values from the defined datasource in the report). I referred to the table under 6.11 section that gives some info as below but I don't know how do I add a datasource parameter to the URL

"...p_  Can be used to specify parameters. After the underscore character, the parameter will be prompted by its key. p_myparameter=abc|def, for instance, can be used to set a list parameter to abc and def. ..."

Please advice

Last edited by shahidkapoor (2017-11-30 03:12:42)

Offline

#4 2017-11-30 19:44:41

shahidkapoor
Member
Registered: 2017-11-20

Re: Reportserver url for Asp.Net MVC

Is it possible to have an interactive report with DynamicList report type using a URL (without login), where the user be able to select parameter values and run report? Or i must think of using another report type like BIRT? Please suggest

Last edited by shahidkapoor (2017-11-30 20:55:48)

Offline

#5 2017-12-04 20:55:34

shahidkapoor
Member
Registered: 2017-11-20

Re: Reportserver url for Asp.Net MVC

Admins, any suggestion?

Offline

#6 2017-12-12 09:13:29

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Reportserver url for Asp.Net MVC

Hi shahidkapoor,

" Can we expose that kind of the URL without login (something like described in 6.11.4, but without login)?"
No, this is not possible in the current reportserver version. Nevertheless, you can make an interactive parameter page using HTML or similar, and putting the parameters in the URL to call reportserver.

You are right, 6.11.4 should also work with APIKEYs. We will look into this for the 3.1 version coming next year. I created ticket RS-2823 for this purpose.

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB