How to assign an Autosearch variable when using calculated fields?

frankp01 · February 2019

Greets:

I have two calculated fields: Extract(Month from DOB) and Extract(Day from DOB). In the Query Designer the first has a field alias of BirthMonth and the second of BirthDay. In the Query designer, to search them, the Query designer assigns the full expression as the Field name. If I change the Field name to the alias I get an error.

When the report runs, both search values show up as "DOB" and that's all. Since they have the same name, how do I differentiate between them? I need to be able to assign the values to the two AutoSearch variables. When using AutoSearchByName() I've tried the full expression and/or the alias. Neither seems to work. Using DOB does work. However, since I have two search variables, how do I differentiate between them?

Phil Frank

nicocizik · February 2019

Hi Phil,

ReportBuilder ties its report parameters closely with the autosearch feature. I highly recommend creating report parameters for each of your search conditions and giving them unique names so they can be differentiated in the Autosearch dialog. You can then assign the parameters to the search conditions in the query designer. See the following article on the basics of using report parameters.

http://rbwiki.digital-metaphors.com/end-user/fundamentals-end-user/report-parameter-fundamentals/

frankp01 · February 2019

Thanks, I'll take a look.

frankp01 · February 2019

Ah, I forgot to mention that this is with RB 7.04. I don't think Report.Parameters were fully implemented at that point, were they? This report is in a fairly old app, but if I have to I'll create a small free-standing exe just for running this report with RB 19.

How to assign an Autosearch variable when using calculated fields?

Comments