mbmorgan

It was simple. Everyone is happy. Thanks for your help, rajesh and tchen!

Hello everyone, I have someone in my company who is presenting a report to a client this afternoon. She asks: "can you please change the settings for me so that it does NOT time out if I leave the screen idle?" Can this be done in JR Server? I couldn't find anything about it in the documentation. Any and all assistance will be greatly appreciated. Thanks, M.B.Morgan

I'm only familiar with SQL, but here's something that might help: select Col3 from [TABLE] where Col1 = Data1 and Col2 = Data2 Note that the syntax might depend on what datasource you are using. Hope this helps! M.B.Morgan

Thank you, sir. I'll give this a look.

Hello everyone, Can anyone help me on how to use scriptlets? I have ZERO experience with Javascript, and I have no idea how even to get started (how do I create a JAR file, how do I build it into the report, etc). Any assistance is appreciated. Thanks, M.B.Morgan

Hi, I previously posted an answer, but for some reason it is not showing. It sounds like you want to implement a conditional query. Here is a link to a very helpful video explaining how to do just that: http://community.jaspersoft.com/blog/how-implement-conditional-query-ireport-using-sample-database-sample-included Good Luck, M.B.Morgan

Here is a link to a very helpful video on how to implement conditional queries: http://community.jaspersoft.com/blog/how-implement-conditional-query-ireport-using-sample-database-sample-included Good Luck! M.B.Morgan

Try this (assuming what you are 'collecting' are of String type): new ArrayList(Arrays.asList(new String[] {""})) Good luck! M.B.Morgan

Try using this as your default value expression: new ArrayList(Arrays.asList(new String[] {""})) Good luck! M.B.Morgan

Haidar, To build a dashboard, it helps to have an outline of want you want it to include...similar to making an outline before writing a paper. Who are the end users? What information will they need? What functionalities will they need? All those questions must be answered before you can really get started. As for exporting as a PDF, that can be done in Jaspersoft Studio and Jasper Reports Server. I hope this helps you get pointed in the right direction. Good Luck, M.B.Morgan

You can add charts and tables to any band of the report you want. Consider using subreports also to contain the tables and charts. Please elaborate on what you are trying to accomplish. Thanks, M.B.Morgan

What about it was not working?

Hi Mallik, I'm not sure I understand your question. "...but just one problem when the chart executes in the server it comes as an empty report. After chossing the data from the control the chart poopulates" - This is by design from when you made the input controls mandatory - the report will not populate in the JR Server until the user actually selects something in the controls for it to work with. Please elaborate on what exactly you want to accomplish.

Were there any other details provided in the error message?

Hi, a few suggestions: "I need to create one date Input-control which will be in relation like (from date - to date. )" - This sounds like you actually need two date-based input controls, Start_Date and End_Date for example. In Jaspersoft Studio, make sure the date parameter is of class java.sql.Date. In JR Server, when you set up and edit the input control, on the "Create Input Control" page, select "Single Value" as the type (make it also Mandatory and Visible if it's necessary to run the report). Then, on the "Set the Datatype Kind and Properties Page", select "Date" as the type. You can enter optional max and min values there. Your report query should look something like: "select * from table where date_column >= $P{Start_Date} and date_column <= $P{End_Date}..." I am a new Jasper developer and I had this same problem recently. This solution is what worked for me. Good Luck, M.B.Morgan