I'm using Microsoft SQL Server 2008 as my database, as for reporting services I’m using Microsoft SQL Server BI Development Studio 2008. Let me rephrase my situation: I have a report with the following Columns:
Sales Country, End October Sales, End November Sales in this case Sales Country is fixed but End October Sales and End November Sales changes so as to allow user input to manipulate it according to their condition. Let say a user wants a sales report based on End January and End February, in this case it not possible to achieve that because columns are fixed for End November Sales and End October Sales only. I want these columns to be dynamic because sales report must be done based on the two months which of course changes. What can I do to achieve this?
Submit an article or tip