Search results for query: *

I have a report - Analysis Results - that has 3 groups Report header Page header = Data_Point Norm_Type Test_Op_No gh1 - TEST_OP_NO xxxx xxxxxxx xxxxxxx (these are all Attributes) gh2- DATA_POINT (suppressed) gh3- RESULT_NO = Result_No Outer_Max Outer_Min detail...

Worked perfectly, thanks so much!

oracle CR11 I have multiple sections in Report Header, multiple sections in Page Header and Details. There is currently no grouping. I want to print my Report Header (which may be 1 or more pages) then print the rest of the report BUT I want to suppress one section in the Page Header after...

Excel 2010, I have 5 rows of data on one sheet with the first column = part. On the second sheet I have a list of parts - 101, 102, 103. I need to copy the 5 rows with part = 101, then copy the 5 rows again with part = 102, etc.

it does the same thing, it works until I add the group for GF2. I ap0preciate your help but apparently there is no way to get this to work. Thanks.

Yes, this works if I’ve deleted GF1 & GF2. I think it has something to do with the fact that we can have multiple values of ‘D’ for each OrderNo. This is what I show with OrderNo 123 – it can have only one PartNo and only one P but D can be either 1 or 2. We group on D at GF2. The sum of Qty...

Sorry, I wasn't clear. Yes, I have only one formula as i defined and I sum it for the Grand Total. I then copied this summary to all the footer groups as you suggested. If I 'show' GF5, for example, the sum is correct. If I drill-down to GF5 the sum is zero. It is also zero at the top level...

No, it just puts zero as the sum at every level. Again, when I just SHOW a lower level, the sum formula is correct.

CR 11, Oracle 11 I'm having trouble getting a Qty formula to show properly, including in a drill-down. I've tried various ways - Running Totals & formulas with WhilePrintingRecords/Shared NumberVar and I can get the Qty values correct when I just show each group footer but when I hide these and...

Yes, that post worked fine for my needs. Thanks to everyone!

I appreciate all your input but I should have stated that I group data on this string so I don't think I can use the "WhilePrintingRecords".

That's very helpful, Pete. Just one thing, most of the time we only have 3 components but occaisionally 4. I tried adding a 4ths section but I get the error "A sbuscript must be between 1 and the size of the array". Since this is rare, I'd live with these exceptions showing up in whatever...

But I can't control if the data is numbers or alpha so I don't know how to correctly add a zero when needed. I also can't control how many characters are in each section so I wouldn't know how many leading zeros to add.

CR11.5 and Oralce I have a field with strings, generally like 105.2.12, 105.2.2, 105.D.5, 105.F1.ABC I'd like these to sort nicely, in particular, 105.2.2 should come before 105.2.12 but since it is a string it does not. Please help.

I tried using Selection..Group but this didn't work. I realize now I had an error in that formula. Once I fixed, it worked great. Thanks!

Well, yes, I tried this but it doesn't suppress the details. I assumed it had something to do with when it computes the total of group1 vs when it reads the details.

exmaple: ABC -12 ABC 10 ABC -2 Group2 BCD -4 BCD 6 BCD 2 Group2 0 Group1 all lines should be suppressed

CRII and Oracle I have 2 groups. I sum at group2 & group1. I want to suppress all the details if group1 sum = 0. I've tried both running total and numbervar without success. Too simple?

Never mind, I read a post from LBASS for a different user and as usual, LBASS was extremely helpful. I changed my subreport and it works well.

I figured out my problem with the incosistent column data but I'm only getting the last part no from the main report into the subreport instead of all part nos for the project. I don't normally need to put the subreport in the top group (Project) but in this case I need the subreport to print...