Siul1981

Is this the best way to have dynamic querys? If I have something like this: select TBL.field1, TBL.field2, TBL.field3, TBL.field4, TBL.field5, TBL.field6, TBL.field7, TBL.field8, TBL.field9from(select field1, field2, field3, field4, field5, field6, field7, field8, field9from view_1where $P{P_Report_Type} = 1unionselect field1, field2, field3, field4, field5, field6, field7, field8, field9from view_2where $P{P_Report_Type} = 2 ) tblwhere $P{P_Info_Type } = 1and tbl.field2 = $P{P_xx} and tbl.field3 = $P{P_yy} and tbl.field1 = $P{P_zz}[/code] I'll have to have this repeated for all values for P{P_Info_Type}? In my case 8 times. Isnt' there a best way? Thank you for the help,Siul19981

I have the following query: SELECT DISTINCT ORIG FROM VIEW_A WHERE $P{P_Info_Type} = 1UNION SELECT DISTINCT ORIG FROM VIEW_B WHERE $P{P_Info_Type} = 2UNION SELECT DISTINCT ORIG FROM VIEW_C WHERE $P{P_Info_Type} = 3UNION SELECT DISTINCT ORIG FROM VIEW_D WHERE $P{P_Info_Type} = 4UNION SELECT DISTINCT ORIG FROM VIEW_E WHERE $P{P_Info_Type} = 5UNION SELECT DISTINCT ORIG FROM VIEW_F WHERE $P{P_Info_Type} = 6UNION SELECT DISTINCT ORIG FROM VIEW_G WHERE $P{P_Info_Type} = 7UNION SELECT DISTINCT ORIG FROM VIEW_H WHERE $P{P_Info_Type} = 8[/code]How can I make it as a dynamic query? Update: Each query would be executed according to the value of the parameter P_Info_Type. Thank you for the help, Siul1981

Thank you for the answer. You mean something like this right? <style name="Bold"><box><pen lineWidth="0.5" lineColor="#000000"/><topPen lineWidth="0.5" lineColor="#000000"/><leftPen lineWidth="0.5" lineColor="#000000"/><bottomPen lineWidth="0.5" lineColor="#000000"/><rightPen lineWidth="0.5" lineColor="#000000"/></box><conditionalStyle><conditionExpression><![CDATA[$F{BOLD}.intValue() == 1]]></conditionExpression><style isBold="true"/></conditionalStyle></style> The thing is that it doesn't seem to work. Any idea why? Thank's for the help, Siul1981 Solved - Had to change in Style and Print Details the Style into Bold (the dynamic style created)

I have a table and in one column i have a text that may or not be displayed in bold. I have a field $F{BOLD} value 1 or 0. If it's 1 the field $F{Text} must be printed in bold else $F{Text} is printed regular. How can I make this work? Thank's for the help, Siul1981

You have to add the parameters on your report inside the server. Have you already tried to add them (select your report in server + edit + select controls and resources and them add the input control)? After you add them you can run the report. Siul1981

Problem solved. Changed the Evaluation Time in Chart Properties to Now Thank you, Siul1981

I have a report that has Text Fields as Title of some Tables. How can I hide/don't print the Text Field is the result of the dataset that fills the table is null? Is it possible to group the Text Field and the Table? Is it possible to use the Print When Expression and use the Dataset as a condition? Thank you for the help, Siul

Can you give more information please

The Chart query q.quest_code = $P{Questionnaire}, (if is the same as in tables), should generate 3 charts: The 1rst with q.quest_code = XXX; The 2nd with q.quest_code = YYY; The 3rd with q.quest_code = ZZZ. I'm getting 3 charts all with q.quest_code = ZZZ. If I use the same query for a table, I'll get 3 tables, one for each quest_code with their correct values, in charts I'll get the same chart with in all 3 always the last quest_code values. /sites/default/files/images/tables.png /sites/default/files/images/charts.png Here is what I get in Charts and Tables. The correct result should be the same as in the Tables

Hi I have some bar charts and they are not beeing filled correctilly. q.quest_code = $P{Questionnaire} is where it gives the parameter values to fill the chart (for instance 1st is XXX, the 2nd is YYY and the 3rd is ZZZ). All the 3 charts are only using the 3rd (ZZZ) value for the parameter, so I have 3 bar charts exactly alike. Any ideas on where to solve this problem? Thanks for the help, Siul1981

Thanks for the answer. Tried that already and didn't work. If I run the subreposrts solo in subreport_1 I have 1 page as result (2 pages are blank and with the option When No Data Type - No Pages activated they aren's shown) and in subreport_2 I have 12 pages as result. When I run the report (with the subreports) I was expecting to have 13 pages as result, instead I have 15 pages (2 from subreport_1 blank) Any more ideas? Thanks for the help, Siul1981

Hi there, I'm using JasperStudio and I have a report with two subreports, lets call them subreport_1 and subreport_2. What I need is to remove the blank pages in subreport_1 (For example subreport1 has 1 page filled and 2 blanks) and then get the pages from subreport_2 so that I won't have blank pages in the middle of my report. If I run the subreport_1 solo I only get 1 page (blanks are ignored using the When No Data Type - No Pages option). If I run the report complete I get some blank pages on the middle (subreport_1 pages). Thanks for the help, Siul1981