Problem with Nulls in Crystal 9 1

[lana123]

Hi,people.
I created the view that I have to use in Crystal 9(Oracle 9.2).
Here is the example of my view:

SELECT
claim_prof_entity_fk,
MAX(claim_prof_name) AS name,
SUM(DECODE(Type_Alert_M1, NULL, 0, 1))AS M1
from claim

Here is my question - how it may happen:
when I run this view through database I get value 47 for M1
when I run the report based on this view I get value 49 for M1(but when I send the query from report into database and run it there I get 47 again)

I'll highly appreciate any help.
I checked and unchecked default null values in Options but I didn't get the value 47 that I see in database(and I need it in report).

Thanks in advance

Lana

 

[synapsevampire]

How are you connecting to Oracle?

Use the native connectivity in Crystal for the best performance, if you insist on using the inferior ODBC type, do NOT use the Oracle or MS supplied Oracle ODBC drivers, use the one supplied by Crystal.

Once you change the connectivity to what you were supposed to use you'll probably get the correct results.

-k

 

[lana123]

I insert my business view through Database Expert choosing it from the list
Lana

 

[synapsevampire]

You should have stated a Business View, a View is a common database object...

How does the Business View connect to Oracle?

If you don't know, then you may discover that it's done incorrectly, stands to reason anyway.

-k

 

[lana123]

I'm sorry...
I just realize that I sent wrong mail - I mean - view -the regular view that I created using Toad and inserted using Database Expert

Lana

 

[synapsevampire]

...

OK, but that has NOTHING to do with how you're connecting to the database, the more you share more I'm certain that you don't understand the basics.

How were you able to connect to the database, Crystal didn't automatically figure out that you had an Oracle database that held the data you needed, you had to specify connectivity, how did you do so?

-k

 

[lana123]

I open Database Expert -> Create New Connection ->Oracle Server -> I feel out Service,User ID,Password boxes(the same that I used in Toad to connect to database) and I choose the view that I created.

Lana

 

[lana123]

THANK YOU VERY MUCH!
I CHANGED CONNECTIVITY AND IT'S WORKING NOW!