[Multi select for 4.7 seems broken]

Ernestoo's solution works for me in v5.6.1. Thanks

[Will the jasper able to generate pdf file with 50 million records which is present in the data base]

Consider using a report virtualizer. See here:

http://jasperreports.sourceforge.net/sample.reference/virtualizer/

http://community.jaspersoft.com/wiki/comparison-report-virtualizers

[How to create multiple pdf from a single jasperreport?]

JasperReports Server has a scheduling feature that automatically exports to PDF. If you redesign the report to use parameters instead of grouping then this could be an easy configuration via a Scheduled Job.

[Filtering by information in higher level subreports]

The subreport element has a property to pass in parameters values from the parent report to the subreport.  Those values can be any legal expression like a field, variable or parent report parameter.

[How to pass a parameter (client_status) with one of three selections, All, Active, None and when client_status is set to None to not use this as a condition in the where statement when running the sql?]

What you are describing sounds straightforward with techniques like $P{} SQL injection in the WHERE clause, Print When Expressions on subreports or creative use of grouping. But, you will need to provide more info if how want prescriptive assistance. Thanks

[Any way to prevent an orphaned line or two on next page?]

If you use Grouping in the report and get this block of text in its own group then you can prevent the text block from starting to print on the bottom of the page.

[Summarizing a field]

The details band is processed for every row in your results. Your summary table needs to be moved to the Summary band. 

[$P{parameterName} in sql statement (fetch first N rows only)]

Use $P!{param}.

 

The exclam makes the value an unquoted string.

[Using multiple IF statements in calculated fields]

You can next IF functions. Here is a sample with the Foodmart sample data.

 

[Any way to prevent an orphaned line or two on next page?]

If you use Grouping in the report and get this block of text in its own group then you can prevent the text block from starting to print on the bottom of the page.

[Concurrent Query Execution & Conversation Locks]

Have you tried JDBC v JNDI data sources? Do you see a performance difference?

[Regarding Static text]

You can do this with a bar chart or even a Text Field element. Make the element the max width desired. And, fill it with an expression that uses the results of the final value of the REPORT_COUNT variable.  

[1099 Template]

Hi Jeff and Everybody,

This question came up again today. I am curious if you have come across this.

Thanks,

Sam

[where do you specify input parameter's where clause in jasperserver]

Your question is not clear. It sounds like you are unsure how to create Input Controls on JasperReports Server. Input Controls is how the server solicits parameter values from the user. Is that what you mean?

[How to make a sort]

  Here is a sample report that prompts the user to choose which field/column to use for sorting and grouping. It is built on Jaspersoft v4.5 using the sample foodmart database.

[dynamic group expression]

 Here is a sample report that prompts the user to choose which field/column to use for sorting and grouping. It is built on Jaspersoft v4.5 using the sample foodmart database.

I reattached the sample, re-tested on version 5.5.

Post Edited by sfriedman at 12/15/2011 22:35