Recent content by CrystalUser1

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

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

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

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

It was not there. thanks

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

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

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

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

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

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

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

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

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

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