SQL command for crystal report

[makk07]

Hi Everyone,

How to write a SQL command for a crystal report for retrieving records only for last 7 days from a SQL Server database.

I am using crystal reports XI.

Thanks in advance for help
mak

 

[ptheriault]

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.

 

[SQLBill]

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