mbmorgan

The query also contains a CASE expression, which I'm starting to think is the real cause of the problem. I posted another question about that on the community. Do you know if a CASE expression is allowed in the query dialog? Thanks.

I don't believe the 100% stacked bar is available in the community edition (it is included in the HTML5 charts in the Pro edition). However, you could still use the standard stacked bar chart in the manner of a 100% stacked if you define some variables to express your data as percentages of each category. Good Luck, M.B.Morgan

By "close up", do you mean that you shrunk them to 0 height, or that you completely deleted them from the report? In either case, first go to the "Outline" pane in Jaspersoft Studio, then right click the band in question. If the height was simply reduced to zero, but the band is still in the report, select "Show Properties" from the context menu, click "Appearance" in the "Properties" pane, then adjust the Height field under the "Band Properties" heading...keying in "20 px" should be sufficient for it to appear wide enough to adjust on screen. If the band was completely removed from the report, simply select "Add Band" from the context menu, then it will be added to the report, and the properties are available to modify. Good luck, M.B.Morgan

In Jaspersoft Studio Professional... My query looks like this: select count(field1), CASE field2 WHEN '...' THEN '...' ...ELSE 'Other' END as field2 from table where ... group by field2 This query works fine when I run it in the actual database client, but when I copy it over to the query dialog box in Jasper and hit "read fields" I get an error: "Error converting SQL statement into byte array..." What am I doing wrong? Thanks, M.B.Morgan

In Jaspersoft Studio Professional...my SQL query contains a clause like "WHERE column_A >= $P{From_Date}", and my question is: how do I set the parameter 'From_Date'? Class: java.util.date Is for Prompting: checked Default Value: new SimpleDateFormat("MM/dd/yyyy").parse("01/01/2001") The column in question is of a Date datatype, in the MM/DD/YYYY format. [edit] - The problem comes when I try to read the fields from the database...I get "Error converting SQL statement into byte array..." What am I doing wrong? Any guidance is welcome. Thanks, M.B.Morgan

I had this exact same problem and reported it to Jaspersoft Technical Support. Their answer: "This is a known issue, bug 35212. It is resolved in 5.6, (expected late May). The workaround is to edit /webapps/jasperserver-pro/scripts/report/viewer.js and comment out the entire if (!it.localHyperlinksInitialized) block. The drawback however is that that will result in local anchor and local page hyperlinks not working in JRS." A modified version of the viewer.js file was attached in the response, and perhaps if you open a ticket, they'll send you one too. When I saved the updated file, the link worked! Good luck, M.B.Morgan

There's a helpful video that probably answers your question: http://community.jaspersoft.com/blog/tutorial-create-drill-down-reports-using-jasper-reports Thanks, M.B.Morgan

Hi again... you may now disregard this question as I have now figured out something that worked...it was a matter of correcting the syntax in my sub-queries and assigning the correct data types to the parameters. Thanks again, M. B. Morgan

Thanks for your response! Yes, the Query_Input_Control is of class java.lang.Integer and the default value is 1 (no quotes necessary for an integer, correct?). No success upon hitting Read Fields. However, if it helps you gain some insight into the matter, my sub-queries do contain parameters, and they look like: "SELECT count(field1), field2 from table WHERE field3 =" + $P{Param_1} + " AND $X{IN, field4, Param_2} AND $X{IN, month(field5), Param_3} AND + year(field5) =" + $P{Param_6} + " group by field2" I have the sub-queries set as string class, so the entire query is wrapped in quotes, except for skipping occurrences of Parameters, which I have concatenated. Am I doing something wrong here? Thanks again for your assistance.

Should it not be $P!{Query}...with the exclamation mark between the P and the {...?

The query dialog box in Jaspersoft Studio will not let me "read fields" with my query. Let me show what I have: A Query_Input_Control parameter, Integer class, set for prompting, to accept 1, 2, 3, etc. A Query_Controller parameter, String class, NOT set for prompting, with default value expression like: $P{Query_Input_Control} == 1 ? $P{Query_1} : $P{Query_Input_Control} == 2 ? $P{Query_2} : "select * from table where column = 'value'" The Query_1 and Query_2 are themselves parameters, String class, and NOT set for prompting, with default value expressions as the queries I want to run based on the input control. As for the actual query for the report, I have simply: $P!{Query_Controller} Upon clicking "Read Fields" in the dialog box, I get an error: "Expected lexical element not found: CREATE, DROP, SELECT, INSERT..." which I find odd, since my conditional queries are vanilla SELECT statements. What am I doing wrong? Any assistance is appreciated. Thanks, MBM.

When configuring parameters to "cascade" when running the report on Jasper Server, is it necessary to define the type as "java.util.Collection", with "java.lang.string" as the nested type name? And is a default value expression optional or required? Any assistance is greatly appreciated.

How do I include in the labels for a pie chart the value of ALL the data elements in the pie and the respective categories' percentages of the total? For example: First section would have a label as: Category 1: 24/100 = 24% Second section would have a label as: Category 2: 13/100 = 13% etc. Any assistance would be appreciated.