Search results for query: *

Thank-you! That does the trick. Not one I've had to do before. I appreciate your patience and assistance. Merle

@MaxCapacity = {Command.CAPACITY} * 0.95 @Rooms = {@MaxCapacity} / 15 @TotalArea = {@Rooms} * 60 At Detail level with CAPACITY = 1: @MaxCapacity = 0.95 @Rooms = 0.06 @TotalArea = 3.80 (CAPACITY is always 1 or greater in this report) If I change: @TotalArea = Round ({@Rooms}) * 60 Then...

No percentage signs in any formula. Just for kicks, I started afresh, created a new report from blank, created the same formulas with the same result. I won't go into everything else I've tried that didn't make a difference, but I did try modifying @Rooms: @Rooms = @MaxCapacity / 0.15...

Actual formulas as created (though sans braces, sorry. should've copy/pasted). Each is then placed in the Details section and a Summary for each one inserted in Group Footer 2. There is a Group 1, as well, but it's just a further grouping by Campus. I'll eventually want Summaries there as...

Crystal XI. Have these fields/formulas to calculate the number of rooms required for a building with a particular capacity: CAPACITY @MaxCapacity = CAPACITY * 0.95 @Rooms = @MaxCapacity / 15 @TotalArea = @Rooms * 60 And Group sum totals for each placed in the Group Footer. ...which all seems...

Duh. Never mind. I put the detail fields in the Item# group header and suppressed the detail. Thanks for your help! Merle

Thanks, both of you! I went with lbass' solution, realizing I had actually tried grouping on Item# at some point, but couldn't come up with the right Group formula. It works great except for when there are two transactions on the same date, whereupon it displays both records for that date...

I'm having a hard time figuring this out, so any help would be appreciated. I have these tables: Inventory - Item#, description, category Inventory_by_location - Item#, DATE (inventoried), Site, Bin, Qty History - Item#, TranDate, qty change on that date All tables are linked by the Item#...

LB, No, not yet, haven't had a chance. (I've been pulled several other directions since my initial post...) I thought it a good one, though. I've used that technique before, but it hadn't occurred to me to use it here for some reason. I appreciate you bringing it up. Thanks!

Actually, it looks like I mislead you in a previous posting by not separating the data into the two tables. You have it almost right, but there is no orgcode in N0 as it resides solely in G0. NO TABLE ------------------------ empid repto group name 1 top John 2 1...

The whole thing strikes me as odd..." -- I agree! "In short I think you want to find the people that report to (say) empId 3. From these people you wanna take the orgCode. This orgCode you will then want to use to find anyone under them." -- Exactly! Only because it's the only way I can...

CoSpringsGuy, It's the "should only" that's getting me. You made me think to create the parameter so it shows the person's name but returns the reportsto instead of the empid. I thought I was on a roll, but it only nets me the people who report directly to the selected person. So, I thought...

If I don't filter the report, I get the correct orgcode for each employee record. So, I think the linking is working correctly. empid repto group orgcode 1 top 01 2 1 sales 0101 3 2 mktg 010101 4 3 cad 01010101 5 2...

Using CR XI Oracle 10g Two tables linked on group: N0 (employee data) empid group reportsto (empid of the person this record reports to) G0 (org data) group orgcode The orgcode keeps the group heirarchy and is formatted as 01010100000000 where each two characters is a level in the...