sql server reporting services: How to integrate reporting services to ASP's application? -- sql server reporting services

You're in the

sql server reporting services

group:

How to integrate reporting services to ASP's application?

How to integrate reporting services to ASP's application?

Paul
8/23/2005 4:15:41 PM

sql server reporting services:

How to integrate/setup the SQL 2000 Reporting Services (Report Manager UI)
to a ASP's (Application Service Provider not Active Server Page) type of web
application? i.e. this web application is shared by more than one company
with different SQL back end and the security of the data is very important
and company does not want their Sales report etc. available to other
competitive company using this application. Thanks.

Re: How to integrate reporting services to ASP's application?

Bruce L-C [MVP]
8/23/2005 8:57:03 PM

Although you can do this in 2000 it is a lot of work. You have to be able to
figure out the database they should be going to based on their userid (there
is a global variable called User!UserID that you can get this from).
However, it is not easy to develop where the database gets changed on the
fly. I just posted today some code you can use for this. Also, you would
need to implement custom security since this in an internet app. RS 2005
will be easier in several ways for this sort of thing. For instance,
expression based data sources. RS 2005 comes out in November.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: How to integrate reporting services to ASP's application?

Peter Nolan
8/24/2005 2:21:01 AM

Hi Paul,
I would have thought that the 'easiest' way would be to have one set of
reports in VS.NET and then deploy them to many locations, and then you
could go in and change the connection settings for each client...

This way the client goes to a web url that is their url and the changed
connection sends them to their data....all you need to do then is to
make sure that each client can only see their reports folder which I
think you can do using https (though I am no expert on that).

Of course, you do have the problem that when the reports are
re-deployed you need to remember not to accidentally overwrite the
connections but you can turn off 'overwrite connections' in VS.NET....

If you do things like imbed the client logos etc you can also deploy
them so the reports looks a little customised.....

I have not done this....but this is what we are planning to do.....I
can't see any problems with it......be nice to know there are no
problems... ;-)

Peter

Re: How to integrate reporting services to ASP's application?

PTosh
9/19/2005 12:08:06 PM

I have a similar situation of ASP model application. However I dont have
different databases for different customers. All in one database identified
by a customer id. Is there anyway I could pass on this customer id to all
reports as a hidden parameter or like add in a global variable.
We haven't started using RS but intend to starting with the SQL 2005 release.
Thanks in advance.

[quoted text, click to view]

Re: How to integrate reporting services to ASP's application?

Peter Nolan
9/20/2005 8:48:58 AM

Hi PTosh,
well, where there is a will there is a way....I am not v3ery
experienced yet...but what I am seeing/hearing is that the general way
RS is deployed is as part of an application. That is, some application
calls the reports as a web service mostly...in this environment, the
application would be able to pass the userid/password of the person who
has logged on the application to each report called...

The bit that confuses me is that such an application seems to be a 'no
brainer' for someone to develop and sell....but I haven't heard of
one..

Peter

Re: How to integrate reporting services to ASP's application?

PTosh
9/20/2005 12:40:18 PM

Thanks for your reply Peter.
I have to do more R&D on using RS. I know RS 2005 comes with report controls
that can be embedded in the application. So will look into those.
Please update me if you get any ideas or have suggestions.
PTosh.

[quoted text, click to view]

Re: How to integrate reporting services to ASP's application?

Peter Nolan
9/24/2005 2:47:46 PM

Hi PTosh,
we are testing with Dundas chart for RS2005 and found it pretty good so
far....I don't know of anyone else with a beta chart control that plugs
into RS....Dundas will have the lead on that as their chart product is
in RS2000....

So far we have found RS2000 to be quite good for what it is supposed to
be...which is a reporting tool....

We have just gone through the phase of designing and defining how our
reports will be produced and able to be customised for each client we
sell them to...

So, good luck with your R&D.. :-)

Peter

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 in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn