How to use field name in search tab

rbuser

Hi,

I have a table which saves all search values for reports. I want the end
user capable to designate a field for search value in RAP (e.g. WHERE
fldDate <= tabData.EndDate). Is it possible? Or is it possible to disignate
a JIT field for the search value (WHERE fldDate <= tabJIT.EndDate).

Thank you!

nicocizik

Hi,

Would you like your users to be able to add a field in the search tab or in
RAP. If you are using the search tab of the query designer, they can simply
insert the field name into the value editbox. If you would like them to
edit the search expression in RAP, they will need to use the TdaSQLBuilder
object. See the TdaSQLBuilder topic in the ReportBuilder help for more
information.

--
Regards,

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

rbuser

Hi, Nico!
I prefer my users use the search tab but capable entering field or some
kind of variable instead of search value.
The reason is, I made my own autoSearch form. However, linking the report
with my form is a lot of work. In the search tab, a report knows what field
for a criterion, not the serach value (unless a fix value). In
TdaSQLBuilder, a report knows the search value from my AutoSearch form, not
the search field (unless all report has that same search field). I think
what you really want to recommend is TdaSQLBuilder. But I have to code what
the search field name is, for different report. And that is just one
possible criterion.
So my question is: since you have JIT field for Design Tab, pass through
function for Calc Tab, can you have some kind of Link Value for the Data
Tab? So I can link Delphi's value within the Data Tab. That will reduce my
endless coding for report criteria.

Thank you!

nicocizik

Hi Bin,

If I understand correctly, you need something like Parameters available in
the TQuery object? Unfortunately DADE does not currently support this type
of feature. It is something that we have discussed and could possibly make
it into a later release. For now this will have to be done manually as you
describe below.

--
Regards,

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