[Input Controls height adjustment]

Hi,
I may not have a solution to decrease the height and suspect its not possible. However, I can give you a work around.
Why dont you change the position of the input control to "Top of the Page"? That should solve the issue.

Regards,
KKriplani

[what is the subdataset?]

Hi,
In your previous question, I have replied for the first question

A couple of reasons why datasets are used are stated below;
1) If you have to execute 2 or more queries and populate various charts and tables etc, you will have to use datasets.
2) A table always requires a dataset and never picks the main query.

Regards,
KKriplani

[How to drop a subdataSet's Field into the report?]

Hi, 
You can create a table and drop the field within the table.
Note: Creating a table has a few steps like creating report connection and linking the parameters.

Regards,
KKriplani

[Report scheduling issue]

Hi,

1) Try using port 25 instead.
2) Also add this line to applicationContext-report-scheduling.xml ;
        <props>

                <prop key="mail.smtp.auth">true</prop>

                <prop key="mail.smtp.starttls.enable">true</prop>

           </props>

Hope this helps,
KKriplani

[Charts in Jaspersoft]

Hi,
If you are using jasperserver 6.2, then using tree map would be a nice option. Try creating one using adhoc view.

Regards,
KKriplani

[Query is executed again on download in jasper server GUI]

Hi,
I am no expert but I am afraid the query will be executed again. Jasperserver rexecutes the query and populates the reports again to get the current export. This is the normal behaviour.

Regards,
KKriplani

[csv export directly from jasperserver without running the report]

Hi,
I have a very simple method. 
embedd an image/text field in the report (it may say "export"), give it hyperlink to the report you want to export in either csv or xls as ReportExecution and Parent. While linking parameters, pass a parameter name as "output" and expression as "xlsNoPag" or "csv" as required.

Refer the image below.

You can have two images/text fields saying "Export to CSV" and "Export to XLS".

This should help,
Regards,
KKriplani

[how to append rows in excel reports]

Hi,
There is no such functionality in jasperserver to do so, Jasperserver populates a table from a table dataset.
However, you can create a query such that all this data is available, for example using a Union in the dataset query should logically help.

Regards,
KKriplani

[How to prevent dashboard from loading data before input control is applied]

Hi,
Either leave the default expressions of all parameters blank or leaving the default expression of any one parameter blank and marking that parameter as mandatory would help.
The first option is generally preferred. 

Regards,
KKriplani

[Dynamic Connector]

Hi,
Give a better insight of your requirement. what exactly you mean by dynamic connector? Are you trying to obtain data from more than a single database or type of database (for example from both mysql and oracle simoultaneously)?
Lastly, what version of jasperserver are you using?

Regards,
KKriplani

[Rus Language in Jasper Server]

Hi,
When you login, under the login credentials selection, there is an option of "show locale & timezone".
There isnt russian in that section so this is going to be tough as even if you create a new locale as russian (which for your information is done at  applicationContext-security.xml within <tomcat>/jasperserver-pro/WEB-INF), you will have to define various config files at <tomcat>/jasperserver-pro/WEB-INF/bundles. Even if you dont create new files, the en_US locale files will be picked by default.
So its of no use if you dont have the right files deployed for the the new locale created.

Read page 152 from this guide shared here >> http://community-static.jaspersoft.com/sites/default/files/docs/jasperreports-server-admin-guide.pdf?_ga=1.213488466.777635134.1461570079

To sum up, you would need to deploy the lanuage specific file in <tomcat>/jasperserver-pro/WEB-INF/bundles , with the below format; 
<file-name>_<locale>.properties|
and then call the same locale with applicationContext-security.xml (around line 146) within <tomcat>/jasperserver-pro/WEB-INF

Regards,
KKriplani

[jasper report extended logs]

Hi,
Yes you can view the logs.
For that you will have to follow the below listed steps;
1) Jasperserver, click on Manage >> Server Settings .
2) Upon reaching the log_settings, set the property to debug for the things you want to view in the logs (inclucing "SQL Query Executer")
3) on the server where jasperserver is deploed, Go to <tomcat-directory>/webapps/jasperserver-pro/WEB_INF/logs and view the file named jasperserver.log , you will find the logs there.

[Exporting a table in Excel]

Hi Guys,
I am using jasperserver 5.5 and exporting a table into XLS format (xlsNoPag). The issue is that whenever I export the table, the zero values in the table are printed as -
Is it a normal behaviour or is there any work around? Not sure what I am missing out.

Thanks is advance,
KKriplani

[How to hide/show Input Parameters in Jasper Server]

I can't really give the specific code but you will have to show and hide the input control based on their id.
use something like explained in this link.

Regards,
KKriplani

[How to hide/show Input Parameters in Jasper Server]

Hi,
These come as an additional customization.
You can write a jquery/jsp code in a file within the scripts folder of jasperserver-pro and call them during run time in the dashboardViewer.jsp

Regards,
KKriplani

[How to suppress Paged headers in CSV exports -- new in 6.x]

Hi,
What you can do is using ReportExecution hyperlink, calling the same report again, create an addition parameter, let us call it p_Print and having a default expression as 0.
When the report is rerun pass p_Print as 1 and for the page headers, pass the PrintWhenCondition as;
$P{p_Print} !=1

So, as the report is rerun , this parameter is passed and it hides all the page headers (if multiple) and just prints the CSV formats.

Regards,
KKriplani

[Error while taking backup of reports]

Hi,
I am not a cent % sure but this may be an issue of rights. check if the user exporting the zip has the right to export or not.

Regards,
KKriplani

[Problem with report Compilation]

Hi,
Using a table, have you linked the datasource and parameters of the table to that of the report?
Also check if the dataset has the fields listed above?

Regards,
KKriplani

[Jasper or JRXML - Which are more efficient]

Hi,

are you aware that jasper builds reports in xml format specifically called jrxmls (Jasper reports extensible markup language).

Just build a report in designer and the xml will be updated in the backend. They are one and the same.

Regards,
KKriplani

[Values not visible when using input controls in jasper server]

Hi,
At first run the same query in the database and verify if the result is the same. If so, obviously the reason is with the query else verify if the input control is created correctly (like if the datasource is correctly mentioned) etc.

Regards,
KKriplani

[Dashboard whit report name as parameter]

Give an example to understand the requirement better.

[Hyperlink When Expression does not work]

Thanks for sharing the Solution Hozawa, will give it a try.

Regards,
KKriplani.

[Hyperlink When Expression does not work]

Hi,
Though I haven't dug deep into it but I feel that it doesnt work.
I had a requirement of not displaying hyperlink when the value of that field is 0 but have hyperlink when the value is non zero.
So i simply used two text fields (same text fields) one over the other, one with hyperlink and other without hyperlink and printed them using the printwhen condition.

Regards,
KKriplani.

[Anybody knows how to retrieve subreport value without displaying subreport?]

Hi,
The purpose of the subreport is just to return a result from the query?
If thats the only point, add a dataset in the main report and just use the field value.

That should help.

Regards,
KKriplani

[Anybody knows how to retrieve subreport value without displaying subreport?]

Hi,
Why not calculate the text field within the subreport and display the subreport containing only that calculated text field? I am not sure if that meets the requirement but give it a try.

Hope this helps,
KKriplani