Is this possible??

[FRED_EMMERICH_(Guest)]

I have a report that prints 15 years of data down the page. I have 10 columns of this data. Only 5 can fit on a page left to right. Can I somehow place the second 5 colums beneath the first 5 columns on the same page?____year col1 col2 col3 col4 col5__1__2__...__15______year col6 col7 col8 col9 col10__1__2__...__15

[kfleming]

It is possible but not directly possible.____You could create a set of conditional totals or could set a second scan relation to year file as alternatives.____Kathleen__R&R Support

[FRED_EMMERICH_(Guest)]

I am not sure how setting conditional totals would work, I need to create a total for the 15 years below each set of columns (forgot to mention that, sorry). The second scanning relation sounds interesting, but I am not exactly sure how to do it. Will it let me link more than once to the same table? I assume I could with a different alias. I am wondering if my 15 year total will screw this up.____Crystal uses what they call sub reports, (I am not a Crystal user) to do this type, I have seen it work where each section (in my case each set of 5 columns) would be a separate sub report. It calls a report from within a report. Is R&R going this way at all?____Thanks

[kfleming]

Adding sub reports is a feature that many used have asked us for.__How we might make that concept happen in R&R is still to be determined.____You can indeed just change an alias name in order to use the same table twice in a report.____Kathleen__R&R Support

[FRED_EMMERICH_(Guest)]

I have my records showing up okay in my report by using SCAN TABLE functionality as outlined in the manual. I don^t understand why I can^t do this for my headers for my columns-setting certain ones to print while scanning a particular table. The book says to use a calculated field whose value changes with the table being scanned. The example does not go into more detail. What should this calculated field expression be and how do I set up the conditional printing of the headers?____Thanks!

[kfleming]

A calculated field with the expression SCAN(TABLEA) should work for grouping.____You then create two SCAN(TABLEA) group headers__year col1 col2 col3 col4 col5__year col6 col7 col8 col9 col10____and then set a line scan condition so that the first line prints for TABLEA and the second for TABLEB.____Kathleen__R&R Support__

[FRED_EMMERICH_(Guest)]

Do you mean SCANNING(TABLEA) when you say SCAN(TABLEA)? I actually have expanded to three separate sets of columns. The last 2 sets of columns I have working fine but for some reason the header on the first set repeats after every detail record. The manual says on page 348 if I have more the 2 relational scans set up, I need to combine the SCANNING function with the IIF function.____Thanks

[FRED_EMMERICH_(Guest)]

Kathleen, I have set up my 3 relations and am trying to get the to print using both methods described in the manual. The first, I have 3 calculated logical fields, set to true when I am scanning each of my 3 related tables. I then set my group headers to print based on those calculated fields. I then tried it using a single calculated field with a nested IIF where I set the value to 1,2,3 depending on which file was being scanned, I then grouped on this calculated field which I called SCAN. In both cases, my second and third set of headers printer correctly before my body lines, but my first set printed along with EVERY body line. Is this a known problem? I have double checked everything and I can^t figure out why these headers don^t print just once. All my 3 sets of headers titles are in the same group header section.____Thanks,

[kfleming]

Place your calculated group field on the layout and see what its value is.____I am reasonably confident that we can find the cause of the problem and get this report to work.____Kathleen__R&R Support

[FEmmerich]

I put the calculated field on the report (several places) and it shows correctly-the value based on the table I am scanning. I cheated and got the first set of headers to work by placing them in the page header-which coincidentally worked. However, I have the exact same problem with the footers-the first set (associated with scanning the first table) keep repeating with every body line. I can^t put these in a page footer since they are in the first set of columns on my page. ____When I was constructing my report, everything worked fine when I only had 2 scans going, when I added the 3rd, thats when the trouble started.____What to do?____Thanks,