Good information.

However, imagine there are ~30 odd reports. Single change will trigger modification in ~30 reports. Suggest to use custom DLL, which can be accessed easily using custom code....

Hi,

Interesting topic and well written.

For those who are wondering about achieving the same functionality in SQL Server 2005, it should be possible to use using .NET CLR programming (like writing...

Hi,

I would be glad to help. But i am not sure how can i do that...!!! Do you want to send you some URLs??

I would suggest to do GOOGLING and...

Hi,

Database for a web application can be installed using the same technique. You will be creating a setup for you web-site. So, integrating the logic of Installer class, including the...

Custom Report Item is very interesting and it involves very specific syntaxes to achieve what we want. I will have Part 2 listed soon.

Also, there are lots of other options...

scott mcnitt (11/9/2007)

---

For those of us coming from the old ADO world, do the parameter names have to exactly match the sproc parm names? In ADO the ordinal position mattered...

Steve,

The look n feel is really nice.

One thing which is missing is the link to the author page. Also, there used to be a link which showed the list...

I have been using this tool for few months now. Only thing which impresed me was the response time compared to the Management Studio.

Note: You should be careful in deleting database objects...

I feel the third option is the correct answer, OR should i say a better answer. (You need to build a second report and link it to this report.)

The second option...

Somehow the link for the zip file is missing. I have raised a request to the moderator to make it work. Sorry for the trouble...

Nicely done... simple and easy language.

Keep it up!!!

hi..

Make sure that you are assigning the proper values to your parameters [for the report which you are calling in "Jump To report"].

In Reporting services, the type-validation is not done. The values are converted implicitly.

If you pass ("1,2,3") to an int parameter in the function, then it is considered as 123.

If ("1,2,3") is passed...

Steve,

I feel that there is a need of a direct link to the discussion page from each article.

For example: The current display is:

Ideas for SQLServerCentral.com

By:

The parameter passed to the stored procedure can be assigned the XML file from the application.

For example: In .NET,

- Create a dataset.

- Get XML-string using the <DataSetName>.GetXml() function.

- Pass this XML-string...