sorry, i'm a little confused. I've written some custom crystal reports and uploaded into clarity but never edited an OOTB report so i'm still really newb. I am working on the project storyboard report on version 13.3.0.286.02.19 of clarity in crystal reports 2008 and have saved it locally to my computer. When i open it in crystal reports and go to command the query looks different from yours. I pasted it below so you can see it. I just want to be able to edit this query but when i go to the command editor in crystal and make changes i get the prompt for parameters but it never seems to work when i enter it in. I used the parameters in the picture i posted above but I don't see any values in the browser url when i run the report. Thanks for taking the time to help out though I really appreciate it.
SELECT i.id investment_key,
i.code investment_id,
i.name investment_name,
CASE WHEN u.last_name IS NULL THEN NULL else u.last_name || ', ' || u.first_name END investment_manager,
l1.name project_type,
l4.name stage_type,
sr1.cop_report_date current_report_date,
l3.name project_status,
l2.name progress,
i.schedule_start start_date,
b.start_date baseline_start_date,
cop_calc_finish_fct(i.schedule_finish) finish_date,
cop_calc_finish_fct(b.finish_date) baseline_finish_date,
CASE NVL(sr1.cop_overall_status_color_nls,'X')
WHEN 'Green' THEN 1
WHEN 'Yellow' THEN 2
WHEN 'Red' THEN 3
ELSE 0 END c_overall_status,
NVL(sr1.cop_schedule_status,0)/10 c_schedule_status,
NVL(sr1.cop_scope_status,0)/10 c_scope_status,
NVL(sr1.cop_cost_eft_status,0)/10 c_cost_effort_status,
CASE NVL(sr2.cop_overall_status_color_nls,'X')
WHEN 'Green' THEN 1
WHEN 'Yellow' THEN 2
WHEN 'Red' THEN 3
ELSE 0 END p_overall_status,
NVL(sr2.cop_schedule_status,0)/10 p_schedule_status,
NVL(sr2.cop_scope_status,0)/10 p_scope_status,
NVL(sr2.cop_cost_eft_status,0)/10 p_cost_effort_status,
pv.obj_objective description,
sr1.cop_report_update status_report_update,
NVL(pv.baseline_usage,0) baseline_hours,
NVL(pv.actuals,0) actual_hours,
NVL(pv.etc,0) etc_hours,
NVL((SELECT SUM(s.slice)
FROM prTeam t
INNER JOIN srm_resources r ON t.prResourceID = r.id
INNER JOIN prj_blb_slices s ON t.prID = s.prj_object_id
AND s.slice_request_id = 10
AND s.slice_date BETWEEN prj_max_actthru_fct(t.prProjectID, t.prResourceID)
AND LAST_DAY(prj_max_actthru_fct(t.prProjectID, t.prResourceID))
WHERE t.prProjectID = i.id
AND t.prIsOpen = 1
AND r.resource_type = 0) +
(SELECT SUM(s.slice)
FROM prTeam t
INNER JOIN srm_resources r ON t.prResourceID = r.id
INNER JOIN prj_blb_slices s ON t.prID = s.prj_object_id
AND s.slice_request_id = 6
AND s.slice_date > NVL(LAST_DAY(prj_max_actthru_fct(t.prProjectID, t.prResourceID)),TO_DATE('01/01/1900','MM/DD/YYYY'))
WHERE t.prProjectID = i.id
AND t.prIsOpen = 1
AND r.resource_type = 0),0) remaining_alloc,
sr1.cop_key_accomplish key_accomplishments,
sr1.cop_upcoming_act upcoming_activities,
NVL(pv.ev_acwp,0) actual_cost,
NVL(pv.ev_etc,0) etc_cost,
NVL(pv.planned_ben_total,0) planned_benefit,
NVL(pv.planned_cst_total,0) planned_cost,
cop_calc_finish_fct(pv.planned_breakeven) planned_breakeven,
NVL(pv.planned_roi,0) planned_roi,
NVL(pv.budget_rev_total,0) budget_benefit,
NVL(pv.budget_cst_total,0) budget_cost,
cop_calc_finish_fct(pv.budget_breakeven) budget_breakeven,
NVL(pv.budget_roi,0) budget_roi
FROM inv_investments i
INNER JOIN inv_projects p ON i.id = p.prID
INNER JOIN odf_project_v2 pv ON i.id = pv.odf_pk
INNER JOIN cop_inv_days_late_v dl ON i.id = dl.investment_id
INNER JOIN cmn_sec_users u ON i.manager_id = u.id
LEFT OUTER JOIN cop_prj_statusrpt_latest_v r1 ON i.id = r1.investment_id AND
r1.report_order = 1
LEFT OUTER JOIN odf_cop_prj_statusrpt_v sr1 ON r1.report_id = sr1.odf_pk AND
sr1.odf_user_id = {?param_user_id}
LEFT OUTER JOIN cop_prj_statusrpt_latest_v r2 ON i.id = r2.investment_id AND
r2.report_order = 2
LEFT OUTER JOIN odf_cop_prj_statusrpt_v sr2 ON r2.report_id = sr2.odf_pk AND
sr2.odf_user_id = {?param_user_id}
LEFT OUTER JOIN prj_baseline_details b ON i.id = b.object_id AND
b.object_type = 'PROJECT' AND
b.is_current = 1
LEFT OUTER JOIN cop_inv_rim_stoplights_v sl ON i.id = sl.investment_id
LEFT OUTER JOIN cmn_lookups_v l1 ON pv.obj_request_type = l1.lookup_code AND
l1.lookup_type = 'OBJ_IDEA_PROJECT_TYPE' AND
l1.language_code = '{?param_language}'
LEFT OUTER JOIN cmn_lookups_v l2 ON i.progress = l2.lookup_enum AND
l2.lookup_type = 'INVESTMENT_OBJ_PROGRESS' AND
l2.language_code = '{?param_language}'
LEFT OUTER JOIN cmn_lookups_v l3 ON i.status = l3.lookup_enum AND
l3.lookup_type = 'INVESTMENT_OBJ_STATUS' AND
l3.language_code = '{?param_language}'
LEFT OUTER JOIN cmn_lookups_v l4 ON i.stage_code = l4.lookup_code AND
l4.lookup_type = 'INV_STAGE_TYPE' AND
l4.language_code = '{?param_language}'
WHERE (p.is_program = 0)
AND (p.is_template = 0)
AND ('{?param_status}' = 'all'
OR ('{?param_status}' = 'approved' AND i.status IN (1,5,8))
OR ('{?param_status}' = 'unapproved' AND i.status NOT IN (1,5,8)))
AND (0 IN {?param_investment} OR i.id IN {?param_investment})
AND (0 IN {?param_i_manager} OR i.manager_id IN {?param_i_manager})
AND (i.is_active = CASE WHEN {?param_i_active} = 0 THEN 1 ELSE i.is_active END)
AND ({?param_i_obs} = 0 OR
i.id IN (SELECT obsa.record_id
FROM prj_obs_associations obsa, prj_obs_units_flat obsf
WHERE obsa.unit_id = obsf.unit_id
AND (obsa.table_name LIKE 'INV%' OR obsa.table_name = 'SRM_PROJECTS')
AND obsf.branch_unit_id = {?param_i_obs}))
AND ((EXISTS (SELECT user_id
FROM cmn_sec_assgnd_obj_perm_r_v
WHERE object_type = 'RECORD'
AND object_code = 'PRJ_PROJECT'
AND permission_code = 'ProjectViewManagement'
AND component_code = 'PRJ'
AND user_id = {?param_user_id}))
OR
(EXISTS (SELECT object_instance_id
FROM cmn_sec_assgnd_obj_perm_v
WHERE object_instance_id = i.id
AND object_type = 'RECORD'
AND object_code = 'PRJ_PROJECT'
AND permission_code = 'ProjectViewManagement'
AND component_code = 'PRJ'
AND user_id = {?param_user_id})))
ORDER BY UPPER(i.name)