yama818

It may be possible to achieve this by reversing the idea. Leave the parameter as 'Is For Prompting'. After uploading the report to the server, hide the relevant input controls. In Studio preview, the parameter is displayed and can be entered. In Server, the input controls are not displayed.

Let me confirm your question. For example, here is the report Does 'Your test' in the first line mean that '25' is the expected value, not '20'? If my understanding of the above is correct, then one solution to get '25' is as follows 1. Create a 'test_init_val' in Variable. 2. Write '$V{test_init_val}+$V{test}' in the Text Field expression.

If you mean that you want to change the column header labels from 'vertical' to 'horizontal', you can do so by adjusting the layout. * Design Image * Preview Image

If you mean that you want to change the 'vertical alignment' to 'horizontal alignment', this can be done only by changing the setting. * Design Image * Preview Image

I was able to create a layout that is very close. The instructions on how to create it are very complicated, so I will just show you the key points. * In the Crosstabulation Wizard, select all the items you want to display. In your example, 'Other Date' and 'SameData' are selected as 'Row Items'. * The automatically created 'Other Date' and 'SameData' text fields will be deleted. The column width is also set to '0px'. * Delete the text fields in the automatically created grand total. * Create a new text field to display 'Other Date' and 'SameData' in the grand total. * I will omit the detailed explanation, but please note that the 'Layouts' of each item must be changed to 'Free Layout' in order to be placed properly. The concept is summarized as follows. * Create a cross tabulation table using the wizard as usual. * Delete the row items that are created by default and rearrange them in the total tally area. * Design Image * Preview Image I hope this will be helpful to you.

I don't know if this is a solution, but there is a setting to reduce memory consumption. Virtualizers in JasperReports https://community.jaspersoft.com/wiki/virtualizers-jasperreports I hope this will be helpful to you.

There is a way to arrange two table components in a summary band. * Design Image * Preview Image

There are two methods I know of. Text Adjust = CutText or Text Adjust = ScaleFont Set by * Text Properties Setting * Text Adjust = StretchHeight * Text Adjust = CutText (*Default) * Text Adjust = ScaleFont

The '?' in the log means as per lucianc's answer. I agree with jgust's proposed solution idea. My other points I noticed are the following. There is area where the use of $P{xxxxxxx} and $P!{xxxxxxx} seems incorrect. The following manual is helpful in explaining the difference in use. https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v790/using-parameters-queries --> Using Parameters in a SQL Query For example, in your SQL, the part I was wondering about is this 'ORDER BY'. ----- ORDER BY groupby, locationgroup.name, IF($P!{ckOrderByCustomer} = 1,customer.name,so.num), so.num ----- It would seem correct to describe this as follows ----- ORDER BY groupby, locationgroup.name, IF($P{ckOrderByCustomer} = 1,customer.name,so.num), so.num ----- However, I do not know of any RDBMS that allows 'IF' in SQL. So, is it a correct SQL syntax to begin with? I doubt it. (However, this is most likely my ignorance). If you don't mind, please let me know what RDBMS you are using. I think you can use 'CASE' instead of 'IF'.

I thought it was an expected result that the parameter part would be output in the log with '? in the log, which I thought was an expected result. Your SQL seems to be well written. I tried to copy your SQL to see if it works, but I couldn't get it to error. If you could attach the 'full error log' or the '*.jrxml file', I might be able to notice something.

It would be better to solve the problem in the local environment first. This is the case when both Server and Studio are built in the local environment. 1.'I'm trying to copy the jrxml file' how did you operate? Generally, you use Studio's upload function to place reports to the Server. 1-1.Connecting to JasperReports Server https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v790/connecting-jasperreports-server 1-2.Publishing a Report to JasperReports Server https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v790/publishing-report-jasperreports-server YouTube : 2.'in Jasper Studio I'm using Data Adapter but in Jasper Server I can only find Data Sources instead.' is correct. Studio --> Data Adapter https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v790/data-adapters Server --> Data Sources https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v790/data-sources 3.'Then if my report is using a local Data Adapter (in xml) should I also bring it to the server?' is unnecessary. Just having 'Data Sources' is sufficient. (but may be necessary for advanced usage). 4.'Then if my report taking in parameters should I create input controls?'is depends on the situation. Basically, they are created together when a Report is uploaded from Studio to the Server. After that, if you need to edit the input controls to incorporate SQL, etc., you will need to edit the input controls after uploading. The next step is to solve the remote environment problem. As you have already recognized, it is most likely affected by the network configuration. If it were me, I would investigate where the cause is as follows 1. Issue a ping from the local PC to the server IP to see if a connection can be made (but it will fail if the Windows Server does not allow pings) 2. Check if you can connect to the server IP from the local PC by specifying the port. If the local PC is Windows, run 'Test-NetConnection server_ip_address -Port 8081' in PowerShell. 3. Check if you can connect to the server's tomcat from your local PC (for example in your environment, http://server_ip_address:8081/)

Perhaps this document may be helpful. If you are talking about using Visualize.js on p.18-19, I believe it is 'Commercail Only'. If you are talking about using iFrame, I think it is possible in Community.

I have not tried it, but is this document not available? (for 8.0/8.0.0/8.0.1) https://community.jaspersoft.com/documentation?version=64266 　--> TIBCO JasperReports Server Installation Guide 　　　--> View PDF 　　　　　https://community.jaspersoft.com/documentation/v80-v800-v801/tibco-jasperreports-server-installation-guide

It is possible to display the label on all pages by placing the label component in the 'Page Header' band or 'Page Footer'. However, if the number of pages is not fixed, it does not seem easy to control that only the last page is not displayed. I have not found a solution. * Preview * Design

'Crosstab Wizard' I thought it was feasible only to select only 3 columns.