> Hi
> My current data source is a join of several tables in an access
> database. I have added a query in that database to select some fields
> from a linked Btrieve table, because the linked tables do not show up
> in the  "Add database to report" window.
> 1. Then I add this query to my report by choosing it in the list of
> available "SQL Tables".
> 2. Then I used the visual linking expert to properly link the new
> query to the existing tables.
> 3. Then I "Insert Fields/Databse" to put a field from the new qry onto
> the report.
> The report fails because when I "Show SQL query", although it shows
> the field in the select list, it did not add the qry to the FROM
> clause of the query. Why doesnt it add it in or how can I add it in to
> complete this query?
> I tryed the Select expert. I thouhgt maybe if I told it there that the
> condition should be that this new field = the related field in another
> (existing) table that maybe that would link it, but that can not be
> done either.

> Sorry but I seem to have a lot of trouble adding new data to my report
> once the query has been established initially.
> Any help is much appreciated.
> Thanks
> Jeff

>Have you "verified" your database in the report since changing the
>tables/queries?  From the report design window, select from the "Database"
>menu "Verify Database."  You can also it in code, talk a look at help under
>verify database.

>> Hi
>> My current data source is a join of several tables in an access
>> database. I have added a query in that database to select some fields
>> from a linked Btrieve table, because the linked tables do not show up
>> in the  "Add database to report" window.
>> 1. Then I add this query to my report by choosing it in the list of
>> available "SQL Tables".
>> 2. Then I used the visual linking expert to properly link the new
>> query to the existing tables.
>> 3. Then I "Insert Fields/Databse" to put a field from the new qry onto
>> the report.
>> The report fails because when I "Show SQL query", although it shows
>> the field in the select list, it did not add the qry to the FROM
>> clause of the query. Why doesnt it add it in or how can I add it in to
>> complete this query?
>> I tryed the Select expert. I thouhgt maybe if I told it there that the
>> condition should be that this new field = the related field in another
>> (existing) table that maybe that would link it, but that can not be
>> done either.

>> Sorry but I seem to have a lot of trouble adding new data to my report
>> once the query has been established initially.
>> Any help is much appreciated.
>> Thanks
>> Jeff

>I dont remember if I had verified it, so I went through the entire
>procedure again and did include the verify process in my activites
>this time. The new qry that is added to the report still does not show
>up in the SQl statement-FROM clause. Any other ideas? This is driving
>me nuts.
>If there was a way to just change CR's SQL clause myself it would be
>easy for me. Is there a way to get into the SQL directly to make
>changes?
>by the way this is CR version 7
>thanks again
>Jeff

>>Have you "verified" your database in the report since changing the
>>tables/queries?  From the report design window, select from the "Database"
>>menu "Verify Database."  You can also it in code, talk a look at help
under
>>verify database.

>>> Hi
>>> My current data source is a join of several tables in an access
>>> database. I have added a query in that database to select some fields
>>> from a linked Btrieve table, because the linked tables do not show up
>>> in the  "Add database to report" window.
>>> 1. Then I add this query to my report by choosing it in the list of
>>> available "SQL Tables".
>>> 2. Then I used the visual linking expert to properly link the new
>>> query to the existing tables.
>>> 3. Then I "Insert Fields/Databse" to put a field from the new qry onto
>>> the report.
>>> The report fails because when I "Show SQL query", although it shows
>>> the field in the select list, it did not add the qry to the FROM
>>> clause of the query. Why doesnt it add it in or how can I add it in to
>>> complete this query?
>>> I tryed the Select expert. I thouhgt maybe if I told it there that the
>>> condition should be that this new field = the related field in another
>>> (existing) table that maybe that would link it, but that can not be
>>> done either.

>>> Sorry but I seem to have a lot of trouble adding new data to my report
>>> once the query has been established initially.
>>> Any help is much appreciated.
>>> Thanks
>>> Jeff

>Hi, Jeff. You're not going nuts alone !  :)

>One workaround might be that you complete your SQL-query in your program
>code,
>execute that query so that you get an recordset. Then after that, you tell
>in your program
>Crystal to use that recordset as table for filling up your fields in the
>report.

>I struggled with SQL joins too. Btw, do you use the OCX or do you use
>Automation interface
>to do stuff on your report ? I used ocx and noticed that if I do things like
>I mentioned above, the
>report comes up *really* quickly even if I had some 10000 records to put
>into report. This speed
>is compared to speed that it takes for Crystal to execute the query through
>the db-provider.
>(To those who might think me lying : I hadn't saved the data with the report
>! Checked that many times :)

>Good luck,  Tomas.

>>I dont remember if I had verified it, so I went through the entire
>>procedure again and did include the verify process in my activites
>>this time. The new qry that is added to the report still does not show
>>up in the SQl statement-FROM clause. Any other ideas? This is driving
>>me nuts.
>>If there was a way to just change CR's SQL clause myself it would be
>>easy for me. Is there a way to get into the SQL directly to make
>>changes?
>>by the way this is CR version 7
>>thanks again
>>Jeff

>>>Have you "verified" your database in the report since changing the
>>>tables/queries?  From the report design window, select from the "Database"
>>>menu "Verify Database."  You can also it in code, talk a look at help
>under
>>>verify database.

>>>> Hi
>>>> My current data source is a join of several tables in an access
>>>> database. I have added a query in that database to select some fields
>>>> from a linked Btrieve table, because the linked tables do not show up
>>>> in the  "Add database to report" window.
>>>> 1. Then I add this query to my report by choosing it in the list of
>>>> available "SQL Tables".
>>>> 2. Then I used the visual linking expert to properly link the new
>>>> query to the existing tables.
>>>> 3. Then I "Insert Fields/Databse" to put a field from the new qry onto
>>>> the report.
>>>> The report fails because when I "Show SQL query", although it shows
>>>> the field in the select list, it did not add the qry to the FROM
>>>> clause of the query. Why doesnt it add it in or how can I add it in to
>>>> complete this query?
>>>> I tryed the Select expert. I thouhgt maybe if I told it there that the
>>>> condition should be that this new field = the related field in another
>>>> (existing) table that maybe that would link it, but that can not be
>>>> done either.

>>>> Sorry but I seem to have a lot of trouble adding new data to my report
>>>> once the query has been established initially.
>>>> Any help is much appreciated.
>>>> Thanks
>>>> Jeff