Search criteria problem

rbuser

Hi there,

I have RB Ent 11.08

I have 3 dade pipelines in the data tab of a report. On my second and
third I have search criteria

Second one (2 search criteria items) both on the same field

Field: TranPeriod, Operator >=, Parameter: TranPeriodStart
Field: TranPeriod, Operator <=, Parameter: TranPeriodEnd

On third one I have one search criteria that should look like

Field: TranPeriod, Operator =, Parameter: TranPeriodEnd


However the operator on the search criteria of the third query is linked
to the second query, such that if I change one it changes the other
where the parameter is the same. In other words if I change the
operator on the search criteria that uses parameter TranPeriodEnd on the
second query, it changes the operator to be the same on the third query
on the criteria that uses also TranPeriodEnd.

I hope I am clear. The work around obviously at the moment is to use
different parameters for each query. This is not problem since the
parameters are set by code before executing the report and aren't set by
search dialog. This works.

Thanks,
Kevin Day

nicocizik

Hi Kevin,

I will take a look at this however I believe as a rule of thumb you want to
keep a separate parameter for each search criteria. This keeps things
separated and easy to understand as well as avoids conflicts like the one
you are experiencing.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com