Search results for query: *

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.

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

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

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

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

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