lookup parameter with another parameter filter
Good day!
In the research report builder I have 3 fields display of parameters.
Start date, end date and a lookup.
In the lookup field, I'm listing data filtering information by start and
end date.
The problem is that these data are not updating automatically according
to the informed user in the search screen dates.
The database lookup to appear, but filters only by the dates initially
put default value.
I tried to find some event type "OnEnter" parameters in the query but to
reopen but not found.
Any solution?
In the research report builder I have 3 fields display of parameters.
Start date, end date and a lookup.
In the lookup field, I'm listing data filtering information by start and
end date.
The problem is that these data are not updating automatically according
to the informed user in the search screen dates.
The database lookup to appear, but filters only by the dates initially
put default value.
I tried to find some event type "OnEnter" parameters in the query but to
reopen but not found.
Any solution?
This discussion has been closed.
Comments
Take a look at the following article explaining parameters and
autosearch in ReportBuilder. Hopefully it will get you on the right
track to updating your reports.
http://www.digital-metaphors.com/rbWiki/End-User/Fundamentals/Report_Parameter_Fundamentals
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
parameters.
In my case, the lookup needs to be bound to a query with filter start
and end date, which could do.
The problem is that if I change the start or end date in the search
screen to open the lookup on the same screen, the information remains
the same.
Ie linked to the lookup query does not update. Should be updated when
opening it. Correct?
Em 09/07/2014 13:00, Nico Cizik (Digital Metaphors) escreveu:
Has a similar case in 13/09/2012 in the same group.
And another case in 20/09/2013 in the group "dm.prdatapapelines", where
it was said:
"However I will add this to our list of possible enhancements for the
later release of the product."
Upon entering the lookup should also update the linked query with the
updated value of the parameters.
Any solution?
Em 09/07/2014 13:47, Fabricio Soldati escreveu:
Thank you for the further explanation. A feature for automatically
updating autosearch fields based on previous user input is not currently
available in ReportBuilder. As mentioned in the other posts you
referenced, it is on our possible enhancements list for a future release
of ReportBuilder. Thanks for your feedback.
Currently you would need to create a custom autosearch dialog that
performs this task manually.
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Problem is that this case was a custom report user.
Complicated ... but I have to create a specific search screen then ...
Any predictions have this functionality, because since last year has
been asking users?
Em 10/07/2014 11:55, Nico Cizik (Digital Metaphors) escreveu: