Load .RDL file in a Report

I have a .RDL file.
I need to show it as a Report in a internet Explorer using Asp.net.
Simply,
I have a .RDL File and using ReportServer i have to view .RDL in a Report
Format.
Thanx
Karthik.AToday you have to deploy the report to Reporting Services server. Then you
can use either URL integration or web services to integrate the report with
your app.
With version 2 there will be webform and winform controls but that will be
awhile until they are released.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Karthik" <Karthik@.discussions.microsoft.com> wrote in message
news:9D34BC28-B872-4C0E-9955-D2BAD8D6472C@.microsoft.com...
> I have a .RDL file.
> I need to show it as a Report in a internet Explorer using Asp.net.
> Simply,
> I have a .RDL File and using ReportServer i have to view .RDL in a Report
> Format.
> Thanx
> Karthik.A
>
>sql

little problem..

hey guys, i have a little problem:

i use ASP with MSSQL and i have a query that adds these values to the database:

values(' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ')

when a value is empty, the fields are not filled
but when a value contains a single quote ('), that quote ends the value:

values(' hel'lo ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ')

so my question is, how can i make the quote (') in hel'lo .. invisible or something, so MSSQL wont see it as the end of the value.

(im MYSQL, you can just place a (\) in front of the (') but that doenst work in MSSQL...)use like this :

values(' hel''lo ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ')

-Rohit|||Use one more single quote as the escape character.|||thanx lads! :)

List all SQL/VS.NET objects on an aspx page?

Hi guys,

Being new to ASP.NET, I may be asking something that is dead simple, but please bear with me!

How would I go about listing all the tables, stored procedures and views from a SQL database within an aspx page? I understand how to connect and return a dataset etc, but that's about as far as I can get. I want to be able to list all of these objects from a given db - any ideas?

Additionally (this may not be possible) - is there a way I can list all of the objects within a visual studio.net solution, again within an aspx page?

Thanks for any help,

JonSQL has a number of procs and views that allow you to get at the meta data of its database. It's also got some weird foreach functions that help too.

select * from sysobjects

is one place to start, but there are nicer views.

As for .net you can use reflection and work your way around that.

System.Reflection.Assembly.GetExecutingAssembly();

is another good starting place.|||Thanks alot - that gives me some useful pointers.
I shall have a go and post results (if anyone else is interested in how it's done).