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: *

  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 missing field

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

    about formula

    sorry, Database is oracle9 for all sql's.
  4. qwertyu1

    about formula

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

    about missing field

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

    about missing field

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

    about missing field

    Thanks, I tried as you said but the result is same.
  9. 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"...
  10. qwertyu1

    about report

    thanks
  11. qwertyu1

    about report

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

    about report

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

    about chart

    thanks
  15. 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...
  16. qwertyu1

    about sql

    hello all, I tried subreport and i placed in groupheader, its giveing acres amt for that perticular group. i would like to c my report like below: ttype tname recin_id acres %acres %acres A aspen 124 20000 20 10 BH redwine 55...
  17. qwertyu1

    about sql

    where should i place subreports? do i need to link subreports to mainreport?
  18. 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...
  19. qwertyu1

    summury fields

    can u tell me what formula should i use?
  20. 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.

Part and Inventory Search

Back
Top