cactusbeef

/images /report I have main report and one sub report , both locate at folder /report I also have two images, locate in folder /images in my main report I use /image/logo1.png it work ok , but in my subreport ./image/checked.jpg I get error at something checked.jpg is not find

what is th edifferent between "repo:" and "./" ..insert your code here..[/code]<parameter name="SUBREPORT_DIR" class="java.lang.String"><defaultValueExpression><![CDATA["repo:"]]></defaultValueExpression></parameter> <parameter name="SUBREPORT_DIR" class="java.lang.String"><defaultValueExpression><![CDATA["./"]]></defaultValueExpression></parameter>

My report need to display store name1 SubrportA, subreportB, subreportC …… Store name2 SubrportA, subreportB, subreportC …… Store name3 SubrportA, subreportB, subreportC …… any suggestion is welcome

I have an Integer parameter LOCATION_COUNT, I want to use it to control which sub report to display. I use the following syntax in my main report. It work as I expected in Studio. But when I publish to server. Only one sub report be publish to server, I had to upload there other sub report by myself. But whatever I give I or 2 in the parameter LOCATION_COUNT it always show one sub report <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + ($P{LOCATION_COUNT}>1? "SCHOOL_SUB02":"SCHOOL2_SUB01") + $P{SUBREPORT_EXT}]]></subreportExpression>

$V{Group1_COUNT}>=$F{SUM_COUNT} 1) I have a Group1 with Expression as $F{SCH_ID} , so I can display the Group1_COUNT 2) also in my sql I have someting sum (1) OVER (PARTITION BY SCH_NUM, LOC_NUM) AS SUM_COUNT, 3) $V{Group1_COUNT}==$F{SUM_COUNT}? "Total : "+$F{SUM_COUNT} : "" 4) in my testing example, the last row, the display of both Group1_COUNT and $F{SUM_COUNT} all 98 , but just can not hit the equals part ? why

the detail brand is presented data from DB , the high is not fix , how can I resize the report?

..insert your code here..[/code]my report has column header, detail and summary band, which has $V{REPORT_COUNT}, how to prevent my summary band start as a new page?

Thanks! I already solve my questions.

How to do it ? looking for some thing, if condition A add 20px at each column. can "Print When Expression" work with this

but my mast report only has some static information , not like the examply that you suggested person and email table did have a relation

Is a way to use condition to control the width of the text field in i report?

Thanks for th reply, then how to pass the parameters from main report to th esub report. my master report just some static text and log

I have master repot it contain image , Company name and so on in title I have a subreport in head, store relate information, such as name , location , state ans so on , the parameters are passt from web. where I shouls put my parameters? in master or subreport ?

I need to have sql like seelct * from student where stuid='123456' and school_year='2017' or seelct * from student depende on do the two parameter be givein gor not

Thanks, horzawa, I fingure out these 1) if you want to compile with ant you have to download jasperreports-6.0.0 the most new version did not including dis and lib folder 2) if you use eclipe +jassperSoft Studio, you have to add both jasperPorts library and jasperpot library dependencies , same tutorials only suggest five or six library , it just not work out for me . KKriplani, I just add some testing data in java class.