Is this possible??

[Michael_Hoffmann_(Guest)]

Hi Fred,____try it like this. ____Let^s say you work on the file "DATA.BDF" that has an index expression "KEY" in the index file "DATA.NTX". The key values must be unique.______Step 1: Double up all records.____Create two scan relations from DATA, both using KEY.__The first relation connects to DATA.DBF and DATA.NTX and the alias name should be DATA1.__The second relation connects TO DATA.DBF and DATA.NTX again and the alias name should be DATA2.__Since KEY bears a unique value every scan relation will find exactly one record.____You can check if it worked by putting some fields from DATA1 on one record line that is only printed when scanning DATA1. Put the same fields from DATA2 on one record line that is printed when scanning area 2. Run the report: Every record will be seen twice.______Step 2: Split up the records into two groups.____Create a calculated field GRP = IIF(SCANNING(data1),"1","2"). Make this field your first sort and group field. ____You can check if it worked by running the report and making sure that all records will be printed twice. But this time you will see 2 sequences of all records.______Step 3: Finalize the design.____Now you add two group header lines, one printed when scanning DATA1 and one printed when scanning DATA2. Now place your COL1-5 column headers on the first one and you COL6-10 headers on the second one. Remove all unwanted fields from the record lines (we needed them for debugging only) and put your fields COL1...COL5 on the first record line. Put your fields COL6..COL10 on the second record line. ______Step 4: Have a beer.____Now run the report. It will look as you want it to look. Do some little layout adjustments (extra space lines, ...). Go to the fridge, get a bottle of beer and enjoy.______Step 5: Send me a beer, too.____Kind regards,__ __Michael.____mhoffmann@compar.cc____

[kfleming]

Hi, I did this and it worked when I had 2 set of columns (1-5 and 6-10). I added a third set and it does not work. The group header and footer for my first set repeats for every body line, but the second and third sets of columns are fine. I modified all the expressions for adding the third scan relation. Can^t figure out why it does not work.

[FEmmerich]

If you could fax a copy of your printed report specs to me at:__978-779-6717____I could give you a better opinion of what is going wrong.______Kathleen__R&R Support

[FEmmerich]

On the way

[kfleming]

Thanks for the fax. But I also need the specs.__Use File Print and then in the Print What box at the lower right change from default of Report to Report Specifications.__And then send that printout to me.____Thanks.____Kathleen__R&R Support

[FEmmerich]

Kathleen, Did you get the report spec fax I sent yesterday?____Thanks,

[kfleming]

It is probably sitting at the office however I am working remotely today.____Is your SCAN() calc field the first level of grouping in your report? If not can you try making it group level 1 and see if that helps.____Kathleen__R&R Support

[kfleming]

I just looked at the report spec.__I think that my guess about the grouping was correct.__Remove your Group1/Group2 fields and make SCAN the first group level.__On your layout move the current Group3 band lines to Group1 band lines and your report should then work.____Kathleen__R&R Support

[FEmmerich]

This would really change my report, my first level group is basically sorting the pages-each page represents a different entity and my second level sorts by the years so the rows come out in the correct order. I suppose I could change this up, but at some point I need to total the years for each set of columns like this:____ Year1__ 2__ ..__ Year 15____ Subtotal__ Remainder__Total future ____The example in the book shows SCAN as being at level 2, mine is at level 3, do you think moving it to level 2 would work, that way I could remove my current level 1 and maintain my level 2 as a new level 1? (needed for subtotals)____Thanks,

[kfleming]

You do not need to change the 3 sort fields.__It is just the group field that changes.____Kathleen__R&R Support