Home› DADE
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Any suggestion ??

rbuserrbuser
edited October 2004 in DADE
This is my problem.
Our data is stored on a daily base (transactions), but, quite some
reports work on a weekly base. There is a 'calendar' in de database,
because not for every company in our db the week starts on the same
day. In our reports i'm having over 14 datasets working on this week.
All have to perform the same join to the calendar table. This is not
performing very well. In a normal program one would select once the
week and use then the start & stop date to perform the other selects.
But as we run the reports with a reports server we prefer to have it
mostly in dade & rap, no additional delphi code. Could this be done
(get first dates and afterwars launch all others datasets). With
regular dade i don't know a way to control the excecution of the
datasets.
Kinds Regards
Harry Leboeuf.

Comments

  • nardmoseleynardmoseley
    edited October 2004

    Below is an example that you can download. For the first query, create
    autosearch criteria and then for the subsequent queries create standard
    search criteria. When the user enters the search criteria, you can
    programmatically apply the value to all applicable queries.

    www.digital-metaphors.com/tips/OneAutoSearchCriteriaToMany.zip


    --
    Nard Moseley
    Digital Metaphors Corporation
    www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • rbuserrbuser
    edited October 2004
    Nard,
    This technique i am already using in other situations, but in this
    case this week parameter is already an autosearch value, the only
    solution i'm seeing might be to create a Passtru that creates an ado-
    connection and fetches the dates for me so that they can be filled
    into the other dade-autosearch values before they execute.
    Might this work ?
    25/10/2004 18:28:01
  • nardmoseleynardmoseley
    edited October 2004

    I did not fully understand the original question. So you have an AutoSearch
    value and you want to use the value to build a query against the database
    that is used to populate search criteria for other queries in the report.

    Yes, I think that will work. You could write a RAP pass-thru function to do
    that and then use the technique shown in the downloadable example.



    --
    Nard Moseley
    Digital Metaphors Corporation
    www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.