[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
[JASPER] Built-in parameters (SOLVED)  XML
Forum Index » Technical Help - SpagoBI Server - REPORTING
Author Message
daareiza.spw

Newby

Joined: 08/07/2010 06:49:49
Messages: 21
Location: Bogotá, Colombia
Offline

Hello,

I am migrating all my jasper reports from JasperServer to SpagoBI, but I use a lot one built-in parameter.

I was looking for a full list of built-in parameters for the jasperreport engine of SpaboBI, without success . The only one I have found is "$P{SBI_RESOURCE_PATH}".

Exist a list and the value of each built-in parameter????


Thanks in advance.

This message was edited 2 times. Last update was at 22/07/2010 22:51:14

angioia

SpagoBI hero
[Avatar]

Joined: 12/04/2010 15:41:11
Messages: 562
Location: Milan, Italy
Offline

SBI_USERID
SBI_HTTP_SESSION
SBI_RESOURCE_PATH
SBI_LANGUAGE
SBI_COUNTRY
REPORT_LOCALE
REPORT_RESOURCE_BUNDLE

plus all the analytical drivers associated to the doc. What do you need to do exactly?

Andrea Gioia
-------------------------
@andrea_gioia
@geobinitiative
-------------------------
[WWW]
daareiza.spw

Newby

Joined: 08/07/2010 06:49:49
Messages: 21
Location: Bogotá, Colombia
Offline

Hi angioia, thanks for your reply.

I needed the login name of the user, but while reading posts in the old forum, I have solved it with LOVs and user atributes.

I will play with the build-in parameters to take advantages of them in my reports, some are interesting.

Thanks again.
daareiza.spw

Newby

Joined: 08/07/2010 06:49:49
Messages: 21
Location: Bogotá, Colombia
Offline

Hi angioia,

I was trying to use the parameters in the list, with the following results:

Only SBI_USERID, SBI_LANGUAGE, SBI_COUNTRY, REPORT_LOCALE works fine, with the rest I have problems:

SBI_HTTP_SESSION: with this in the parameters list of the report, when is executed, a white page is the result.
SBI_RESOURCE_PATH: it's an empty string
REPORT_RESOURCE_BUNDLE: is null

However, when I use REPORT_PARAMETERS_MAP, this three are listed and two has a value.

This is the full list of parameters showed by REPORT_PARAMETERS_MAP:

* fechaFinal = (report parameter)
* JASPER_REPORT=net.sf.jasperreports.engine.JasperReport@900980
* REPORT_TIME_ZONE=sun.util.calendar.ZoneInfo[id="America/Bogota",offset=-18000000,dstSavings=0,useDaylight=false,transitions=5,lastRule=null]
* SBI_HTTP_SESSION=org.apache.catalina.session.StandardSessionFacade@1287b6f
* query=XXX
* isFromCross=false
* SBI_EXECUTION_ID=7d9db1828fa011dfa1df1bd8e73c84b6
* SBI_COUNTRY=ES
* REPORT_PARAMETERS_MAP=(this Map)
* documentLabel=gestionAlertas2b
* IS_IGNORE_PAGINATION=false
* srptnum=0
* document=5
* SBI_HOST=XXX:8080
* SBI_LANGUAGE=es
* SBI_SPAGO_CONTROLLER=/servlet/AdapterHTTP
* fechaInicial= (report parameter)
* SBI_RESOURCE_PATH=/usr/local/tomcat/webapps/SpagoBI/resources/img/
* SBICONTEXT=/SpagoBI
* user_id=biadmin
* REPORT_LOCALE=es_ES
* REPORT_VIRTUALIZER=net.sf.jasperreports.engine.fill.JRSwapFileVirtualizer@5feb35
* SBI_EXECUTION_ROLE=/spagobi/admin
* REPORT_CONNECTION=com.mysql.jdbc.Connection@14afe69
* SBI_USERID=biadmin
* REPORT_FORMAT_FACTORY=net.sf.jasperreports.engine.util.DefaultFormatFactory@84bbdb
* dateformat=dd/MM/yyyy
* REPORT_RESOURCE_BUNDLE=null
angioia

SpagoBI hero
[Avatar]

Joined: 12/04/2010 15:41:11
Messages: 562
Location: Milan, Italy
Offline

Ok, thanks for the feedback.

Andrea Gioia
-------------------------
@andrea_gioia
@geobinitiative
-------------------------
[WWW]
 
Forum Index » Technical Help - SpagoBI Server - REPORTING
Go to:   
Powered by JForum 2.1.9 © JForum Team