Report not display Null fields

[gatorx]

Hello all,
I want to remove the following view from my Microsoft SQL 2000 server and use a SQL expression inside of crystal reports to return the data that I need. How would I write this expression in crystal?

select supportpoc as poc, [incident #], [date], sequence
from magictsd._smba_.[incident details]
where (support poc is not null)

any help is greatly appreciated

regards,
James

 

[Madawc]

You need something like not isnull(support.poc).

Always test for null on a field, before testing anything else. Crystal's default is to stop when a null is found.

Madawc Williams (East Anglia, UK)

 

[MisterMo]

select supportpoc as poc, [incident #], [date], sequence
from magictsd._smba_.[incident details]
where (supportpoc)is not null

Mo

 

[rosemaryl]

Dear James,

You cannot do this statement in a SQL Expression. A SQL Expression can only return one result.

Maybe if you tell me exactly what you are trying to do I can help you write the SQL Expression for Crystal Reports against this MagicTSD database.

Regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[gatorx]

Hello Rosemary,
Thank you for your response.
My requirement is to build a report showing the last support POC for each problem number for a certain date range.

The support POC is in the incident details view. I was able to get the the POC information in the report although if there is more than one POC associated to the incident number I am getting them as well. How can I tell the report that if the incident number is the same only use the poc closest to the current dat?

Thanks, James

 

[lbass]

Please provide your exact table and field names, as in {table.field}, for the date field, incident number, and the support POC.

-LB