beekerc69

i want to make the title of an html5 chart bold, but i don't see that option in the Chart Properties / Titles. i see there are bold options in the chart families drop down but the font that i need to use doesn't have a "<font> Bold" option. i tried "<b>title<b/>" and set useHTML to true in Advanced Properties, but because the title is multiple words and lines, it doesn't display as the unbolded text what are my options here to get bold title?

a bar chart doesn't print all the y-axis labels nor do all the data bars line up. here are two versions of the same bar chart the underlying data query returns 11 rows. here's the one in the report i inherited. clearly not all 11 rows of data are accounted for. here's the same chart but i increased the size from 240 to 400 pixels in Jaspersoft Studio and you can see all 11 axis labels, data rows and data labels. how can i make all the data show in the given space of 240 pixels as it appears that Jaspersoft just decides to drop stuff (like axis labels) when it calculates that space is tight.

i have a stacked bar chart showing cap and op expenditures. as you can see i've managed to turn on the label display so it shows the value associated with each bar component. however what i want is the total value of each bar to be displayed at the right end of each bar, which is more commonly used and makes the values visible. how can i get the total bar value to display?

this page is at the Studio/Server level. is there a way to use this so that the default filename draws from the Report Name and not the Report ID?

yes., would like to see an answer to this question as well

have a complex report that needs modification, however there will be an interactive review and testing process which means the original version has to remain in place and the new version has to live in parallel for users to access. it also has to be tested against PROD data so my thought is to simply clone it and work on the copy and when all is said and done, point the parent application at the new report's URL. in Jaspersoft Studio i can copy/paste, import/export the report so i'll the working copy and the new version. but that means having to re-import all of the Resources and rebuild the Input Controls (and there are lot of them). is there a way to clone the report, and give it a new name and ensure that it is faithfully duplicated in both the Repository (as seen from JS Studio) and in the Jaspersoft GUI (as seen from the web-browser)? step-by-step instructions are always appreciated. 😁 Thanks

if you put a blatantly false statement in the "Print When Expression" of a sub-report properties page, say like 1 == 0, what exactly doesn't happen when this sub-report is encountered? does it completely ignore the sub-report and not try and evaluate the underlying SQL? or does it still execute the SQL but just not print anything in the frame? here's my scenario. i have a report with multiple sub-reports. i want to modify and test each sub-report one by one, but i can't use the preview mode on the individual sub-report (lack of chrome.exe for rendering graphs due to company IT policy), so i have to run it from the host application GUI (in this case Clarity PPM) as the real/full-on report. in addition I'm having to change several report parameters from single to multi-select which means massive changes to a lot of SQL - going from $P= to $X(IN, - and i don't need JS runtime syntax throwing errors when i've got other things i need to troubleshoot and debug. so my "win" here is confirmation that a "false" value in the "Print When Expression" box means that the sub-report is completely ignored and the SQL is never even looked at by the report engine at run-time. can this be confirmed? 🤞 Thanks in advance B

thank you shreekrishna, but i think i need the screenshots version. i'm not fully following what you're saying. yes, i have Agility2.jrxml as a subreport on main.jrxml. i have tried multiple means to copy Agility2.jrxml to create Agility3.jrxml so i can edit 3 and then change the subreport expression in main from "repo:Agility2.jrxml" to "repo:Agility3.jrxml". no matter how i try and create Agility3.jrxml, i cannot get it to be visible in the Repository Explorer. but now it seems to exist but cannot be seen because i tried to simply create an XML file called Agility3.jrxml, but Studio won't let me because "this ID is already used in this folder". File Save As doesn't work. i simply don't understand why i can't get a new sub-report to show up in the repository in the report folder.

not sure i follow your question. let me add this picture to clarify. this is the repository explorer. Main.jrxml is my report. Agility is a sub-report inserted into Main. Agility2 was an updated version i want to make a copy of Agility2.jrxml and call it Agility3.jrxml, then modify its SQL code of to update the subreport. then in Main.jrxml, i want to take remove Agility2.jrmxl from its given frame and put Agility3.jrxml in its place. this way i can still keep the older version (Agility2) in the folder for rollback, even though it's Agility3 that's in the active report output. so, how would does one go about duplicating Agility2.jrxml, naming it Agility3.jrxml so it can be modified without making any changes to Agility2.jrxml, but more importantly, make Agility3.jrxml visible in the folder chain? copy/paste, Save As and Download to File do not behave in the Repository Explorer as the those same functions do i File Explorer.

using jaspersoft studio pro 7.9.0 i'm modifying a sub-report (call it sub_4). but i want to keep the old version in the repository. so i want to create a sub_5, make changes then insert that into the main.jrxml file. the most obvious answer is to right click on sub_4, select copy, then paste, however, it did exactly that, made a copy of sub_4 (so now there are two) but there's no way (that i can find) to rename the second on sub_5. File/Rename (f2) doesn't work. right click doesn't offer "rename" and properties doesn't have a rename option. then i tried right-click download to file. chose the same parent folder and specified the name sub_5.jrxml and clicked okay. it opened up the in the editor with the tab sub_5.jrxml but there was no corresponding sub-report element in the Repository Explorer, even though i refreshed at every folder level i could find. figured it might some sort of error, so i did the action again - Download to file of sub_4.jrxml, saved to sub_5.jrxml, but this time gave the error that the file already existed, even though i can't see it in the Repository Explorer. what's going on? why can't see .jrxml's that i've added?

what if the input control is a SQL query?

i see the answer below that requires modification to a file on the jasperreport server. i don't have this luxury. i don't have access to the server and the admins will not mofidy any files. how do i force the column headers to display, but do so in the .jrxml code? Thanks

I'm having the same issue. Tried both DIME and MIME. didn't make a difference

I have a need to copy/move/migrate ad-hoc views from one JasperReports server to another (from a DEV environment to a PROD environment). Everything i've found on the internet and in this forum says to use the import/export capablity of the Web UI after logging in as superuser. This option is not available to me and will never be available to me, so please do not tell me that i need to get that access as superuser and follow the posted instructions. it's not going to happen. I can only login as an Organization user with ROLE ADMINISTRATOR rights. The thing is i was not the original Ad-hoc View author so i don't know how it was built or anything about it (other than i need to copy it), but unlike Reports and other objects, there is no right-click Edit option for Ad-Hoc Views to find out how it's build and how it can be recreated. Can anyone walk me through the steps to look at an Ad-Hoc View to gather what is needed so it can be re-created in on another JasperReports server? Please understand that my competenecy is with Jaspersoft Studio reports and not Ad-Hoc View creation, so please make the steps very basic. Thanks in advance.

based on the replies and some other research, i've got one more option. Select * from ( with xyz as (select.....) select from where ) in this form, you can still use with/as constructs but it complies with the rule that word SELECT must be first . this would be useful when changing the server SQL validation is not an option.