ajinkya_c

Hi, You can make a query which shows top 5 for the your measures by using functions like Rank in query. You can use both chart and table with same datasource but some time it may not in sync becouse table shows as is data fetch by query and chart grouped internally as per series and categary expression. So I prefer to use separate datasource for both chart and table. Thanks Ajinkya

Hi, Are you tried java.lang.double with numeric input control? Thanks Ajinkya

Hi, Are you mapped parameter in subreport parameter map in subreport properties? Thanks Ajinkya

Hi, You can also download it from sourceforge.net. From here you can download any version of Jaspersoft. Best of Luck. Regards, Ajinkya

Hi, Are you add ojdbc5.jar file in iReport classpath for creating datasource in iReport. And also paste in lib folder of installed jasperserver setup folder. Thanks, Ajinkya

Hi, Go to installed folder of jaspersoft and serach files decorator.jsp and ViewReport.jsp where you can find all the report structure where you can comment out the portion which you not want on report page. like You can comment out portion which remove search box from report. Hope this helps. Thanks Ajinkya

Hi, Every tool have its different way of working for same analysis. In BO driill & hyperlink are two different things for different purpose, in same way in jasper also drilling possible with adhoc report in version 5.0 later. In the same way you defined hierarchy in BO here you need to add dimensions in row in hirararchy sequence then one input control added in the report automatically by which you can drilldown & up. Same functionality but in different way. If you want to develeope report which behaves drilling likewise in BO then you need to develope it in iReport becouse adhoc report have limited feature. iReport is very flexible tool to cater any requirement but not very developer friendly, You need to take more efforts in jasper than BO to cater similar requirement. In my requirement i have report which drilled like YY--MM--WW--DD--HH, and I manage it in two report. One is my main report another is my detail report both the reports are same in structure and queris the only difference is second report input control having all the promts optional so when i drilled down from main report it not asked for input control to apply and all input control gets the value from main report. To drill up i used a text field like when i drilled down from yy--mm then in monthly report i can see year text with hyperlink to drill up with same input controls to main report. For your requirement you need to do workarounds like that. Hopes that helps. Thanks Ajinkya

Hi, Drill down thing is quite complex to develope and maintain as well. For drill down feature you need to make many changes in your report. You need to handle multiple parameter in report in such way so that end user not able to see parameter year, month week etc These parameter not available for selection to end user, these parameters are hidden and read-only for drill down purpose. Suppose you able to drill down from year-->month-->week and at lowest level of drill down and again you want to driill up so what you do for that becouse year, month input controls should not available to end user according to your requirement? Thanks, Ajinkya

Select * From Table_name Where F2=$P{P2} $P!{P1} P1 parameter expression== iif(($P{P1}==null? ' ' : "AND F1=$P{P1}") So if no values select from list then no parameter used in where condition. When some value select from list then AND F1=$P{P1} part involved in query. Thanks Ajinkya

Hi, Yes you can acheive this using hyperlink. Use parameter in report and pass the parameter through hyperlink to another report. Example: Drill down: Year-->Month-->Week Three reports year report, month report, week report when i clicked on perticular year then it takes me on month report with year on which clicked is passed to the month report query as parameter and i able to see the detailed data of cliked year same for Month --> week. You can manage it in single report also by using different datasource or by using subreports. You can also pass parameters through charts to report or charts to chart. Direct drilling not possible with iReport based report. Some type of drilling possible in adhoc domain or topic based report. or olap based report. Hope it helps. Thanks, Ajinkya

Hi, Try optional prompt with input control so that if no values check then it takes all values of list by default. Or Use optional prompt with dynamic where condition i.e (where condition in parameter $P!{}) If no value select from list then where condition not involve in query hence all values get from list. Hope this helps. Thanks, Ajinkya

Hi, Are you using subreport as resource in main report and :repo.subreport in parameter expression. Or any other way, becouse I used subreports with main report without specifyng connection. My main report and subreport both with oracle connection. Is there any different thing that you did like main report and subreport with different connetion etc. Thanks Ajinkya

Hi, Your query where condition in report may be: Where Year(chg_srv_ts)=2013) AND chg_code in (7111 ,7221,8155) or if you are using parameter for chg_code like $P{chg_code} then query becomes Where (Year(chg_srv_ts)=2013) AND $X{IN, chg_code, $P{chg_code} } =====$P{chg_code} datatype java.util.collection or java.util.list and your multiselect list input control query is select chg_code from table_name Hope this helps. Thanks Ajinkya

Hi, I am not recollect what exactely issue is but i think you miss somewhere, as report works fine in iReport so the beans class may be correct. Some referece links may be helpful to you. http://community.jaspersoft.com/wiki/custom-data-source-sample-readme#Custom_Bean_Data_Source http://community.jaspersoft.com/wiki/switching-datasource-based-user Thanks Ajinkya

Hi, Go to report properties and increase the page height and width of the page according to your crosstab width and make all crosstab column in single page. To remove blank page go to each band property and set band height and with 0 for unnecessary bands. Hope this solves your problem. Thanks Ajinkya

Hi, You can try print when expression for header band. Write condition in print when expression of header band So that it display only when query returns data. Try this may be helpful to your requirement. Thanks Ajinkya

Hi, You mean say subreport field align like main report field. Yes you can align. What issue that you face please explain in detail with some screenshots. Thanks Ajinkya

Hi, Create input control as Single select list of values for single value selection and as Multiselect list of values for multiple selection from list. Create your iReport query with where condition - single select $P{}, multiselect $X{} (java.util.collection or java.util.list). Hope this helps. Thanks Ajinkya

Hi, I think it may custom datasource related problem, Becouse when you deploy report on jasperserver then it not gives any error. Are you create custom datasource on JRS, and test the connection before run report? Thanks Ajinkya

Hi, As you have to create same analysis for each company on different page. You can add group band for company as group and place your chart in group footer, place company field in group header. So that your chart repeat for each company value. And adjust your page height and width in such way so that each page having only one chart as per your requirement. Hope this helps, Let me know what happen. Thanks Ajinkya

Hi, I think you can try to use java function in field which gives current date and time to the field. So that you can use that field as single field in report somewhere or use it in table column wherever suitable to your requirement. Thanks Ajinkya

Why you want to change sql in input control, Are you looking for cascading input control.

Hi, Check with aspose plugin for jaspersoft to export reports in formate like word, pdf, rtf etc or used jpg/png files as dipesh suggested. Thanks, Ajinkya

Hi, If tab report exported in pdf then multiple tabs should split into sections and if groups used in report then it breaks into index. So that if any report having only one tab and multiple group in same report then one section having indexes of multiple groups. Hope you understand. But this is just my thought trigger. Do whatever best in future releases. Thanks Ajinkya

Hi, Try multi-slect list of values input control so that you can select any number of values from list. You can also provide default charge_code value when none of value selected. Hope this helps. Thanks Ajinkya