trvpseudo
-
Posts
63 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by trvpseudo
-
Hi hi~ probably make sure the data field from dataset is java.sql.date and i think better use 'pattern' than 'pattern expression' in the properties so.. -click on the text field -in the properties theres 'text field' tab -in the pattern, u can choose the date option there or custom it by combining some format or just type 'dd-MMM-yyyy' the pattern there are quite different from usual, so please take a look at https://community.jaspersoft.com/wiki/date-and-time-patterns to understand it. simply 'd' is for day, 'D' is not -- 'M' is for month, 'm' is not -- etc, look above. wish u did well on ur project! - TV
-
hi pal, maybe the same as mine! i find it in development tho. i just log in as superuser then go to repositories. i make sure that one user account has right permission in the specified folder then solve it! *note : u can set the role permission or just specific user. in my case the role is just read only. but i set that one user read + write, the user still can save the schedule regards, TV - ur friendly hope-will-be-helpful-neighbor :D * edit : the configuration is inside the application tho, unless perhaps the policy state u dont own the superuser or admin account within the app ? for the admin/superuser : -login to the app as superuser/admin -go to repository page -look for the folder u want to check the permission -right click on the specified folder and u can change the permission there by role / user
-
hi pal! insert 'Yes you can! just do it!' meme lol first u have to query normally, fix data case like "select * from dual where dummy = 'X' " when initiate new reports then in the left bottom outline box, theres parameter. u can create ur parameter there and chose its type in the properties in right bottom. also dont forget to make it always prompt in the properties if done, lets say the param u create is "INPUT_TEXT" then right click the report and change the query to "select * from dual where dummy = $P{INPUT_TEXT}" ($P{} stands for parameters) the next time u execute the report there will be input type text asking an input before the report generate. use that knowledge anywhere u need and i hope that helps! *note : after change the query make sure to 'read fields' to make sure theres no error. regards, TV - noobie as well :D
-
i've been using jasperreport around 5 months, my current opinion is its not that dynamic and hard to customize. but thats prolly coz i lack of knowledge on how to work with it. i create some reports already with custom looks and custom parameters that goes to query before generating report. the parameter is input by user and could be anything depends on the input type and u could use it in query or just show it in the report. im proud of myself with the result! also i find it quite difficult to find answers of my report development problem in google or community. u can see that many unanswered question in the question list, but comment like this haha but maybe thats because i lack of experience and still learning its 'rarely-demonstrated feature'. if i were to rate it from other reporting tool (which i never use as well), i would give 7/10 (with 6 is the lowest i would ever give. unless the app is really broken or left, i will give lower number). i advise u take ur time to look around and consult ur need, coz some company needs support for the app they purchase. then see wether jasper meet ur need or not. and if u ask me to make report like the attachment above, i would say im 35% confident to make it looks like that. 45% with minor changes, and 65% with major changes. hope my opinion helps :D regards, TV - noobies
-
wherever i look i always see it.. to play with visual.js need to do some coding. i dont have the source code or .war of the jasperreport, only .exe which embbed tomcat and jasper so i can hardly modify the application. so far i develop report using jasperstudio and i dont code the reports, jst drag and drop so little i know about coding withing jasperreport. can you provide me guide or things to work visual.js with the bundled jasperreport? itll be great help! Thanks in advance! regards, TV
-
hi tiam, he's right! we cant move the summary band location :( last time i struggled with page number in the footer page and a table in summary page, but footer page band placed above the summary band. but no worries! when printed out, the footer page content should be below summary page. regards, TV
-
How to position a table after another another table
trvpseudo replied to jaspersoft_198's topic in Products
ure welcome :D -
How to position a table after another another table
trvpseudo replied to jaspersoft_198's topic in Products
hi pal, set the 2nd table position type to float. hope that helps, cheers! regards, TV -
anyone know how to make stacked bar that when u click a part of it, will redirect user to other page and has detail of what you've clicked in it ? i explore a while theres just a little discussion without clear answer/unsolved. not just by redirecting it to other page but only the clicked part data from stacked bar category will be shown just like foodmart example. thanks in advance! regards, TV
-
DONE! in query do : to_date($P{SELECTED_DATE}, 'dd-mon-yy') ------#or any date format a day of wasting time duh, lol. hv a nice day all
-
Hi All, so i create a parameter $P{SELECTED_DATE} and will be prompted when user want to generate report based on the date they select. problem is when jasperstudio try to query, its like "...where col_date = '2/8/19'...." (8 february 2019, and it is date type), while my col_date return '08-FEB-2019' (date type), so it wont match. i try to change the pattern in jasperstudio, a label which the param will be written within the page, but only applied there in label and not the query before it generate the report. try new SimpleDateFormat...... in parameter expression, but can only as default expression where '2/8/19' will soon replace it again after user select the date then the query wont match. is there a way to change the user input result '2/8/19' to '8-FEB-2019' in jasperstudio? i tried to reduce too many logic/convertion in my sql. short version : how can i get pattern 'dd-mon-yyyy' from my date_input, not 'm/d/yy' in jasperstudio? im using oracle sql. thanks in advance! TV
-
1. ctrl c + ctrl v 2. put the query data in detail band, any textfield within it will be created as much as the data
-
Hi All, so i want to change server from windows to linux. 1st problem is i want the same configuration in windows is the same later with linux. BUT my jasper is a bundling version, which is in .exe (v6.2.1 for windows) and .run (6.2.3 for linux). theres some differences in bundled tomcat extention later after i install it. i confirm can copy-replace/add configuration file in /WEB-INF/ or within jasper app file in both server and that will do okay and might solve 1st problem but one of those files will refer to default_master.properties that will contain encrypted LDAP password. 2nd problem is encrypting and decrypting key will be different and placed randomly within jasper instalation files everytime we do an instalation (correct me if i read it wrong), so i cant blindly copy and paste default_master.properties coz the config file wont be able to decrypt later. and i dont know the LDAP password coz of the company rule, made me unable to just type and encrypt it again with new encryption key. any suggestion about those 2 problems guys? any idea helps :) thanks in advance! regards, TV
-
Hi Mr. Makushatnik, do you mean like rendering 1 row consist of grouping data only then render its group data detail below it till next group and repeat? if so, ive done similiar case with table element. i use column header band (column name), group header band (grouping), and detail band (other column data). i merge all cell in group header band and put the grouping query data render there while the other column data in detail band. example i query person group by city, preview will be : NAME AGE GENDER newyork A 45 male B 30 male los angeles C 25 female D 55 male hope that helps. cheer! regards, TV
-
lol
-
Hi Mr. Chris, i see ure using jasperstudio. check on the properties. click on ur file and u should see "When No Data Type" in the properties. u can set it to "null" or "blank page" or any that match ur needs. hope that helps :D ----edit---- try advanced and find "print when expresion" set value to "false" should do it, but need to set true to render the chart https://community.jaspersoft.com/questions/825151/hiding-empty-chartband try some logic that change the value false to true based on the data returned :D regards. TV
-
so u want to generate report form jasper daily? i think jasper can run jobs to generate report, i hvnt tried it tho. perhaps u could make a report with query that show the specified date everytime the report open and export it daily via jobs. if u by any chance able to do it, pls share here too, prob ill do the same in the near future :D
-
i would rather get your experience of how to do it rather than reading documentation :( i did read all of those, but different when you do it. sometimes the documentation tell you how to do it but dont explain where to do it. like they told you to cook but dont tell where the kitchen and tools are, so we are struggling with woods and rock. they gave you books about how to cook, soo many books that have same content but some better. you'll spend much time reading all those books to find the right one. and when you get to a place where you could ask for a clearer hint, they jst said read those books. whats the point? if there are steps of someone experienced the same problem and already solved it, at least theres something similar of those steps no matter which version we use. i write steps and related documentation after my questions get solved. so people who has the same problem will have it easier after reading those. no worries, upvote for any response i get :D thanks for your attention at least theres someone trying to help me :) continue.. requirement is i need jasper connect to an API for login. the API will check if user can access jasper then go login, if not then meh. any idea? thanks! TV
-
hi thanks for your response! i read almost everything but no idea how to do it (coz always easier said than did it right ? haha ) i follow https://community.jaspersoft.com/documentation/tibco-jasperreports-server-ultimate-guide/v610/restricting-access-role quite a while and at last it resolved my problem. clear answer if theres someone have this problem : 1. make a yourCss.css 2. open decoratorsdecoratorMinimalImport.jsp 3. add tag lib uri authz as link above, follow the link above part "Restricting a Section of a JSP File by Role" 4. give it your specified role (your link to the css can be below overrides_custom.css or anywhere that meet your requirement) 5. restart the app 6. login with superuser and upload yourCss.css to your active theme (cannot be default theme, idk if you can but i dnt know how) 7. refresh the page and login with the specified role 8. your css shoould be applied for that role only thats it! hope that helps newbie like me as well! Regards, TV
-
so this will be my last resort of things i would do with the jasper UI. can we give specific role a CSS that applied last, which is after overrides_custom.css? example : role admin will apply admin.css but role user will apply user.css i really need that to hide several menu based on roles. thanks in advance! regards, TV
-
well i need to separate "Admin" access A - role Admin - can only access repository B- role Admin - can only access user and role thats what im trying to do. any suggestion? an upvote for your kind response :)
-
i think i can do it by giving specific role to the jsp, but i cant locate it at all!! help :'(
-
Hi All, this one is urgent please help. So i need to make 2 role, say its A and B. A only able to Add users and role, while B can access repository only. how can i achieve the condition? Thanks in advance!
-
Hi All, So i want to connect my jasper with my other team authentication LDAP API. this way the user will be kick out of jasper if they re not registered to access jasper. i tried looking for this but hardly find one understandable or close to what im trying to do. Please help! Thanks! TV
-
i got the professional edition but without audit feature. should i ask my jasper provider about that?
