Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: qwertyu1
  • Content: Threads
  • Order by date
  1. qwertyu1

    about sql

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

    about formula

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

    about missing field

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

    about report

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

    about chart

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

    about sql

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

    summury fields

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

    date ranges

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

    date ranges

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

    about cross tab

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

    display chart

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

    about summery field

    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)...
  13. qwertyu1

    about date ranges

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

Part and Inventory Search

Back
Top