jkeri
-
Posts
90 -
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 jkeri
-
Have you considered designing your query as 3 queries combined with a UNION statement and then using PRINT EXPRESSION ? SELECT a,b,c, 'QUERY1' from xtable UNION SELECT a,b,c, 'QUERY2' from xtable UNION SELECT a,b,c, 'QUERY3' from xtable
-
I had a similar situation. My solution was to use a crosstab design. all my depratments were across the top and the sale dates were the vertical column.
-
this is the parameter in XML <parameter name="FROMMATERIAL" class="java.lang.String"/> <defaultValueExpression><![CDATA['XX']]></defaultValueExpression> </parameter> My default value to appear is 'XX' which the user can select or change the value. But Im getting an error: 'Invalid content was found starting with element 'defaultValueExpression'
-
i want to create an input control that shows a default value. The user can change the value if they wish. I am not sure how to set up the input control. I created TYPE: SINGLE VALUE and added the default value to the PATTERN. but it doesnt seem to work when the uses enters a value.
-
I want to print the TITLE band on the first page of my report and have it on a page all by itself. I tried PRINT WHEN EXPRESSION on the TITLE band new Boolean($V{PAGE_NUMBER} !=0) and it didnt work.
-
I dont know XML well enough to make such a code change. I was thinking that there is some sort of Java code I could put into the PRINT WHEN EXPRESSION that would test that value of the field and set the backgorund to red
-
I have a $F{NAME} field in my report. If the value of the field is null then I want the background red else just print normally. I have tried PRINT WHEN EXPRESSION and just cant figure out how to do it.
-
I am not a Java developer so I dont know the java well enough. My question is. I want to print a value of 'YES' when $F{NAME} is null and 'NO' when it is not null.
-
Mlopez. Thank you for the time. You were absiolulty correct in your solution. There was a small speeling difference that was hard to spot.
-
Jasper version 6.3 I have two parameters: Single select for COUNTRY. depending on which COUNTRY, my cascading input control displays a list of STATES. User can select one or multi STATES. In the report query i have a WHERE CONDITION $X{IN,table_field,STATES} STATES is definied as a java.util.ArrayList. PROBLEM. The SQL WHERE condition doesnot work. It looks like STATES contains null even though I selected multi from the dropdown.
-
My user has to enter single or multiple values for a paramater. WHen I try to create the input control, I do not see an option under 'TYPE" similar to 'SINGLE VALUE' to allow multiple values. There is no list of values not SQL equery required. All the user has to do is to enter one or more values for the parameter. What would i select for the TYPE when creating the input control?
-
I have a client who wants to run compiled jasper report, not from a Jasper reports server, but instead from a Java GUI application that they can write in-house. Does anyone know a website or other resourse where I can further explore this option?
-
We created a jasperreport using Jaspersoft Studio 6.3.0... We want to deploy our report to our users. What tools are beign used to launch the reports? We want to launch each report from a GUI via its own button which will fire up the reports input controls and then launch the report. All our reports are beign re-written from Oracle forms so we haev tp have some sort of a launch pad.
-
I have a barchart and the vertical lines are too thin. I need to increase the width. My understanding that in order to do this i need to create a barchart customerize class. an someone tell me how to create one and when it is to be stored and how do i invoke for this report?
-
I want to print my DETAIL band when $F{CENTER} not equal 'NYC' Can someone help with this?
-
I have a report that has a cross tab and a chart in the summary band. The cross tab uses the main dataset and the chart has its own dataset. both crosstab and chart have a common parameter. The cross tab queries using the paramter, but the chart which uses its ownd dataset doesnt seem to get the paramter value passed to it.
-
I have a crosstab that has daily totals for each sale_type and a final total for each sale_type for each city. CITY DATE SALE1 SALE2 SALE3 Boston 01/01/17 11.11 0.00 22.22 01/02/17 44.44 88.88 77.77 Portland 01/01/17 10.00 70.00 90.00 What I want to do is to put the city totals (Boston SALE1 55.55, SALE2 88.88, SALE3 99.99 & Portland SALE1 10.00 SALE2 70, SALE3 90.00) into a bar chat I dont know what values to use for VALUE, LABEL, CATEGORY or SERIES nor am I sure what bar chart style to use.
-
I want to use a map of a city and in it identfy the areas for each zip code. Anybody know where I can get such maps for my Jasper report?
-
Why not just add another DETAIL band and make it conditional as to when u want it to print? Thats what i would try and change the TITLE BAND hieght to 0
-
Why not just add another DETAIL band and make it conditional as to when u want it to print? Thats what i would try and change the TITLE BAND hieght to 0
-
I just created y first CROSSTAB report and it was very simple to do. Make sure you put the crosstab into the SUMMARY band.
-
I would suggest perhaps doing as much of the CASE work in the SQL . Ive had situations similar to yours and it was easier to get the SQL to do it.
-
I have an input control which uses an ID called SITES and is a MULTI-SELECT QUERY for one of my reports. I need to create another input control for an ID called SITES which is a SINGLE SELECT QUERY. Jasper report uses $X{IN,fileda,SITES) allows multi select. The other report is 'WHERE $P{SITES}= fieldb' which allows for single select. Question: Can i use the same ID (SITES) in two different input controls? Beacuse when i try to create my single select query input control i get an error that 'the resource with the same id already exists'.
-
I disagree with your answer. it is better to use SQL BETWEEN as in this case: and pay.payment_date between $P{DATEFROM} and $P{DATETO} But that is not my original question. I was asking during the publishing step, do I need to do anything to the date parameter to pop up or is that done at the time input controls are created?
-
I have a Jasper report with 3 paramaters. I have started to publish it and was able to create a SQL for one of the parameters but I dont know how to handle the other parameters that are date ranges (DATEFROM and DATETO). what needs to be done for the date parameters?
