views:

400

answers:

0

Hi!!

I would like to pose a question regarding the Chart Filter properties in SSRS. I would like to know why the filter property doesnot work when I try to filter the Last 3 years of data. The condition is that I can't tamper with the database nor can I modify the Columns at tha database level. I need to implement this Filter at SSRS level itself. I tried using the filter nut it shows me either the Last 2 yrs or First 2 yrs of data. I need the Last three years of Data. Is there any code in VB? NB: I tried to concatenate 2 columns, that includes the year so that the Data is displayed according to the given format. So the table is grouyped on these two columns. Kindly help.