wahoyaho

Is it possible to have the entire result query as a parameter? I tried just putting the result query as a parameter but when I enter in the sql command string when the prompt comes up for the parameter it always says that there is an sql syntax error even though I've checked it in a external query browser to make sure it works. Please help, thanks.

Hi, sorry I'm kind of new to this, could you explain in greater detail how I can implement JRChartCustomizer and modify the existing chart? Thanks.

Hello again, I have 2 questions about iReport. 1. In a chart, how can I make the horizontal label to appear vertically? For example, if I was showing dates on the x-axis, how can I make the date show from bottom to top instead of left to right? 2. If one of the data I'm collecting from a field in the database is presented in number instead of it's actual meaning. Like if I have the field flavor and entries 0-5 where 0-5 is a different flavor, how can I present the report where 0-5 is translated to their corresponding flavors? I seem to remember using a *.properties file but I don't remember how to use it. Thanks for any help.

Thanks for the fast reply, just a quick question, how can I make a variable that is total of each day? For example, the first table in http://www.fortinet.com/FortiLogdemo/file/Network_Activity.html I can get the subtotal % values to show up correctly with Grand Total percentage provided in the crosstab options, but how can I get the % for the unclassified values?

I only see the option for the percentage of grand total, is there anyway to make it a percentage of something else?