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...
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
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...
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...
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.