vinays84
-
Posts
88 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Everything posted by vinays84
-
You didn't set the style in any of the elements. Simply defining the style is not good enough. You then have to assign it to whatever elements you desire. Select whatever elements you want to use the style for, then right click and click properties. Finally, locate the Style drop-down (bottom right) and select your style (marca_efectiva).
-
You need to provide more detail for one to determine why Styles don't work properly for you. At the least, provide your jrxml file. I would suggest looking at some of the samples in the JR Distribution that make use of styles and trying to see what's different from yours.
-
When you put the new SQL in the Report Query and clicked "Read Fields", did the field show up? If so and it's highlighted, it will be automatically added to your Fields list. Anyway, you can always manually add, delete, and modify fields. Just right click on any of the fields in the "Document structure" window.
-
I saw this method implemented in the Scriptlet example from the JR samples. I had just avoided it, cause I thought there might be an easier way than using "fillers" to make sure the entire band is covered. Wouldn't it be easier to achieve the desired effect with conditional styles, opposed to creating two new groups and replicating the detail band twice?
-
I saw this method implemented in the Scriptlet example from the JR samples. I had just avoided it, cause I thought there might be an easier way than using "fillers" to make sure the entire band is covered. Wouldn't it be easier to achieve the desired effect with conditional styles, opposed to creating two new groups and replicating the detail band twice?
-
Yes, I see now. Thanks to you both.
-
I have PNG images which have transparent backgrounds (I can tell by clicking the file in windows explorer and viewing the preview that appears in the left panel). How do I transfer this transparency to Jasper? I have the image appearing against a gray background and would like the white surrounding it to be gone. Thanks!
-
I tried using the method described in that post, however the static text box seems to disappear when it is placed in the back (with the 'send to back' option) and has a transparent element over it. This only happens with the HTML export (it works fine with the JRViewer). However, I plan to export to HTML, so it's a problem for me.
-
How do I make background colors for a band? I specifically would like to employ the 'ever other line grayed' effect, in which every other line is colored lightly to more easily distinguish rows. Thanks!
-
monodude - I can't do that for the reasons I listed in my initial post. svenn - I'd like to avoid using subreports if possible, because I'd like one jrxml file to host the report in its entirety. Thanks for the responses nonetheless.
-
I'd like to print the sum of values before they are displayed. For example suppose I had the query: Code: SELECT branch,day,sales_amt FROM sales WHERE branch='Toys' OR branch='Auto' which returns : Code:[code] BRANCH DAY SALES_AMT Toys 1 200 Toys 2 300 Toys 3 400 Auto 1 100 Auto 2 200 Auto 3 300 I'd like to display Code:[code] Toys 900 1 200 2 300 3 400 Auto 600 1 100 2 200 3 300 If I group by branch, I can create a variable which sums the sales_amt and resets for the group. The problem is the variable will only total after the last day is reached, making it possible to put the total in the group footer, but not the group header. Is there any way to achieve this? Note: I cannot change the query to include the sum. I have to do it in Jasper. Thanks!
-
I'd like to print the sum of values before they are displayed. For example suppose I had the query: Code: SELECT branch,day,sales_amt FROM sales WHERE branch='Toys' OR branch='Auto' which returns : Code:[code] BRANCH DAY SALES_AMT Toys 1 200 Toys 2 300 Toys 3 400 Auto 1 100 Auto 2 200 Auto 3 300 I'd like to display Code:[code] Toys 900 1 200 2 300 3 400 Auto 600 1 100 2 200 3 300 If I group by branch, I can create a variable which sums the sales_amt and resets for the group. The problem is the variable will only total after the last day is reached, making it possible to put the total in the group footer, but not the group header. Is there any way to achieve this? Note: I cannot change the query to include the sum. I have to do it in Jasper. Thanks!
-
use $P!{dbQuery}
-
Yes, view the second two options I provided.
-
Define a style (under Styles in the Format tab) and assign the element(s) to that style (Right click, click properties, set style to the new style you defined). Then set conditions within that style for what you want to display. You can configure when each condition is chosen (based on the value being negative or whatever) and the new style (which can include the color change) for that condition.
-
These are expressions and thus must evaluate to a value in a single line of code. So don't use 'return' as if it were a method. Instead of Code:if (field) return 'X'use Code:[code](field)?"X":"O"
-
You have a variety of options. You could create subreports to hold either or both of the columns and data you want to print out. These subreports would be their own jasper report with their own query. I don't know much about subreports, however, so I can't comment any furthur. Depending on the structure of you table and your query, you could also hold the column names in parameters or variables. Finally, you could restructure your query to be a union of the two reports and use custom styles to label the header rows as you desire.
-
thanx
-
I understand the point of a tooltip. I was using it to serve my mouseover needs and my initial question was if the mouseover could be acheived without using hyperlinks with tooltips. Mouseovers do make sense in report scenarios depending on the report. For instance, if a report is significantly long, the column headers might not be visible for majority of the rows and having them available on a mouseover, opposed to having to scroll up for each value to verify the proper column is much more user friendly. This, of course, is only one example..there are countless others.
-
I'm not aware of any way creating an operator from a string. Since you only have a few operators possibilities, I suggest using many conditionals, which might be ugly, but will achieve your goal. Code: Boolean.valueOf( $P{comparator}.matches(">="«»)?($F{Field_name}>=9): ($P{comparator}.matches("=="«»)?($F{Field_name}==9): ($P{comparator}.matches(">"«»)?($F{Field_name}>9): ($P{comparator}.matches("<"«»)?($F{Field_name}<9): false ))) )
-
I'm not aware of any way creating an operator from a string. Since you only have a few operators possibilities, I suggest using many conditionals, which might be ugly, but will achieve your goal. Code: Boolean.valueOf( $P{comparator}.matches(">="«»)?($F{Field_name}>=9): ($P{comparator}.matches("=="«»)?($F{Field_name}==9): ($P{comparator}.matches(">"«»)?($F{Field_name}>9): ($P{comparator}.matches("<"«»)?($F{Field_name}<9): false ))) )
-
I like the ability of displaying mouse overs (tooltips) on elements. However, they seem to require that a hyperlink be provided for them to show up. I can put a null link (javascript:void(0)), but it still gives the user the impression that clicking the element will lead some where because the pointer icon appears over the element. Is it possible to achieve mouse overs w/o the hyperlink? Thanks!
-
Does Jasper provide the capability of changing font for different values? For instance, I may want to color certain outliers red. Thanks!
-
I tried that method and nothing printed out, which makes sense because nothing was in the detail band as both rows were in the group header and footer. Maybe I didn't understand what you meant. I'll give and example of what some data looks like to make my example clearer: Suppose I have a query (column upper case) which returns as follows: ROW_TYPE NAME LEG_NUM ------------------------------ bird chirpy 2 dog barky 4 dog limpy 3 cat bitchy 4 If I want to display certain rows (distinguised by the ROW_TYPE column) bold (say the dog rows), how could this be implemented with groups? Thanks
-
I thought of making use of the "print when" feature and setting two rows of text fields, one (the bold one) print when it's bold row matches and the other printing when the bold row doesn't match. This accomplishes my goal of bolding specific columns, but has the nasty side affect of printing blank lines for when the "print when" is False. The result is quite ugly and definitely not worth the sacrifice. Again, I'd like to bold certain rows based on their values but also have constant single spacing throughout the report. Please let me know if you're aware of how to to this. Thanks!
