yama818

I understood that the error of not being able to include '@' in the user name has been resolved. The following error '#1227' is also thought to be caused by a setting on the MySQL side. It seems that the connection user used by phpmyadmin is not granted CREATEUSER permissions. Please try granting permissions to the connection user using the GRANT statement.

Is your requirement to get the report in PDF? If yes, I think you can achieve this by simply issuing the following URL in the GET method. * Reference https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v790/reports-service * Example URL http://srv-test:8080/jasperserver/rest_v2/reports/public/test_report.pdf?j_username=user&j_password=pwd

This is puzzling. Can you transcribe the create user statement that you executed?

Empty columns will not be output by adding the following option to the report properties. net.sf.jasperreports.export.xls.remove.empty.space.between.columns = true * Reference http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.remove.empty.space.between.columns

It is assumed that you need to create a user on the MySQL side. * Example of the user to be created 'gsf650s_vlks'@'212.22.33.9' 'gsf650s_vlks'@'212.22.33.%' 'gsf650s_vlks'@'%' * Example of SQL for confirming a registered user select user,host from mysql.user;

Setting the 'Text Adjust' of the text field to 'ScaleFont' may help. Alternatively, embedding the font in the PDF may help. https://community.jaspersoft.com/wiki/how-embed-fonts-jasperreport-ireport-generated-pdf-file https://community.jaspersoft.com/wiki/how-embed-pdf-report-output

Are you creating the report in Studio? If Yes, I believe you can specify the date format in the pattern expression settings of the text field. - Text Field Setting Sample - Report Preview I hope this is useful to you.

Perhaps the DataAdapter is not configured properly. Try to specify 'Select Expression'. - Data Adapter Setting Sample - Report Preview - I made a few edits to the json file for testing. [ { "data": { "common": { "data": [{ "projectNameLabel": "XXXX" }] } }}] I hope this is useful to you.

I was able to achieve something similar. - Report preview image - Report design image Note that 'Model Name' and 'Model ID' are label components. - Test Data I hope this is useful to you.

I think it can be done by using groups as gustavofarias said. If you want to group by date as well, it would be difficult to do so without adding one more line for the date. In other words, add one more group and place the date there. - Report preview image - Report design image I hope this is useful to you.

It's a curious phenomenon. For debugging purposes, why don't you try placing a temporary text field? For the text feed expression, specify $P{LoggedInUsername}. Check to see if the 'value displayed' matches the 'value you specified in the fixed value'. You may be able to find 'differences in uppercase and lowercase letters' or 'differences with and without extra spaces'. I tried with the following SQL and it worked as expected. The database I am using is MySQL, so the syntax is a little different. select * from tablewhere CreationDate > date_format(curdate(), "%Y-%m-01")AND table.user = $P{LoggedInUsername}- test data - Report Design - Report Display Results

This is an example configuration for the Chart component. It is different for the Html5 Charts component. - Preview image - series1 settings - series2 settings I hope this is useful to you.

I would like to begin by declaring that I may not understand your question. Therefore, please understand that it may not be helpful as an answer. * Assumptions of the report structure main_dataset --> parameters > Param_main --> Variables > Variables_main sub_dataset --> parameters > Param_sub --> Variables > Variables_sub * Case1:main --> sub list > Dataset > prameters The setting here passes 'Param_main' to 'Param_sub'. * Case2:main <-- sub list > Dataset > Return Valus The setting here returns 'Variables_sub' to 'Variables_main'. Note that you need to be aware of the 'Evaluation Time'. Preview image. I hope this is useful to you.

I found a solution here. https://community.jaspersoft.com/wiki/missing-column-titles-when-exporting-ad-hoc-crosstab-view I hope this is useful to you.

The following URL will probably work. http://adress:port/jasperserver/rest_v2/reports/folder/file.xlsx?j_username=jasperadmin&j_password=jasperadmin I hope this is useful to you.

If your requirement is to control the data reference range for each logged-in user, the 'Domain Security File' may be useful. The configuration is a bit confusing, but the manual below explains it. Creating a Domain Security File (JRS7.9.0) https://community.jaspersoft.com/documentation/tibco-jasperreports-server-data-management-using-domains/v790/creating-domain-security You will need to read the manual for the version of JRS you are using, as different versions have different ways of writing and uploading files. I hope this is useful to you.

メッセージをありがとうございます。 他の人への共有と私の記録のためにこちらで返信させていただきます。 > ウェブブラウザでは背景を確認したいし、プリントするときは用紙に印刷されていないといいなと思います。 これは可能ですか？ 私が提案したアイデアでの運用は次の通りです。 まず、出力内容を確認するため、ブラウザ上で確認します。 この時は「P_imageにチェックをつけて」表示させます。 表示内容をみて問題ないようなら「P_imageのチェックを外して」再表示させます。 そして、この状態でPDF形式等でエクスポートします。 最後に、このエクスポートしたPDF等を「背景ありの用紙」へ印刷します。 お察しの通り、この運用は面倒なので「操作性は良くない」と宣言しました。 私はあなたの言う「プリントするとき」の運用を正確に理解していないと考えています。 あなたの要件の詳細を教えてください。 例１）ブラウザ表示 ＞ ブラウザで印刷プレビュー ＞ 印刷 例２）ブラウザ表示 ＞ PDF形式でエクスポート ＞ 印刷 例３）ブラウザ表示 ＞ Excel形式でエクスポート ＞ 印刷 もしも例３であれば別のアイデアもあります。 -------- Thank you for your message. I will reply here to share it with others and for my records. > In a web browser I would like to see the background and when I print it I would like it not to be printed on the paper. Is this possible? The operation with the idea I proposed is as follows. First, to check the output content, you check it in the browser. At this time, "P_image is checked" is displayed. If there is no problem with the output, uncheck P_image and display it again. Then, export the file as a PDF file in this state. Finally, print the exported PDF file on "paper with background". As you can see, this operation is cumbersome and I declared it "not operable". I do not believe I understand exactly what you mean by "when printing" operation. Could you please elaborate on your requirements? Example 1) Browser view > Print preview in browser > Print Example 2) Browser view > Export as PDF format > Print Example 3) Browser view > Export in Excel format > Print If it is example 3, we have another idea.

I would like to begin by declaring that I may not understand your question. Please understand that this may not be helpful as an answer. - How to connect to a database from Studio In order to connect to a database, you need to create a 'Data Adapter'. For details, please refer to the following manual. https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v790/working-database-jdbc-connections - How to connect to a database from Server In order to connect to a database, you need to create a 'Data Sources'. For details, please refer to the following manual. https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v790/jdbc-data-sources By the way, when you upload a report created in Studio to Server, you need to specify the 'Data Sources' already created in Server. https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v790/publishing-report-jasperreports-server --> Choosing a Data Source for a Published Report --> Data Source from Repository I hope this is useful to you.

I would like to begin by declaring that I may not understand your question. Therefore, please understand that I may not be able to help you as an answer. - Answer to the first question For example, how to write the URL for report execution is described in the following manual. https://community.jaspersoft.com/documentation/tibco-jasperreports-server-ultimate-guide/v790/repository-http-api -->Executing ReportUnits A sample of the simplest way to write a URL http://<host>:<port>/<context>/flow.html?_flowId=viewReportFlow&reportUnit=/public/Samples/Reports/SalesByMonthReport - Answer to the second question For example, I think it may be possible to achieve this by using the login user attribute. Specifically, it is possible to change the database to connect to for each login user. For details, please refer to the following manual. https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v790/attributes-data-source-definitions I hope this is useful to you.

In conclusion, you may try the following modification to solve the problem. - Before correction AND ( contratos.unidade_orcamentaria_id IN ($P!{unidadesOrcamentarias})) - After correction AND ( $X(IN,contratos.unidade_orcamentaria_id,unidadesOrcamentarias) I guess the reason for the error is that the class of your parameter 'unidadesOrcamentarias' is an array type (ex:'java.util.Collection'). In this case, you cannot use '$P'. For more information, I recommend you to read the following manual https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v790/using-parameters-queries --> IN and NOTIN Clauses I hope this is useful to you.

If you simply want to hide it permanently, I think you can do it with 'overrides_custom.css' using the theme file. Changing the UI With Themes https://community.jaspersoft.com/documentation/tibco-jasperreports-server-ultimate-guide/v790/changing-ui-themes -->Hiding UI Elements https://community.jaspersoft.com/documentation/tibco-jasperreports-server-ultimate-guide/v790/hiding-ui-elements - Default theme is enabled. - Image of the display when the custom theme is enabled (copy is hidden) - Example of 'overrides_custom.css' in the above example (Not guaranteed to work. It may affect other items as well) #copy { display:none;} I hope this is useful to you.

It seems that you can control it by adding the parameter 'Show background/Hide background'. If you want to check it in the browser, you can set it to 'Show background'. If you want to print it out, set it to 'Hide background'. Unfortunately, the operability is not very good... - Display image of the report (with background) - Display image of the report (without background) - Image of parameter settings - Image of the background image property settings I hope this is useful to you.

I haven't tried it, but the 'Data Snapshots' setting may be useful. https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v790/enabling-data-snapshots Normally, StudioReport does not have a cache like AhohcView/Report. However, with this setting, it seems that snapshots can be used instead of cache for StudioReport. Ad hoc caches are fast because they are stored in memory. However, snapshots are stored in the repository database. Therefore, it seems that the speedup is only due to the fact that the process of re-fetching data is omitted. In other words, it is important to note that this is different from so-called 'in-memory' caching. And it seems that we need to consider the timing of the snapshot update according to the system requirements. I hope this is useful to you.

We were able to achieve the following images. - Display image 1 (with Cost data) - Display image 2 (without Cost data) - Design image 1 (Cost on the left, Value on the right) - Design image 2 (Cost dataset setting) Set '$F{cost}>0' for 'Increment exception'. * I've omitted the screenshot, but I've set up an expression in 'chart.events.load' according to the site you referenced. I hope this is useful to you.

The following formula may work. function() { if(this.series.name == "Actual") return this.series.name + this.y + 'A '; else return this.series.name + this.y + 'C';} I hope this is useful to you.