sir i have attached a report which i have created in sample db for my requirement but its showing some error and i dono how to pass parameter by script in before open so can u able to pass parameter i.e i can't able to pass parameter for year,quarter,month
kindly provide sampledb for this ..its urgent needed...
Take a look at this modified report. I used a separate dataSet to fill the values for the parameters and created a display value field to look like the fields you wanted and an integer field of just the straight month and quarter value for the actual parameter value. This really only needs to be done for the month.
Then, I added a couple lines to your beforeOpen script of your msrp dataSet to limit the query results by the parameter values selected.