ajinkya_c

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,
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,
Before increase column header width you may need to increase report width from report properties.
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,
What is your source i.e.Oracle, Sqlsever, file etc., you should use database specific functions to take month part out of date.
Example: Oracle : to_char('account_invoice.create_date','MONTH')
then group by month.
Thanks
Ajinkya

Hi,
You can use stored procedure as source for jasper reports.
You can write cursor in stored procedure and use it as source.
But if you can able to load the cursor logic into summary table through any ETL or any other way then it is better way becouse it will improve performance of the report. 
 
Thanks,
Ajinkya

Hi,
When you pass parameter from url and then you get input control page with all input control fill with url passed parameter.
I think  you should set all parameters optional or unchek prompt property by edit report input control. so that no need to click on apply button.
Try this may helpful.
Regards
Ajinkya

Hi,
Which version of jaspersoft you are using, I think earlier version not support this feature.
Regards,
Ajinkya

http://community.jaspersoft.com/documentation?version=6263

Yes you can create such report, for that you need to calculate week from dates and use it in series expression. 

Tooltip provide to show value when mouse over event occur on that perticular bar. If you want to show value above the bar then there is a property to show value. select bar chart and go to its properties.
In Pie chart you can write label expression like "label : value expression" so it displays label with respective values.
Try this may be helpful. 

Best way to use crosstab in group footer if you add any group band, if group required. Otherwise you can used in summary. As crosstab increases dynamically on horizontally so it is difficult to adjust chart side of crosstab.If you placed chart & then crosstab side of it then it works but  Best way is to use chart  above crosstab. if your crosstab repeat for perticular field then used it with report group. So your crosstab & chart repeat for each value of group field.
Try this may be helpful.
If you found the way of crosstab,chart design side by side the way you want. Then let me know your solution.

for last two column write a condition that
$F{Field}==null?0:$F{Field}

Your  $V{company_idMeasure} value in crosstab caluculate based on may be some input controls or by grouping of row group values & column group values, so if you click on that value then bi-furgation of that value open in new report with another parameters.
e.g. I click on value 18 then bi-furgation across quarter like Q1=3, Q2=6, Q3=0, Q4=9 should shown in my detail report.
What i do here is send all parameters which are needed to drilled report as $P{} and $V{Stage_id}, $V{date} as variable which send the parameters on which i click. (Suppose I click on 18  then $V{stage_id}=null &  $V{date}=2012-45 & $P{}=Global) So the detailed reports gets thse parameters as input controls. for that you need to make appropriate query in detailed report.
 You can achieve this may be some other better logic this is what I did.