trvpseudo

fyi, the 5432 in console is a hardcode string, can ignore it or change it somewhere in postgre folder. find the script used to turn on postgre and u'll find the hardcode text. regardless, if u do the step above it shouldve been connect to the assigned DB.

hi, thanks for the answer. will do consider it. thanks!

hi i want to know if anyone hv jasperserver v6.2.1 installed in your windows server 2016 and it works fine? i look at the guide instalation book it says windows server 2008 but currently im using it in windows server 2012 and its fine. so to make sure its also fine in WS 2016. please share your idea, thanks! regards - TV

hi please check ur driver / lib. make sure u have the required driver installed within the apps. in my case i was losing ojdbc.jar regards, TV

if u use jasperstudio or ireport, theres "pattern" properties. just click the elements and find "pattern" in the "text field" properties tab. theres some default pattern in there u can choose. regards, TV

u cant add logic in parameter default expression, coz default expression will be overwritten by the time user give an input. try to add logic into ur SQL instead : select * from [table_name] where [column_name] = (case when $P{param_name} = 1 then 26 else 0 end) u can put the logic to variable. but i hvnt tried adding variable to the SQL. regards, TV

try to move the logic to sql

found the way for bundling version - if you need to create DB first in remote server follow this step: 1. install the jasperserver with .run (linux) 2. change in buildomatic default_master.properties : host, port, dbusername, password & ucomment something like "js.dbName = jasperserver" (can change jasperserver to ur custom DB name else it will create DB by the default name jasperserver) 3. change jasperserver file META-INF/context.xml, change username, password & url 4. go to buildomatic command prompt and do './js-ant clean-config' then './js-ant gen-config' (using linux, if windows without ./ ) 5. then do './js-install.sh minimal' (minimal = no sample data), this step will create the DB with the new config in default_master.properties note that u need existing credential within the server allowed to create DB so buildomatic can create the DB. - if you already have DB created within the remote server : 1. simply change username, password and url in webapps/jasperserver/meta-inf/context.xml 2. restart jasperserver it shouldve connect to remote server. Regards, - TV - last update 13 aug 2020

thank you and i did already tried it. so its because the admin dont allow my userid to crate omg.. now the DB has been created in remote server, cant connect to it when i start the ctlscript.sh start the postgre seems to connect to port default 5432 not the port i specified like 5551 any idea about that? thanks a lot

hello all, so lets go to the main point. i already did ALL documentations provided but nothing! heres what i did : 1. install jasper 2. have postgre 9.5 in app server 3. have same postgre 9.5 in db server 4. test wether they can connect (yes they can connect) 5. change buildomatic/default_master.properties parameter, META_INF/context.xml 6. clean config 7. gen config 8. js-install.sh minimal 9. DB created 10. start service with "ctlscript.sh start" 11. postgre connect to 5432 (in remote server its 5551) how to setup the connection to the right port? any idea? pls help, any idea might give me a clue. regards, -TV

pre filter the data 1st when u query the data (where ...)

found it! 1. u can check release note on ur jasper installed folder 2. use pgAdmin reference to : https://database.guide/how-to-check-your-postgresql-version/ 3. or lastly go to documentation of any version u need then find any file named tibco-jasperreports-server-supported-platform-datasheet it should have the better explanation. regards, TV

hi, anyone can tell me where can i check compatible postgres DB for jasperserver ? esp jasperserver 6.2.4 linux? i want to make DB environtment then instal jasper with existing Postgres DB i've prepared. pls help regards, TV

i think u can no pass variable from the subreport to master because master is generated first u can no pass a parameter until its exist and after the subreport is generated yea, theres no way itll tell its master a new param since the master is finished Goodluck ! -TV

u can do : login as admin/superuser > manage > server setting > export check anything u want to export then name the export file. then go to ur production : login as admin/superuser > manage > server setting > import voila! -TV

hi, i dnt know how to do it but maybe a schedule could be alternative? right click on the report, choose scheduler and email everyone u want to send the file :D

XD

hi Gaby, not weird, its just.. theres someone special similar to ur name :') anyway XD sometimes works from scratch did the magic! delete the variable, just use field. when u drag there, in the popup choose sum option welp, i did try some cases before telling others the way and it seems fine (including using variable instead of field), but prob not this one :/ no worries, eventually ull get use to it through experiment. i once stuck on something for 3weeks without a clue lol hope u did well asap El :D regards - TV

are you using linux? i once have similar problems, its becoz of the license cant be found. if so, perhaps you will need to change the path so the app can find license. check https://community.jaspersoft.com/documentation/jasperreports-server-install-guide/v56/setting-jasperreports-server-license

hi hi~ i hv something similar, but in jasper scheduler, u cant put dynamic value (as far as i hv explore, i might be wrong) if the date is repetitive like 'today' then u can set the query always today! in my case : "... case when $P{SELECTED_DATE} is null then sysdate-1 else ${SELECTED_DATE} end ...." so if the user intend to use the sceduler, itll always get the day-before data :D if u want something more complicated but prolly dynamic, put the input date in a table say table A, then use batch or something to update the date. the report query then will select the date in the table A. note : havent tried but was my last idea at that time, lol regards - TV

Hi Gabriel :') try step below : - add header footer if ure using table component - drag the field to header footer and it will popup a menu, u want to choose summary - try execute the report, it should show the summary of the data u rendered else u want to test first? drag any field to any other than detail band in ur report then choose summary. it should render the total of the field. else u hv complicated one which the total is based on each group. in ur case the group is S.L.U, then if u render ex. S.L.A u want the total is based on the data shown in S.L.A group u might need to change the Reset type. hope u did well ! - TV

Hi there, i did it like : -create variable grand_total -default expression is 0 -expression is : $V{GRAND_TOTAL}+$F{FIELD_NAME} -put the variable in the table note if u want to reset the grand total, the step @gabriel told us is the way! damn why ur name is gabriel :') also make sure both variable and field is BigDecimal type im also new to jasper, hello fellow newbies :D regards - TV

hi gradstu1 ! i think u dont use "OR" in "IN" unless theres subquery inside "IN". ckeck https://www.w3schools.com/sql/sql_in.asp :D perhaps u need to write "... WHERE adm.id IN($P{ID}, 'ALL') ...", it will return ID which user input & 'ALL'. but that will only work for 1 parameter, idk if case "$P{ID}" contains multiple value separated by comma "," could be read by the query as well. hth + regards C-TV lol

Hi, i want to make a barchar report and whichever user click on it, table will show up with the data. anyone know links or guides i can read to learn it? side notes : - i use bundled version 6.2.1, so no source code i guess - i already explore hyperlink but i think thats a trick to do this while im still looking the best practice of it - example click 2nd bar in barchart, only data in 2nd bar shown, this already done in sample report but theres no explanation or i couldnt drill its concept/theory/etc.. thanks in advance. TV

me pleasure, goodluck on ur project! - TV :D