grant.king

Thanks Ankur I have set the default values of the parameters to be -1 and "" as suggested and also checked that the parameters run in the same order as they do in the stored procedure. I had already got the report to run in ireport even before your suggestions, however when I try to run the report through the repository navigator it does not return any results regardless of what dates I enter. When I try to run the report on jasper Server, the calendar selector does not allow me to select dates and when I try to enter them manually, it says I am not entering a valid data type http://community.jaspersoft.com/questions/808677/jasper-server-date-parameter

Does anyone know if it is possible to use a Cross Tab element within a List element in ireport? I am a newcomer to jasper and have used Microsoft Reporting Services previously. I am trying to replicate a matrix report in reporting services, where a seperate cross tab table is presented for each value of the parameters selected. eg a table for each customer, with each table on a seperate page. This is very easy to do in SSRS by using the list element, but I cant work out how to use the list element properly in Jasper Ireport - Where for example do you determine how the table iterates, eg in my example, where do you specify that there needs to be a seperate cross tab table per customer.

I am new to using Jasper and had designed a simple report which returns values based on a start date and end date from a SQL stored procedure, built using ireport. In ireport, the start and end date parameters are set as java.util.date. The report runs in ireport when previewed. I have then created input controls in Jasper Server to take these parameters and named them the same. These input controls use the data type of date. The report does not run in Jasper Server. 2 issues. 1) The date calendat selector freezes and does not allow me to select dates. 2) When dates are entered manually, the report returns with no results. My initial thought was that Jasper Server is passing the parameters to the SQL database in a different format that it needs. To test this I created a new report, this time taken from a view - eg select * from view where AddedDate between '2010-01-01' and '2012-01-01'. The report runs with this format. Can anyone suggest what I may be doing wrong with the parameters and why the calendar does not work? Thanks

So I got the query to work now, but the report does not run correctly. I get an error stating the the scalar variable must be declared. The parameter is set as sql.timestamp in jasper, is this correct?

Can any one help with this question? I can get the query to work if I use a view rather than a stored procedure. I guess that means I have the parameters set up correctly and there must be an issue with my syntac in the query when using a stored procedure, but I cant work it out

Hi there, I have literally been using Jasper for a few days now and so far I like a lot. I am testing out some of the features, but am struggling to get date parameters to work with an sql stored procedure. The report query is Execute sp_MyProcedure $P{@In_Start}$P!{@In_End}$P{@In_Skill} I have set up teh parameters and they are set to timestamp for @In_start & @In_End and string for @In_Skill The fields cannot be found by the query, i get the following error - Error executing SQL Statement for null check username and password If I modify the stored procedure to remove the start and end date parameters and adjust the jasper parameters then the query works, but I need it to include date parameters. Does anyone have any suggestion what I might be doing wrong?