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.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  Month To Date / Year To date

Author  Topic  abernut Starting Member 6 Posts Posted - 2011-03-08 : 10:54:35 Hello. Right now we are trying to decide between SSRS and Crystal Report Server. I've been writing simple reports with Crystal for a little while and I love the ease of making the report look nice and pretty for the end user. So far with SSRS I can only get tabbed reports but I love the ease of deploying the reports. But on to my question. I have a table which contains all sales transactions {sales_tx}. With-in the table is sales_date and sales_amount and customer_name I need to to create a report to display LastYear Sales, MonthToDate Sales, YearToDate Sales, and Total Sales. I am a bit lost on this. Thank you for you help.