Liveware Publishing Support Forum

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 work____Thanks, Dekers____P.S - I posted this post 3 times already, while I was logged in. I can^t see my posts and that is why I posted a new thread. Am I doing something wrong?

The name that prints for the group band is the name that of the field that you have selected as the group field for that level. The group band line will then print when the value of the group field changes.____So if you have__FIELDA FIELDB__A 1__A 1__A 2__B 2__B 3__B 3____if you group by fieldA, the group will break twice (once after the A^s and once after the B^s but if you group by fieldB, you would get three group breaks for the 1, 2, and 3.____Kathleen__R&R Support__

Hello Kathleen,____One thing was missing in your explanation: that I should have taken the WHICHSCAN field into the _group order_. Another good idea (in my own humble opinion) is to use explicit directions like: _go to database->group order->1) and do this and that______Of course this is only meant to be a constructive advice. Anyway I am thankful for the time you spend in helping me and I am sure I can speak for all of us here! Right boys and girls?____Do you have any idea what could cause such a _silent shutdown_ like I described in my first post in section 3? I tried to convert both types that I compare into a string (using STR() ) but it didn_t work. Do you have any ideas for a workaround? ____Thanks, Dekers __

Hi Kathleen,____I^m hanging in the air here - any ideas why a report simple shuts down without saying one word of warning??__I really need your help on this since I can^t finish my report.____I^ve manged to isolate the problem: everything is working fine until I add the following query: if column X has ^KE*^ OR ^KS*^ in it than print the value in that column. When I add this the reoprt simply shuts down____Thanks, Dekers

An update:____Any query I try to add to the report simply causes a sudden shutdown before any information is presented.____Dekers

Another update:____When I use a query to compare a ParameteRR to a certain column in order to start the report in the right position (I tell the reoprt to use the start value ID-No. xyz in order to get all the descriptions that have this ID-No.) the report simply ignores one table it should also search and delivers only the results for the second scanned table.____Any ideas?__Dekers

And yet another update:____If I use a query from the first table - only the results from this table apear in the report. If I use a query from the second table - only the results from this table apear in my report. If I use both queries at the same time I get no results at all and the reports shuts down without a warning.____Thanks, Dekers

In a multiple scan report, each composite record has a value from only one of the scanned tables. So typically you need to use two query clauses that are joined by an OR condition.____So you would __include all records when SCANA->field is equal to 123 OR where SCANB>field is equal to 123____to have the report show all of the 123 records in SCANA as well as all of the 123 records in SCANB.____Kathleen__R&R Support

Hi Kathleen,__First thanks for your advice _ it did work. Still I don_t understand why R&R simply shuts down without any notice.____Of course I now have a new problem I can_t solve. It looks like this:__I added two new conditions to my query and now again I only get the first table out of two I would like to see.____My Queries look like this:__TABLE01->FIELD01 is equal to ParameteRR01 //give me a limited FIELD01 __or (TABLE02->FIELD02 is equal to ParameteRR02_//give me a limited FIELD02 as well__and TABLE02->FIELD03 is equal to _KE*__//FIELD02 only if FIELD03 is___or TABLE02->FIELD03 is equal to _KS*_)_//or _KS*_____I_ve tried endless versions of this query constellation but I always get only the first table scanned. Any idea what I am doing wrong?____Thanks, Dekers __

Hi Kathleen,____Do you have any idea about my query "problem"? I would like to filter out all the values that are not ^KE*^ OR ^KS*^ out of the second scanned table. Until now I only managed to eliminate whole tables: only the values from one of the tables apears or to eliminate both tables: I get an empty report/the report simply closes the window wihtout a warning.____I^m greatful for any help you could give me__Dekers