k1234

Thank you for the response. We have set the Expression class to java.lang.String Its a data base column of type varchar(its a numeric value - Varchar data type in DB) . We have taken String in report for this field, When we export to excel,,its getting converted in to a number and shows in exponential format.. Kindly give some inputs..

Hi Everyone, Can anybody give some suggestion on this.. This is a very urgent requirement to my client. Please help in this regard, Any help would be greatly appreciated..

To create the report xml file we are using iReport tool. But we are facing problem while exporting report to Excel format.We are getting one field in exponential format. We tried using TO_CHAR in SQL query, but not able to resolve problem. For eg. we have SQL query as follows : select column1 from xyz column1 is containing values in format 11581000029014400 but when report is exported to excel, value in cell is shown in exponential format.(Formula bar in excel show 11581000029014400 ). Kindly provide a solution to remove exponential format, and show value in proper number format in excel report Thanks in advance,

Hi Everyone, In a report i tried to put "<style forecolor ='red' isBold='true' pdfFontName='Monotype Corsiva'>"+"PHARMACY"+"</style>" This font shows 'Monotype Corsiva' in .doc, .xls. But in PDF format it s not showing in font 'Monotype Corsiva'. if pdfFontName='Times-Bold' (any font which shows in pdfFontName dropdown we give here in style it works else it wont work.) then it works well in PDF too. I am using iReport 3.1.4. Any Help would be appreciated.. Thanks, Keerthi Code: Post Edited by k1234 at 05/16/2011 09:58

Hello Everyone, The same issue i am facing in my report. Can anybody help in this regard ? Its an urgent one.. Any Help Teodor? Any suggestions would be appreciated. -Keerthi

Hi Everyone, I have a report includes a crosstab, in crosstab i use 1 row group. So, my need is to show the group count , i have 10 groups (i did order by group_name in my query) . for ex : S.No. Group_Name 1 G1 2 G2 up to S.No 10 and Group_Name G10. How i could i achieve this in cross tab? Any help would be greatly appreciated. Thanks in advance.

Can u attach the jrxml file, i am not clear about your problem in report. Post Edited by k1234 at 07/24/2009 06:22

hi ktalarico, I have not find any solution yet for this, if u find any solution please let me know. Thanks in advance..

Hi everyone, even i have come across this problem, and not yet got any solution for this. If any one can help in this will be appreciated. Thanks in advance.

hi dgiulian, Please check out the code, you wrote that the pen stuff is not working with u, but this should work fine. If it doesn't work then use 4 lines around the textfield, but this may give u problem when the text field is stretched dynamically. Just try out once. Thanks. Code: <textField> <reportElement x="291" y="0" width="128" height="20"/> <box topPadding="1" leftPadding="1" bottomPadding="1" rightPadding="1"> <topPen lineWidth="0.5" lineStyle="Solid"/> <leftPen lineWidth="0.5" lineStyle="Solid"/> <bottomPen lineWidth="0.5" lineStyle="Solid"/> <rightPen lineWidth="0.5" lineStyle="Solid"/> </box> <textElement textAlignment="Center"> <font size="12"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{eid}]]></textFieldExpression> </textField>

hi Yogaraj, I can give u one simple example, say there is a parameter called "OFFICE_ID", If u dont want to display one static text in your report when this "OFFICE_ID" parameter is null, Then do the following.. 1. In printWhenExpression give this expression new Boolean($P{OFFICE_ID}==null) and also Set RemoveLineWhenBlank is true. The Code should be like the following, <staticText> <reportElement x="196" y="0" width="100" height="20" isRemoveLineWhenBlank="true"> <printWhenExpression><![CDATA[new Boolean($P{OFFICE_ID}==null)]]> </printWhenExpression> </reportElement> <textElement/> <text><![CDATA[static text]]></text> </staticText> Please try out this. Thanks, Keerthi

No one knows the solution for this problem ??? This is the very important issue in my report...

Hi Everone, In my report i am using 2 Columns and with a single group. i set for group Start on a new column = true then i get the page break for each 2 columns....What i shld set to overcome this page break problem... This is very urgent ..............Please if any one can help ASAP will be appreciated.. i have added my jrxml file and also PDF shows the page break.. Thanks in Advance... Post Edited by k1234 at 07/01/2009 10:09

When i try to create row groups it gives the first created group variable not found. For Eg : I first create G1 and it works fine, When i Create a 2nd Group it gives me $V{G1} not found. Y it is giving this error.

Hi Lucian, Thanks much for the reply....... AS u said to use single cross tab, I need One Row group and 3 col groups. I need to have 3 measures too for the diff col groups. How to take 3 measures ? The problem while creating the measure is, while dragging cross tab on to the report designer pane i can give only one measure right, so after crosstab is done, am trying to add a measure again. How to take measures ?