Zucker Date Parameter

[JeanetteRoss]

Hi
I am trying to write a Zucker report with mySQL and parameters

I have done this report in iReports but can get a good excel document - as it has loads of lines inserted.

So
Here is my basic query....

Select * from tasks
WHERE
tasks.deleted <> 0
AND
`tasks`.`date_due` > $datestart
AND
`tasks`.`date_due` < $dateend

I have two parameters that I have bound called
datestart and dateend - in put type is date.

When I hard code the date it works but as soon as I use the parameter nothing outputs.
I have date format of 2007-06-30 in the data base but the date parameter is in UK date format -
30-06-2007.

Any ideas
Cheers

[JeanetteRoss]

Solved it
"$datestart"

[sidh211]

Hii

can you plss let me kno how you have achieved this date range requitrements as we need to generate reports for certain date range..plss help me out


regds
sid

[asbaeza]

You should write your query in iReports using the proper name of your parameter. That is, if your parameter in ZuckerReports is Date, you should use it as $Date, as in this sample:

select x,y,x from sometable where x.date = "$Date" ...

Regards

[sidh211]

Hii asbaeza

actually we have the requirement where, when you run the report at that time the application should promt you two fields where you can enter the dates and then at the back end query should take these two date fields and search in the database for the records which are created between these two dates

can you plss help me out

thanks

regds
sid

[mikesolomon]

Hii asbaeza

actually we have the requirement where, when you run the report at that time the application should promt you two fields where you can enter the dates and then at the back end query should take these two date fields and search in the database for the records which are created between these two dates

can you plss help me out

thanks

regds
sid

create a start & end date parameter in zucker reports & with the same name in ireport

then use them in the ireport report query:

AND DATE(t.`date_start`) BETWEEN $P{1date_start} AND $P{2date_end}

where 1date_start & 2date_end are the parameter names

Then in zucker reports bind the parameters to the report

[sidh211]

hii thanks for the quick reply

but canyou tell how can i create these two parameters in zucker reports do i have to add code in vardefs
and how to bind these parameters to the module

plss help

thanks

regds
sid

[mikesolomon]

hii thanks for the quick reply

but canyou tell how can i create these two parameters in zucker reports do i have to add code in vardefs
and how to bind these parameters to the module

plss help

thanks

regds
sid

you create them using the 'Report & Query Parameters' option in zucker reports - this should be in the left hand panel

Once you have created the report click on it and near the bottom of the page you can select a parameter and bind it to the report

[sidh211]

hi mike

I have written this query in iReports but its giviing me an error

SQL Problems: [Microsoft][ODBC SQL Server Driver] Syntax Error Or Access Violation{2}

select * from leads
where date_entered between
$P{zucker_reportparameters.startdate} AND $P{zucker_reportparameters.enddate}

I have created startdate and enddate these two parameters in zucker report and query parameters

Can you suggest something

Thanks & Regds

Sid

[mikesolomon]

hi mike

I have written this query in iReports but its giviing me an error

SQL Problems: [Microsoft][ODBC SQL Server Driver] Syntax Error Or Access Violation{2}

select * from leads
where date_entered between
$P{zucker_reportparameters.startdate} AND $P{zucker_reportparameters.enddate}

I have created startdate and enddate these two parameters in zucker report and query parameters

Can you suggest something

Thanks & Regds

Sid

If you go to Connections/Datasources & click on your connection then click on the test button does it work

It sounds like a connection issue rather than a sql problem