Click here to Skip to main content
15,844,152 members

Comments by s_magus (Top 4 by date)

s_magus 5-Jan-12 23:34pm View    
You will either need to create a setup project as described above to install crystal reports on your machine or find a crystal reports distribution for the version you have. You could also install the crystal reports feature for visual studio by running the installer and choosing to add the crystal reports feature from the installer which i don't believe is I would say to install whatever version you plan to redistribute or use with your application that way you don't run into problems with your application once you actual start to deploy it, because of a wrong version of crystal is being installed that is not compatible with the version you have been testing against.
s_magus 4-Jan-12 16:20pm View    
What are you attempting to accomplish with @datetype? What datatype is @datetype?
s_magus 3-Jan-12 9:31am View    
What version of crystal reports did you make the report with?
What version of Visual Studio are you using?
Do you have the crystal reports feature installed with Visual Studio?
s_magus 28-Jul-11 1:37am View    
You never specified what database you were using so I don't know if the database has them or what they may be called. Scalar-Valued functions are part of MS SQL Server which is the database I use on a day to day basis so it is what I used as the database system to write my solution. A scalar-valued function allows you to pass in parameters and return scalar (single) value such as a date, int, string, etc. In my solution the function DaysOut would return an int representing the number of days out in the time period.

DateDiff returns a number representing the count of the specified datepart for the date range. DateDiff(day, DateLeft, DateReturned) would return the number of days they were gone. Since it returns a number you can Sum the DateDiff to get the total days gone. Sum(DateDiff(day, DateLeft, DateReturned)) As DaysOut