Can you be a bit more specific?
I have totally lakhs data.can i save this data into excel?
How are we supposed to answer a question like this?
Yes you can get data into Excel. Totally lakhs (remember this is an international forum. Use real numbers) data? I don't know, how much is totally lakhs data?
It seems to me you need to tackle this problem with SSIS (Integration Services), not SSRS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP