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

kkriplani

Members
  • 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. What about the catalina.log in the log folder of tomcat?
  2. Steps involve: 1) Right click on styles >> Add >> Style 2) give it a forecolor 3) right click on style >> Add Conditional Style >> give a condition like below; $P{GroupField}="text" For the field you want to apply the style, click on the field and in the property select the style. Note: This property would apply to complete string and not just one word of that field.
  3. What is the name of the date parameter you have used in sql of the report? have you linked the input control with the parameter? Run the logs and check what the query returns.
  4. Firstly, on your jasperserver, manage > server settings > for the property "SQL query executer", set the property value to Debug (from the drop down on the right). Secondly, clear the jasperserver.log (empty the file, don't delete) and save. Then run the report and view the query that runs, run the query in the database by replacing the ? with relevant values. This will help you check the result from your query.
  5. The url build should be something like below; http://localhost:8080/jasperserver-pro/report......&p_para=2&p_para=3&p_para=4 where p_para is the collection parameter.
  6. Since Jasperserver is just a reporting tool, you cannot hide the footer band when the Group footer is printed. However, if you can assign a parameter such that its value is 1 when the group footer is printed but 0 when not printed, then you can achieve the requirement with printwhen condition of the page footer. Regards, KKriplani
  7. Your first and formost step must be to analyze the jasperserver.log and if possible, share it here on the forum. Also using which user are you logging into jasperserver and if you arent using superuser or jasperadmin, what is the user permissions? Regards, KKriplani
  8. Hi, This is usually a case of postgres jar in the lib folder of tomcat. Replace the jar with the latest jar and make sure you remove the older version from the directory! Also try to look for jar conflicts. Regards, KKriplani
  9. Select the field and in the properties bar, add the "Print when Expression" with the required condition. Basically, the fields will only print if the value of the parameter exceeds a certain value, in your case, 20.
  10. Your example clarrifies your requirement. Ignore my previous answer. What I finally understand is that you want to display first 20 records in table 1 and next 20 records in table two. The easient way would be to have two separate datasets. But even without that, what you can try is give all the fields of table 2, a print when condition like ; $P{Id}>20. In that case, all the fields of table two will only be printed as and when the ID is greater than 20. Hope this helps, KKriplani
  11. using the same query, you can implement the above requirement using either Conditional Parameters or if the field definition remains the same in both table, just display only the required fields in the table 2. Hope you are aware of the fact that a table need not display all the fields from the query.
  12. Hi, Just create one dataset and use it twice in the tables displaying the relevant / required fields. Regards, KKriplani
  13. Jasperserver is trying to find the license on the path mentioned above. Place the license on the above mentioned path and rerun jasperserver. Regards, Kkriplani
  14. Hi, Try using ternary statement in the expression for that text field; $V{test} == 1 ? "Heading 1" :$V{test} == 2 ? "Heading 2" : "Heading3" Regards, KKriplani
  15. Hi, You will have to edit the scheduler that you have created. In the "Notifications" tab, uncheck the "Send Failure Notification". Hope this helps, KKriplani
  16. Hi, I just came across the reason. Read below: MongoDB is a big data architecture based on the NoSQL model that is neither relational nor SQL-based. Jaspersoft provides aconnector that allows reports to use MongoDB as a data source. Reports based on a MongoDB data source can be used asTopics that allow users to create Ad Hoc views based on the fields returned by the MongoDB query. However, Domainsrequire relational data sources, and therefore MongoDB data sources cannot be used in Domains. Regards, KKriplani
  17. Hi, I guess it is not possible to use MYSQL DB and mongo db to be used individually in the same report. However, you can implement Data Virtualization to do so which would use the two different DBs as one. Regards, KKriplani
  18. Hi, You are looking to install jasperserver using Mysql metadata instead of Postgres? Get the related installation here. download any ***-bin.zip Let me know when we are on the same page. Regards, KKriplani
  19. Hi, Using a "Page break" would help. In the default expression, use a field like; $V{REPORT_COUNT} == 10 Regards, KKriplani
  20. Hi, regarding your prev question, Click on the parameter in the report >> In the properties section, you will see a checkbox for "Is For Prompting". Uncheck that and add a default value for which the report always populates data. Regards, KKriplani
  21. Hi, The use of page break and report count should help. Apply a page break and give it a print when condition such that; $V{REPORT_COUNT} > 50 Regards, KKriplani
×
×
  • Create New...