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