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...

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.

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...

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.

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?

Oracle and CR 11 The main report has group 1 = Project, group 2 = Part No Records show on group 2 footer as Part No, Units Complete, etc. The subreport is in group1 footer linked by Project and Part No The subreport has sub-group 1 = Part No, sub-group 2 = Dept Records show on sub-group 2 footer...

I have records for each employee and their positions with a start_date and stop_date. emp start_date stop_date 123 7/1/2010 9/13/2010 123 9/14/2010 7/14/2012 123 7/16/2012 1/1/2049 256 4/1/2009 1/1/2099 753 12/1/2011 6/8/2012 753 6/9/2012 6/20/2012 I need to find if there are any gaps. I don't...

CR11 and Oracle Main report has 2 groups 1 = part_no 2 = dept Subreport has no groups, linked by part_no and dept., sums std_hrs Subreport formula in Subreport Report Footer called stdhrs: WhilePrintingRecords; Shared NumberVar SH := Sum ({PRS.STD_HRS}); Subreport formula in Subreport Report...

Oracle 10g and SQLPlus I have customer orders with multiple lines of Part A – a top level assembly. The user enters the customer order # and I’m using CONNECT_BY_PRIOR to pull a simple indented bill of material for Part A and finding the total qty needed of each part based on the sales qty...

Oracle and CR11.5 I have Group 2=Tran_ID & Group 1=Part. I take the maximum quantity by Trans_ID in GF2. I want to sum these by Part. I have 3 formulas: SumPart in GF2 WhilePrintingRecords; numbervar MP := MP + Maximum ({PROJ \\.QUANTITY}, {PROJ \\.TRANS_ID}); DisplayPart in GF1...

Oracle and CR 11.5 I have 2 groups, #1 = Part No, #2 = Transaction ID There are multiple lines for each transaction _id. I have a formula that sums qty at group #2 footer based on type of transaction = {@qty} I have a shared variable that sums @qty = Q WhilePrintingRecrods; NumberVar Q := Q +...

CR 11 and Oracle I have Milestone, Part, Qty, Date Due and I group by Milestone and then Part. In a subreport I have Part, Qty Received, Receipt Date and I link Part to Part and Date Due <=Receipt Date. I want to count Qty Received and if this is greater than Qty it needs to go into the next...

CR11 & Oracle I have Page Header/Footer a & b, 1 group and Report Header/Footer a, b & c. In Report Footer c I have {Notes} and this section has New Page Before and Suppress Blank Section. I only want the Notes to print on the last page, if they exist. These Notes are for internal use only...

Oracle and CR11 I have 1 group on {PRODUCT} and 10 formulas If account = x then STOCK, If account = y then WIP, etc. The formulas are summed by group. I also have a formula TOTAL which takes the SUM{STOCK}+SUM{WIP}+, etc. I want to suppress the GF1 where {@TOTAL} = 0 This doesn't work - I still...

Oracle and CR11 I have a simple cross-tab but no experience with them. I have 3 fields for the row - period, project, part I just want all fields to show on all rows so when it exports to Excel the user can sort easily. So instead of: 3 ABC 123 TOTAL 3 DEF 456 789 TOTAL it...

Oracle and CR11 I have a parameter = {?Contract} that is set to allow multiple entries The user could enter * for All or 20203 for only one Contract. This all works fine. The user could enter a string that may look like 20203;204;2001 (etc.) and I want Crystal to read this as multiple entries...

CR11 & Oracle I have a number field, GL.yearmonth where the data looks like: 201101 201102, etc. I have a paremter field - (?EndPeriod) where the user enters the ending yearmonth for the report. I need to truncate this to just the first 4 digits and then compare it to a number field, GL.year...

Oracle and Crystal XI I have a ship_table with field = DELIVERY. DELIVERY may include multiple delivery #s separated by commas. i.e. 6579, 6548 On the report, I have a subreport that pulls the TRACKING_NUMBER from fedex_table. There may be multiple tracking numbers per delivery #. I link...

Crystal 11 and Oracle I have a cross-tab in my report header with column = Labor, rows = Part, Order#, Qty Complete and Sum = sum of Costs. This works fine and Costs are totaled correctly. I also sum Qty Complete per Part. Now I want to use these sums to determine avg cost = sum of Costs/Qty...