ZuckerReports Query with Parameters

[carlo75]

Hi to all,
I try ZuckerReports, and I wnat to parameter a query SQL,
the correct syntax in the query editor, for a parameter is:

$name_of_parameters

If the response is yes, I've a problem, when I run a report
with parameters I receive an error SQl, and the report doesn't
work.

Can anyone write me a working example with parameters?
I use reports inline, without any template, there simple sum or
count.

Any ideas

[carlo75]

This is the output error:

Output

Error while running Report
Query: SELECT Sum(`opportunities_cstm`.`consumo_c`) FROM `opportunities` INNER JOIN `opportunities_cstm` ON `opportunities_cstm`.`id_c` = `opportunities`.`id` WHERE `opportunities`.`date_closed` BETWEEN '2009-01-01' AND '2009-12-31' AND `opportunities`.`sales_stage` = $FORNITORE AND `opportunities`.`deleted` = 0;
MySQL error :

$FORNITORE is the parameter... whre I'm wrong?

[crmsiva]

Did you created the query/report parameter with name "FORNITORE "?

If yes, are you using Friendly Name or Default Name of the parameter? You should use Default Name.

Put single quotes before and after the parameter

[carlo75]

Hi Siva,
thanks for your time, yes I made the parameter
FORNITORE and Friendly Name and Default Name are
both FORNITORE, when I put

'$FORNITORE'

in the query the output was blank, it seems that Zucker can't
recognize parameters.

My installation is Sugar5.2CE and Zucker 1.10CE (fixed)

Other ideas?

[crmsiva]

What type of parameter you have created? Is it Drop-Down List?

If yes, did you selected the value in dropdown list while running report?

[carlo75]

Yes is it a droplist, and when I launch the report,
I cannot see the dropdown list to select a value...

[crmsiva]

you need to add your parameter 'FORNITORE' as a filter to the report. You can find "New Filter" sub tab in the detailview of the report. You can add filters here

[carlo75]

There's something strange when I save the parameter,
I've attached the screenshot...

In the table zucker_reportparamaters I see the "default" parameters like ACCOUNT_ID
CONTACT_ID, that have the column RANGE and RANGE_OPTIONS full of data, but my
new paramaters is NULL and NULL (see screenshot)

I don't know if this can help

[crmsiva]

The type of other parameters are different. Your parameter's type is dropdown list. So don't worry.

[carlo75]

sorry but when I edit my Reports, I can't see
the Filters Tab, here's a screen