Can't be done... I don't see in anyway UNION and JOIN doing a similar jobs... at least in what I'm doing... I have to remind that the query has nothing wrong, it's fetching the necessary rows, the problem relies either in the TDBPipeline or TppReport, I don't know if it's a bug or there's something I have to do I don't know about....
Vahan -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of CyberBug Sent: Friday, June 10, 2005 8:16 AM To: [email protected] Subject: RE: [delphi-en] Problem in Report Builder TppReport component Try your SQL UNION stetement replaced with JOIN statement. --- Vahan Yoghoudjian <[EMAIL PROTECTED]> wrote: > 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] > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ----------------------------------------------------- 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/
