Jump to content
We've recently updated our Privacy Statement, available here ×

yama818

Members
 View Profile  See their activity

  • Posts

    173

  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Downloads

Everything posted by yama818

  1. yama818
    I have checked your attachment. You have defined the field type as 'java.lang.Integer'. It is indeed strange that your 'expression' does not work. The reason is that I tried it with a mock expression and it worked as expected. By the way, what values do you see in the execution result?
  2. yama818
    If '$F{annee_entree}+"/"+ ($F{annee_entree}+1)' doesn't work, it is assumed that $F{annee_entree} is of type String. '$F{annee_entree}+"/"+ (Integer.parseInt($F{annee_entree})+1)' might work.
  3. yama818
    It may work if you rewrite the condition as follows conditionExpression><![CDATA[($F{seqno2}.equals( "999") ) && ($F{Description} != null)]]></conditionExpression>[/code]
  4. yama818
    Hi,tchen Thank you. I now understand that 'Fusion Chart' means 'ChartPro'.
  5. yama818
    Hi,tchen I'm sorry for going off topic from the title. I am interested in this. Is this what you mean by Fusion Chart? https://www.fusioncharts.com/ If yes, is there a manual available on how to use Fusion Chart? I know that I can use Highcharts. (although the version is a bit old...) https://www.highcharts.com/
  6. yama818
    If I change 'Evaluation Time' to 'Group CrDr' in the calculation result field in the group footer band, does the result change?
  7. yama818
    I missed the attachment when I asked my question. Sorry about that. So it looks like your understanding of 'the settings don't seem to have any effect' is correct. Sorry for not being able to help you.
  8. yama818
    1) I see, it's not 'data source', but 'data set'. I misunderstood the question. I'm sorry. I don't know of any way to create a single crosstabulation from multiple datasets. However, I assume that you can combine elements of multiple datasets to create a single dataset, from which you can create a cross-tabulation. Of course, I don't know the detailed requirements, so I can't say for sure. 2) I saw the attached image. However, I could not understand the requirement. Therefore, it is just a guess. If the idea is to repeat the SQL execution 5 times, I think that would be difficult. If you can take the approach of creating a SQL that retrieves the data for 1-5 weeks at a time, you may be able to solve the problem. 3) That's good to know！
  9. yama818
    As shown in the linked post. '$X' can only be used for multiple return parameters. So you need to use '$P'. ex1) SELECT * FROM viewTest WHERE COMPANY = $P{LoggedInUserAttribute_company} ex2) SELECT * FROM viewTest WHERE COMPANY = $P{LoggedInUserAttribute_company1} OR COMPANY = $P{LoggedInUserAttribute_company2}
  10. yama818
    My idea is as follows: 1. provide a parameter (P_subrepo) for subreport selection in the main report. 2. place one subreport component in the main report. 3. Set '$P{P_subrepo}' to the expression of the subreport component. The user can select and display the subreport in the input control on the main report.
  11. yama818
    The first thing I came up with was to use 'LoggedInUser' in 'Built-in Parameters'. https://community.jaspersoft.com/wiki/built-parameters-logged-user You can embed it in the SQL where clause. If I wanted to use an arbitrary parameter, I could use 'LoggedInUserAttributes'. You can use attribute information related to the user as a condition.
  12. yama818
    The very first idea I came up with was to use sub-reports. I thought that each person could develop different sub-reports at the same time and place them in the main report at the end. https://community.jaspersoft.com/wiki/subreports-jaspersoft-studio
  13. yama818
    1) You may be able to use a virtual data source if you have the commercial version. I haven't tried it with MongoDB, but for example, you can combine Oracle and MSSQL data sources and still get them. Therefore, I thought it might be possible to combine different MongoDB data sources. https://community.jaspersoft.com/documentation/jasperreports-server-administration-guide/v561/virtual-data-sources 2) You may be able to do this by setting the From-To date in the input control and using 'relative date (WEEK+1)' as the initial value. https://community.jaspersoft.com/wiki/how-use-relative-dates-tibco-jaspersoft-studio-report Available relative dates: DAY, WEEK, MONTH, QUARTER, SEMI, YEAR 3) You may be able to use Scriptlet. Available at: https://community.jaspersoft.com/blog/scriptlet-example-jaspersoft-6x-begineers-hello-world-sample-example
  14. yama818
    Yes,That property is correct. Can't solve the problem by changing the settings?
  15. yama818
    My ideas are as follows. 1. Create the parameter 'P_table_name'. 2. Embed the parameter in the From clause of SQL. ---. select a,b,c from $P!{P_table_name} ---. *'!' It is important to add https://community.jaspersoft.com/wiki/how-use-p-parameter-implement-dynamic-grouping-ireport-and-jasperreports-server 3. Upload the report to the server. 4. Change the parameter settings and configure the settings for getting the list values.
  16. yama818
    Why don't you start by checking jasperserver.log to see what the error is? https://community.jaspersoft.com/documentation/jasperreports-server-install-guide/v561/jasperreports-server-log-files
  17. yama818
    You can try changing the 'When No Data Type' setting in the report properties to see if that helps.
  18. yama818
    It looks like there is no problem with the permission settings. Is it possible that the test user has a role other than 'ROLE_USER' and that permissions are affected?
  19. yama818
    I suspect that the simplest possible cause is that the'ROLE_USER'permission for the report is'no access'.
  20. yama818
    .
  21. yama818
    It may be good to write as follows LoggedInUserAttribute_<attribute name> ex) LoggedInUserAttribute_company1 LoggedInUserAttribute_company2 Reference URL https://community.jaspersoft.com/questions/538920/profile-attributes-within-main-query
  22. yama818
    Although it is unconfirmed in the community version, I think that the information on the commercial version can be found at the following site. https://community.jaspersoft.com/documentation/tibco-jasperreports-server-source-build-guide/v790/source-build-setup-other-database-0 FYI···
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore