ReportViewer control Impersonate User

I need to impersonate to allow my asp.net ReportViewer control to load
reports from my SQL 2005 reporting server.
I have two ways of doing that and I was wondering which way was best
practice (or if there is any better way):
--
Method1: impersonate in in web.config
identity impersonate="true" userName="domain\username" password="password"
--
Method2: override IReportServerCredentials
...
if (!Page.IsPostBack)
rv1.ServerReport.ReportServerCredentials = new
MyReportServerCredentials();
...
[Serializable]
public sealed class MyReportServerCredentials : IReportServerCredentials
...
return new NetworkCredential(...)
(above explained excellantly in
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx)
Thank you!Hello Dev,
I suggest you use the second method. If you impersonate in the web.config
file, the whole application will effected and since you hardcode your
credential information in the web.config, it may have some security issue.
If you use the IReportCredentials and programmatically specify the
credential, it only use on the page which include the ReportViewer Control
which is more secure.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community 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.

ReportViewer authentication

I am using Microsofts sample ReportViewer in my asp app
I am using window impersonation but I can not get the viewer to use the
identity
of the user that I am impersonating
Is there a way (within ReportViewer) to set the authentication for viewing
the reports?
--
Dain
Computer ProgrammerHave a look at this link. Hope helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_6ne8.asp
Regards,
Barbaros
MCDBA, MCAD
"Dain1234" <Dain1234@.discussions.microsoft.com> wrote in message
news:D82A2D58-9C79-4F8A-A0FF-DF328DBA4462@.microsoft.com...
>I am using Microsofts sample ReportViewer in my asp app
> I am using window impersonation but I can not get the viewer to use the
> identity
> of the user that I am impersonating
> Is there a way (within ReportViewer) to set the authentication for viewing
> the reports?
> --
> Dain
> Computer Programmer

ReportViewer AspNetSessionExpiredException

I get a

Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired

immediately when a user clicks the Export link on the ReportViewer. I tested it on two other machines and it works. What would cause this?

I have a similar problem but could not solve it yet (as a matter of fact, did not go deep into it). Here is a post that I posted in MSDN forums, which has some possible solutions. It might solve your problem. If it does, please let me know what you did to solve it.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1357694&SiteID=1

|||

I had the same trouble and the solution of limit MaxWorkingProcesses to 1 commented in that post, solved the problem.

ReportServer

I want to create ReportServer which processes crystal report and sybase database using c#. Particulary this report server

get parameters from user and process this report send it back to user additional also send email,print,ftp etc... Also report server should be able to schedule reports as per user request.

Does microsoft gives any classes /services to start programming for this? Any suggestion or Any Idea ?

thanks for looking into this..

Out of the box .NET supports SQL Server and Crystal Reports. I don't know about Sybase. For SQL .NET has builtin support for displaying reports in WinForms or WebForms (Microsoft.Reporting). CR does the same thing (CrystalDecisions.Web) but they are in no way related.

In projects past if my app had to support multiple reporting subsystems then I created a generalized reporting manager with abstract report and parameter classes from which I derived specific types for SQL, CR or whatever. This is a lot of work and you are ultimately tied to the LCM of the reports. For example if Sybase doesn't support scheduling then you can't do it irrelevant of what your interface exposes. Therefore you must either target the LCM or do some sort of "Supports feature X" system to allow the generalized components to play nice together.

Michael Taylor - 9/14/07

http://p3net.mvps.org

|||what is LCM ?|||

Least Common Multiple. In the context of this discussion the list of features shared by all reporting types (such as types, parameter options, etc).

Michael Taylor - 9/25/07

http://p3net.mvps.org

|||

thanks for your reply.

I am now planning to write my own report manager. Because i tried "Crystal Report Server" , but it has limitation with features what I need

I am planning to write report manager which supports

- View /print/mail/ftp reports

- also schedule a job which containts bunch of reports with predefined parametes

- most important we also want to put user request in queue if other user is has submitted request for this report. this

type of reports take long time and may cause dead lock on database.

again thanks for your time

ReportServer

I want to create ReportServer which processes crystal report and sybase database using c#. Particulary this report server

get parameters from user and process this report send it back to user additional also send email,print,ftp etc... Also report server should be able to schedule reports as per user request.

Does microsoft gives any classes /services to start programming for this? Any suggestion or Any Idea ?

thanks for looking into this..

Out of the box .NET supports SQL Server and Crystal Reports. I don't know about Sybase. For SQL .NET has builtin support for displaying reports in WinForms or WebForms (Microsoft.Reporting). CR does the same thing (CrystalDecisions.Web) but they are in no way related.

In projects past if my app had to support multiple reporting subsystems then I created a generalized reporting manager with abstract report and parameter classes from which I derived specific types for SQL, CR or whatever. This is a lot of work and you are ultimately tied to the LCM of the reports. For example if Sybase doesn't support scheduling then you can't do it irrelevant of what your interface exposes. Therefore you must either target the LCM or do some sort of "Supports feature X" system to allow the generalized components to play nice together.

Michael Taylor - 9/14/07

http://p3net.mvps.org

|||what is LCM ?|||

Least Common Multiple. In the context of this discussion the list of features shared by all reporting types (such as types, parameter options, etc).

Michael Taylor - 9/25/07

http://p3net.mvps.org

|||

thanks for your reply.

I am now planning to write my own report manager. Because i tried "Crystal Report Server" , but it has limitation with features what I need

I am planning to write report manager which supports

- View /print/mail/ftp reports

- also schedule a job which containts bunch of reports with predefined parametes

- most important we also want to put user request in queue if other user is has submitted request for this report. this

type of reports take long time and may cause dead lock on database.

again thanks for your time

sql

ReportServer

I want to create ReportServer which processes crystal report and sybase database using c#. Particulary this report server

get parameters from user and process this report send it back to user additional also send email,print,ftp etc... Also report server should be able to schedule reports as per user request.

Does microsoft gives any classes /services to start programming for this? Any suggestion or Any Idea ?

thanks for looking into this..

Out of the box .NET supports SQL Server and Crystal Reports. I don't know about Sybase. For SQL .NET has builtin support for displaying reports in WinForms or WebForms (Microsoft.Reporting). CR does the same thing (CrystalDecisions.Web) but they are in no way related.

In projects past if my app had to support multiple reporting subsystems then I created a generalized reporting manager with abstract report and parameter classes from which I derived specific types for SQL, CR or whatever. This is a lot of work and you are ultimately tied to the LCM of the reports. For example if Sybase doesn't support scheduling then you can't do it irrelevant of what your interface exposes. Therefore you must either target the LCM or do some sort of "Supports feature X" system to allow the generalized components to play nice together.

Michael Taylor - 9/14/07

http://p3net.mvps.org

|||what is LCM ?|||

Least Common Multiple. In the context of this discussion the list of features shared by all reporting types (such as types, parameter options, etc).

Michael Taylor - 9/25/07

http://p3net.mvps.org

|||

thanks for your reply.

I am now planning to write my own report manager. Because i tried "Crystal Report Server" , but it has limitation with features what I need

I am planning to write report manager which supports

- View /print/mail/ftp reports

- also schedule a job which containts bunch of reports with predefined parametes

- most important we also want to put user request in queue if other user is has submitted request for this report. this

type of reports take long time and may cause dead lock on database.

again thanks for your time

Reports wont show any result in another User Account

Hi,

i got a problem with all the reports which where created in by one user. This user has left our company. The weird think is that all the reports the user has created works/runs fine in that users account.

The problem is if i try to run exactly the same report in my user account it does not show any values, except of one that is total count of the data entries. I got the connection to the database, i created a test report with basic values, it works fine.

The reports wont run on any other user account. It just run fine in the account where it got created.

I assume the user must have setup something in his Crystal Reports, DB2 or anywhere else. Attributes and the rights are exactly the same. My account is in the same group like the other account. I do have exactly the same rights i also can modify the file and safe it but i cant see the result after i run the report. If i can't check the results it makes no sense to modify it. I have to login in that account to do the modifications or to test them.

I have a tool which runs report independetly. There i can see the result in any account. The reports does only not work in Crystal Reports.

Anyone has idea what could be wrong ? I have tried everything but i cant find out what the problem is.

It's really urgent i hope someone has a solution

TrayHard to say, have you checked the database connections under the "working id" and compared them with yours. Perhaps he set up a custom connection to the database that your connection does not have.
" Grasping at straws "sql

Reports with dynamic user entered parameters.

I am new to Crystal Reports. I am getting into reports and need to design few first crystal reports. I have read some tutorial and created simple once with no problems.
However I am looking for an ability to create ASP.NET page with crystal report where user will be able to select different parameters that will be passed to stored procedures to generate different reports For example select the date or user name or something like that. I know that I can design selection part in ASP.Net and then pass it to crystal report to generate dynamic report. I was just wondering if Crystal report has this option build in where I will not have to create separate AS.NET promt controls abut use Crystal Once and put it on the same page where user selects parameters clicks some button SUBMIT and gets report, then chage para,etrs and get different report. I hope I explained it well to understand

Thanks for any help !!!!anybody, please??|||I was just wondering if Crystal report has this option build in where I will not have to create separate AS.NET promt controls abut use Crystal Once and put it on the same page where user selects parameters clicks some button SUBMIT and gets report, then chage para,etrs and get different report. I hope I explained it well to understand

I'm not sure I understand what you're asking. Can you restate your question?

Linda|||I am trying to create dynamic crystal report. What I mean by "dynamic" is I would like to have some controls like textBox or ComboBox that will collect some parametrs from user and will be imported into SQL statement wihtin crystal report to retrevie different results. For example, I have report that gives me daily activty of the store. I want to have control that has promts user for a date and depending on user entry diplay report for following day.

I know that I can create the controls in Windows.Forms or In ASP.NET and then pass it to crystal report. But I was wondering if there is such functionality built in crystal reports where I can user control to insert parametrs. I have seen it somewehere that it was done but in 2 pages where user select the parametrs first and then get report, but I want to have it on one page like for example parametrs selection on top and report on the botom of the page

Thanks!!!|||I am trying to create dynamic crystal report. What I mean by "dynamic" is I would like to have some controls like textBox or ComboBox that will collect some parametrs from user and will be imported into SQL statement within crystal report to retreive different results. For example, I have report that gives me daily activty of the store. I want to have control that promts user for a date and depending on user entry diplay report for enterted day.

I know that I can create the controls in Windows.Forms or In ASP.NET and then pass user entry to crystal report. But I was wondering if there is such functionality built in crystal reports where I can user control to insert parametrs. I have seen it somewehere that it was done but in 2 pages where user select the parametrs first and then get report, but I want to have it on one page like for example parametrs selection on top and report on the botom of the page

Thanks!!!|||If I understand you correctly, you want to prompt the user for parameters and display those parameters along with the report?

Have you thought about using frames? You could use the top frame for the parameters and the bottom frame to display the report.

Alternately, you could display the parameter fields right in the report.

Linda|||Thanks for the answer

Well, I want a little bit differetn think. I want user to be able to enter some parametrs and then click some button what will display report based on parametrs. So I do not wnat just to display parametrs in report but have report use these parametrs lets say in WHERE clause in SQL command or as paramters in Stored Procedures. So this way user will be able to slect different paramters and siplay differetn reports

?

Thanks|||I *think* I've read that you can design an entire report programmatically, but I've never attempted anything like that myself. I'm not sure I would want to unless there weren't any other way. IMO it's just easier to design a report in the report designer and then hook into it programmatically and pass some pre-defined parameters.

What kind of SDK's do they have for ASP.Net on the Business Objects site? I'm still ASP based with Crystal and use the RDC and RAS SDK's for COM. They usually post the SDK's in the Developer Zone, but you might have comb the BO site or buy a really good book to be able to do something like that.

Linda|||Thanks for your answers. I am just a begginer with crystal reports so any advice is valuable to me.

Alternately, you could display the parameter fields right in the report.

Can you please tell me or send a link to some tutorial that talks about how to do it.

[qoute]What kind of SDK's do they have for ASP.Net on the Business Objects site?[/quote]

If I exactly uinderstood you I am using Visual Studio to develop any ASP.NET based projects.

Thanks a lot

Reports vs. ReportServer permissions

I have created and deployed my reports on my report server, then I have set the appropriate permissions for MYDOMAIN\Domain Users (System User + Browser Role) across the whole report server (inluding the Home folder and its My Sample Reports subfolder). However, when I (as the domain user) access http://myreportserver/Reports I see nothing, only the empty Home folder. The same time, when I access http://myreportserver/ReportServer I can browse all I need and even generate reports. Please explain, what is wrong with my Report Manager at http://myreportserver/Reports, what security issues I may have. Thanks in advance.Thanks for no response but we have already solved the problem by adding missed <identity impersonate="true" /> line to C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\web.config. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetAP05.asp for details.

Reports Use one Model dynamically connected to several databases with identical schema

We have several archived databases with identical schema. Is it
possible to develop a single SQL Server 2005 report model such that
the user can generate reports by picking which database to connect to?
The report model are only based on the schema of one database. It is
not required to cross reference data from different archived
databases.
We have to support multiple users such that we cannot rename the
database while the report is generated.
Thanks in advance.
SimonEven if you manage to do for all databases, how to give an option of
selecting the database and binding to the model ? Not possible.
My suggestion is you can create the same model and copy that and change the
database it is pointing and the name. e.g
Data 2003, Data 2004, Data 2005 some thing like this.
When the user goes to the report model designer he can see all the model
available, let him select whichever he wants and creates a report.
Amarnath, MCTS.
"Simon" wrote:
> We have several archived databases with identical schema. Is it
> possible to develop a single SQL Server 2005 report model such that
> the user can generate reports by picking which database to connect to?
> The report model are only based on the schema of one database. It is
> not required to cross reference data from different archived
> databases.
> We have to support multiple users such that we cannot rename the
> database while the report is generated.
> Thanks in advance.
> Simon
>|||On Mar 16, 3:03 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
The issue is that the archives are not limited to yearly archive. The
user can create an archive at will.
I tried to use "Data Source Expressions" but failed because that data
source expression can not be used in a shared data source.
Simon
> Even if you manage to do for all databases, how to give an option of
> selecting the database and binding to the model ? Not possible.
> My suggestion is you can create the same model and copy that and change the
> database it is pointing and the name. e.g
> Data 2003, Data 2004, Data 2005 some thing like this.
> When the user goes to the report model designer he can see all the model
> available, let him select whichever he wants and creates a report.
> Amarnath, MCTS.
>
> "Simon" wrote:
> > We have several archived databases with identical schema. Is it
> > possible to develop a single SQL Server 2005 report model such that
> > the user can generate reports by picking which database to connect to?
> > The report model are only based on the schema of one database. It is
> > not required to cross reference data from different archived
> > databases.
> > We have to support multiple users such that we cannot rename the
> > database while the report is generated.
> > Thanks in advance.
> > Simon- Hide quoted text -
> - Show quoted text -|||Simon,
Infact you need to have report model for RB, it means the RModel should be
fixed with all possible links with tables, so that the user can select any
field. So RModel cannot be on the fly created by the user, unless you create
a custom code, which will be difficult, and I hope that should not be the
options, due to difficulty..
Amarnath, MCTS.
"Simon" wrote:
> On Mar 16, 3:03 am, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
> The issue is that the archives are not limited to yearly archive. The
> user can create an archive at will.
> I tried to use "Data Source Expressions" but failed because that data
> source expression can not be used in a shared data source.
>
> Simon
> > Even if you manage to do for all databases, how to give an option of
> > selecting the database and binding to the model ? Not possible.
> >
> > My suggestion is you can create the same model and copy that and change the
> > database it is pointing and the name. e.g
> > Data 2003, Data 2004, Data 2005 some thing like this.
> >
> > When the user goes to the report model designer he can see all the model
> > available, let him select whichever he wants and creates a report.
> >
> > Amarnath, MCTS.
> >
> >
> >
> > "Simon" wrote:
> > > We have several archived databases with identical schema. Is it
> > > possible to develop a single SQL Server 2005 report model such that
> > > the user can generate reports by picking which database to connect to?
> >
> > > The report model are only based on the schema of one database. It is
> > > not required to cross reference data from different archived
> > > databases.
> >
> > > We have to support multiple users such that we cannot rename the
> > > database while the report is generated.
> >
> > > Thanks in advance.
> > > Simon- Hide quoted text -
> >
> > - Show quoted text -
>
>

Reports Security--Windows authnetication

Hi,
I have created a user and a link in our website which links to the report.
Now whenever anyone clicks the button to view the report,a prompt comes up
for Uers name & password. But if wrong password id enterd it shows Reporting
services error-- The permissions granted to the user are insufficient . See
rsOnline for help." Till yesterday, when the person entered a wrong user
name & password. It would prompt the user name & password again & again and
after 3-4 time it would take you to the page... "You are not authoized to
view the page..Plz click the refresh button..."
I tdont want the users to see any reporting svcs error but this general
error : "You are not authoized to view the page..Plz click the refresh
button..." > I think its related to IIS.
How to get over this?
--
pmudI hope you are using Form Authentication example from Microsoft site. All you
have to do is edit the UILogon.aspx page. You have to redirect to the page
where you say that user credential is invalid to see the report.
HTH
--
Rajesh
MCSD.NET
http://meenrajan.blogspot.com
"pmud" wrote:
> Hi,
> I have created a user and a link in our website which links to the report.
> Now whenever anyone clicks the button to view the report,a prompt comes up
> for Uers name & password. But if wrong password id enterd it shows Reporting
> services error-- The permissions granted to the user are insufficient . See
> rsOnline for help." Till yesterday, when the person entered a wrong user
> name & password. It would prompt the user name & password again & again and
> after 3-4 time it would take you to the page... "You are not authoized to
> view the page..Plz click the refresh button..."
> I tdont want the users to see any reporting svcs error but this general
> error : "You are not authoized to view the page..Plz click the refresh
> button..." > I think its related to IIS.
> How to get over this?
> --
> pmud

reports on AD elements

Is there a way that RS can create reports using the DC
Active Directory as the data source? I need to pull a
report listing two fields: User and e-mail address(from
exchange). Any help is appreciated. Thanks, RonI found the info. it is included in case someone else would like to know how to do it:
Other Data Sources
One exciting aspect of SRS is its ability to query multiple data source types in addition to SQL Server. Any ODBC or OLE-DB provider can be a potential data source for SRS. We will be covering two of these additional providers while covering both developing reports in SRS as well as examining an overall Business Intelligence platform with Analysis Services in a later chapter.
For a simple example of using a data source other than a SQL Server database, let=D5s look at the OLE-DB Provider for Directory Services. By using a direct LDAP query, it is possible to generate field information for use in SRS.
SELECT cn,sn,objectcategory,department
FROM 'LDAP://DirectoryServerName/ OU=3DOuName ,DC=3DCompany,DC=3DCom'
The query uses a standard SQlLdialect that will return the common name, surname, objectcategory (computer or person) and department from the Active Directory. The field names will be automatically created and can be used like any other data field for a report.
There are couple of caveats that must be taken into consideration when querying AD, as well as other data sources that do not support the graphical query designer in SRS.
* Query Parameters are not supported directly in the query, however, Report Parameters can be defined and utilized both in the query, referred to as dynamic query, or used to filter data.
* Because a graphical query designer is not available, the query will need to be developed in the generic query designer by typing the query directly and testing. This requires knowledge of Active Directory objects and names.
Tip: There are several tools available to assist in the development and management of Active Directory, such as ADAM (Active Directory Application Mode) and LDP, an Active Directory tool included in the Windows Support Tools.
>--Original Message--
>Is there a way that RS can create reports using the DC >Active Directory as the data source? I need to pull a >report listing two fields: User and e-mail address(from >exchange). Any help is appreciated. Thanks, Ron
>.
>

Reports based off MDB

i have set up a report package that unfortunately uses an MDB as the
datasource (it will be upsized to SQL server soon); however, when any user
attempts to view/generate the reports they get the following error:
Reporting Services Error
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'Accreditations_DB'.
(rsErrorOpeningConnection) Get Online Help
Unspecified error
The report(s) run fine off my test machine (i am the admin for the report
server).
any suggestions?
thanks,
benYou could put the MDB on a share and set that path in your connection
string. Or every user can have the MDB in the same path on each of their
local machines.
--
| Thread-Topic: Reports based off MDB
| thread-index: AcWXcPgArs6cX3IkSE6p/O0qCf3ZDQ==| X-WBNR-Posting-Host: 205.210.222.129
| From: =?Utf-8?B?QmVu?= <ben_1_ AT hotmail DOT com>
| Subject: Reports based off MDB
| Date: Tue, 2 Aug 2005 07:46:30 -0700
| Lines: 17
| Message-ID: <2C049966-34CD-4AEC-98D8-F24B6FB91CDD@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:49442
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| i have set up a report package that unfortunately uses an MDB as the
| datasource (it will be upsized to SQL server soon); however, when any
user
| attempts to view/generate the reports they get the following error:
|
| Reporting Services Error
| An error has occurred during report processing. (rsProcessingAborted) Get
| Online Help
| Cannot create a connection to data source 'Accreditations_DB'.
| (rsErrorOpeningConnection) Get Online Help
| Unspecified error
|
| The report(s) run fine off my test machine (i am the admin for the report
| server).
|
| any suggestions?
| thanks,
| ben
||||Both those options are options that we are trying to avoid. I think it has
something to do with credentials because i stored my login and pass in the
datasource and checked the "impersonate" option and that seemed to work.
""Brad Syputa - MS"" wrote:
> You could put the MDB on a share and set that path in your connection
> string. Or every user can have the MDB in the same path on each of their
> local machines.
> --
> | Thread-Topic: Reports based off MDB
> | thread-index: AcWXcPgArs6cX3IkSE6p/O0qCf3ZDQ==> | X-WBNR-Posting-Host: 205.210.222.129
> | From: =?Utf-8?B?QmVu?= <ben_1_ AT hotmail DOT com>
> | Subject: Reports based off MDB
> | Date: Tue, 2 Aug 2005 07:46:30 -0700
> | Lines: 17
> | Message-ID: <2C049966-34CD-4AEC-98D8-F24B6FB91CDD@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:49442
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | i have set up a report package that unfortunately uses an MDB as the
> | datasource (it will be upsized to SQL server soon); however, when any
> user
> | attempts to view/generate the reports they get the following error:
> |
> | Reporting Services Error
> | An error has occurred during report processing. (rsProcessingAborted) Get
> | Online Help
> | Cannot create a connection to data source 'Accreditations_DB'.
> | (rsErrorOpeningConnection) Get Online Help
> | Unspecified error
> |
> | The report(s) run fine off my test machine (i am the admin for the report
> | server).
> |
> | any suggestions?
> | thanks,
> | ben
> |
>

ReportParameter.ValidValues

I have been assigned to create a new report subscription form. I have
done everything but prompt the user for values. So there are a bunch
of reports with varied parameters. Some of these parameters are
hard-coded lists and others are DataSetReference. How do I provide the
subscriber with an accurate list of valid values?
I was thinking something like:
ReportParameters[0].reportParameter.ValidValues
but that comes back null.
I tried reportService.GetReportParameters(report, historyID,
forRendering, values, credentials)
Values comes back null.
Please help!
Thank you!
--Larry--"values" in GetReportParameters is used to validate parameter values.
Actual parameters are returned by GetReportParameters.
You can try something like this:
ReportParameter [ ] rp = reportService.GetReportParameters(report,
forRendering, historyID, null, credentials);
rp[0].ValidValues should contain valid values.
This posting is provided "AS IS" with no warranties, and confers no rights.
<lfarrell@.setfocus.com> wrote in message
news:1105590508.069271.235070@.c13g2000cwb.googlegroups.com...
>I have been assigned to create a new report subscription form. I have
> done everything but prompt the user for values. So there are a bunch
> of reports with varied parameters. Some of these parameters are
> hard-coded lists and others are DataSetReference. How do I provide the
> subscriber with an accurate list of valid values?
> I was thinking something like:
> ReportParameters[0].reportParameter.ValidValues
> but that comes back null.
> I tried reportService.GetReportParameters(report, historyID,
> forRendering, values, credentials)
> Values comes back null.
> Please help!
> Thank you!
> --Larry--
>|||Thank you, but that didn't work,
The ValidValues is <undefined value>
I used the following code:
ValidValue[] vv = new ValidValue[0];
parameters = server.GetReportParameters(thisfolder, null, false,
Paramvalues, Paramcredentials);
if (parameters.Length != 0)
{
vv = parameters[0].ValidValues;
}
when I look at parameter[0] (and 1 as well) I have ValidValues
<undefined value>
CalidValuesQueryBased = true
ValidValuesQueryBasedSpecified = true|||Thank you, but that didn't work,
The ValidValues is <undefined value>
I used the following code:
ValidValue[] vv = new ValidValue[0];
parameters = server.GetReportParameters(thisfolder, null, false,
Paramvalues, Paramcredentials);
if (parameters.Length != 0)
{
vv = parameters[0].ValidValues;
}
when I look at parameter[0] (and 1 as well) I have ValidValues
<undefined value>
CalidValuesQueryBased = true
ValidValuesQueryBasedSpecified = true|||Thanks to Daniel Dieb, I fixed my problem. He commented on a similar
post:
If ForRendering has a value of false, the parameter meta data returned
represents the parameter data that is currently associated with the
specified report. If any parameters values are based on a query and you
are
interested in returning the query-based parameters valid values list,
you
need to set ForRendering to true, In addition, for query based
parameters,
you need to ensure that you have passed in all of the credential
information
required to return the query parameters.
I set this parm to true and got my values!!

ReportingServicesCompression.dll error

I have a report that will not initially run if the user running the report is
not a local administrator on the machine running reporting services. If the
user is a local administrator, the report will run. The user that is not a
local administrator is able to run the report after the local administrator
user has run the report.
It appears a local administrator has to get a dll loaded first before a
non-local administrator can run the report.
The error received is:
An unexpected error occurred in Report Processing. (rsInternalError) Get
Online Help Unable to load DLL (ReportingServicesCompression.dll).
The log file for reporting services contains the following:
w3wp!processing!d94!11/05/2004-08:56:02:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing. -->
System.DllNotFoundException: Unable to load DLL
(ReportingServicesCompression.dll).
at
Microsoft.ReportingServices.Diagnostics.CompressUtil.inflateInit_(z_stream
strm, String version, Int32 stream_size)
at Microsoft.ReportingServices.Diagnostics.CompressUtil.UnCompress(Byte[]
input, Int32 outputBufferLength, Byte[]& output)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.Uncompress(Byte[]
compressedBuffer, Int32 uncompressedBufferLength, Byte[]& uncompressedBuffer)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.ReadAndUncompressBuffer()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.FillBuffer()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream..ctor(Stream
store)
at
Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStream(Guid
snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32
chunkType, String& mimeType)
at
Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String
name, ReportChunkTypes type, String& mimeType)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext
reportContext, GetReportChunk getCompiledDefinitionCallback,
SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection
dataSources, Boolean checkIfUsable, ServerDataSourceSettings
serverDatasourceSettings)
Please advise.Hi,
Thanks for your post.
From your descriptions, I understood that you will have to view the report
by local administartor first to load DLL file, otherwise it will be error.
Have I understood you? Correct me if I was wrong.
It seems to be a permission issue and please make sure that non-local
administrator user was content manager ("New Role Assignment" in Report
Manager's Properties). Try to initial view the report with the non-local
administrator again and let me now whether it works this time.
If it doesn't work, please show me the detailed descriptions about your
sceanrio, such as remote access or local access, how do you change the user
to view the reports.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||We have an IIS Server running Reporting Services (machine "RS") with the
report published to it.
User "A" is a domain user on the network and logs onto computer "Computer A"
on the local intranet. User "A" does not have administrative priviledges on
machine "RS". User "A" is a Content Manager.
User "B" is a domain user on the network and logs onto "Computer B" on the
local intranet. User "B" has administrative priviledges on machine "RS"
User "A" runs the report on "Computer A" and the error is received.
User "B" runs the report on "Computer B" and it runs fine. User "A" on
"Computer A" can now run the report also.
The report uses a shared data source. The security on the shared data
source is
"Credentials stored securely in the Report Server" - "User as Windows
credentials when connecting to the data source" - "Impersonate the
authenticated user after a connection has been made to the data source". The
user specified is a domain user who is an administrator on "Computer RS"
""Michael Cheng [MSFT]"" wrote:
> Hi,
> Thanks for your post.
> From your descriptions, I understood that you will have to view the report
> by local administartor first to load DLL file, otherwise it will be error.
> Have I understood you? Correct me if I was wrong.
> It seems to be a permission issue and please make sure that non-local
> administrator user was content manager ("New Role Assignment" in Report
> Manager's Properties). Try to initial view the report with the non-local
> administrator again and let me now whether it works this time.
> If it doesn't work, please show me the detailed descriptions about your
> sceanrio, such as remote access or local access, how do you change the user
> to view the reports.
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>|||Hi,
I am looking into this issue, I will update you as soon as possible when I
find anything valueable.
Thank you for your patience and corporation.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi,
What kind of Reporting Server you are using now? Is it Reporting
ServicesSP1 (8.0.878)? Go to the report server virtual directory and see
what version number it says.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi,
I am currently standing by for an update from you and would like to know
how things are going there. Should you have any questions or concerns on
the recent questions/ information I've posted, please don't hesitate to let
me know directly. It's my pleasure to be of assistance
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

reporting views

Hi
We are using SQL reporting services as the reports engine on our projects.
Some reports come with a table view and a chart view. User wants to see
(print) the table report first by default. The chart report is optional.
The original approach is to have a link (button) on the first report; user
can click on it to see the chart report. However, since two trips will be
made to the data source, user might see different data because of the delay.
Is there a way to avoid that? We want two reports to have the same data.
Does SQL reporting service provide "Views"? So users can retrieve the
report and select different views without going back to the data source?
Thanks in advance!You can't build two different reports on the same query execution but what
you could do is have both the table and the chart in the same report. Set
the visibility propery on each to a parameter that tells which to display.
Have a link on the report that toggles between them.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"James Huang" <jianh@.avanade.com> wrote in message
news:unjgemapEHA.324@.TK2MSFTNGP11.phx.gbl...
> Hi
> We are using SQL reporting services as the reports engine on our projects.
> Some reports come with a table view and a chart view. User wants to see
> (print) the table report first by default. The chart report is optional.
> The original approach is to have a link (button) on the first report; user
> can click on it to see the chart report. However, since two trips will be
> made to the data source, user might see different data because of the
> delay.
> Is there a way to avoid that? We want two reports to have the same data.
> Does SQL reporting service provide "Views"? So users can retrieve the
> report and select different views without going back to the data source?
> Thanks in advance!
>

reporting user access rights on SQL7

I need to migrate a SQL 7 database server (in domain 1) to a new SQL 2000 (i
n
another domain 2).
To map the users from the domains, I need to know which users are configured
on the databases, plus which access rights and roles they have.
Can I get a report of this?
Does SQL have a default stored procedure for this?
Best regards,
-Peter-
Peter Geelen
System Engineer
www.identitymanagement.bePeter
Start quering sysusers system table , sp_helprotect system stored procedure
"Peter Geelen" <PeterGeelen@.discussions.microsoft.com> wrote in message
news:F767749C-6397-4791-8986-FE3A28D25D41@.microsoft.com...
>I need to migrate a SQL 7 database server (in domain 1) to a new SQL 2000
>(in
> another domain 2).
> To map the users from the domains, I need to know which users are
> configured
> on the databases, plus which access rights and roles they have.
> Can I get a report of this?
> Does SQL have a default stored procedure for this?
> Best regards,
> -Peter-
>
> Peter Geelen
> System Engineer
> www.identitymanagement.be

reporting user access rights on SQL7

I need to migrate a SQL 7 database server (in domain 1) to a new SQL 2000 (in
another domain 2).
To map the users from the domains, I need to know which users are configured
on the databases, plus which access rights and roles they have.
Can I get a report of this?
Does SQL have a default stored procedure for this?
Best regards,
-Peter-
Peter Geelen
System Engineer
www.identitymanagement.bePeter
Start quering sysusers system table , sp_helprotect system stored procedure
"Peter Geelen" <PeterGeelen@.discussions.microsoft.com> wrote in message
news:F767749C-6397-4791-8986-FE3A28D25D41@.microsoft.com...
>I need to migrate a SQL 7 database server (in domain 1) to a new SQL 2000
>(in
> another domain 2).
> To map the users from the domains, I need to know which users are
> configured
> on the databases, plus which access rights and roles they have.
> Can I get a report of this?
> Does SQL have a default stored procedure for this?
> Best regards,
> -Peter-
>
> Peter Geelen
> System Engineer
> www.identitymanagement.be