signaturensa.blogg.se

Rowwise grandtotal in oracle11g
Rowwise grandtotal in oracle11g











rowwise grandtotal in oracle11g rowwise grandtotal in oracle11g

In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. When talking to potential WebFocus customers, one of the first things I talk positively about (of many) is this Forum, BECAUSE of all of the friendly and knowledgeable help that is offered. You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. I used it again last week becuase it solved another business reporting requirement, that would have taken more code and been less efficient if done another way.Īnd to all the coders who like to show off (and those who don't), keep it coming! I appreciate your efforts. I wish I had learned it back in the Eighties when it was first published in the Focus Sysytems Journals as I would have employed it on many of the coding challenges I faced through the years. It's needed because it solves several complex coding problems that WebFocus cannot perform easily using standard code. The "McGuyver Technique" is not some esoteric classroom coding trick. I can make it work by adding standard McGuyver code but maybe there is something new in 8.0/7.7 having to do with fseq? Talk about complicated code.and it was slow to run.ĭanny, am I wrong in thinking you're missing some code up top? This doesn't work out of the box for me on 7.6.11. I found this out when I received webfocus agent crashes doing too many INCLUDES on the subfoot. Doesn't work well when you need multiple sets of sub-totals for major sort groups. MightyMax, your code works great when you want a single set of sub-totals at the end of the report right before the Grand-Total.













Rowwise grandtotal in oracle11g