Remember selected parameter? -- sql server reporting services

Just D.
2/12/2006 9:01:39 PM

Hi Peter and All,

I got a couple of questions.

First question is - "Where can we read about SQL Reporting Services API with
examples to use these services from our own WebApp directly and how
complicated is that?"

The second question is more about the application structure and its correct
configuration. The question is not very simple. To little bit simplify the
situation I can tell the following. We're having one database, this database
has data for many different offices and each office can have many users with
different permissions. This is more or less usual. The problem is that the
user's permissions are saved on the database in one table that is managed by
our own business logic, so the connection string to the database is only one
and included into the Web.Config file. I have one SP on the database that
has to be used to generate the reports, it retrieves the data from many
tables and generates some report in our application. Some of the columns
should be created manually. Probably I can place the code from the business
logic into the SP itself, although I'm not sure how easy it should be in my
situation, but that's a problem for me only for sure.

The question is - the report URL should be only one, I'm not going to
create a separate URL for each office, and the same SP should work with the
different offices. The difference is in the SP parameters. So how can I do
that? From one side if I include the office ID into the report them I will
not have a way to redefine it for another office. But it should not be
public accessible for sure. Another one limitation - the report should only
be accessible for a defined category of users, not to all of them, and the
user should enter his login/password to get it. The SP should get these
login/password and the office ID to check the user and to show the report or
show that the report is unavailable for this user. Isn't a very complicated
schema to use the MS SQL Server Reporting Services? I've seen a couple
examples in the movies provided by Microsoft on the MS site but it's
absolutely not enough to understand the whole logic of this powerful system.

From the other side if we could generate the DataSet in our own application,
that's exactly what we're doing now, and then just bind and show the Report
using the Reporting Services AND this DataSet them it would be the best way
to go. But how? Is it possible or I want too much from these services? I can
generate a DataSet in my app. adding all required generated columns and all
I need to do is to show the report using this DataSet. Am I dreaming or
somebody is already doing similar things?

Just D.

[quoted text, click to view]

petery NO[at]SPAM online.microsoft.com
2/13/2006 3:00:17 AM

Hello,

Based on my scope, this feature is not available in report manager.
However, if you develop your own Web applicaiton by using reportviewer or
report Web service API directly, you could try to track parameters in your
own web application code
..
Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
[quoted text, click to view]

David
2/13/2006 12:38:23 PM

Hi Peter,

Thanks for your response. We do have a web application that uses
reportviewer to access reports (through the report server URL access method -
not through a web service). By the way, we are using SQL Reporting Services
2000.

When the user selects a parameter from a drop down list in a report and
clicks "View Report", then navigates away from the report (to another screen
in the web app), I want to be able to display a "return to previous report"
link. I am able to do this, but not to the extent where it remembers what
parameter the user selected. Any additional thoughts you may have on how to
accomplish this would be appreciated.

Thanks,
David

[quoted text, click to view]

petery NO[at]SPAM online.microsoft.com
2/14/2006 1:43:52 AM

Hello David,

You could consider using cookies for the value of the parameters of the
report in report viewer.

server parameter reportviewer
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=131733&SiteID=1

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
[quoted text, click to view]

petery NO[at]SPAM online.microsoft.com
2/16/2006 12:00:00 AM

Hello,

You could check RS services API via SQL BOL. Per your question, you may
consider using forms authentication:

Using Forms Authentication in Reporting Services
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/ufairs.asp

You could manager users by group and add the groups to different roles of
reports as you want.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
[quoted text, click to view]
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!nntp.giganews.com!peer01.cox.net!cox.net
!p01!fed1read03.POSTED!53ab2750!not-for-mail
[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 reporting services

sql server reporting services : Remember selected parameter?