crystal rpts - show null values 1

[jameys26174]

Hi..
Hope anyone can help. I am trying to show null values - another words, I have a rpt to show all names, even if they don't produce anything?

Thanks,
J

 

[dgillz]

What is your report doing now? What behavior are you trying to avoid?

More details please.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[jameys26174]

I have a rpt that is reporting sales info. I have some months that reps do not sale anything. Therefore, these do not show up on rpt b/c their sales activity is null. I need for these reps to show no matter of null activity. This is happening when I group by rep names.

Txs,
J

 

[glalsop]

Try switching to a left-outer join. If you have more than 2 tables, you will need LOJ's all the way across.

-Gary

 

[jameys26174]

I really appreciate that.. could this join be done in crystal rather than Access?

Txs,
J

 

[sommererdbeere]

i believe the join should be done in access rather than crystal as crystal is an interface of an report.


when i do crystal report, i try to work everything off from my sql. this will gaurantee me that everything will be pull out. if there are some duplicates (not complex), i will create formular or do suppress if duplicates in crystal.

hope this help!

m

 

[glalsop]

To do it in Crystal, go to the Visual Linking Expert, right click the link, select Link Options and switch to Left-Outer Join.

-Gary