Hi, Try Query.close and than Query.open
--- Vahan Yoghoudjian <[EMAIL PROTECTED]> wrote: > I have a TppReport (Report Builder component > connected to a TDBPipeLine) > that uses a query as a datasource. This query text > is composed of 3 parts (2 > UNIONS) each one based on a certain condition > provided by the user. > Let's say > > if (checkbox1.checked) then > // Set first part of the query text > > // Set main part of the query > > if (checkbox2.checked) then > // Set third part of the query > > For info before setting each text other > evaluations are done also to > know if the UNION key word is to be used or now > according to the > combination. > > Now my problem is that, when I check the > checkboxes and print the report > everything works fine. I uncheck the first checkbox > and reprint again. the > report preview is displayed but empty. no page > numbers are displayed. while > tracing the query returns records, but the report is > somehow unable to see > it. On the preview form I have to click on 'next' or > 'previous' page so that > the preview form positions itself on the first > page... any similar problems > with anyone? What do you think the reason is... I > tried all possible methods > to fix the problem but could not... like Loaded, > Refresh,Query.First, > Query.Next etc... > > > Thanks in advance > Vahan > > > [Non-text portions of this message have been > removed] > > __________________________________ Discover Yahoo! Stay in touch with email, IM, photo sharing and more. Check it out! http://discover.yahoo.com/stayintouch.html ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/