nitin403

Hi! csilva2001 Create another variable. Lets say "PRODUCT_TOTAL". The variable Expression keep "PRICE". Check the datatype of "$F{PRICE}" if it is string, then keep "new BigDecimal($F{PRICE})" //Assuming field name of PRICE as PRICE Keep calculation type as "sum" Reset Type as Report. And Increment Type as "none" I hope this will help. P.S. I don't know derby DB.

Hi! to all. How to retrive a field from Xml Datasource in runtime from a report. Thanks in advance.

Hi! to all. I have a master report and a subreport and subreport has one more subreport. It works fine. But fails at one condition. In which my master report has no data for display in it, But the subreport has to be shown. How can this be done. Thanks for your reply in advance.

Hi! to all. I have created a Report using iReport 2.0.1. I have field in Detail band which I want to stretch. I tried multiply combination but nothing is working. Can anyone give me some clear instruction how to stretch a field. Thanks for your help in advance.

Are you using iReport? From what I see , this is not possible without using a group, also I don't know how are you using two table. First sort the datasource by "PRODUCT". Create a group called Product_Name. In group Footer keep the PRODUCT_NAME and a variable total describe previously keep its reset type to group and Reset group to PRODUCT. Hope that will help. Just for information, what type of datasource are you using.

Hi! I use iReport to create my Report files. Create group e.g.abcd. In group expression of group keep the field name( the One which holds the values of 750 and 420) then try again. If that doesn't helps, then show/give me a sample of your database and the desire output then I might be able to give some clear solution. The error you got was because you have not difine any group. Try using iReport, you will be able to create faster and easily.

Hi! lucianc Thanks for your reply. I got the answer to my. What I wanted was to get a boolean value (T/F) as per availability of node. The answer is to use the boolean function. e.g."boolean(/A/b)" Once again for you help.

I found the solution to it. I just need to create a field. And in field discription type sum(A/B//@amount) and :woohoo: it works

Hi! to all. I need get total of amount in a node. Below is an sample of my xml datasource. Code:<A> <B Amount="20" /> <B Amount="20" /> <B Amount="20" /> <B Amount="20" /> <B Amount="20" /> <B Amount="20" /> <B Amount="20" /> <B Amount="20" /> </A> My Query string is /A I want to take /A/B as An Object and get the summation of /B/@Amount attribute. How can I do this. I use iReport. Thanks for your help in advance.

Hi! to all. How to assign an boolean value to a field in an xml datasource. Since we cannot have custom value to a field. I want to display an group header footer,according to the availability of a node. If I am able to assign an field a custom value or an boolean value also, then I can get the group header a right way. Thanks for your help in advance.

Hi! to all. How to assign an boolean value to a field in an xml datasource. Since we cannot have custom value to a field. I want to display an group header footer,according to the availability of a node. If I am able to assign an field a custom value or an boolean value also, then I can get the group header a right way. Thanks for your help in advance.

If you need tutorial on REPORT_PARAMETER_MAP buy the services form JasperReport. They can also train you in Jasperreport. Form what I know about the REPORT_PARAMETER_MAP it stores the parameters & Datasources pass to jasperReport on Runtime. About using REPORT_PARAMETER_MAP if come to know any way to use it, let me know too. I am also as clueless as using it for retrieving value from it as you are. Currently when passing parameter from master to subreport I pass the REPORT_PARAMETER_MAP to the subreport.

Attach your JRXML in this post it self. Or send me your e-mail address to me. To mail me follow this steps. ->Login to this forum ->In the left side see the "My Community" link ->Go this link search for "nitin403" ->form there you can send E-mail to me with your email ID Then I will send you my ID. Best, will be you to attach the files in this post.

Hi! I have created report's using xml. Send your jrxml and xml Datasource. I might be able to help you.

Hi! As far as I know it is not possible to change the height of band. I am not an expert but try one of the following idea might help. (I use iReport to generate my JRXML files) 1). Create a new group with no group expression. Put your line 2 in this group footer. In "print when expression" write your condition. 2). In iReport, Select your fields(Line two) give the condition for "print when expression" Select "Remove line when blank" for the fields in line 2. The first condition I think will surely work in your case.The second idea might also work. Try it, tell me if succeed or not

Does nobody have the answer to my above question?

Hi! If you post your JRXML file, I might be able to help you and correct it. Another thing try using iReport 2.0.0. Since I tried using iReport 2.0.1 and that seems to me full of bugs.My experience with iRpeort 2.0.1 is not good.(Sorry for the makers). I have seen our 'newbie: XML data source and iReports' post. try this to print just the userid. Open your jrxml in iReport. 1)In menu click on view->Fields 2)Click on new 3)give field name as newUserId 4)select class as java.lang.String 5)This is IMP.In the 'Field Description' type 'UserId' without quotes 6)In Report Query '/FooReport/header' without quotes 7)Create a Text Field in the title band 8)Keep its Expression as $F{newUserId} Hope this help. If it doesn't just send your JRXML file.

Hi! mark5009 You choose xml as Datasource and same as active Datasource I assume. In the right sidebar of Data/Report Query you will see your Datasource. Just Drag the required node the field name section. Then use it as field.

Hi! to all I use iReport mostly to create as test Report. My datasource is XML. Can we create some field inthe queryString. Some examples will be very helpful. Thanks in advance

Hi! to all Thanks teodord for your quick response. I am trying to create an expense report. In this report there are different types(Type A,B,C and misc) of expense. Each expense type as it own tag. In this types of expense there is multiple period tag. In period tag there are multiple amount tag. I am using a variable for calculating the amount and it is working fine. Below is an example of what I want my report to generate I created a group for Expense Type Code: Type A Period 31-02-2007 $100 Period 31-03-2007 $12 Period 31-04-2007 $105 SubTotal $217 Type B Period 31-02-2007 $100 Period 31-03-2007 $12 Period 31-04-2007 $105 SubTotal $217 Type C Period 31-02-2007 $100 Period 31-03-2007 $12 Period 31-04-2007 $105 SubTotal $217 Type Misc Period 31-02-2007 $100 Period 31-03-2007 $12 Period 31-04-2007 $105 SubTotal $217 Grand Total $868 When I tried with only Type A expense it worked fine. But now I am confused:pinch: , that where should I keep The Expense header and SubTotal for each type. My pervious idea was to create a group of "/TypeA/Period" and if there is no more element in it then print the subtotal. Or if I can insert an element in query string right after "/TypeA/Period" then I can use it as a flag. I don't want to use subReport. Then how can I create the desire report. Thanks for your Help in advance.

Hi! to all. I have seen that in jasperreport Jaxen has been added. So what type of languages does Jasperreport support for Query string for XML Document. Does XSLT is now supported. What are new features of Jaxen for XML. Also can we add custom variable in QueryString for XML datasource. Thanks. (I don't see any examples on jaxen in /samples folder)

Hi! to all. I have created multiple groups. In the footer of these groups I want to print a total. But the footer should print only once. So How do I find if there is no more rows available in the group element, So I can use that in "print when expression". I tried many combination :S but noting worked. Thanks for your help in advance. (Also a Question about XPath for XML Datasource. How to add elements using QueryString in JasperReport. Let's Say I want to add some flag as per the some condition.)

Hi! to all. If I wish to use XQuery as QueryString for an XML datasource. How can we use that. Thanks for your help in advance.

HI! to all. I have a few Question. I am using XML as my datasource in iReport. I have band in my report which I want to print only when a node in datasource is presence. For examples let following be the datasource <A> <B>"sdfsf"</B> </A> So I want the band to print only when /A/B is available How do I do this. Thanks for your help in advance.

Does nobody know's if this is possible or not.:angry: