Select the solution on top of solution explorer. Right click and go to properties.

There are two option - Debug and deployment.

IN deployment there are 4 options:

Overwritedatasource - U...

u can check the margin of the page because it might be that the margin of page in report is less to accomodate the textbox. there might be some hidden...

I would say no. I never write semicolon into TSQL. It is neither good or bad.

Thanks all for your kind help.

It is true that SSRS is limited when it comes to use parameters and specially default parameter. If we use the setting provided by...

Thats the first question came to my mind that why do u need to split it in 40 tables? u better right 4 million record instead 40 lacs record. some...

It seems it is not available in SQL 2005. It is available in 2008 though. Please see this link.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3909125&SiteID=1

Yes, i can write something so that it will appear with default dates if they select weekly or monthly. But if they select weekly then stored procedure will return the...

If you are not using data driven subscription then it would be bit difficult to handle. U need to use data driven subscription which u can set up so that...

sorry forget to mention 32 bit.

Windows Vista Home Premium

Service Pack 1

I agree with indexing on table field which is used in the join. May be check execution plan and see table scan or index scan.

This article is nice for...

can u please write your query code?

Hi,

thanks for your reply. Yes i can do it using data driven subscription. there is no problem. But i was thinking to do it via subscription (simple subscription).

I have...

I have found the solution. Basically i can assume that when RS passes the multi value parameter from RS to SP then it will pass it as array of very...

Can any one help please?