I already do that... every time the print button is clicked the whole SQL text of the query is erased and re-assigned again in the way described below...
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of CyberBug Sent: Thursday, June 09, 2005 2:08 PM To: [email protected] Subject: Re: [delphi-en] Problem in Report Builder TppReport component 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 a.. To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ----------------------------------------------------- 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/
