dcooman

I have a three level folder hierarchy for reports. All security is set by roles. By default, each role has "no access" to every folder. If I grant "read only" access to a second-level folder. That user can see all the reports in that folder and all the folders below. The folders below show "read only" is inherited from the parent. This works fine. Is there a way to allow inherited security upward too? In other words, is there a way to inherit "read only" access to the first level folder needed to reach the allowed second level folder? This would make my security structure easier to manage. If this is not possible I will have to explicitly set "read only" on the first level folder and "no access" to all the other second level folders that I don't want this user to see.

Sorry for the delay, just getting back from vacation. I had not thought about "Color Picker" in Paint. A quick screen capture and I was able to determine all the color codes. Thanks!

Does someone know the hex values for the default color series you get when you don't specify the colors for a chart? I like the color series, but I want to change the order for some charts. For consistency, I'd like to use the same exact colors that you get by default. I just need the hex codes to create my own custom series in the order I want. Thanks.

I have moved this to the JasperServer forum.

I have two questions about Input Controls. 1) Is there a way to hide or otherwise not show the "Save Values" button? I have made the repository read-only and users always get an "access denied" message. I would rather just not show this button at all. 2) Is there a way to present an initial value for the selection box? I have two Input Controls, each with a Single Value Query which returns a list of month/year values. The values are the previous 12 months in order from most recent to oldest. One input control selects the starting month while the other selects the ending month for the report. I'd like the Starting Month one to initially show three months ago and the Ending Month to show last month. Is this possible? Right now they both propose the first month in the list which is last month. Any help on these would be greatly appreciated.

I have two questions about Input Controls. 1) Is there a way to hide or otherwise not show the "Save Values" button? I have made the repository read-only and users always get an "access denied" message. I would rather just not show this button at all. 2) Is there a way to present an initial value for the selection box? I have two Input Controls, each with a Single Value Query which returns a list of month/year values. The values are the previous 12 months in order from most recent to oldest. One input control selects the starting month while the other selects the ending month for the report. I'd like the Starting Month one to initially show three months ago and the Ending Month to show last month. Is this possible? Right now they both propose the first month in the list which is last month. Any help on these would be greatly appreciated.

I have two questions about Input Controls. 1) Is there a way to hide or otherwise not show the "Save Values" button? I have made the repository read-only and users always get an "access denied" message. I would rather just not show this button at all. 2) Is there a way to present an initial value for the selection box? I have two Input Controls, each with a Single Value Query which returns a list of month/year values. The values are the previous 12 months in order from most recent to oldest. One input control selects the starting month while the other selects the ending month for the report. I'd like the Starting Month one to initially show three months ago and the Ending Month to show last month. Is this possible? Right now they both propose the first month in the list which is last month. Any help on these would be greatly appreciated.

It appears the I need a "Time-Series Bar Chart". The regular "Time-Series" graph offers just a line chart. I can make the data work, but a line chart does not present the data the way I need it. It is more important that the makeup of the date broken out by the series variable is displayed rather than the changing of each separate series over time. Is there a "Time-Series Bar Chart"?

I have a stacked bar chart with dates along the category axis and multiple data values stacked up for each date. The chart is fine when I am showing 30 or so dates as each bar is wide enough to display the date label rotated 90 degress at the bottom. However, when I try to display 90 days, there are (of course) 90 bars across the axis and the labels all mash together. How can I display, for example, only every seventh date label? I've tried using the "Label" part of the Category Series and even providing an additional field to use as the label. The additional field is blank for labels I don't want to show and has a formatted date when I do want it to appear. The "label" field is apparently ignored and it still tries to show a date label for every bar. I can find nothing else in the properties area that might address this need. This is something that is easy to do in Crystal Reports. Is this feature available in iReports?

I am extracting data from MS SQL database with a timestamp and an integer. The timestamp is a SQL date rounded to the hour (ie: 2010-02-02 14:00:00) and the integer is the number of phone calls during that hour. I want to plot a bar chart with "hour of the day" on the x-axis and the number of calls on the y-axis. I can get the chart to show correctly, but I cannot format the x-axis to just show the time (ex: 1 PM). I have tried using the "Category Axis Tick Label Mask" which, according to what I have read, accepts format strings like those used in SimpleDateFormat. I have tried variations of "h:mm a" (both with and without quotes) as well as standard format names like "SHORT". In all cases the format is ignored and the entire date (2010-02-02 07:00:00.0) is printed. I am using iReport version 3.5.0. Do these format strings work on SQL TImestamp fields? Any help on what to use as a format string would be greatly appreciated.