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.
| Author |
Topic |
|
imusic1991
Starting Member
1 Post |
 Posted - 2010-07-27 : 21:09:37
|
| Hi,I have a small issue, and ill just jump straight into it....I want to basically create a report that shows the Years and Months Sales per branchsoo something similar to this:Branch This Months Sale This Years Sales--------------------------------------------------------JansTown 2000 70000Blaxville 100 200I am using report builder 3i have managed to create either YTD or MTD on 1 report but i need both,Just a bit of background that there are 2 tables, branches( Contains the branches Name)and orders( contains all the sales and the date the sale was made), and they are related together by Branch ID also i am fairly new to reporting services, but know my way around stuffThanks in advance |
|
|
|
|
|
Creating a Repor Calulatting MTD and YTD Values