Page 1 of 1

Values from 2 tables in one column

Posted: Tue Feb 01, 2005 11:37 am
by 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__

=> Values from 2 tables in one column

Posted: Wed Feb 09, 2005 2:05 pm
by 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

=> Values from 2 tables in one column

Posted: Thu Feb 10, 2005 11:56 am
by 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__

=> take two

Posted: Thu Feb 10, 2005 11:58 am
by 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