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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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
  7. 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...
  8. CrystalUser1

    First Letter capital in crystal

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

    Passing User id and password to sub report

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

    Report Publishing in CE

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

    UNION All VS OR in oracle

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

    window.navigate error

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

    Oracle connection not supporting parallel transaction

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

    Group Tree Question

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

    Batch Job

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

    How to override the default number format in crystal

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

    How to format the summarized field in cross tab

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

    How to put zeros in there is no data in Cross Tabs

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

    Crystal REports Viewer Problem

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

    Formula Problem

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

Part and Inventory Search

Back
Top