Recent content by qwertyu1

Hello all, I am using crystal xi and oracle 9. I got a sql like following : select r.PRIM_TIMBER_TYPE ptt, tt.TIMBER_TEXT ptx, count(r.RECON_ID), sum(r.ACRES_AMT) Acres, TO_CHAR(sum(r.ACRES_AMT)/TO_NUMBER(:P53_RECON_ACRES,'999999999')*100,'990.99') P...

i did the same thing as you said above, the reslut is like this: 03/03/1995 12:00:00AM i got this in the place of missing year field. but i need for year 1994, how can i make changes.

sorry, Database is oracle9 for all sql's.

Actually my sql is like this select r.PRIM_TIMBER_TYPE ptt, tt.TIMBER_TEXT ptx, count(r.RECON_ID), sum(r.ACRES_AMT) Acres, TO_CHAR(sum(r.ACRES_AMT)/TO_NUMBER(:P53_RECON_ACRES,'999999999')*100,'990.99') P, TO_CHAR(sum(r.ACRES_AMT)/TO_NUMBER(:P53_FORESTED_ACRES,'999999999')*100,'990.99') P2...

Hello all I am using crystal xi and oracle 9. I have a sql like this: select sum(r.ACRES_AMT) FROM fr_recon r, fr_timber_type tt where r.PRIM_TIMBER_TYPE = tt.TIMBER_TYPE and tt.FOREST_FLAG = 'F' and nvl(instr(r.STAND_PREFIX_CODE,'R'),0) = 0 and nvl(instr(r.STAND_PREFIX_CODE,'Y'),0) = 0 and...

sorry, here is the formula YEAR({FR_TIMBER_SALE_GENERAL.SALE_ESTABLISHED_DATE})

i tried using running total like below: i placed FR_TIMBER_SALE_RECON"."PROPOSED_ACRES_AMT", field as summary , at evalute place using formula , i placed year field and at reset i checked never option. i placed this in report footer its not giveing any value. do i need to do any thing...

Thanks, I tried as you said but the result is same.

Hello all I am using crystal xi and oracle 9. please see the below sql which is from show sql query. SELECT DISTINCT "FR_TIMBER_SALE_GENERAL"."FR_PROP_CODE", "FR_TIMBER_SALE_GENERAL"."SALE_ESTABLISHED_DATE", "FR_TIMBER_SALE_RECON"."PROPOSED_ACRES_AMT", "FR_PROPERTY_XREF"."FR_PROP_NAME"...

thanks

thanks. can u tell me where should i place subreport in main report. and do need to link the subreport to main report i got a one parameter field.do i use this field to link subreport to main report,and where should i place subreport formula in section expert.

I did the same thing as you said above. but am not getting the result as i want. in data base view the past, present and future acres amt fields are not detailed level those are group levl . is that the reason am not getting the result.

hello all I am using crystal xi and oracle9. my question is? I have a report on that i need to see data like below . i have a colums like: timber base past present future text year acres acres acres forest: ab 1977...

thanks

Hello All, I am using cr xi and oracle 9. I have two data base fields in group header.i need to see chart and data just side by side. i placed chart in group header section,but iam getting chart for each group by that iam getting 30 pages. is it possible in group header section to see...