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 gkittelson 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: *

  1. Maniyur

    running totals on new page are wrong

    Just create another running total that doesn't reset.
  2. Maniyur

    Right Outer join does not work

    Figured it out. Joined the county table with a subselect of all other table joins. Thanks for all youe help.
  3. Maniyur

    Right Outer join does not work

    I have looked at the SQL and it looks OK. (+) sigh is put on the right colum for the join. The scenario is this. Out of 10 tables which are joined there are 3 main tables ISSUE, CONTACT and COUNTY. ISSUE to CONTACT is equi join CONTACT to COUNTY is right join. The objective is to bring in...
  4. Maniyur

    Right Outer join does not work

    I have 10 tables in a report in which one join is Right Outer Join. I have removed all selection criteria to test this with only joins and it does not work. I am using Oracle 9 with CR8.5. Please help
  5. Maniyur

    CE 8.0 Standard Edition - DSN Setting

    I have multiple developers developing reports with various DSNs. When I move these reports to the Server I am currently setting the databse parameters for each report one by one. I have 60+ reports. Is there any better way to do this in Crystal Enterpeise...like a setting which I can make to...
  6. Maniyur

    CE 8.0 Standard Edition - Probelms with Aging report

    I have got the problem number 1 resolved by running the CE Service Pack. Please help me with 2 & 3.
  7. Maniyur

    CE 8.0 Standard Edition - Probelms with Aging report

    I have around 60 reports to be put into CE8.0 Standard Editioin. 1. When I run an aging report on Crystal development environment it gives the right results. When the same report runs on CE aging changes. 2. Is there a way I can set the databse parameters for all reports at once? 3. How do I...
  8. Maniyur

    Oracle Number data type retrived with decimal points.

    That fixed it. Thanks much for this help.
  9. Maniyur

    Oracle Number data type retrived with decimal points.

    These are the stepe I took for formatting. Right clicked on field. Chose "Format Field". Under "Number" tag chose the format without decimal points. Eg: -1123. Also I did the same setting using the "Ooptions" Menu. Looks like when the report gets the value it adds...
  10. Maniyur

    Oracle Number data type retrived with decimal points.

    I did try "Format Field" in Crystal. It does not work. It suppresses the last 2 digits. ie, 4000 is diplayed as 40 when I change the format.It should show up as 4000.
  11. Maniyur

    Oracle Number data type retrived with decimal points.

    I am using Crystal Reports 8.5 with Oracle 9.2. While retrieving data using ODBC (CR Oracle 8 v3.6 / MS ODBC for Oracle) the number datatype is retrieved with two decimal points..for example, value 4000 in databse shows up as 40.00. I am not sure if this is a problem with ODBC driver? Please...

Part and Inventory Search

Back
Top