i have 30days data for the month of nov and 31days data for the month of december.
i have a listbox in the qvw file where i am maintaining the calender(1-31 nov/dec) and have a chart item (related with power consumption)in the qvw file.
while i am selecting 30th nov from calender but the chart showing 1dec data.
I re-created your day list box and it worked just fine. Your original list box was not working fine even after the new list box. Not sure what the problem is, but I would create the day, month and year fields in my loading script and not have them with an expression, like you have them.
No, I fixed them to 7 and also the sorting order and it looked and worked just fine. I did it with QV10.
As I said, the best way to handle this is to create these columns in your loading script. It can be done by a simple preceding load on the top of your SQL using the exact same formulas that you have in your list boxes.
