Thanks much...I appreciate it very much. I will try that.
Brian
--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
wrote:
Brian
--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
wrote:
>write the
>
> Yes.
>
> Only on your BAQ's, however.
>
> When I prefer to see "NO RESULTS" in the preview window, I'll
> BAQ with the Company table as the first table and outer join thetables
> I really want.in
>
> Say for instance you wanted to create a simple PO report BAQ.
>
> Company table is first. Then add POHeader; outer join.
>
> Choose a few fields to display from POHeader. Put Company.Company
> there, too.where
>
> Now analyze/test it and you'll see all your PO's.
>
> Now, in Phrase Builder (for this test) put a filter on POHeader
> PONum = 999999999 or something crazy you know doesn't exist.have
>
> Now re-test the BAQ. Company will still be displayed and you will
> one record as a result. The fields you chose from POHeader arenull now
> because of the filter we set above on the PONum.NULL,
>
> I then set up something in Crystal Reports to where if PONum is
> then suppress the Detail band and display this message "NORESULTS".
>system.
> It's not the greatest way to do this and it should be easier or
> standard. But we have to always come up with ways to "fix" the
> :-)get
>
>
> -----Original Message-----
> My question to the group is, has any of you found a solution to
> crystal or vista to pop up something to tell you nothing is coming?
>
> Thanks,
> Brian
>