Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL command for crystal report
- Thread starter makk07
- Start date
ptheriault
IS-IT--Management
Mak,
You are going to have to provide us a lot more information if we are to be able to help you!
Have you written anything yet? If so post it. That would be a good place to start.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
You are going to have to provide us a lot more information if we are to be able to help you!
Have you written anything yet? If so post it. That would be a good place to start.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
I also suggest posting your question in one of the Crystal Report forums. Not all SQL Server TSQL commands work in Crystal Reports.
Personally, I would create a stored procedure in SQL Server that has the number of days as a parameter. Then run the query from Crystal Reports inputting the number of days you need.
It's been a while since I used Crystal Reports, so again you might get better help in the Crystal Reports forums.
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
Personally, I would create a stored procedure in SQL Server that has the number of days as a parameter. Then run the query from Crystal Reports inputting the number of days you need.
It's been a while since I used Crystal Reports, so again you might get better help in the Crystal Reports forums.
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
- Status
Similar threads
- Locked
- Question
