I tried that too but no use. Also the problem is only in the mornings and night it exports good. So is there any problem with the report server.

what is meant by auto complete is it you need default values to all the parameters. Than in that case you can set up default values to all the parameters.

There can be a Stored procedure in the rdl file so how can you know with out getting the rdl file to the BI. If me i would add the...

If i understood correctly... in your parameter make default values as you are choosing for Available values.

In the parameter in general--> check the allow multiple values.

the query runs good for any values in less than a minute. even the reprot runs good on BIDS. The problem is on the report manager. FYI... the report is...

i think its better to do it in query... so that u can have all the data in one data set.. may be you can use union if I am...

Hi Thank you for the reply..

I did inner join put a where clause and deleted one table there were x rows affected but when i try to put one...

Thank you guys it helped me a lot.

Thank you guys. I will try to convince him sp is a good thing.

somebody please help me.

i am sorry i was curious to know the solution. i will keep in mind. Thank you.

there is work around in ssrs when you want to select multiple values. If you declare a parameter i think there ia function to accept that parameter. i am not...

i have edited my posts thank you anyway for informing.

It was so simple i forgot to even look at it. Thank you.

I ALSO WANT THE SUM OF THAT 2 ROWS AFTER THE 2 ROWS I NEED A ROW SPECIFING SUM ROW AND COL3...