irnewbie

Hi Does anyone have any ideas how to do this, i've had 4 views and no replies? I do not understand how to display this variable value and cannot get to the bottom of why it is displaying null in the msg but is showing value when placed on report display? The variable is a long type, do I need to do anything like pass it to a parameter or similar, if so how do I do that? IRNewbie

Hi I have a field that is summed and a resultant variable that holds the sum value. I can display this value when putting the variable anywhere on the page but when I try to include it in a msg expression within the a text field heading it displays null. How can I have it display the value in the text msg. A sample of the heading is below; msg("Total for ({0} to {1}) {2}", $P{startDate}==null ? "No Start Date" : new SimpleDateFormat("dd/MM/yyyy", Locale.UK).format($P{startDate}), $P{endDate}==null ? "No End Date" : new SimpleDateFormat("dd/MM/yyyy", Locale.UK).format($P{endDate}), $V{total}) The total variable in bold shows null. Thanks IRNewbie

Hi I have a grouping of records and a total at the end of the records for a particular column. In some cases the numbers are negative and what I get is a much larger number than what would have been the result of adding say two negative 5s. I woul get something like 356. Is there a reason why it is giving me a seemingly much larger arbitrary number when I encounter negative numbers to be totalled? Is there a way to handle negative numbers so that it displays the negatively added numbers correctly like it does with positive numbers? Thanks IRnewbie

I tried that but it still lists both towns then the results below instead of grouping. The way I am doing it is I create the cross tab then create the group outwith the cross tab and then add the town field to the group - in every other normal report this works fine but with cross tab it is not working. I would appreciate any more advice. Thanks IR

I posted this a while ag obut got no solutions or suggestions from anyone and wondering if I can try this time to get some help. I have no idea how to do this and am having continual problems trying to display a separate group by field from the query in a group above a cross tab sub report. The report design is a follows: First of all I have a sub report with cross tab display that displays all results I require from the DB. But for each result the result could have been registered at a different location so I want to show a set of results per location and display that location field in the group header above the cross-tab. When I create a group in the sub-report it shows a location then one result, then the same location then another result but I want to keep all results from the same location in one cross-tab group. I have described the problem more visually below if that helps. First of all I do not know how to perform what I am trying to do or whether I can do this in one report or have to use sub-report for the cross-tab. From what I have learned the summary band is where the cross tab goes and I need footer details for this report so this is the main reason I am using a sub-report as I cannot get the summary column above the footer. The sub report - I have tried in different bands in the main report like the page header etc but am not sure where to put it or if I need to group in the main report or sub-report. This is my previous question: I am using crosstab in iReport 3.7.4 and have found some help here with this design; http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=72213 The problem I am having now that I cannot find the solution is that I am grouping by say town and the crosstab shows results for each town but every record is split up into each town even if more than one results for the same town is there. for example it will be like this: town A Results 1 town B Results 1 town A Results 2 but I am trying to get: town A Results 1 Results 2 town B Results 1 I am not sure if it is the town column, which is what I am resetting the cross tab by. Do I need to change the resetting or change the town column to another band then update the resetting by part of it? The town column is in the Group header, the cross tab is in the group footer. Would anyone have any suggestions? Thanks

Bump. does anyone know? I am using two row values and one column value but there is no option to group the results. how can I group the results by a field from the query? All it does currently is show a group per result seperately as described in my first post. Thanks IRNewbie Post Edited by irnewbie at 04/05/2011 14:38

Hi I don't suppose anyone knows how to do this? Thanks IRNewbie

Hi I am using crosstab in iReport 3.7.4 and have found some help here with this design; http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=72213 The problem I am having now that I cannot find the solution is that I am grouping by say town and the crosstab shows results for each town but every record is split up into each town even if more than one results for the same town is there. for example it will be like this: town A Results 1 town B Results 1 town A Results 2 but I am trying to get: town A Results 1 Results 2 town B Results 1 I am not sure if it is the town column, which is what I am resetting the cross tab by. Do I need to change the resetting or change the town column to another band then update the resetting by part of it? The town column is in the Group header, the cross tab is in the group footer. Would anyone have any suggestions? Thanks IRNewbie

Thank you fo the reply and information.

Hi Thanks for your help. I am not sure if this will do what we need it to do; we need to be able to pass a parameter value that the user picks from a drop down list in the application then use this in the report to sort. I am thinking along the lines of maybe a parameter in the query that this value the user picks is then sent to. It would only sort by one field at a time. thanks

Hi I wonder if anyone knows how to use order by in jasper reports. Our old system (Crystal Reports) used a drop down list of order by fields, pulled from DB, and then this would be used in the report application viewer to sort by. I am unsure how to do the same thing in iReports. In CR there is a formula field menu and a sort by option where a case statement would be placed such as : SELECT (@SortField) CASE 'Name' : {Report.Name} CASE 'City' : {Report.Town} Default : {Report.State} Our new system can support a similar DB set up with a table with a list of values to sort by and dropdown functionality built-in to the application. How do I achieve a similar sort of thing in iReport as i've described above or is there another way of doing it? Thanks A

I closed sql developer and found there to be uncommited changes so this must have been the problem. I always commit at the end of any DML but must have missed one, the report now works.

I now have yet another report doing something similar, I have set up the data in the DB to show one record, and the query does just that, but in the report it is showing no data, yet this is exactly the same query. Is this a bug or something in iReport. I mean it is the exact same query on the DB and in the report yet opposite results returned.

Hi Is there anyone who knows what might be causing this, I am stumped. If i pull the exact query from the report and run it in the DB it shows no records, as I want, but in the report viewer it shows the one record that was showing before I had altered the query. I have check the xml and the query is exactly the same one that returns no records in the DB. Thanks IRnewbie

Hi I have a report that showed 1 record and since changing the query it now does not return any records as Iwas wanting to happen but even though running the report query in the DB shows no records I keep getting this one record showing in the report previewer. I have tried closing down iReports, deleting the .jasper and recompiling, even creating a new test report and it does not help. How can the same query in the same database as the report is getting the data from return a record in the report but not in the DB? Thanks for any helpful suggestions. IRNewbie

Can you tell me what this has to do with mapping parameters/fields to a sub report. I have a cross tab report that I would like to use as a sub report in a main report but the main report itself does not have any fields it is used for display purposes only My questions are: Where do I put the query - in the main report, sub report or both Do I create parameters in the sub report and link them to the main report's query fields (dependant on answer to above) or vice versa? Thanks IRNewbie

Hi I am building a report in IReport version 3.7.4 that was originally designed in crystal reports as a cross-tab. I am now designing a cross-tab in IReports and need to have a main report and use the sub report as I understand that I need to put the sub-report in the summary section therefore will not have any page footer, and the main report will have the page footer. The query is just a straight SQL Statement and I need to know what to do to have the sub-report link to this data so that it runs in the main report. I have the sub-report running successfully and when I put the sub-report in the main report all I get is a blank report. I am currently just learning how to use IReport and have only been playing about with it for a few weeks so am quite unfamiliar with it - especially linking the sub report -> Main report I do not understand what I need to do at that point regarding the database fileds/parameters/variables etc. Hopefully someone can give me some pointers on this specific bit of the project. Thanks IRNewbie