Crystal Reports & SDP
Why oh why on gods green earth have adventnet not used a date field for storing dates?
This makes it nigh on impossible to write decent reports using Crystal (because lets face it, the built in reporting tool of SDP is pretty mediocre at best).
How are we supposed to write date specific reports when the date is stored as a frikken string? And before you say anything, Crystal does not recognize the "<from_thismonth> command (at least if it does I can not get it to understand it).
Considering how well the SQL database has been constructed, and laid out, it does surprise me that someone (who really deserves a kick) decided against using a standard date field!
This makes it nigh on impossible to write decent reports using Crystal (because lets face it, the built in reporting tool of SDP is pretty mediocre at best).
How are we supposed to write date specific reports when the date is stored as a frikken string? And before you say anything, Crystal does not recognize the "<from_thismonth> command (at least if it does I can not get it to understand it).
Considering how well the SQL database has been constructed, and laid out, it does surprise me that someone (who really deserves a kick) decided against using a standard date field!