ajinkya_c

Unable to login mobile demo site of jaspersoft

Hi, I am not sure but you can check y axis scale property, where you can set scale of Y axis at lower level so that you can see difference between bars. Let me know if need help. Thanks, Ajinkya

Hi , Can you provide any screenshot which may give more clearification and if problem is that you can not able to see crosstab properly on report then you may increase report width at maximum so that crosstab able to see properly on horizontal report as well. Please mention exact issue. Thanks, Ajinkya

Hi, you can create report with iReport and deploy on jasperserver or you can directely create report on jasperserver through domain. 1. Static reports based on iReport 2. Adhoc reports based on Domain These two main way of report generation and another way is to create OLAP based report through jasper analysis workbench. Based on your reporting requirtement you can choose any one of them. Thanks, Ajinkya

Hi Emily, You can do drill down in jaspersoft using hyperlink but hyperlink work with jasperserver based reports which you can publish through iReport or jasper studio. You can pass parameters to another report or same report through theough hyperlink and then pass these parameters to your input controls and then it works as drill down report. Thanks, Ajinkya

Hi Sanjay, I think this can be achievable using crosstab and filter, You can add filter for required columns for which you may use union query. Thanks, Ajinkya

Let me know if you find any solution or workaround for this. Thanks, Ajinkya

Hi, This can be possible with optional prompt. For example if my database is oracle then i create my optional propmt(input controls) like if i provide startdate and enddate then it takes these value to the where conditiion, if user not provide values, that is startdate enddate null then my where condition is like Startdate=(next_day(sysdate,'SUN')-7) and Enddate=(next_day(sysdate,'SUN')). similarly use date function of respective database to findout sunday dates. You can manage these two where condition based upon starttdate and enddate input control null or not null. Use P!{} parameter for optional where condition. Hope this may help. Thanks, Ajinkya

Hi, You can add preselected condition direct in query. like where col1=Naveen OR col1=sharad OR col1=$P{Multiselect_Parameter} this might one way to select predefined solution. Thanks Ajinkya

Hi, This type of requrement i think should be handle at etl side where we can use previous and current record easily or you may need to use stored procedure for that. Thanks, Ajinkya

Hi If you found this is an product related issue then raised it on tracker as bug. Assign bug to someone based on priority. Some one help you to solve your product related issue in tracker. Regards, Ajinkya

Hi, I don't understand your requirement but i think you might want the functionality of group band where no of rows separated by group of data. Can you please elaborate your requirement. Thanks, Ajinkya

Hi, Create parameters which holds multiple values like parameter with datatyoe java.util.collection or java.util.list and asssign the value of parameters as field. So that you will get all the values of field to parameter and map this parameter with your other dataset parameter. Hope this helps. Thanks, Ajinkya

Hi, Try to use an EmptyDataSource...from that it looks may be issue in datasource. Just open query designer and and try to fetch sample rows (read fields) if your query is ok then it shows sample rows in query designer. Try this out may you find something over there. Thanks Ajinkya

Hi, Try Startdate with alias a.startdate that may be the issue. Thanks, Ajinkya