reporting services valid values query based

I have a parameter that is query based. I have created my own UI to list out
the text boxes per parameter required by the report. Now comes the problem of
a query based parameter. How to I get the queary based valid values to
populate my drop down list boxEddie,
If I understand your correctly I may have some ideas that will help you with
query based Parameters, but first please clarify the reason you built a UI
for users to pass parameters into the report?
thx.
"Eddie" wrote:
> I have a parameter that is query based. I have created my own UI to list out
> the text boxes per parameter required by the report. Now comes the problem of
> a query based parameter. How to I get the queary based valid values to
> populate my drop down list box|||I have several clients that use browsers which the report viewer doesn't
behave well.
I did figure it out. The valid values come back as array when you call the
GetReportParameter method and set the "ForRendering" to TRUE.
So all I did was add the values to ListItems and populated a drop down.
Also, a nifty thing was to find all the Date type parameters and lock the
text box and provide a calendar. This allowed me to use our application's
Localization methods to handle all the different Date formats.
"RS_CZAR" wrote:
> Eddie,
> If I understand your correctly I may have some ideas that will help you with
> query based Parameters, but first please clarify the reason you built a UI
> for users to pass parameters into the report?
> thx.
> "Eddie" wrote:
> > I have a parameter that is query based. I have created my own UI to list out
> > the text boxes per parameter required by the report. Now comes the problem of
> > a query based parameter. How to I get the queary based valid values to
> > populate my drop down list box

Reporting Services using NTLM Authentication

I need to have MSSRS send emails to external email addresses. Our Exchange
Server requires email to be authenticated. I am using SMTPAuthenticate value
of 2. My MSSRS server is in a different domain than my Exchange Mail server.
Currently I am testing before deployment into the field and my setup is
mirroring what the corporate desired setup is.
I receive the following error when I attempt to send a report to an external
email:
Failure sending mail: The message could not be sent to the SMTP server. The
transport error code was 0x80040217. The server response was not available
When I sniff the traffic during the report serving, my local Admin login
account is being authenticated by the Exchange Server in the mailer domain.
What type of setup or config changes can be made for the proper hand shake to
work? I must send authenticated email externally to our customers, but the
MSSRS Server and Exchange Servers will be in different domains.
Thanks,
RobertGood morning!
Did you ever find the solution to your question below? If so, what did you
do to resolve it?
Thank you.
"gilliatt via SQLMonster.com" wrote:
> I need to have MSSRS send emails to external email addresses. Our Exchange
> Server requires email to be authenticated. I am using SMTPAuthenticate value
> of 2. My MSSRS server is in a different domain than my Exchange Mail server.
> Currently I am testing before deployment into the field and my setup is
> mirroring what the corporate desired setup is.
> I receive the following error when I attempt to send a report to an external
> email:
> Failure sending mail: The message could not be sent to the SMTP server. The
> transport error code was 0x80040217. The server response was not available
> When I sniff the traffic during the report serving, my local Admin login
> account is being authenticated by the Exchange Server in the mailer domain.
> What type of setup or config changes can be made for the proper hand shake to
> work? I must send authenticated email externally to our customers, but the
> MSSRS Server and Exchange Servers will be in different domains.
> Thanks,
> Robert
>sql

Reporting Services using IBM DB2 Data Provider for .NET framework 2.0

Hello, I have been testing the IBM DB2 .NET data provider the last couple of months with the intention too use it with Reporting Services. I am using the IBM DB2 Data Provider for .NET framework 2.0. Everything seems too work fine until I started too test the Cashing and Scheduling of reports in Reporting Services.
Too be able too cash or too schedule reports in Reporting Services you have too set the "Credientials stored securely in the report server". The problem is when I do this with the Data Connection using the IBM .Net Provider I get an error Message:

"The data source 'XXXX' uses a managed data provider which does not implement IDbConnectionExtension. Only Windows Integrated Security or No Credentials are supported."

Is it possible too write a wrapper around the IBM dataprovider too implement IdbConnectionExtension and thereby extend the SSRS security model or is this something IBM have too do in the provider.

You can implement the wrapper yourself. Use this documentation to get started: http://msdn2.microsoft.com/en-us/library/ms154655(SQL.90).aspx

-- Robert

|||

Ok, thanks. I will look into this in a couple of days. Will this kind of wrapper couse much overhead or lack of performance?

I still wonder why IBM has not implemented this Interface in their release of the dataprovider.

B

|||

The purpose of the wrapper is mainly to "link" the defined interfaces, properties and methods to the underlying managed DB2 provider.

Your data extension wrapper should not perform any real data processing - just passing through calls. Hence, there won't be any significant overhead.

-- Robert

|||Were you able to create this provider?

Reporting Services using ASP

Is it possible to use SQL Server Repotring Services without using .net
framework? I want to use it using ASP.Depends on how you want to use it... You can call reports and pass
parameters via URL from ASP...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sumanta" <Sumanta@.discussions.microsoft.com> wrote in message
news:C07F6A9A-9C90-4213-AAB3-68E242E4213C@.microsoft.com...
> Is it possible to use SQL Server Repotring Services without using .net
> framework? I want to use it using ASP.

Reporting Services User Problems...

What I learned this week is that Reporting Services security is annoying as
hell. :-)
I'm curious if there is any logical reason that you cannot create a
subscription out of
a report that references the User!UserID? Perhaps I can see why some other
values
in User! may not be available, but the subscription is clearly associated
with the username
that created it, so I cannot even conceieve why there would be a limitation
like that.
Second, I was curious about the context under which a scheduled report is
executed.
The restriction above seems to indicate that it is run under the context of
some unknown
generic user, but my experience below seems to indicate otherwise.
The nuts and bolts of it is that I am receiving the infamous
"ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files,
AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service
account doesn't
have rights to check domain user SIDs.". I started with the server running
as NETWORK
SERVICE, changed to LOCAL SYSTEM, and am finally using a domain account that
clearly has access to the domain controller to lookup SIDs.
My confusion here is that if *I* create a subscription (being an
administrator) the
subscription runs fine. If any other user creates the subscription, it will
fail with the error
above. I'd sure like some insight into how this authorization crap works to
help track
down the problem.
Thanks,
Joel
jdk6 at case dot eduJoel,
> I'm curious if there is any logical reason that you cannot create a
> subscription out of
> a report that references the User!UserID?
There is a good reason and it is that subscriptions are executed in an
unattended mode by the RS Windows service so any user context is irrelevant.
> Second, I was curious about the context under which a scheduled report is
> executed.
> The restriction above seems to indicate that it is run under the context
of
> some unknown
> generic user, but my experience below seems to indicate otherwise.
Under the context of the RS Windows service account.
Every user with Create Subscription rights should be able to create
subscriptions. From there, it is the RS Windows service responsibility to
handle the subscription.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Joel D Kraft" <jdkraft2@.nospam.nospam> wrote in message
news:eaWoPv4mEHA.316@.TK2MSFTNGP10.phx.gbl...
> What I learned this week is that Reporting Services security is annoying
as
> hell. :-)
> I'm curious if there is any logical reason that you cannot create a
> subscription out of
> a report that references the User!UserID? Perhaps I can see why some
other
> values
> in User! may not be available, but the subscription is clearly associated
> with the username
> that created it, so I cannot even conceieve why there would be a
limitation
> like that.
> Second, I was curious about the context under which a scheduled report is
> executed.
> The restriction above seems to indicate that it is run under the context
of
> some unknown
> generic user, but my experience below seems to indicate otherwise.
> The nuts and bolts of it is that I am receiving the infamous
> "ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in
the
> log files,
> AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service
> account doesn't
> have rights to check domain user SIDs.". I started with the server
running
> as NETWORK
> SERVICE, changed to LOCAL SYSTEM, and am finally using a domain account
that
> clearly has access to the domain controller to lookup SIDs.
> My confusion here is that if *I* create a subscription (being an
> administrator) the
> subscription runs fine. If any other user creates the subscription, it
will
> fail with the error
> above. I'd sure like some insight into how this authorization crap works
to
> help track
> down the problem.
> Thanks,
> Joel
> jdk6 at case dot edu
>
>|||> Joel,
>> I'm curious if there is any logical reason that you cannot create a
>> subscription out of
>> a report that references the User!UserID?
> There is a good reason and it is that subscriptions are executed in an
> unattended mode by the RS Windows service so any user context is
> irrelevant.
> > Second, I was curious about the context under which a scheduled report
> > is
>> executed.
>> The restriction above seems to indicate that it is run under the context
> of
>> some unknown
>> generic user, but my experience below seems to indicate otherwise.
> Under the context of the RS Windows service account.
> Every user with Create Subscription rights should be able to create
> subscriptions. From there, it is the RS Windows service responsibility to
> handle the subscription.
Well at least your answers are consistent! :-)
Which is what I expected, though I cannot say that I agree.
My problem still remains then, is why when I create a subscription as an
administrator,
my subscription is delivered properly, but a subscription created by a
normal user
gets an AuthzInitializeContextFromSid error. This seems inconsistent with
the report
being solely run from the context of the RS Service account... if it had
permission
to process my subscription correctly, it should be able to do them all!!
This is RS 2000 SP1 under Windows 2003 and a Windows 2000 domain
functional level. "Authenticated Users" has the rights to read all of the
user and
group objects...
Joel|||Check the following thread:
http://groups.google.com/groups?q=AuthzInitializeContextFromSid&hl=en&lr=&ie=UTF-8&selm=O4qGzyL%24DHA.1700%40TK2MSFTNGP12.phx.gbl&rnum=7
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Joel D Kraft" <jdkraft2@.nospam.nospam> wrote in message
news:%23uO7VJ5mEHA.3296@.TK2MSFTNGP10.phx.gbl...
> > Joel,
> >
> >> I'm curious if there is any logical reason that you cannot create a
> >> subscription out of
> >> a report that references the User!UserID?
> >
> > There is a good reason and it is that subscriptions are executed in an
> > unattended mode by the RS Windows service so any user context is
> > irrelevant.
> > > Second, I was curious about the context under which a scheduled report
> > > is
> >> executed.
> >> The restriction above seems to indicate that it is run under the
context
> > of
> >> some unknown
> >> generic user, but my experience below seems to indicate otherwise.
> >
> > Under the context of the RS Windows service account.
> >
> > Every user with Create Subscription rights should be able to create
> > subscriptions. From there, it is the RS Windows service responsibility
to
> > handle the subscription.
> Well at least your answers are consistent! :-)
> Which is what I expected, though I cannot say that I agree.
> My problem still remains then, is why when I create a subscription as an
> administrator,
> my subscription is delivered properly, but a subscription created by a
> normal user
> gets an AuthzInitializeContextFromSid error. This seems inconsistent with
> the report
> being solely run from the context of the RS Service account... if it had
> permission
> to process my subscription correctly, it should be able to do them all!!
> This is RS 2000 SP1 under Windows 2003 and a Windows 2000 domain
> functional level. "Authenticated Users" has the rights to read all of the
> user and
> group objects...
> Joel
>

Reporting Services unstable.

I have been using reporting services for about 1 1/2 months, developing
reports in VS2003.
I have noticed that my changes don't get saved within the IDE (I have to go
out to notepad and edit the XML), as well as locking up when changing the
SQL statement in the report enviroment data window and changing the tab to
design or preview.
I have windows XP SP2 and SQL 2000 SP3a and Reporting Service SP1.
Unfortunately I don't know how long this has been happening.
Also when starting to apply changes to the report , VSS (Visual Source Safe)
doesn't prompt me to check out the report, it only does this when trying to
save it (which is doesn't do anyway).
Regards,
AdrianI too have been having very specific issues with changes to either the SQL
or the report layout format not being saved when integrated with VSS.
Neither the version in my working directory nor the version in VSS gets
updated.
Vivienne|||Sometimes it does not catch SQL changes. I always go to the layout mode
after I have made a change and then save it there. I have never seen a
problem with the report layout not being saved. Note that I do not use VSS
but the issue with changing the SQL is a problem regardless of whether VSS
is involved.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vivienne" <Vivienne@.discussions.microsoft.com> wrote in message
news:B57466D2-FFA7-4159-BE0F-4DCF07587C87@.microsoft.com...
> I too have been having very specific issues with changes to either the SQL
> or the report layout format not being saved when integrated with VSS.
> Neither the version in my working directory nor the version in VSS gets
> updated.
> Vivienne

Reporting Services under Windows Vista

Hello,
I tried to install SQL Server 2005 Express with Advanced Services under
Windows Vista RC1 x64. However I allways get the following Warning:
"ASP.Net Version Registration Requirement:
Failed to find the ASP.Net Version Registration with Microsoft Internet
Information Services (IIS)."
Having this warning it's not possible to install the Reporting Services.
Are there compatibility issues with IIS7 or am I doing sth. wrong?
MartinHello Martin,
Reporting Services won't be correctly supported until SP2 for SQL Server
2005, due to ship about the same time as Vista does. The IIS7 issue has to
due with the ISAPI filter RS uses. There is a KB article on this topic (920201,
see [0])
[0]: http://support.microsoft.com/kb/920201/en-us
I've tried getting working the RCs to not avail.
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/|||I just think that is goddamn ridiculous
a) we can't use _ANY_ database on Vista until SQL 2005 SP2 comes out.
b) we can't get a DOCUMENTED release date on SP2.
c) we don't know what features are in SP2.
It's like-- all of a sudden; a month after vista ships; we're supposed
to flip the switch and have every dev box in the world using MSDE on
Windows XP on day one and SQL 2005 on Vista the next day.
I just dont understand WTF that company is thinking; it's goddamn
ridiculous
If you dont have enough programmers; hire more-- as it is; a company
that has 50,000 people and they're stressed about having 5,000
programmers working on Vista _AND_ Office 2007 combined?
No wonder google can out-develop you even though they only have 8,000
total employees-- I guess at Google; they don't require 45,000
redundant project managers / excel dorks
-Aaron
Kent Tegels wrote:
> Hello Martin,
> Reporting Services won't be correctly supported until SP2 for SQL Server
> 2005, due to ship about the same time as Vista does. The IIS7 issue has to
> due with the ISAPI filter RS uses. There is a KB article on this topic (920201,
> see [0])
> [0]: http://support.microsoft.com/kb/920201/en-us
> I've tried getting working the RCs to not avail.
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/|||I installed mine last week but not on x64. You have to go in to the Control
Panel / Programs and check all boxes for IIS. You can't rely on the top
check boxes for each subsection. You have to expand the hierarchy for IIS
and manually check ALL items.
Then it will install
--
"Everyone knows something you don't know"
"Martin W" wrote:
> Hello,
> I tried to install SQL Server 2005 Express with Advanced Services under
> Windows Vista RC1 x64. However I allways get the following Warning:
> "ASP.Net Version Registration Requirement:
> Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS)."
> Having this warning it's not possible to install the Reporting Services.
> Are there compatibility issues with IIS7 or am I doing sth. wrong?
> Martin
>|||You have to go to Control Panel/Progams and manually expand the IIS section
so you can MANUALLY CHECK all IIS items. Just doing the top checkboxes won't
work.
--
"Everyone knows something you don't know"
"Martin W" wrote:
> Hello,
> I tried to install SQL Server 2005 Express with Advanced Services under
> Windows Vista RC1 x64. However I allways get the following Warning:
> "ASP.Net Version Registration Requirement:
> Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS)."
> Having this warning it's not possible to install the Reporting Services.
> Are there compatibility issues with IIS7 or am I doing sth. wrong?
> Martin
>|||You have to go to Control Panel/Progams and manually expand the IIS section
so you can MANUALLY CHECK all IIS items. Just doing the top checkboxes won't
work.
--
"Everyone knows something you don't know"
"Martin W" wrote:
> Hello,
> I tried to install SQL Server 2005 Express with Advanced Services under
> Windows Vista RC1 x64. However I allways get the following Warning:
> "ASP.Net Version Registration Requirement:
> Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS)."
> Having this warning it's not possible to install the Reporting Services.
> Are there compatibility issues with IIS7 or am I doing sth. wrong?
> Martin
>sql