dan_thorman

when i execute with an active connection, i get this: ÂFilling report... ÂLocale: English (United States) ÂTime zone: Default and it just sits there... is there any way to tell what is causing the hold up? a generation log or something like that?

I have a group that prints out the counts of a number of columns by brand, with the group reset on brand (the sql statement pulling the data groups the counts by brand). I have a group footer that is supposed to print at the bottom (once all the brands have run through) and print out the sums of all the counts (the counts are how many of a given brand have a date in a given range, and the sum is to see how many of every brand have a date in the given range). however, the footer prints after each brand, as opposed to just the last brand. Why? I tried putting the totals in the column footer and setting the group footer size to zero, and then it only prints once, but it prints a few inches below the data.

does anybody know of a good one of these? i've been looking for the last day, and can't seem to find one...

as a part of the query, you could use a decode statement (if it's an sql query)... for example, if you are pulling prices, and certain items have no price, you could make your select something like: decode(price, NULL, "No Record", price) according to the syntax: decode (expression, search_1, result_1, default)

First, sorry for the multiple postings... my web browser messed up and i didn't realize it ended up posting twice until it was too late. Secondly, thank you all for your help. There was some great advice there, and I tried it all. However, none of it seemed to work. Here is what did: For the life of me, I simply could not figure out what I did wrong. So, I deleted the sub-report section on the main report that was supposed to link to that second sub-report. I copy/pasted the sub-report section that linked to the first report, and simply changed the name of the file that it was pointing to. That worked. I'm running into a few issues with certain static text printing, and certain static text not printing, but i'm sure that i'll be able work my way around that somehow. Again, thanks for all of your help!

I have one main report with 2 subreports. The 2 subreports are in the details section of the main report. I want to pass to each the same parameter, and for each to evaluate for the same parameter, so that i get a table that looks something like this: brand name 1: condition1count condition1sum condition2count condition2sum brand name 2: condition1count condition1sum condition2count condition2sum brand name 3: condition1count condition1sum condition2count condition2sum etc. where condition1count and condition1sum are the results of 1 of the sub-reports and condition2count and condition2sum are the results of the other sub-report. in the main report, i am using a jdbc connection to an oracle database to pull distinct brand names and their unique id's, and i want to pass the unique id to the sub-queries as it is a condition in the query they run. The problem i have is that sub-report 1 is evaluating correctly, but sub-report 2 is returning all null data. What did i do wrong?

I have one main report with 2 subreports. The 2 subreports are in the details section of the main report. I want to pass to each the same parameter, and for each to evaluate for the same parameter, so that i get a table that looks something like this: brand name 1: condition1count condition1sum condition2count condition2sum brand name 2: condition1count condition1sum condition2count condition2sum brand name 3: condition1count condition1sum condition2count condition2sum etc. where condition1count and condition1sum are the results of 1 of the sub-reports and condition2count and condition2sum are the results of the other sub-report. in the main report, i am using a jdbc connection to an oracle database to pull distinct brand names and their unique id's, and i want to pass the unique id to the sub-queries as it is a condition in the query they run. The problem i have is that sub-report 1 is evaluating correctly, but sub-report 2 is returning all null data. What did i do wrong?

as i expected, a newbie mistake. i let it sit for an hour or two and came back to it with a fresh set of eyes, and then realized that i wasn't viewing the output of the compile. compile errors were my problem. DUH.

For more info, it appears to only return the report when I filter the report so that only 1 record is returned.

My issue seems to be similar to the one posted here: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=19787&catid=9 The user there was having a problem where the 2nd (and so on) compliation of the report was causing iReports to freeze. My problem is that after compiling the report, I try to Execute (with active connection) in order to preview the report in JRViewer Preview, and nothing happens. Once in a while, the report will actually return. Other times, there will be a message that pops up that says something to the effect of "No data returned", but I am quite certain that there is data (because when i run the same query against the same database in TOAD, I get data). I am new to iReports, so I could be making some sort of rediculous newbie mistake, but I just don't know. I am running version 1.3, and have an active connection to an Oracle database.