ruthran

After upgrading from V6.4 to V7.5, we are facing issues with REST API calls to the reports. The intended parameter values for the reports are not getting passed and is always NULL. Once we downgrade the version back to V6.4, everything seems to be working fine. Is there any changes to REST API calls in V75 or is there any configuration changes that can cause this issue ?

Variable execution depends on which band there were actually placed. Can you let me know where you are placing it. Variable usually return NULL if they were not rendered at proper time. To manipulate this, we also have another called "Evaluation time" on the text box. You can try changing the default value "Now" to some other value and see whether it is working.

Hi, We are using Jasper server V6.4.3. We have a sample folder structure like below. MyFolder(Parent) - Folder1(Child) - Folder2(child) We have created 2 roles ROLE_1 and ROLE_2. For MyFolder, these two roles were set with "Read Only" permissions. For Folder1, ROLE_1 has "Read+Write" and ROLE_2 has "No Access". For Folder2, ROLE_2 has "Read+Write" and ROLE_1 has "No Access". When I login with a specific user who has ROLE_1 assigned, I can able to see MyFolder->Folder1 in the left side panel tree. Folder2 is not appearing in the tree. This is expected behavior. But, when I search for a report by typing something in search box, it displays the results from Folder2 as well. I tested the same scenario in V6.4.0 and it is working fine. We don't get any search results from Folder2. But, the same sceario is not working in V6.4.3.

I am not completely sure I understand your question here as the image you added had more masking and difficult to read. From the code, it looks like you were trying to accomodate the entire para within a textbox. Instead, why can't you try using different text box for each of the bullet point and put them together inside a Frame element? That way, you can set the "Stretch Type" of the text box as 'Float' and they will not overlap.

Considering you have a fixed list of values stored in the parameter, you can use the 'Print When Expression' of the text field to check whether the value exist in your list. If present, then the content of the text box will be displayed. If not, it will not appear.

Try publishing your report inside public folder so that it can be shared between different clients.

We had a discussion with TIBCO and resolved this issue by upgrading our Jaspersoft server to most recent version.

This is very useful. Could you please let me know whether there is a way to breakdown a single day's cell to display different details. For example, JAN 1 is NEW YEAR and it will be a holiday in countries like USA, IND, UK etc. I want to show under JAN 1 cell the list of coutries that are having that day as Holiday and differentiate them with some color codings. Is this possbile ?

There is an intermittent issue with our UI running Jaspersoft reports where the browser hangs. The fix seems to be to clear the browser cache, or to open an Incognito window which starts with a new empty cache. Need your help to research whether there are any options on the Jaspersoft server that tell the browser not to cache? Is there a way to send any HTTP headers or Jaspersoft specific instruction to the browser that controls caching?

We resolved this issue. Fortunately, we had a subreport in the inner most group's footer. We returned a flag variable from the subreport and used it in the Print when expression. We were able to eliminate the group header in unwanted pages now.

Hi Hozawa, I am trying to do take this approach only but unable to figure out a way on how to do this. Can you guide me on how to create this variable ?

Hi, My report uses 4 different groups. My innermost group header has some details and the band is enabled with 'Print header on each page'. It prints fine in all the pages. But, the problem is, even after the group is completed, the header keeps getting printed in subsequent pages. This affects the report output as unwanted header is getting printed till last page. Is there any way to hide the Group header after the group is completed with execution. ?

Hi All, I am working on a report requirement where I need to show a summary of records in my Main report with hyperlink to a detailed subreport. Once I click on hyperlink, I should be able to export the report directly to pdf/xls format. But, with current option of "ReportExecution", I can able to first render the subreport and then export it to pdf/xls. Is there any way I can skip the render of hyperlink reports and directly export it to pdf/xls ?

That worked like a charm !!. I actually thought I had it enabled already and tried many solutions yesterday. But, after seeing your answer, when I verified once again, it was not there. Thank you for your help.

Hi, As you suggested, I tried using tooltip.Formatter function, but I don't see that formatting has been applied to the chart result. Below are the values I am using in different properties. tooltip.formatter - "(function() {return this.series.name + '<b>'+ Highcharts.numberFormat(this.point.y, this.point.exponent)+ '</b>' ; } )" tooltip.pointFormat - <span style="color:{point.color}">●</span> {series.name}: <b> {point.y} </b><br/> (point.exponent is a bucket property I defined for each series) Could you please let me know what I am doing wrong here ?

Hi Andrew, Thank you for your reply. I forgot to mention about that. I am already using the series bucket property to get the required decimal points. But, we cannot use any bucket expression in the tooltip.ValueDecimals properties. We can either use a hard-coded number or some other custom expression. I tried this option already but got no success.

Hi All, I am using HTML5 bar charts for one of the report. I have a question on tooltip formatting option we have for charts. I need to display amount values for each of the series (coutry in my case) in the graph and the amount should be formatted based on each currency. So, the decimal format will change for each value. Under Tooltip -> Formatting, I see an option called Value decimals which allow us to configure the decimal places. But, this is a constant value and I cannot get different decimal points for different series. I tried to use the expression in this field but it is not helping as the bar chart is present in summary band and always picks up last value. Is there any way to include custom formatting in "Point Format" option of formatting? I tried to include some HTML codes in it, but it is not working. Please do let me know if there are any other way to handle this issue.

Changed Priority from Low to Urgent Hi, How to fix this error in Jasper studio tool ? I don't see any such property in the tool.

Hi, how to fix this error in the Jasper Studio tool ?

Hi, One of my report uses query that has "WITH" clause in it. Though the query runs just fine in SQL tools, it is throwing error in SQL editor of Jasper studio. Is there any settings in Jasper studio that we can change to avoid this error.?

Hi, One of my report uses query that has "WITH" clause in it. Though the query runs just fine in SQL tools, it is throwing error in SQL editor of Jasper studio. Is there any settings in Jasper studio that we can change to avoid this error.?

Team, I am working on a report requirement wherein I need to display a dynamic progress bar in the report. For example, if the system has 100 files to be processed and 65 of them are are already processed, then I need to dispaly a progress bar with percentage of files that are aready processed (In this case 65%). This progress bar will change dynamically based on number of files processed in the system. Is there anyway we can achieve this in the Jasper studio V6 ?

Hi Ajinkya, I can see only "Total Position" in the properties. There is no subtotal option in the row group or column group. If I select Total position as start or end, It is going to print the sum for all departments instead of printing it for every single department. Could you please explain me where you are exactly referring to?

Hi, I am working with Crosstabs and want to know whether following requirement can be done. I have a crosstab with Date, Division and Department as Rowgroups and CODES(REG,STP etc..) as column group. I can create Daily Totals for the day by giving Total row group. But how to create sub-total at every Division level as shown below?