r.reddy.galla

Hi, I have requirement to hide the column based on condition for that i have used "print when expression" and added property <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/> these functionality is used in subreport,its giving correct in subreport but when run the main report the empty space is not removing even i used remove empty space in main report aswell. please help us anyone that would be greatly appreciated. Thanks,

Hi Shertage, Thanks for your help it is working fine and so useful for me. thanks lot once again...

Hi, 1)I want to export data into excel format there i can see the numbers stored as tesxt format error. for that i used "net.sf.jasperreports.export.xls.detect.cell.type" then this issue been resolved. But now time format is giving error 'd-MMM-yyyy h:mm a' exported as like 7-Jul-2017 10:27 a it is not giving AM/PM format and simply displaying 'a' 2) percentage pattern error: value like 5.75 in database when i used pattern "#,##0%" this is (value*100) giving 575% Please help us steps if any one these questions that would be greatly appreciated. Thanks, Ravi.

Hi Team, I am using Jaspersoft Studio 6.2.0 and am generating reports and exporting into Excel format. 1)here am getting error: number stored as text(the filed which is having number values,by default it is taking BigDecimal in jaspersoft, evan I have changed to number or integer still am getting) 2) for dates am getting error: the cell contains a date string represented with only 2 digits for the year(this by default displaying values as per database format that time it's not giving any error,but have requirement as format 01-JAN-17 for this have used pattern then that time it's giving error) let me know the possibility form jasperside or query side ? Please help us anyone if know's the answer that would be greatful for me . Thanks,

Hi, Have added variable as "var" , I want to get the last value for the data. col ----- 10 21 12 15 16 ----- 16 need to get inthe report. always need to get lastvalue only. please help us any one knows logic soon. Thanks.

Hi, Have data in database like below 1594 113962 . . I want like 1,594 113,962 . . . Thanks.

Hi, am new to jasper, I have requirement like belowe. when you passed "customer" as parameter like ALL it should give below format. ------------------------------------------------------ customer date | John | Sam | Tito 01-Jan-17 10 20 30 Please let us know if anyone knows the logic..

Hi, I have requirement like, am passing parameter as customer,when you passed null it will give the all customer details like that have written query. But i want each customer details separately like below format. customer:john col1 col2 -------- ------- A 11 B 10 customer:Siva col1 col2 ------ ------- A 12 C 66 Please sugget this if any one knows..

Hi, I want pass a date as parameter by default it is taking Fri/01/27/2017.(mm/dd/yyyy) but i want change that format to yyyy/mm/dd. Please helpus someone quickly that would be great..

Hi, Good day, I have requirement like, Customer as a parameter when u passed perticular customer then it should give that customer details. or when you passed NULL or Empty as a parameter it need to give all the customer details. Please help us any one if you know the answer quickly,Thanks

It should be matched to the that col2 calender year like 01-JAN-18 to 31-DEC-18. Please help us anyone quickly need urgent requirement in my project

Hi, I have a requirement like, col1 col2 col3 ---- ----- ------- A 03-JAN-18 05-JAN-18 for this user need to pass a parameter as daterange like 01-JAN-17 to 31-DEC-17, but when user pass this some of columns data as exceded of this range ,that time the daterange also should be matched with the col2 and col3 Please help us anyone if know the logic ? Thanks

Hi, I have requirement like, one column having with data, I want split those column data into 3 columns column ---------- 1 2 3 4 5 6 I want like col1 col2 col3 ----- ----- ------ 1 3 5 2 4 6 Please help us to know the answer if anyone. Thanks

Hi I have requirement like, select *from table where col between 01-JAN-17 and 31-DEC-17 for that i need pass a parameter for daterange like 01-JAN-17 to 31-DEC-17 how can we take single parameter for date range? or is there any alternative way to pass parameter? Please help us any one if know the solution . thanks.

How to calculate total for every 2 rows like below format i need out put. col1 col2 col3 col4 ------ ---------- ------ ----------- aaa 10 11 12 bbb 32 4 1 Total 42 15 13 ccc 2 12 4 ddd 12 1 3 Total 14 13 7 . . . . Please help us how to get these format thanks