Resource In SQL Reporting Services

Can someone help me

is SQL reporting services supports the Resource .

HI, Nezo:

Would you please elaborate more about your requirement? Do you want to use some resource files?

|||

Hi Nizar,

I think what you want is to use some Name/Value pairs, in which value can be accessed using name. I dont think there is anything like Resource files as we have in visual studio.

The only way I can think of to do something like this is by using custom assemblies(http://msdn2.microsoft.com/en-us/library/ms153561.aspx) , you should be able to access properties in assemblies.

|||

thanks alot

but i need drop down List which contain Language like (English , Arabic)

when someone choose language the report change the Title and Alignment to Left if English And to Right when arabic

if that possible in SQL reporting or not

please help me

|||

I dont see any direct functionality provided in SSRS to do this, what you can do is to pass the selected language(from list) to the report and set the TextAlign property of Title using Expressions.

Resetting Page Number in SQL Reporting Services

Does anyone know of a way to reset page numbering when the group changes?
Thanks,
DennyDenny:
Try this blog that I found on this same group.
http://blogs.msdn.com/bwelcker/archive/2005/05/19/420046.aspx
Sher
Denny wrote:
> Does anyone know of a way to reset page numbering when the group changes?
> Thanks,
> Denny

reset report parameters back to defaults

I am running SQL 2005 Reporting Services and designing reports via Visual
Studio.
Is there an easy way to reset/clear the report parameters back to the
defaults while viewing the report in IE.
Right now I have create a hyperlink which will re-direct to the URL of the
report which thus sets the paramaters back to their defaults, but it seems
that there must be a better way to do this.Hello,
Reporting Services did not provide the method to reset the parameters back
to the default.
Your solution is the best way I think to achieve your requirement.
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.|||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.sql

Requirements to set up on a new server?

I wanted to test drive the reporting services against Crystal.
I have a new stage server system where all servers were just promoted to
Win2003, and SQL 2000 on the data server box.
I understand that I need to put the reporting services on my IIS box. That
has .NET 2003 run time and SP applied.
When I attempt to install Reporting Services I get a lame error back about
lacking resources. This is the Reporting 2000 version. What am I missing?
TIA
__StephenWhat is the error? Please copy in the exact error message, and it's easier
to help. :) What resources are missing?
Have you installed Internet Information Services on your RS box? WIthout IIS
you won't get far with RS.
Kaisa M. Lindahl
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:OddBAscHGHA.1132@.TK2MSFTNGP10.phx.gbl...
>I wanted to test drive the reporting services against Crystal.
> I have a new stage server system where all servers were just promoted to
> Win2003, and SQL 2000 on the data server box.
> I understand that I need to put the reporting services on my IIS box.
> That has .NET 2003 run time and SP applied.
> When I attempt to install Reporting Services I get a lame error back about
> lacking resources. This is the Reporting 2000 version. What am I
> missing?
> TIA
> __Stephen
>

Required free eBook on Reporting Services 2005.

Hello Friends,

I am in need of eBook on Reporting Services 2005 for study perpose, Please guide me through any link.

Thanks,

Vishal.

Don't know of any ebooks, however I think the most thorough set of tutorials is here:

http://www.databasejournal.com/article.php/1459531

Cheers
Mark
|||The Books On Line help file is a good place to start.|||

Hello Mark,

Thanks for this link, it is very helpful to me.

Bye.

Required free eBook on Reporting Services 2005.

Hello Friends,

I am in need of eBook on Reporting Services 2005 for study perpose, Please guide me through any link.

Thanks,

Vishal.

Don't know of any ebooks, however I think the most thorough set of tutorials is here:

http://www.databasejournal.com/article.php/1459531

Cheers
Mark
|||The Books On Line help file is a good place to start.|||

Hello Mark,

Thanks for this link, it is very helpful to me.

Bye.

Required free eBook on Reporting Services 2005.

Hello Friends,

I am in need of eBook on Reporting Services 2005 for study perpose, Please guide me through any link.

Thanks,

Vishal.

Don't know of any ebooks, however I think the most thorough set of tutorials is here:

http://www.databasejournal.com/article.php/1459531

Cheers
Mark
|||The Books On Line help file is a good place to start.|||

Hello Mark,

Thanks for this link, it is very helpful to me.

Bye.

Reprting services on XP

Hi,
Which combination of sql server and Reprting services do I need on winxp? (I
mean which version of RS and which version of SQL serevr)The system requirements are listed on
http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp but basically
you need the Developer Edition of both, which means that it can't be put
into production.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Ray Alirezaei" <ray@.my.com> wrote in message
news:uJdqc%23e6EHA.2452@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Which combination of sql server and Reprting services do I need on winxp?
> (I mean which version of RS and which version of SQL serevr)
>

Reprting Services 2000 Printing

Hi,
I am using Reporting services 2000 in asp.net application.Everything is working fine ,but when I am trying to get a print using Internet Explorer Printing options ,the toolbar of the report is also coming into the print preview.I want to get rid of it.I want only the report no toolbar.
Can anybody help me?
Thanks!!I am not sure if IE Printing options will allow you to do that. You might need to write some code to do that. I'll see if I can cook up something for you if I get the time.

repoting services charts rendering

Hi Guys
Can any body help me for this problem.
I am having a table and two charts. These charts are places one below
the other. When ever i view the report the first chart shows up fine at
the side of the table. But the other chart which was placed below the
first chart shows up after the table. Dont know why. Is there any way
so that i can fix the position of this second chart so that it can show
immediately after the first chart instead of showing after the table .
The table is a drill down table and and when ever i drill down the data
the second chart also moves down accordingly again ending up showing
after the first table.
Can anybody help me with this problem.....Add a rectangle to whichever side of the table you want the charts to
appear, and place both of your charts within the rectangle. This will
group the two charts together, and as long as the page layout is set so
the charts and table both fit horizontally, should solve the problem
you are having.
Passx wrote:
> Hi Guys
> Can any body help me for this problem.
> I am having a table and two charts. These charts are places one below
> the other. When ever i view the report the first chart shows up fine at
> the side of the table. But the other chart which was placed below the
> first chart shows up after the table. Dont know why. Is there any way
> so that i can fix the position of this second chart so that it can show
> immediately after the first chart instead of showing after the table .
> The table is a drill down table and and when ever i drill down the data
> the second chart also moves down accordingly again ending up showing
> after the first table.
> Can anybody help me with this problem.....|||Topher wrote:
> Add a rectangle to whichever side of the table you want the charts to
> appear, and place both of your charts within the rectangle. This will
> group the two charts together, and as long as the page layout is set so
> the charts and table both fit horizontally, should solve the problem
> you are having.
>
> Passx wrote:
> > Hi Guys
> >
> > Can any body help me for this problem.
> >
> > I am having a table and two charts. These charts are places one below
> > the other. When ever i view the report the first chart shows up fine at
> > the side of the table. But the other chart which was placed below the
> > first chart shows up after the table. Dont know why. Is there any way
> > so that i can fix the position of this second chart so that it can show
> > immediately after the first chart instead of showing after the table .
> > The table is a drill down table and and when ever i drill down the data
> > the second chart also moves down accordingly again ending up showing
> > after the first table.
> >
> > Can anybody help me with this problem.....

Repoting Services

I have a question.

Can I hide columns or fields , when there are too many fields in the data set . I want to take all fields but hide some in preview tab.Please somebody help me on this.

Thanks

Sudha

You can set the Hidden property to true. you can do this at the column level, and it will not show up.

BobP

ReportWriter - Soft Artisans

Anyone have any comments on using SoftArtisans ReportWriter that allows
Word/Excel users to write reports and publish to Reporting Services?
Is it very expensive?
is it worth it?"dm1608" wrote:
> Anyone have any comments on using SoftArtisans ReportWriter that allows
> Word/Excel users to write reports and publish to Reporting Services?
Ha! Funny, see a few subject headings down from this post regarding "Excel
reports to RS."
> Is it very expensive?
>
Yes.
> is it worth it?
>
Not really sure yet. I'm asking the same question, although in finer
granularity.
All the best!
Greg--|||"dm1608" wrote:
> Anyone have any comments on using SoftArtisans ReportWriter that allows
> Word/Excel users to write reports and publish to Reporting Services?
> Is it very expensive?
yes, it is expensive.. 7.500 Euro per cpu
> is it worth it?
no, you must redesign all your reports using ms word with the softartisans
addin, if you want to export the reports to word...
And by the Way, i mean the Support by softartisans ist very bad|||So we have SQL Reporting Services in SQL 2000 and 2005. The feature matrix
on SQL 2005 says rendering formats for output are the same: Excel, PDF,
DHTML, images... but still no support for Word.
Does this mean Microsoft itself is shying away from its own product, Word,
by not offering native support within SQL RS? Is there a new industry
standard in word processing that I need to be looking at?
I find it truly mind-boggling for Microsoft to not export to Excel, XML,
even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be the
only tool available... ?
Any other products out there?
Thanks,
Andrew Puente
"cwalloch" wrote:
>
> "dm1608" wrote:
> > Anyone have any comments on using SoftArtisans ReportWriter that allows
> > Word/Excel users to write reports and publish to Reporting Services?
> >
> > Is it very expensive?
> yes, it is expensive.. 7.500 Euro per cpu
> >
> > is it worth it?
> no, you must redesign all your reports using ms word with the softartisans
> addin, if you want to export the reports to word...
> And by the Way, i mean the Support by softartisans ist very bad|||And before I get crucified, let me revise my last paragraph:
I find it truly mind-boggling for Microsoft to export to Excel, XML,
even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be the
only tool available... ?
It's called Proofreading 101. I failed that course, apparently. :-)
Cheers,
Andrew Puente
"Andrew Puente" wrote:
> So we have SQL Reporting Services in SQL 2000 and 2005. The feature matrix
> on SQL 2005 says rendering formats for output are the same: Excel, PDF,
> DHTML, images... but still no support for Word.
> Does this mean Microsoft itself is shying away from its own product, Word,
> by not offering native support within SQL RS? Is there a new industry
> standard in word processing that I need to be looking at?
> I find it truly mind-boggling for Microsoft to not export to Excel, XML,
> even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be the
> only tool available... ?
> Any other products out there?
> Thanks,
> Andrew Puente
> "cwalloch" wrote:
> >
> >
> > "dm1608" wrote:
> >
> > > Anyone have any comments on using SoftArtisans ReportWriter that allows
> > > Word/Excel users to write reports and publish to Reporting Services?
> > >
> > > Is it very expensive?
> > yes, it is expensive.. 7.500 Euro per cpu
> >
> > >
> > > is it worth it?
> > no, you must redesign all your reports using ms word with the softartisans
> > addin, if you want to export the reports to word...
> > And by the Way, i mean the Support by softartisans ist very bad|||I suspect that XPS format and office 12 xml formats will be supported when
released.
--
William Stacey [MVP]
"Andrew Puente" <AndrewPuente@.discussions.microsoft.com> wrote in message
news:1B3A18C9-17C9-4135-B367-5E05253C067A@.microsoft.com...
> And before I get crucified, let me revise my last paragraph:
> I find it truly mind-boggling for Microsoft to export to Excel, XML,
> even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be
> the
> only tool available... ?
> It's called Proofreading 101. I failed that course, apparently. :-)
> Cheers,
> Andrew Puente
>
> "Andrew Puente" wrote:
>> So we have SQL Reporting Services in SQL 2000 and 2005. The feature
>> matrix
>> on SQL 2005 says rendering formats for output are the same: Excel, PDF,
>> DHTML, images... but still no support for Word.
>> Does this mean Microsoft itself is shying away from its own product,
>> Word,
>> by not offering native support within SQL RS? Is there a new industry
>> standard in word processing that I need to be looking at?
>> I find it truly mind-boggling for Microsoft to not export to Excel, XML,
>> even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be
>> the
>> only tool available... ?
>> Any other products out there?
>> Thanks,
>> Andrew Puente
>> "cwalloch" wrote:
>> >
>> >
>> > "dm1608" wrote:
>> >
>> > > Anyone have any comments on using SoftArtisans ReportWriter that
>> > > allows
>> > > Word/Excel users to write reports and publish to Reporting Services?
>> > >
>> > > Is it very expensive?
>> > yes, it is expensive.. 7.500 Euro per cpu
>> >
>> > >
>> > > is it worth it?
>> > no, you must redesign all your reports using ms word with the
>> > softartisans
>> > addin, if you want to export the reports to word...
>> > And by the Way, i mean the Support by softartisans ist very bad

reportviewer: code the windows credentials

I have bought a hosting service for reporting services. The server definitions are set to windows authentication.

I'm using a small application and each time I access a report, a windows prompt asks for the username and password. I would like to avoid this message.

How should I pass the credentials through this application and the reportviewer control (which I use) to the server in order to avoid having to insert the user details in the prompt. This application is to be used by several users and they shouldn't need to insert the account's information.

thank you for a quick reply.

There is no way to add credentials to the report viewer.

Does your local login map to a login on the server at all? If so, Internet Explorer only sends credentials automatically to servers in the Intranet zone, but you can have it automatically send credentials to your host.

You could mark your host as a trusted site (Tools -> Internet Options -> Security), and then tell IE to send credentials automatically to sites in the trusted zone. With Trusted Zones highlighted in the tab, click "Custom Level". Scroll down to the bottom and select "automatic login with current username and password".

|||This can be done. First create a class called ReportServerCredentials that implements the IReportServerCredentials interface. You will need to import System.Net and Microsoft.Reporting.WebForms to this class. Overload the New and GetFormsCredentials methods and the NetworkCredentials and ImpersonationUser properties. Here's a class that I use:

Imports Microsoft.VisualBasic
Imports Microsoft.Reporting.WebForms
Imports System.Net

Public Class ReportServerCredentials
Implements IReportServerCredentials

Private _userName As String
Private _password As String
Private _domain As String

Public Sub New(ByVal userName As String, ByVal password As String, ByVal domain As String)
_userName = userName
_password = password
_domain = domain
End Sub

Public ReadOnly Property ImpersonationUser() As System.Security.Principal.WindowsIdentity Implements Microsoft.Reporting.WebForms.IReportServerCredentials.ImpersonationUser
Get
Return Nothing
End Get
End Property

Public ReadOnly Property NetworkCredentials() As ICredentials Implements Microsoft.Reporting.WebForms.IReportServerCredentials.NetworkCredentials
Get
Return New NetworkCredential(_userName, _password, _domain)
End Get
End Property

Public Function GetFormsCredentials(ByRef authCookie As System.Net.Cookie, ByRef userName As String, ByRef password As String, ByRef authority As String) As Boolean Implements Microsoft.Reporting.WebForms.IReportServerCredentials.GetFormsCredentials
userName = _userName
password = _password
authority = _domain
Return Nothing
End Function
End Class

Next, in the OnLoad of your page with the ReportViewer control, create a new instance of your ReportServerCredentials (I use values stored in AppSettings). Then assign your object to the ReportViewer control's ServerReport.ReportServerCredentials property.

Dim cred As New ReportServerCredentials(ConfigurationManager.AppSettings("MyStoredUser"),_
ConfigurationManager.AppSettings("MyStoredPassword"), _
ConfigurationManager.AppSettings("MyStoredDomain"))

MyReportViewerControl.ServerReport.ReportServerCredentials = cred

A few things can break though-- referenced images on your reports won't render, and you can't use integrated security in your SSRS data sources, unless the account you are impersonating has access to the data as well as SSRS.
|||

Code Salad,

My immeasurable thanks. After three days of searching, your solution was the one that finally got my reports running

|||

It seems CodeSalad's code worked. Can someone explain how it works? Where do I add the code? I am having the same problem. I am using Framework 2.0. Thanks.

DanYeung

|||

I think these links will be helpful -

http://blogs.msdn.com/bimusings/archive/2005/11/18/494436.aspx

http://msdn2.microsoft.com/en-us/library/aa983458(VS.80).aspx

|||

Danyeng,

U have to add a new class file in the app_Code directory

|||

The links and the sample code are very helpful. I still need more help on this. How do I get the ReportViewer control? I am opening the report without using ReportView control. I added the attribute to the button to open the report with Javascript. If I use the ReportViewer control, do I have to open the report differently and how? Thanks.

DanYeung

|||

this is how u doing it.

create a new aspx page and add the report viewer control to ur page by going View Menu -> Toolbox and in the toolbox look under Data.. and then in the properties window, Select the processingmode i.e Remote or local and also specify the report path...

and then in the aspx.vb page in Page_Load sub give this code.

ReportViewer1.ProcessingMode = ProcessingMode.Remote ReportViewer1.ShowCredentialPrompts =True'ReportViewer1.ShowExportControls = False ReportViewer1.ServerReport.ReportServerCredentials =New ReportServerCredentials() ReportViewer1.ServerReport.ReportServerUrl =New Uri("http://IPAddress/ReportServer") ReportViewer1.ServerReport.ReportPath ="/FolderName/Mainrdlfilename" ReportViewer1.ServerReport.Refresh()

ReportViewer1.ServerReport.ReportServerCredentials =New ReportServerCredentials() -- ReportServerCredentials is the base class name of the class that u put in the app_code folder

Hope this helps.

Regards,

Karen

|||

Thanks Karen. I am getting closer. I received the following error:

The path of the item '/Pages/ReportViewer.aspx?nsPortalReports.rptIssuesByRole&rs:Command=Render&intProjectID=119&RunBy=DanYeung' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)

The report is located in the different project with the same solution. nsPortalReports is the project name and rptIssuesByRole is the report name. What is wrong in the path? Thanks.

DanYeung

|||

is ur report stored in the report server? and if ur reports are stored in the report server is there any kinda directory structure in it...

if u answer this questions may be i can give u a better answer.

Regards

Karen

|||

Yes, I deployed the reports to the report server. Thanks.

DanYeung

|||

are u able to run the reports using the report viewer...

Since ur reports are in the report server just give the path as i have given and it should work... if u need to pass any parameters to the report also let me know i will help u out..

Regards

Karen

|||

How do I run the report using ReportViewer? Yes, I have to pass parameters. So I am not supposed pass parameters in the ReportPath? Is my path correct?

ReportViewer1.ServerReport.ReportPath = "/Pages/ReportViewer.aspx?nsPortalReports.rptIssuesByRole&rs:Command=Render&intProjectID=" & cboProject.SelectedValue & "&RunBy=" & Session("strEmployeeName")

Thanks.

DanYeung

|||

your report Path doesnt Look right to me.

Instead of specifying the report Path... Specify a the ReportServerURL so that u can access ur report server directly. and the url will behttp://IpAddress/ReportServer.

take a look at this code as to how to specify the parameters and the report Path

ReportViewer1.ProcessingMode = ProcessingMode.Remote ReportViewer1.ShowCredentialPrompts =True ReportViewer1.ShowExportControls =False ReportViewer1.ServerReport.ReportServerCredentials =New ReportServerCredentials() ReportViewer1.ServerReport.ReportServerUrl =New Uri("http://IPAddress/ReportServer") s =CType(PreviousPage.FindControl("ddlReportType"), DropDownList).SelectedItem.ValueIf (s ="/Statements/StatementMain")Then ReportViewer1.ServerReport.ReportPath ="/Statements/StatementMain"Dim ClientIDAs String = Session("ClientId")Dim param(0)As Microsoft.Reporting.WebForms.ReportParameter'param(0) = New Microsoft.Reporting.WebForms.ReportParameter("PeriodId", "") param(0) =New Microsoft.Reporting.WebForms.ReportParameter("ClientId", ClientID,False) ReportViewer1.ServerReport.SetParameters(param)ReportViewer1.ServerReport.Refresh()End If

u can omit the parameters so that u can directly set them while u run the reports.Hope this helps.

Regards,

Karen

ReportViewer with Authentication

I'm new to Reporting Services but have built some reports and have implemented them. I have used the report viewer which works great and has a great tool bar that users really like. One problem, I can't figure out how to pass network credentials using the viewer.

If I use the ReportingService class I can pass the credentials and everything is great except that I lose the nice tool bar.

I want the best of both worlds without having th build my own toolbar. This must have been done before but I can't seem to find any samples.

So is there a way to pass credentials (Basic Authentication over SSL) while still using the nivce features from the ReportViewer.

Or

Is there a different ReportViewer that has this capability.

Any help will be greatly appreciated.

ThanksDoes anyone have any info on this? Does a ReportViewer control with the ability to pass credentials exist or do I need to create my own?

Thanks,
|||the short answer is "yes".

the devil is in the details...
are you using rs 2000 or 2005 ?
if 2005 I am also trying to get the details down.

I did some work with rs 2000 and see that a lot is the same but the winforms control is new and I hear they "made things better" but so far found few samples of how to get from "A" to "B".
I do know that there are two calls that deal with auth, one to pass data-source credentials and one to pass in "access" credentials.

the access bits seem to have several options.

when I was doing some hacking throuhg they did not seem to work.

I think that was due to messing with the report server and hosing it's settings.

right now I am building a test-lab with a local server and a Virtual PC to run my client app.

I hope I can get a sample working and share....

|||I'm using RS 2000. We may go to 2005 in the future but the immediate need is for 2000.

|||

mcatet wrote:

I'm using RS 2000. We may go to 2005 in the future but the immediate need is for 2000.

Ok, a few things:

1) you want to use *WINDOWS* credentails
2) look at the docs and as I recall you will see that you needs to create an object and then attach it to your calls.... System.Net.NetworkCredentails
you can create one with user,pass,domain and then pass that to the web services at key points.

I am working 2005 now so I'm not readig the 2000 docs right now but I think that the above will start you in the right direction....|||Ok. So with windows credentials setup on the ReportServer web folder, I just need a windows domain account on the server (LocalServerDomain\RSExec). Then pass those credentials.

I have that part working using the ReportingServices class.

What would be really nice is if I could use the Microsoft ReportViewer control for my reports (because I like the appearance of it) while still passing the credentils to it. The ReprotingServices class has a viewer toolbar but it doesn't look as nice.

Is this possible, and if so, do you have sample code I could look at?

Thanks for your help.

|||Just keeping this up front so people see it.

Anyone else have an additional info pertaining to an RS2000 ReportViewer with authentication being passed?

Thanks,
|||I am using RS2005.
IF i call ReportingService2005 web service, i know how i can use windows credentails. for this i use NetworkCredentails. However, i couldnt find out how i can set reportviewer credentails to windows credentails.
Could u help me?|||

Looks like this has been sitting around for a little while:

for SSL - set the URL of the ReportViewer control to start with https.

for specifying the credentials to use, you should use the IReportServerCredentials Interface

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.winforms.ireportservercredentials.aspx

Hope that helps,

-Lukasz

ReportViewer with Authentication

I'm new to Reporting Services but have built some reports and have implemented them. I have used the report viewer which works great and has a great tool bar that users really like. One problem, I can't figure out how to pass network credentials using the viewer.

If I use the ReportingService class I can pass the credentials and everything is great except that I lose the nice tool bar.

I want the best of both worlds without having th build my own toolbar. This must have been done before but I can't seem to find any samples.

So is there a way to pass credentials (Basic Authentication over SSL) while still using the nivce features from the ReportViewer.

Or

Is there a different ReportViewer that has this capability.

Any help will be greatly appreciated.

ThanksDoes anyone have any info on this? Does a ReportViewer control with the ability to pass credentials exist or do I need to create my own?

Thanks,
|||the short answer is "yes".

the devil is in the details...
are you using rs 2000 or 2005 ?
if 2005 I am also trying to get the details down.

I did some work with rs 2000 and see that a lot is the same but the winforms control is new and I hear they "made things better" but so far found few samples of how to get from "A" to "B".
I do know that there are two calls that deal with auth, one to pass data-source credentials and one to pass in "access" credentials.

the access bits seem to have several options.

when I was doing some hacking throuhg they did not seem to work.

I think that was due to messing with the report server and hosing it's settings.

right now I am building a test-lab with a local server and a Virtual PC to run my client app.

I hope I can get a sample working and share....

|||I'm using RS 2000. We may go to 2005 in the future but the immediate need is for 2000.

|||

mcatet wrote:

I'm using RS 2000. We may go to 2005 in the future but the immediate need is for 2000.

Ok, a few things:

1) you want to use *WINDOWS* credentails
2) look at the docs and as I recall you will see that you needs to create an object and then attach it to your calls.... System.Net.NetworkCredentails
you can create one with user,pass,domain and then pass that to the web services at key points.

I am working 2005 now so I'm not readig the 2000 docs right now but I think that the above will start you in the right direction....|||Ok. So with windows credentials setup on the ReportServer web folder, I just need a windows domain account on the server (LocalServerDomain\RSExec). Then pass those credentials.

I have that part working using the ReportingServices class.

What would be really nice is if I could use the Microsoft ReportViewer control for my reports (because I like the appearance of it) while still passing the credentils to it. The ReprotingServices class has a viewer toolbar but it doesn't look as nice.

Is this possible, and if so, do you have sample code I could look at?

Thanks for your help.

|||Just keeping this up front so people see it.

Anyone else have an additional info pertaining to an RS2000 ReportViewer with authentication being passed?

Thanks,
|||I am using RS2005.
IF i call ReportingService2005 web service, i know how i can use windows credentails. for this i use NetworkCredentails. However, i couldnt find out how i can set reportviewer credentails to windows credentails.
Could u help me?|||

Looks like this has been sitting around for a little while:

for SSL - set the URL of the ReportViewer control to start with https.

for specifying the credentials to use, you should use the IReportServerCredentials Interface

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.winforms.ireportservercredentials.aspx

Hope that helps,

-Lukasz

ReportViewer with Authentication

I'm new to Reporting Services but have built some reports and have implemented them. I have used the report viewer which works great and has a great tool bar that users really like. One problem, I can't figure out how to pass network credentials using the viewer.

If I use the ReportingService class I can pass the credentials and everything is great except that I lose the nice tool bar.

I want the best of both worlds without having th build my own toolbar. This must have been done before but I can't seem to find any samples.

So is there a way to pass credentials (Basic Authentication over SSL) while still using the nivce features from the ReportViewer.

Or

Is there a different ReportViewer that has this capability.

Any help will be greatly appreciated.

ThanksDoes anyone have any info on this? Does a ReportViewer control with the ability to pass credentials exist or do I need to create my own?

Thanks,
|||the short answer is "yes".

the devil is in the details...
are you using rs 2000 or 2005 ?
if 2005 I am also trying to get the details down.

I did some work with rs 2000 and see that a lot is the same but the winforms control is new and I hear they "made things better" but so far found few samples of how to get from "A" to "B".
I do know that there are two calls that deal with auth, one to pass data-source credentials and one to pass in "access" credentials.

the access bits seem to have several options.

when I was doing some hacking throuhg they did not seem to work.

I think that was due to messing with the report server and hosing it's settings.

right now I am building a test-lab with a local server and a Virtual PC to run my client app.

I hope I can get a sample working and share....

|||I'm using RS 2000. We may go to 2005 in the future but the immediate need is for 2000.

|||

mcatet wrote:

I'm using RS 2000. We may go to 2005 in the future but the immediate need is for 2000.

Ok, a few things:

1) you want to use *WINDOWS* credentails
2) look at the docs and as I recall you will see that you needs to create an object and then attach it to your calls.... System.Net.NetworkCredentails
you can create one with user,pass,domain and then pass that to the web services at key points.

I am working 2005 now so I'm not readig the 2000 docs right now but I think that the above will start you in the right direction....|||Ok. So with windows credentials setup on the ReportServer web folder, I just need a windows domain account on the server (LocalServerDomain\RSExec). Then pass those credentials.

I have that part working using the ReportingServices class.

What would be really nice is if I could use the Microsoft ReportViewer control for my reports (because I like the appearance of it) while still passing the credentils to it. The ReprotingServices class has a viewer toolbar but it doesn't look as nice.

Is this possible, and if so, do you have sample code I could look at?

Thanks for your help.

|||Just keeping this up front so people see it.

Anyone else have an additional info pertaining to an RS2000 ReportViewer with authentication being passed?

Thanks,
|||I am using RS2005.
IF i call ReportingService2005 web service, i know how i can use windows credentails. for this i use NetworkCredentails. However, i couldnt find out how i can set reportviewer credentails to windows credentails.
Could u help me?|||

Looks like this has been sitting around for a little while:

for SSL - set the URL of the ReportViewer control to start with https.

for specifying the credentials to use, you should use the IReportServerCredentials Interface

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.winforms.ireportservercredentials.aspx

Hope that helps,

-Lukasz