Search results for query: *

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

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

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

Hi, I am using Crystal reports 9.0. There is a field in the database which is string with all uppercase words like "THIS IS A TEST PARAGRAPH". i would like to display this in the report like "This is a test Paragraph". Only first letter should be capitalized. Is there any formula in...

Hi, We are using crystal reports 8.5 and oracle 10g. Created reports using ODBC. We are calling the reports from the web environment and the asp file invokes the report. Recently i created a report which has a sub report. How to pass the user id and password credentials to the sub report...

Hi, I installed Crystal Enterprise on my machine. version 9. I Published one report using crystal publishing wizard. But how to look that report in CE environment. When i click on "Crystal Launch Pad' I am getting the error "Page cannot be found". Can anybody help me how to view the report...

Hi, I am using oracle 9i. I have written a database view using UNION ALL to get the required data. I am getting the same data using OR condition also. Which is good in performance? I tested both, OR condition view is taking more time than UNION ALL View. Can anybody explain which is good...

In our application we are using window.navigate(url) one of our web forms. Its working for most of our clients, but we got a compalint from one user saying that, she is getting javascript error on that page. "Object not found" and its pointing to windoiw.navigate line, when she click submit...

I have an application(C#), we are doing like this try { a. Get the data b. Get the Files c. Open Oracle connection d. For each process try { i. Create all the SQL statements try { ii. In one transaction, executing multiple oracle statements. } catch...

Hi, I am using crystal reports 9.0. I have a report which has is based on the following table: Table Name Purchase: Fields are as follows: ID Name Order Total Amount 1 LC1 Direct 1000 2 LC2 Direct 2000 3 LC Direct 3000 4...

we have a batch job which runs eevery hour. Some times if the job runs for more than an hour long, we don't want to run the job for the next hour. let me explain this more. This job started running at 3pm and it didn't finish by 4 pm for some reasons, so we don't want to run this at 4pm as...

Hi, I have a summarized number field in cross tab. In order to display nulls as zeros and also to have the format depending on the field type, i have created a formula and using that formula as summarized field. if isnull({employee.salary}) then 0 else if {employee.type} ="manager" then...

Hi, I have to format the summarized field which is number type in cross tab. I have to format the summarize the field based on the certan conditon like the following: if type=count, then 9,999,999 if type=percentage, then 99.9 thanks in advance.

Hi, I am using using Crystal reports 9.0 with oralce 9i database. I have a cross tab report like the following: year State Name 2000 2001 2002 VA 100 101 102 MD 200 DC 20 1000...

I have a problem in accessing my report through asp. WE are usin Crystal 8.5. I amnot sure what are all using because i am new here. When I run the report through application, I am getting the following error: Crystal report Viewer: Cannot Open Sql Server. [On CAche/Page Server...

Hi, I am using crystal reports 8.5 and I wrote the following formula to display the concatenated employee name: If there is a middle name, the formula displaying null. I am not sure if I have to " " values also. If there is no middle name, then it is showing concatenated first name and last...