Choose only the exist parameter

[mariog36]

 Hi

I have a problem, I have 6 parameters to use, but I want the report to take only the exist parameter, so the query use it, can anyone help me please.

 

Regards.

[braxivamov]

Hi,

Can u list your parameters and show your query in order to better understand your problem ? =)

[mariog36]

 Hi

I have 6 parameters, maybe more than 1 is used for the search, and I undesrstand that $!P{param} is used for an optional parameter right? if thats the case, I think the query is this:

select serie as serie,

nombre as nombre,

tipo_documento as tipo,

rfc_emisor as rfc,

status as status,

extra17 as ed,

sum(totalmn) as total,

impuesto as impuesto,

folio as folio,

fecha as fecha

 from table

where fecha between $P{fechaIni} and $P{fechaFin}

and nombre like $P{nombre}

or rfc_emisor like $P{rfc}

or extra17 like $P{extra}

or tipo_documento like $P{tipo}

or status like $P{status}

or serie like $P{serie}

group by rfc_emisor, tipo_documento

 

Regards