Values from 2 tables in one column

[happydermis]

Hello,__I posted two times yesterday on a thread I started a week ago but I can find my posts (it was on: Enhancements/Suggestions/General Comments). ____I will go on with this thread here:____Kathleen - I still have things I don^t understand:__1. do I have to create a WHICHSCAN field for each table?____2. on the example you^ve sent me the groups header and footer have the name "1GH-WHICHSCAN" mine just have the default name from R&R. Does the name matters for anything? Does the name link the band to the SCAN function?____3. I couldn^t get your report to run. I put all three dbf-Files into the DB (all three into the same folder) but I still get an ERROR than the file anydbf.dbf cannot be opened (might be in use - but it is not in use)____Many thanks, Dekers__

[happydermis]

Hi Kathleen,____I_ve managed to create the report (the very first draft) but I still have problems with it. __1. I manage to print only the scores from the first table.__2. R&R doesn_t print the header before the scores from each table (_Intern products_/_Extern products_). I didn_t use your report as a base report because I wanted to learn how this is done. I simply followed all the instructions you gave me, based on the report that you_ve sent me (that is now working). I don_t know if this is the reason but on the example you^ve sent me the groups header and footer have the name "1GH-WHICHSCAN" mine just have the default name from R&R. Does the name matters for anything? Does the name link the band to the SCAN function? How do I change the name of a group band?__3. I_ve tried to link a ParameteRR field with a help of a query to the DB. The problem is: when I run the report it creates the indexes but than it simply closes the window suddenly and the report is gone. When I erase this query the report manages to deliver the scores from the first table. I need the linking from the ParameteRR field to the DB because this is my way to tell R&R which values it should look for in the second table. With the first table I manage to create such a link and this link works. ____Thanks, Dekers

[happydermis]

Hi Kathleen,____I_ve managed to create the report (the very first draft) but I still have problems with it. __1. I manage to print only the scores from the first table.__2. R&R doesn_t print the header before the scores from each table (_Intern products_/_Extern products_). I didn_t use your report as a base report because I wanted to learn how this is done. I simply followed all the instructions you gave me, based on the report that you_ve sent me (that is now working). I don_t know if this is the reason but on the example you^ve sent me the groups header and footer have the name "1GH-WHICHSCAN" mine just have the default name from R&R. Does the name matters for anything? Does the name link the band to the SCAN function? How do I change the name of a group band?__3. I_ve tried to link a ParameteRR field with a help of a query to the DB. The problem is: when I run the report it creates the indexes but than it simply closes the window suddenly and the report is gone. When I erase this query the report manages to deliver the scores from the first table. I need the linking from the ParameteRR field to the DB because this is my way to tell R&R which values it should look for in the second table. With the first table I manage to create such a link and this link works. ____Thanks, Dekers__

[happydermis]

Hi Kathleen,____I_ve managed to create the report (the very first draft) but I still have problems with it. __1. I manage to print only the scores from the first table.__2. R&R doesn_t print the header before the scores from each table (_Intern products_/_Extern products_). I didn_t use your report as a base report because I wanted to learn how this is done. I simply followed all the instructions you gave me, based on the report that you_ve sent me (that is now working). I don_t know if this is the reason but on the example you^ve sent me the groups header and footer have the name "1GH-WHICHSCAN" mine just have the default name from R&R. Does the name matters for anything? Does the name link the band to the SCAN function? How do I change the name of a group band?__3. I_ve tried to link a ParameteRR field with a help of a query to the DB. The problem is: when I run the report it creates the indexes but than it simply closes the window suddenly and the report is gone. When I erase this query the report manages to deliver the scores from the first table. I need the linking from the ParameteRR field to the DB because this is my way to tell R&R which values it should look for in the second table. With the first table I manage to create such a link and this link works. ____Thanks, Dekers