Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

lookup parameter with another parameter filter

edited July 2014 in End User
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?

Comments

  • edited July 2014
    Hi Fabricio,

    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2014
    In this example the query related to the lookup is normal, ie has no
    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:
  • edited July 2014
    Continuing ...
    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:
  • edited July 2014
    HI Fabricio,

    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.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2014
    I understand ...
    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:
This discussion has been closed.