ajinkya_c
-
Posts
379 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by 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
-
How to subtract two values fetched from table of same colomn ?
ajinkya_c replied to jyoti.doddagoudar's topic in Products
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
-
Hi, Use java.util.collection as datatype for parameter and use it with $X{In, column name, parameter name} in your sql query. So that you can able to provide multiple values to parameter in iReport. Provide (,) comma separated multiple values to input control. Hope this helps. Thanks Ajinkya
-
Hi, You can pass the value by using parameter of main dataset to subdataset parameter. Open the properties of table where you have to select datasource for table on same window you can provide the main parameter value to subdataset parameter. Hope this helps. Thanks Ajinkya
-
Hi, Report not opened means is it give any error or blank report displayed. Run the same query on your database. May your condition not having data. Thanks, Ajinkya
-
Hi, Check with IE and firefox properties to run scripts on browser. That may be an issue. I am not sure about this but may helps you. Thanks Ajinkya
-
Hi, Use parameter mapping in subreport properties where you can mapp your subreport parameter with main report parameter. Thanks Ajinkya
-
Hi, You can increase the page height according to number of rows. OR you can also set pagination property true so that all records display on single page of report whether rows 1000 or 31 it display in one page. OR you have requirement like 31 records per page. Thanks Ajinkya
-
Hi, Check with query in your oracle DB. Also check if any default value set in parameter becouse if query return more than one row then it should display same records in your single select input control. Let me know if any additiional thing you made in your secnario. Thanks, Ajinkya
-
Hi, I am not sure about this but try to crete domain based report from ireport and use parameter in your query for profile attribute. Thanks Ajinkya
-
Getting problem while print the Jasper iReport
ajinkya_c replied to ankita.twilight's topic in Products
Hi, If you are creating report without query means with static data then you can use band like header, footer or detail to display static data. may this helps you. Thanks Ajinkya -
Hi, You can use jasper ETL to make new file format from older one not sure about the iReport tool becouse it is client tool. Thanks Ajinkya
