[How to change not-for-prompt parameters during development]

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.

 

 

[Variable wants to add a starting value but Initial Value Expression didn't work]

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.

[Unable to create multiple column groups in Jasper report]

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

 

 

[Unable to create multiple column groups in Jasper report]

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

 

 

 

 

[Two column groups next to each other in crosstab]

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.

 

 

[Significant memory consumption due to delayed evaluation (DelayedFillActions)]

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.

 

[Doubts about creating group breaks]

There is a way to arrange two table components in a summary band.

* Design Image

* Preview Image

[How to restrict a report to one page?]

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

 

 

 

 

 

 

[Jaspersoft Studio substitutes question mark for parameter value in submitted SQL]

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'.

 

[Jaspersoft Studio substitutes question mark for parameter value in submitted SQL]

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.

 

[Can I deploy manually jrxml to Jasper Server]

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/)

 

[Create and deploy reports. Limitation with Community Edition?]

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.

 

[Documentation for installing JasperServer 8.0 on Ubuntu/Linux]

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

 

[Manage Static Text dynamically ?]

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

 

 

 

[How to limit the number of columns printed in cross table?]

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

[Summarized data with multiple rows]

I know this is not a smart solution, but it could be accomplished by using a wrist component for the summary band.

* Preview

* Design

 

* SQL
To use the list component, a sub-dataset is required.
The SQL for this sub-dataset should be written as follows

select class,sum(animalqty) as classqtyfrom test.t27group by class

 

[change image color svg jasper]

SVG is available in 'Custom Visualization Component'.

* Compornent

* Most Simple Sample Preview

* Manual
https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v750/custom-visualization-component#kanchor71

* YouTube

 

[How to Handle null values when passing nothing in Double Select Query parameter]

I am using MySQL and was able to achieve this with the second method.

I have changed your SQL idea a bit.
The actual test SQL is below.
(you may need to rewrite it for MSSQL)

SELECT * FROM test.t26WHERE minesite = $P{minesite}ANDCASEWHEN $P{typeOfcertificate} is nullTHEN   1=1ELSE  typeOfcertificate = $P{typeOfcertificate}END

* Case1 (typeOfcertificate is not null)

* Case2 (typeOfcertificate is null)

 

 

[Repeating frame]

I will need the following information to assist you going forward.

* Current report display results (ScreenShot)
* Expected report display results (handwritten image)
* The current *.jrxml file
* Sample data obtained by following the steps at the following site
  https://community.jaspersoft.com/wiki/create-mock-or-sample-query-data-using-jaspersoft-studios-export-sql

However, please understand that we may not be able to solve the problem even if you provide us with the data, and we may not be able to reply immediately.

 

[pagination problem]

I most likely do not understand your requirements.
However, you can use the 'Report Books' feature to achieve page-by-page resizing.

* Manual
https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v790/report-books

* YouTube

 

 

[How to avoid the login page when the report is send as link in the email body ?]

I have not tried it, but there is a way to view reports without logging in.
https://community.jaspersoft.com/wiki/allow-anonymous-access-reports
  --> Allow Anonymous Access to Reports

[Repeating frame]

If you are good with SQL, we may be able to solve this in SQL.
I have written an example below, but the results are not guaranteed and should be rewritten to suit your requirements.
Also, keep in mind that you can expect poor performance with this method.

* SQL that mimics your SQL (not actually calling the function, but assuming the return value of the function)

SELECT func1_return,func2_return,field1,field2  FROM test.t25;

 

 

* SQL I rewrote

SELECT MAIN.func1_return,SUB.func2_return,MAIN.field1,MAIN.field2FROM test.t25 MAINLEFT JOIN (  SELECT func2_return,MAX(func1_return) AS func1_return from test.t25  GROUP BY func2_return) SUBON SUB.func1_return = MAIN.func1_return

 

[Show sum of a few consequtive records in front of the first one]

I have created a simple sample report.

The key points are as follows.
* Calculate 'sum' by aggregating 'amount' using groups
* Set 'Group' for 'Evaluation Time' of 'sum
* Set '$V{Group1_COUNT}==1' as a display condition for 'sum' to display only the first line

- Preview image

- Layout design image

- SQL

- Variable [sum]

- Text field [sum]

[Add continue test when data overflows to next page]

As mentioned above, '$V{Group1_COUNT} ' is automatically created when creating a group, so just use it.

The following wiki is a good reference on how to create groups.
https://community.jaspersoft.com/wiki/groups

 

[Create Datasource from API]

I am also learning to create reports using WebAPI, and the first thing I was wondering is the following.

* If I click on the 'Data Preview' tab > 'Refresh Preview Data' button, does the data show up?

If the data could not be previewed, I thought there was something wrong with the data adapter settings.
If the data could be previewed, I thought it was due to some field setting.