conversion - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

conversion

Author

Topic

netcamnic
Starting Member

9 Posts

Posted - 2006-12-20 : 17:13:26

I have a decimal property in a chart, when I tell for crystal if it will be null pass '-', since I can do

grato

Marcos S. Santos

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-20 : 22:36:07

Please post only SQL Server related questions here. Also, what is your question?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-12-21 : 01:58:06

1 This is sql server Forum. I dont think most of the members can answer your CR related question
2 Use a Formula having the code

If {col} is NULL then
    "-"
else
    {col}

and use this formula to generate Charts
3 Your question seems hard to understand

Madhivanan

Failing to plan is Planning to fail

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2006-12-21 : 07:21:36

Also, since you are using Crystal Reports, just use a formula for when its null.

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-31 : 07:32:27

select isnull(<yourcolumnnamehere>, '-')

Peter Larsson
Helsingborg, Sweden

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-12-31 : 23:26:40

quote:
Originally posted by Peso

select isnull(<yourcolumnnamehere>, '-')

Peter Larsson
Helsingborg, Sweden

Will it work in CR?

Madhivanan

Failing to plan is Planning to fail

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-01 : 08:49:49

No. But if the VIEW or SP used for the report can handle the exception, fine...

Peter Larsson
Helsingborg, Sweden

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-01-01 : 09:05:24

quote:
Originally posted by Peso

No. But if the VIEW or SP used for the report can handle the exception, fine...

Peter Larsson
Helsingborg, Sweden

Yes it is. I thought you were giving CR syntax