Cross-tab reports

[Sandi_(Guest)]

How do you handle cross-tab reports in R&R for xBase 8.1? I have no idea how to do that. Do I need to prepare data in that way that R&R will print everything?____Thanks in advance__Sandi

[kfleming]

Go to__http://www.livewarepub.com/technote.htm____and look at the article Cross Tabulating Totals.______Kathleen__R&R Support

[Sandi_(Guest)]

But what to do when I don^t know which groups to put in headings?__My application doesn^t work what users put in their databases.____Regards,__Sandi

[Mark_LaBarre_(Guest)]

Typically requests for crosstabbed data will include the groupings as the users want to see them, as part of the design specs. It sounds as if, in addition to the expected values, your users may be able to enter values that are outside the preset values/groups for your columns. Usually this is bad system design, but of course, the report specialist gets to deal with the downside since you have to account for all entries and the totals, etc., have to match up.____One way to deal with "rogue" values is to assign them to an "Other" column. If that sounds like it might work in this instance, then you can create a dummy calculated variable using a CASE statement and key your columns on that.____For example let^s say you have 3 valid values A, B and C in MYTABLE->MYFIELD. You also want an "Other" column to catch your nonconforming values. You could make a calc variable, say COL_GROUP, to analyze your MYTABLE->MYFIELD:____CASE(MYFIELD,^A^,1,^B^,2,^C^,3,4)____Which gives anything but A,B,C a value of 4. NOW YOU CAN USE THE NUMERIC VALUES IN COL_GROUP to qualify your Conditional Total variables that give you your cell values, INSTEAD OF the actual MYFIELD values themselves. For example where you would have said in the Total Field condition:____MYFIELD=^A^____Now you will say instead:____COL_GROUP=1 ____And for your "OTHER" column if you use COL_GROUP=4 you will aggregate all the "OTHERS" in the proper cells. Then they can contribute their share of the statistics without contaminating the valid data in the other columns.____Hope this helps.