blabla_1983

Hi, I have several reports that require parameters that are passed from other reports. By this, I mean that one report can link to another report, passing specific variables to it. If the first report has a list of countries, then clicking on one of the countries can take you to the second report which has of a list of provinces within that specific country. Many of my reports act in this fashion; the parameters relying on information from the database. The issue I've run into is that I need to schedule these reports to run every day, but I have to manually enter in the parameters every time I want to create a scheduled report. Again, the actual parameters are just items from a database, but I would be required to create 100+ reports manually. Is it possible to automate this process somehow? I was thinking of writing a script to generate the scheduled report item, but I don't know how JasperServer implements them (XML, some other format). Any help is appreciated. Thanks!!

Can we connect jaspersoft report with firebird ? any tutorial available to do that thank u for your respon, i'm looking forward to it..

Hi, I have recently stumbled upon a very confusing problem. In one report, I have many timeseries (line) charts where I have set the Domain Axis Min/Max Value Expression to a minimum and maximum date, respectively. The min/max date fields are obtain through my query [minDate and maxDate]. For two of my reports, this works flawlessly. The domain is restricted exactly how I want it. However, I have 6 other reports that do not do this. These other six reports have the same exact layout. The charts are exactly the same too (in terms of the properties they have). The only thing that differs is the SQL query. Each successive query has more pieces to it. When I go to run the report for any of these six reports, I notice that only the max domain value expression is set. The min value expression for the domain does not set. If I flip the fields (ie: the domain axis min value expression has the value maxDate and domain axis max value expression has the minDate), then it works the opposite way. The domain axis min value expression is set properly but the domain axis maximum value expression is not. This doesn't make any sense to me as the reports nearly identical. I've printed the values of minDate and maxDate and they are indeed the correct values. Is this a bug or am I doing somthing wrong? Quick recap: The domain min and max limits for my charts work on 2 reports, but not the other 6. They only differ by the SQL query. Thanks in advance!!!!!!!

Still have had no luck. I just wanted to make this a bit clearer to show what I want. Let's say I have 3 dates to plot: 2010-04-01, 2010-05-30, 2011-09-15 When I plot these in iReport, a bar chart is produced with all three bars right next to each other. This might be confusing to the reader, therefore I want to add spaces in between the dates so that the reader isn't confused. That way, when the plot is produced, there is a good gap between the three dates. I tried setting the minimum domain expression value to new SimpleDateFormat("yyyy-MM-dd").parse("2010-01-01") and the max value to new SimpleDateFormat("yyyy-MM-dd").parse("2012-01-01") but that didn't work. Is this possible in iReport? Thanks in advance. Post Edited by blabla_1983 at 08/23/2011 20:25

Hi, I'm trying to force the domain on the bar charts so that the bar chart I'm generating displays between two dates regardless of the data. By this, I mean that normally, iReports will limit the domain so that it fits tightly around the data. I want to force the domain to different values. In my SQL statement, I get the minimum and maximum date as minDate and maxDate (they are of type Date). In my bar chart, I set the domain min value expression to $F{minDate} and the max value expression to $F{maxDate}. The report generates but the domain is not limited as I want it to be. Instead, it fits tightly around the data like it normally would. I've tried various methods including making the date type string and then using a java expression to get the date but that didn't work either. Am I doing something wrong?

Hi, I have a small problem when generating my line charts. There is one case where the line charts contain a large amount of lines to plot. Everything plots correctly and quickly. The issue is there is an abudant amount of lines to display so iReport shrinks the size of my graph. See the pictures for more clarity. The image on top is what I normally see for my line chart. The image on the bottom is what occurs for the 1 scenario where I have a large amount of lines to plot. Is it possible to change the height of the graph dynamically at all or are the sizes fixed at compile time? If not, is there a work around for this problem? Thanks!!!!

Try something like select * from dulceria having existencia>0 Read up on the having clause here. This is a good website for begginers.

Hi, I've come across a situation where I need to generate a chart that is based on a different query than the main report query. The main report query gets passed in parameters and the secondary query should recieve those parameters as well. I have a group set up so that every item in the group gets it's own chart. I tried creating a different dataset and having the chart use that dataset, but that did not work. The report would generate but it would display the default empty chart. I tried creating a subreport where the chart was the only item in the subreport, but upon report gen, the area where the subreport should have been was blank. Is this possible to do at all? I would prefer to use the secondary dataset/chart method as I don't much like dealing with subreports. Thanks in advance! Chris -- Edit: I was able to solve my problem by following the steps on this link (here). Post Edited by blabla_1983 at 08/15/2011 22:32

Kind of unrelated to jasper products but I was able to use substring and the other string functions to get what i wanted. There is just one last problem now. I originally thought that the field i was substring-ing on had the same format for every row entry, but that turns out to be false for ~200 out of the million+ entries. Is there a way to use a different substring match approach if, lets say, the length of the fieldis less than a certain number of characters?

We have a mySQL server so I'm not sure how much that limits me. I thought of using substring function but the substring I wish to grab are not always at the same exact locations (ie: I can't say that they start at 3 and end at 7 always). I also thought of using regular expressions but they will only return whether or not a match was made (true or false) and not the actual matched string. Do you think there is another way?

Hi, I'm trying to group by variable, which in the past has been quite successful. In the past my data was grouped together in the SQL query (group by) so when I was using the iReport grouping tool, all the data would stay together. This was awesome. Unforutunately, this next report has a data column (of type string) which is spread out in the table and has no way of grouping or organizing. I'm using a scriplet to break up the row entry into three parts: vendor, model, and firmware. What I mean by "there is no organizational consistancy" is the following: In my table, there can be 6 "Motorolla" entries followed by 3 "Microsoft" followed by 1 "Verizon" followed by 3 "Motorolla" followed by 2 "Microsoft". Sadly, these entries are not uniform in string name either. The entries are padded on each side by other important data to create 1 big string. That is why I had to use a scriplet...but luckily, I could use a scriplet to grab all the data out of the string I needed. I used the scriplet to grab 3 substrings. Now I have 3 string variables in iReport, one to extract the vendor name, one for the model and one for the firmware. I created a group with the vendor variable. My report should look like something in the code frame below. I would like all the Vendors that have the same name to be grouped together, even though they aren't in what the SQL query returns. However, when I generate the report, the grouping works partially. It works when the vendors are in sequential order. If they are separated by different vendor, then they can will appear as a separate vendor entry. I hope I explained well what I want the problem is and what I want to accomplish. Thanks in advance! Code:Vendor1--->Model1------>Firmware1 - other info ...------>Firmware2 - other info ...Vendor2--->Model2------>Firmware1 - other info ...------>Firmware2 - other info ...------>Firmware3 - other info .......

I wish I could give you a high five. I was forgetting to set the group value I guess. Also, placing it in the footer instead of the detail band helped as well. Again, thank you so much!

Hi, I'm trying to generate multiple graphs based on my query. My query looks something like this: select ID, date, value1, value2 from myTable group by ID, date asc Basically there can be more than 1 ID, and for every ID there is a distinct date, value1 and value2 triple. My graph tries to graph the date versus value1 and value2. Value1 and value2 are the different series on the graph. This works great if I have only 1 ID. The data is graphed properly and I have no issues. My graph has two series with date as the category expression and value* as the value expression. The problem I'm having is that I have multiple distinct ID's that each require its own graph. I tried creating a group with the objecting being ID and placing my chart in the group header, detail1 and group footer but these just produced an incorrect graph many times over. I'm pretty sure this is possible and that I'm just doing it wrong. Can someone point me in the correct direction? I have provided some sample data in case you needed a visual. Each graph should plot value1 or value2 versus date. There should be a distinct id number of graphs (ie: 10 different id's, 10 different graphs). Thanks in advanced! Chris Code: Post Edited by blabla_1983 at 07/25/2011 22:42

Sorry for the post. I figured out how to do it. While it does not place zeros until it fills up the three slots, it does manage to round it. (Math.round($V{variable_name}*1000.0))/1000.0

Thank you so much. That did the trick! For those wondering, you put the section that is similar (my case it would be the IP Address) in the group header and then the rest of the data is entered in the detail1 section.