VS 2003 and SQL 2005 Report Service -- sql server new users

sql server new users : VS 2003 and SQL 2005 Report Service

luke
10/9/2006 12:00:00 AM

Hi,
Is it possible to use SQL 2005 report service in VB.net 2003? I cannot find
SQL 2005 report viewer component in VS 2003.

Thanks

Luke

Kent Tegels
10/9/2006 12:27:59 PM

Hello luke,

You might be a bit confused. The Report Service is a Web Service and yes,
that can be used by the VB.NET 2003 -- or anything else. The Report Viewer
is a WinForm/WebForm control that ships with Visual Studio 2005 SKUs. The
Report Viewer doesn't required the Report Service per se.

Thanks,
Kent Tegels
http://staff.develop.com/ktegels/

Kent Tegels
10/9/2006 8:06:52 PM

Hello luke,

It's pretty simple. The trick is to call the Render method on the service.
Keep in mind that it can return an array of streamIDs that you'll probably
want to call on RenderStream for.

Thanks,
Kent Tegels
http://staff.develop.com/ktegels/

luke
10/10/2006 12:00:00 AM

Hi Kent,

I wonder how to triggle the report from VB.net or C#. I have built a simple
report from sql 2005 but don't know how to bring it up from the code.

Thanks,

Luke

[quoted text, click to view]

luke
10/10/2006 12:00:00 AM

Thanks Kent,

Is there any samples available to use VS2003 to pass parameter and use the
SQL 2005 report service?

Thanks,

Luke

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

home · blog · groups

Questions? Comments? Contact the dn