Thanks Tom,

A really needful post.

The thing now I need to install VS 2005 Professional 🙁

Any suggestion, if I use VS 2003, can i have feature? or is it only...

Hi,

I am trying as per the MS KB 316549. But as per tony's first response,

I am not able to find out the "step into stored procedure" while testing.

What is...

Hi sartorri,

Sorry I have not seen ur post.

I hope you are right and the code is also right. Few days before i have used this pivot function and it worked...

Hi Tom,

Thanks for your reply.

Is there any third party editor, which can serve my purpose?

Debugging the SP is really a tough job to me :w00t:

Thanks in advance.

U need to use PIVOT function

Thanks william.

I wil try the idea.

thanks again.

Hi WolliamB,

Great help.

"Execute a stored procedure that checks if a parameter was selected. If no parameter selected then return a TOP 0 on the dataset and populate a text box...

Hi William,

Thanks 4 ur reply.

But I cant set any of the parameters as default value bcause none of the field is not mandatory.

And SP also cant return a default data...

Hi

the report is not running from a cube.

Anyway, I have got the result 4 "select all" and NUll parameter for multi value.

Only thing i need to know is checking...

Sorry, but I have forgotten to mention, i also dont want to show that "select All" option in the parameter list. Is it possible? If possible, then how?

Hi,

Great help.

It's working fine.

Thanks a ton.

Since databases are different, use fully qualified name of the databases i.e. prefix the table name with server IP.database.user.table

To comapre the results, u can use EXCEPT operator.

loke

select * from...

Hi Marcus,

My problem is, the no. of columns are not defined. they can varry.

So initially I am going to develop the SP using Pivot. I hope this will work. But...

I am using SSRS and want an alternative to Crystal reports cross tab tables.

Thanks in advance.

Hi Marcus,

Again thanks for this beautiful link.