Crystal Report using database package - not returning data

[suzyg]

Hi - I have a Crystal Report 8.5 running on a Database package but it is not returning the correct data:
specifically:
v_errorLocation := 'Start propane';
v_tableIndex := 0; v_product := 'C3';
IF p_priceMonth < '1-Apr-2008' THEN
v_index1 := ‘data1’; v_flag1 := 'n'; v_posting1total := 0.0;
v_index2 := 'data2; v_flag2 := 'n'; v_posting2total := 0.0;
v_index3 := 'data3'; v_flag3 := 'n'; v_posting3total := 0.0;
v_index4 := ‘data4’; v_flag4 := 'n'; v_posting4total := 0.0;
v_index5 := 'data5'; v_flag5 := 'n'; v_posting5total := 0.0;
v_index6 := 'data6'; v_flag6 := 'n'; v_posting6total := 0.0;
v_index7 := 'data7'; v_flag7 := 'n'; v_posting7total := 0.0;
v_index8 := null; v_flag8 := null; v_posting8total := 0.0;
ELSE
-- removed Imperial from list after April 1/08
v_index1 := ‘data1’; v_flag1 := 'n'; v_posting1total := 0.0;
v_index2 := 'data2; v_flag2 := 'n'; v_posting2total := 0.0;
v_index3 := 'data3'; v_flag3 := 'n'; v_posting3total := 0.0;
v_index4 := ‘data4’; v_flag4 := 'n'; v_posting4total := 0.0;
v_index5 := 'data5'; v_flag5 := 'n'; v_posting5total := 0.0;
v_index6 := 'data6'; v_flag6 := 'n'; v_posting6total := 0.0;
v_index7 := null; v_flag7 := null; v_posting7total := 0.0;
v_index8 := null; v_flag8 := null; v_posting8total := 0.0;
END IF;
loop

But - in the report - no matter what date I select it only displays the results for the second option. If I run this query against the database I get the correct data.

The report is only running the package - co other logic is built into it.

Not sure why this is happening

Help! Thanks.

 

[CR85user]

place p_priceMonth on the detail line of returned results where it crosses over this date period and show an example of some returned dates.

It may be that the line:

IF p_priceMonth < '1-Apr-2008' THEN

Is not being correctly interpreted.

'J