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.
| Author |
Topic |
|
Beast777
Starting Member
10 Posts |
 Posted - 2008-01-10 : 13:54:00
|
| I didnt' know where to put this so, I guessed here. I have a stored procedure which I use as my datasource for my crystal report. Because one of the fields is a datetime, when I do my query it does joins and when finally done, each row has a datetime even though, some shouldn't. For those that shouldn't, it displays 1-Jan-1900 but I would rather have nothing there. Is there a way to hide certain dates from the report? |
|
|
blackX
Posting Yak Master
102 Posts |
Posted - 2008-01-10 : 17:44:39
|
| there is multiple ways to fix this. You can conditionally suppress the value. Another easy thing to do is change the font to white when the value is 1/1/1900. You could also use a case statement in the stored procedure. |
 |
|
|
|
|
|
Crystal Report Question