sophannaly

Hi, could anybody guide me on how to do this?

Thank for your reply. What should I do if I have already had jasperreports server install?

Hi, I would like to ask about how to change root folder name is jasperreports server. In previous version, I could change it by going to Jasperserver database, then go to table jiresourcefolder and update name and label that has value equals to "root". But in version 6 the root folder name doesn't take afferct even I tried to restart server after updating the table. Could anybody tell me how to do it? Best regards, Sophanna

Hi Elizam, Thank you so much. Follow your answer, I could change it. Best regards, Sophanna

Hi, I have a question about changing the title from "Welcome ToTIBO Jaspersoft" on login page to other text. I tried to change LOGIN_WELCOME_OS=hello in jasperserver_messages.properties file, but it doesn't change this title. Could anybody tell me how to do this? Best regards, Sophanna

Hi, I would like to access Jasper server webservice via MS acess vba. For login, I use POST login service, so I could save sessionID to use for subsequent request. This is my vba code With jasService .Open "POST", "http://localhost:8080/jasperserver/rest/login", False .setRequestHeader "User-Agent", "Jakarta Commons-HttpClient/3.1" .setRequestHeader "Content-Length", "45" .setRequestHeader "Content-Type", "application/x-www-form-urlencoded" .send "j_username=sophanna&j_password=123"And it return OK for status. As its document said that it is an empty body and it is right cuz when I wrote .responseText then it will return nothing. So my question is how can I get sessionID from cookie in vba? Best regards, Sophanna

Hi, I have assign input control as Multi select query. This is the query that I use in input control query : select revision_number, submit_date, comment from revision where revision_type= 2 order by revision_number asc. What I want is I want it to show in multi line for each result that it get from running query beside show as revision_number|submit_date|comment because comment is a few lines text. Could anybody tell me how to change this input control layout? like where to change properties file to get this result. Best regards, Sophanna

Hi, I have one problem about combining many reports with different layout and query but the same data source and every report contains crosstab. As user used to use excel as her report. In excel file, there are many different sheets. Then I design one report for one excel sheet. So in order for user to produce report as their excel file, they have to run many times different reports which also export in different excel file and combine it manually which is not convinient for them. Could anybody tell me how can I archieve this which user need to run only one time and she will get result as her excel worksheet? Sophanna

Could anybody give me idea on this please ? Because I need to make this report in urgent.

Hi, I have design my crosstab which is column group by table_type and revision. For example, there are 2 values for table_type. I want to use the first table_type column group value in the second table_type value. I have tried with define variable, when it shows in first table_type column group, then it shows the correct value, but when I shows in second table_type column group it will show as 0. I define that variable with expression like ($F{table_type}==1)?$F{amount}:0. Can anybody tell me how to use first table_type column group as global value that I can use it in other column group? Best regards, Sophanna

Hi, In ireport, it previews with double line. When I deploy it report server or export to xls format, it will shows as single line mode. Below is the testing code. Please tell me how to solve this? <?xml version="1.0" encoding="UTF-8"?> select * from revision "hi" $F{admin_code} $V{admin_code} Total admin_code $F{geo_code} $V{geo_code} Total geo_code $F{revision_number} $V{revision_numberMeasure} $V{revision_numberMeasure} $V{revision_numberMeasure} $V{revision_numberMeasure} Best regards, Sophanna

Hi, sorry I forgot to mention that text field is in cross tab. I have a crosstab, and in crosstab I have put text fields as each column title. For text fields, I set border and padding to double line but when i export it in xls format, it shows only single line. Is it the problem with duplicate border between crosstab border and text fields border?

It works like you said if I tested in other section of report. In my case, I want to print it in crosstab. In my crosstab I have put some text fields as title and I choose it border padding as double line with width=1.75, but it still show as single line in excel output. Can anybody tell me why?

In iReport I already increase line width to 1.5 and I tested with xls and docx output format but it still just show as darker single line style. Did I miss any properties in report level?

Hi, I use iReport 5.5.0. When I design report, I click on text field and chose its border and padding with double line line style. But when I run it within iReport preview or deploy it to Jasperreports server, there is no double line output and it is replace with single line style. Could anybody tell me the reason why? Best regards, Sophanna

Hi, Thanks for your reply. This is file that I downloaded to install on my machine : jasperreports-server-cp-5.5.0-osx-x64-installer.app.zip. In my tomcat logs I can see only logs file that created on the day that I install it. After I installed it I can access it, but now when I can click on Jasperserverstart it will popup that error.

Hi, When I click on JasperServerStart then it will popup and error as " The action "Run Shell Script" encountered and error. Check the action's properties and try running the workflow again. Could anybody tell me how to deal with this problem? Best regards, Sophanna

I found a solution and it is sort by year value in data set ( in the first position of other fields that need to sort).

Hi, I have problem about printing and exporting report in multiple sheets with iReport. Let me describe it, first I create report which take multiple years value with this expression $X{IN,budget_year,start_year}. And I create Report Group which its Group Expression is $F{budget_year} (which is a fields from my report query) and in group I use crosstab. My expectation is in jasperserver, for example, when I select two years values :2011 and 2012, I wish to get all data which year=2011 first, then data which year=2012. But what I got is it shows data which year=2011 then data which year=2012 then data which year=2011 again. So when I export it to excel, then it will create many sheets which is based on what it shows on web interface like sheet with year=2011 then sheet year=2012 then sheet with year=2011 again. Can anybody gives me ideas about this issue?

Hi, I do have problem with showing report which use crosstab in jaspereports server. The problem is I don't know where is this border come from? It shows longer than the data. The photo attachment is how report look like when I show it on report server. Best Regards, Sophanna

I already tried to translate its properties file, but it doesn't help. Can you change date language in report created date and modified date?

Hi Sebastian, I also face the same problem when I export report to PDF format. Khmer font doesn't show properly with it leg. Can you tell what is your solution to deal with this problem? Looking forward to see your reply, Phanna

Hi Daniel, I also face the same problem as you, I would like to ask did you find the solution for this problem? Best regards, Sophanna