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

kkriplani

Members
 View Profile  See their activity

  • Posts

    240

  • 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 kkriplani

  1. kkriplani
    That means some data is incomplete. probably the data at value and visible columns is incomplete. example: SQL>> select id,name from tb_details where id = $P{c_id} visible column>> name value>> id Build from the example, regards, KKriplani
  2. kkriplani
    Hi, From the first screenshot you shared, the value and visible columns tab is seen. Also, i see that the finish tab is highlighted in the second screenshot. I would like to point out that in your query you have only one column, how do you intend to define two columns in the value and visible tab?! Regards, KKriplani
  3. kkriplani
    Hi, The image above displays the parameter linking between the main report and subreport. The left colum (Name) is the name of the parameter of the subreport that has to be linked with fields/parameters of the main report. The first row gives an explaination while the second row is an example. Hope this helps, KKriplani.
  4. kkriplani
    Hi, Have you tried a print when condition such that the sub-report doesn't get printed if the report count is null? If not, give it a try for respective subreports in the main report. Regards, KKriplani
  5. kkriplani
    Hi, once at this position, follow the below listed steps; 1) Click on the 3 dots besides the "query" box. Select sql in the drop down and input the query. 2) Once the query is given, come back and mention the value and visible columns. 3) Don't forget to get the datasource. Regards, KKriplani
  6. kkriplani
    Hi, As I had answered earlier to you; " The some of the probable reasons for "Error filling report" could be as follows; 1) any of the report element is overflowing 2) the total band height/width is exceeding the report height/width respectively. 3) Could be a query issue, etc However, this error gives almost no perfect idea of what exactly could be the error. Share the complete log file (jasperserver.log) from <tomcat-directory>/webapps/jasperserver-pro/WEB-INF/logs/ to let us know precisely what the error is." regards, KKriplani
  7. kkriplani
    Hi, Virtualizer would be a good option. Here is the best link for virtualizer I could work with. It will give you the over all detail required and step wise implementation. Regards, KKriplani
  8. kkriplani
    Hi, Try increasing the heap size of the tomcat. Also I read through the following regarding this error; "The GC throws this exception when too much time is spent in garbage collection for too little return, eg. 98% of CPU time is spent on GC and less than 2% of heap is recovered. This feature is designed to prevent applications from running for an extended period of time while making little or no progress because the heap is too small. You can turn this off with the command line option -XX:-UseGCOverheadLimit More info here " regards, KKriplani
  9. kkriplani
    Hi, Have you set any value in the default expression for the parameter going into the input control? If you leave it blank, it would keep the input control blank. Hope this helps, KKriplani
  10. kkriplani
    Hi, First of all you should understand the concept of subreports and main report. A main report calls other subreports into it. Steps you should follow are as follows; 1) Consider your reports to be merged (considering you are merging two reports, lets take the count as 2) as two different subreports. If the two reports are running individually (on same datasource), then you need not perform any changes on them. 2) Create a new main report and call two sub report components from the pallete giving the path of the two reports to be merged. For proper steps, please refer the guide. Hope this helps, KKriplani
  11. kkriplani
    Hi, answer me a couple of questions; 1) are you aware of the total number of options that would be available in the multiselect? (if yes, there could be a possible work around) 2) What is the data type of the multiselect? Is it a collection? Regards, KKriplani
  12. kkriplani
    Hi, The some of the probable reasons for "Error filling report" could be as follows; 1) any of the report element is overflowing 2) the total band height/width is exceeding the report height/width respectively. 3) Could be a query issue, etc However, this error gives almost no perfect idea of what exactly could be the error. Share the complete log file (jasperserver.log) from <tomcat-directory>/webapps/jasperserver-pro/WEB-INF/logs/ to let us know precisely what the error is. Regards, KKriplani
  13. kkriplani
    Hi, Every time a report is scheduled, a pdf of that report is saved at a directory decided while cretaing the schedule, check whether the user has access to that folder where the pdf is saved. Regards, KKriplani
  14. kkriplani
    Hi, what you can do is create a single sub-report. If all the 3 sub-reports are the same, call the same sub-report 3 times in the main report. Hope this helps, KKriplani
  15. kkriplani
    Hi, I assume you are trying to see the input parameters when you open a report? If so, right click on the report folder, click on properties and then click on other and you will see "controls Layout". Select the desired layout and check the box 'Always Promt" if required. Hope this helps, KKriplani
  16. kkriplani
    Glad you have found a solution. I would suggest you to mark the answer you find is right so it helps others with the same question to get to the right answer. Also start a new thread for the question you asked above. Regards, KKriplani
  17. kkriplani
    Okay. The answer to your questions are as follows; 1) The query is the main/dataset query and not the input control query. The query just shows how to implement the IN condition and the use of conditional parameters ( to know more, read my answer on this link) in jasperreports. 2) table_2 and column_2 are just table and column used for the main query (as i stated in point 1 that its just an example). 3) Yes, the conditional parameter ($P{abc}) would be a string while the multiselect parameter would be a collection. Sorry, for the late response. Let me know if you have any more queries, KKriplani.
  18. kkriplani
    Hi, Adding an advanced property as follows would help. plotOptions.series.dataLabels.enabled : true Regards, KKriplani
  19. kkriplani
    Hi, Left click on the header box, select the background color (property name is "Backcolor") and make sure you have checked the box that says "Opaque". This would set the selected color as the background. Regards, KKriplani
  20. kkriplani
    Hi, I was able to get the download from this link, give it a try hoping this wasn't the one where you couldn't download the files. Regards, KKriplani
  21. kkriplani
    Hi, Like in Excel, we have a pattern in which we can display date etc, in iReports too we have pattern. Click on the field, in the property tab, you will notice pattern. Choose the desired pattern and you can achieve the requirement. Regards, KKriplani
  22. kkriplani
    Hi, A hyperlink to another report invloves passing all the rest of the parameters from the first report. If the same is not done, rest of the parameter will be passed as null. You can pass fields in the hyperlink as well. When you link parameters, you link the parameters of the target report with the existing report. Let me know if you have any more queries, KKriplani
  23. kkriplani
    Hi javier.ggi90, Just need a clarrification, "code" and "joindate" are the columns in the table right? what i get from your logic is that you compare if the parameter is empty or has a value and if it has a value, you compare it with the respective column thus giving a filter. Correct me if i am wrong. regards, KKriplani.
  24. kkriplani
    Hi, I suppose there are a couple of workarounds, let me list them as follows; 1) either in the default expression of the multiselect parameter you can enter the values as; [1,2,3,4,5,6,7,8,9] this would check the values in the default expression. Now, Obviously if you have 300 distinct values to be checked you will have to list all of them, which is a bit cumbersome. 2) The Other method is simpler. Declare another parameter as $P{abc} and in its default expression, write; $P{m_parameter} == "null" ? "select distinct <column> from table" : $P{m_parameter} [where m_parameter is the multiselect parameter and column is the values of the multiselect parameter from the table] The sample query for method 2 would look something like; Select * from table_2 where $X{IN, <column_2> , ($P!{abc})} Hope this helps, KKriplani
  25. kkriplani
    Hi, You would probably need a line chart where you could have the month on X axis, value on the Y axis and different lines showing the value of coffee or chocolate, etc for the respective months. Hope this helps, KKriplani.
×
×
  • Create New...

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

Products

Explore