Search results for query: *

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

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

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

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

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

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

hello all, I am using crystal xi and oracle 9. I have a data base fields like exam_year and acres_amt. i need last 5 years total acres_amt , 5-10 years,10-15,15-20 20-30 and >30 yrs like that. at grand total. i have one group field like prop_code. help me. thanks.

hello all, iam using crystal xi and oracle 9. i have a one database date field. on that i have to create parameters like start_date and end_date. (i.e user has to enter these two dates.) how can i create paramter fields on this field. help requested.

Hello all, I am using ceystal reports xi and oracle 9i. iam using table like :fr_planning_schedule i have database fields like: schedule_year, schedule_acres,schedule_timber. parameter field:schedule_prop. i would like to see report as below. schedule_year : schedule_acres...

can anybody tell me where should cross tab work? can we place in group header,page header,like.......

hello , iam using crystal xi and oracle 9i. my question is? i have a fields in page header, group header and grand totals in report footer.i have a chart in report footer. i need to show chart in second page. i tried but pageheader fields and grandtotals are also coming to second page, i...

hi all, iam using crystal xi and oracle 9i. i have database tables like fr_recon and fr_stand_prefix. i have databsae fields like : fr_recon.acres_amt(number5) fr_recon.stand_prefix(varchar4) and fr_stand_prefix.stand_prefix(varchar1)...

hello all, iam new to crystal reports.iam using crystal xi and oracle 9i. i got table name like : fr_recon and database field name :fr_recon.stand_exam_year(varchar4) my question is: i have to compare total recon made by <5yrs,5-10 yrs,10-15 yrs,15-20 yrs,20-30 yrs,>30 yrs based on current...