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 (It seems that's all they care about). So far with SSRS I can only get tabbed reports but I love the ease of deploying the reports to view via a browser.
But on to my question.
I have a table which contains all sales transactions {sales_history}. With-in the table is invoice_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.
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 (It seems that's all they care about). So far with SSRS I can only get tabbed reports but I love the ease of deploying the reports to view via a browser.
But on to my question.
I have a table which contains all sales transactions {sales_history}. With-in the table is invoice_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.