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 Rhinorhino 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: CrystalUser1
  • Order by date
  1. CrystalUser1

    Cross Tab report - suppress problem

    Thank you Gary Parker for you advice. It worked very well. thanks
  2. CrystalUser1

    cross tab problem

    Hi, I have a cross tab report like the below: dept 2001 2002 2003 finance 100 200 300 HR 99 104 250 Recruit 0 0 0 I want to take out the entire Recrit Data row dynamically because it...
  3. CrystalUser1

    Cross Tab report - suppress problem

    Hi, I have a cross tab report like the below: dept 2001 2002 2003 finance 100 200 300 HR 99 104 250 Recruit 0 0 0 I want to supress the Rectuit Det because it has no data. that is...
  4. CrystalUser1

    Formula Problem

    Thank you synapsvampire, i found it in record sort order. thank you very much.
  5. CrystalUser1

    Formula Problem

    It was not there. thanks
  6. CrystalUser1

    Formula Problem

    Thank you durango, i tried there. it want there. thanks
  7. CrystalUser1

    Formula Problem

    Hi, I am working on a report which has a formula in the field explorer. But when i try to find out that formula in the report,i am not able to find that. and also it is not allowing me to delete that formual. can anybody please advice me how to find that formual in the report where it is...
  8. CrystalUser1

    How to find parameter in the report

    thank you turkber, i looked at those 3 places, in record selection formula, group selection formula, and all formulas. nowhere it was used. thanks cs
  9. CrystalUser1

    How to find parameter in the report

    hi, i am working on the report that somebody was created. there is a parameter in the report ?Dept that is being used in the report. the report has atleast two sub reports. I am trying to find out where the parameter was used in the report? I couldnt. how to find that? I tried finding...
  10. CrystalUser1

    Group Tree Problem

    I suppressed the groups, still group trees are not appeared. Whatever i do group tree is not appeared. I have a formual for the group 1. thanks
  11. CrystalUser1

    Group Tree Problem

    I am using crystal reports version 8.5. I created a report with 3 groups. Group1 Group 2 and Group3. Group3 is suprressed. Group 1 and Group2 headers are displayed on each page. I am not able to get the group tree on the left side to explore the groups. Can anybody suggest how to do it? I...
  12. CrystalUser1

    Informatica basic question

    hi rasanders, thank you for your reply. since its a varchar2 field, i think default value is null. we are using oralce 9i. can you please explain the second step to set up an expression/transformation in two or three simple steps. and also how to run the mappings(or create session) after...
  13. CrystalUser1

    Informatica basic question

    Hi, I am new to informatica and using version 7.1.2. I added a source and also a target file. and manually mapped the fields. I have one additional field in the target table. I would like to assign a default value for that fields. Can anybody help me how to do that? thanks
  14. CrystalUser1

    creating database view

    hi mufasa, I am not getting the correct results when i use the above. but i did in a different way, i am getting the correct results. see the below query: SELECT A.CRITERIA_NAME,count(*), A.DEPT , A.DIVISION , A.SECTION , A.SECTION_NAME FROM CRITERIA A,DEPT_TABLE...
  15. CrystalUser1

    creating database view

    hi mufasa, do you need any more clarifications? please help me. thanks in advance.
  16. CrystalUser1

    creating database view

    hi, 1. the count(*) should count the each criteria_name 2. i want grouped rows as well as details rows. for example, criteria abc has total count of 100. it should display like this: criteria count other fields... abc 100 or atleast the best possible way. 3. i have different...
  17. CrystalUser1

    creating database view

    Thank you very much mufasa. I am trying to create the following view based on your advice. I am getting the following error: Y.CNT IS NOT A GROUP FUNCTION. CREATE OR REPLACE VIEW TEST_VIEW AS SELECT A.CRITERIA_NAME,Y.CNT, A.DEPT , A.DIVISION , A.SECTION , A.SECTION_NAME...
  18. CrystalUser1

    creating database view

    Hi Mufasa, thank you for your reply. i tried the following query. select criteria_name,count,dept,division,section,source_name from criteria group by criteria_name,dept,division,section,source_name. the results are like this: criteria_name count dept division section source_name abc...
  19. CrystalUser1

    creating database view

    Hi Mufasa, thank you for your reply. i tried the following query. select criteria_name,count,dept,division,section,source_name from criteria group by criteria_name,dept,division,section,source_name. the results are like this: criteria_name count dept division section source_name abc...
  20. CrystalUser1

    creating database view

    Hi, I have to create a database view in oracle 9i. The view should show the total counts. The data should display like this: criteria_name count abc 100 xyz 209 aaa 100 the count is based on the criteria_name field. along with those above...

Part and Inventory Search

Back
Top