Replacing Null values in query

Hello,

I'm using the query wizard in VB.net to write a query for SQL CE. I want to replace null values with text. I expected the COALESCE function to do this but I get an error message saying its not a valid function. This is a sample.

Select COALESCE(table.Name,'No Name') as Name from table

Any help appreciated

Thanks

Wouldn't ISNULL() do the trick for you?|||I'm connected to SQL compact. isnull() will only return a logical value. NVL doesn't work in SQL compact and when I use coalesce the editor bangs square brackets around it and returns an error message|||

You can use something like

SELECT CASE WHEN c1 IS NULL THEN 'No name' ELSE c1 END AS EXPR1
FROM t1

COALESCE not being recognized by querydesigner looks like a bug. I'll log it. Thanks for reporting!

|||

Pragya Agarwal [MSFT] wrote:

COALESCE not being recognized by querydesigner looks like a bug. I'll log it. Thanks for reporting!

I checked in the newer Visual Studio 'Orcas' builds and this bug has already been fixed :- ).

|||

Many thanks for your help

Replace LoginName control with other data fields from aspnetdb.mdf

I currently have a LoginStatus and LoginName control on my asp.net 2.0 master page. When successfully logged in a message displays "You are logged in as" LoginName. Since I am using the user's e-mail address as the UserName the message will display as "You are logged in as johndoe@.foo.com".

What I want to do is have the message display as "You are logged in as " FirstName LastName. FirstName and LastName are two new fields that I added to the table, aspnet_Users.

What I have done is to use the FormView control to display FirstName and LastName; however this always displays the first record in the aspnetdb database.

Is there a cleaner way (than the FormView control) to display the requested data, using the currently logged in user? I have access to Microsoft Expression Web and Visual Studio 2005, but I prefer Expression Web.

Thank you in advance

Hi,

From your description, it seems that you want to get the FirstName and LastName field for the logon user, right?

If so, I think you can get the current user's name by using User.Identity.Name, and then, invoke the GetUser method of Membership with the current user's name, which can return a MembershipUser typed object. You can access the data filed in the membership tables.

Thanks.

Replace Access with a .NET front end and SQL Backend solution.

My company currently has about 20-25 Ms Access Database that they want to
replace the FE with .net and the BE on SQL.

This will be done using Visual Studio 2005. Once the FE is converted to .net
and the BE is SQL they all will be accessed through our intranet (sharepoint).

I work in Ms Access and intermediate at VBA and just learing SQL through the
ENTERPRISE MANAGER SCREEN.
I am just now looking at what Visual Studio 2005 is, but can some one tell me
how this will all connect?

What is the typical route for this process?

Ms access to SQL - upsizing wizard or SQL importing???

Ms Access FE to .net - summarize how this is done in visual studio (user face
rebuilt) then placed on sharepoint?

Can anyone sum this up?

--
Message posted via http://www.sqlmonster.comAnns via SQLMonster.com (u22580@.uwe) writes:

Quote:

Originally Posted by

I work in Ms Access and intermediate at VBA and just learing SQL through
the ENTERPRISE MANAGER SCREEN.

Enterprise Manager is a tool that exists only in SQL 2000, and I assume
- and hope! - that you will implement your new solution on SQL 2005. The
tool in SQL 2005 is SQL Server Management Studio which replaces both
Enterprise Manager and Query Analyzer. As long as you work with SQL 2000,
QA should be your main tool, because it is from this tool you most easily
can run queries. EM may look a little like Access, so you may feel com-
fortable with that. However, SQL Server is very different from Access,
so best is to use a tool that forces you to unlearn a lot things.

Quote:

Originally Posted by

I am just now looking at what Visual Studio 2005 is, but can some one
tell me how this will all connect?
>
What is the typical route for this process?
>
>
Ms access to SQL - upsizing wizard or SQL importing???

Yes, there is an upsizing wizard. And the word that I have from people
who have worked extensively with both Access and SQL Server is that you
should stay away from it. Access and SQL Server are very different and
build on different mindset. You should more or less redesign your
application for SQL Server and .Net. This may seem like a lot more work
that you had expected, but it is likely to pay off in the long run with
lower maintenance costs, if you do it right from the start.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||SQL 2005 - SQL Server Managment Studio, thank you, when I said I was
currently learning I am learning unfortunately on 2000 b/c that is the study
material I bought and cannot afford to upgrade right now.

You are right with the SQL 2000 Enterprise edition, it is so user friendly
and that edition is all I know and still learning at best with that.

Yes, my company will be doing this on 2005 but for now, my learning is on
2000.
You see I work in a another department besides IT and between that job/baby
and small buisness, I am trying to get my DBA (2000) certification, I would
like the upgrade (2005) but do not have the funds to upgrade.
I have an opportunity to help with this conversion process and learn in
between, but I am trying to get a better grasp of this before sinking.

Does the 2005 Managment Studio look alot like Enterprise manager?
Answer:

Ms Access to SQL - I am assuming your answer would then be exporting/dts tool
from SQL to pull over all these db's?
Answer:

Erland, tell me once the db's are pull over to SQL, now I have Visual Studio
2005 software open - what steps are taken in this software to rebuilt the
user faces and then how is it then put on SHAREPOINT????
ANSWER:

Erland Sommarskog wrote:

Quote:

Originally Posted by

Quote:

Originally Posted by

>I work in Ms Access and intermediate at VBA and just learing SQL through
>the ENTERPRISE MANAGER SCREEN.

>
>Enterprise Manager is a tool that exists only in SQL 2000, and I assume
>- and hope! - that you will implement your new solution on SQL 2005. The
>tool in SQL 2005 is SQL Server Management Studio which replaces both
>Enterprise Manager and Query Analyzer. As long as you work with SQL 2000,
>QA should be your main tool, because it is from this tool you most easily
>can run queries. EM may look a little like Access, so you may feel com-
>fortable with that. However, SQL Server is very different from Access,
>so best is to use a tool that forces you to unlearn a lot things.
>

Quote:

Originally Posted by

>I am just now looking at what Visual Studio 2005 is, but can some one
>tell me how this will all connect?
>>
>What is the typical route for this process?
>>
>Ms access to SQL - upsizing wizard or SQL importing???

>
>Yes, there is an upsizing wizard. And the word that I have from people
>who have worked extensively with both Access and SQL Server is that you
>should stay away from it. Access and SQL Server are very different and
>build on different mindset. You should more or less redesign your
>application for SQL Server and .Net. This may seem like a lot more work
>that you had expected, but it is likely to pay off in the long run with
>lower maintenance costs, if you do it right from the start.
>

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forum...eneral/200607/1|||Anns via SQLMonster.com (u22580@.uwe) writes:

Quote:

Originally Posted by

SQL 2005 - SQL Server Managment Studio, thank you, when I said I was
currently learning I am learning unfortunately on 2000 b/c that is the
study material I bought and cannot afford to upgrade right now.

You can download the Evaluation Edition of SQL 2005 from
http://www.microsoft.com/downloads/...FA7F-C094-49A2-
A050-2D07993566EC&displaylang=en.

Even if your study material only covers SQL 2000, I still think you
should work with SQL 2005.

Quote:

Originally Posted by

You are right with the SQL 2000 Enterprise edition, it is so user friendly
and that edition is all I know and still learning at best with that.

Enterprise Manager != Enterprise Edition. Enterprise Manager is available
in all editions of SQL 2000, except for the desktop version MSDE. The
difference between the editions lies in what features that are available,
and what purpose the edition is licensed for.

Quote:

Originally Posted by

Does the 2005 Managment Studio look alot like Enterprise manager?

It's not completely different, but there are also considerable differences.
In the end, you will only do yourself a disservice by learning a tool
that you will not work with.

But Enterprise Manager and SQL Server Management Studio are just the
tools. These are not what you should focus your learning on. You should
learn how to create databases, tables and indexes, and how to write
queries. You may think that you know SQL from Access, but as I said,
there are considerable differences. In general, SQL Server offers much
more powerful constructs, but there also features from Access that
are completely missing. A classic example is dynamic crosstabs.

Quote:

Originally Posted by

Ms Access to SQL - I am assuming your answer would then be exporting/dts
tool from SQL to pull over all these db's?

Maybe. As I said, I think you should consider a major redesign, at
least in places where you have some quirks in Access, or in places
where SQL Server offers better solutions. Then again, even if you go
for a new schema, it may of course be a good idea bring over the
Access databases to SQL Server, so that you can work with them locally.
And for that end SQL Server Integration Services (which is the successor
to DTS in SQL 2005) may be a good choice. (I've never worked with
neither DTS nor SSIS, so I don't really know.)

Quote:

Originally Posted by

Erland, tell me once the db's are pull over to SQL, now I have Visual
Studio 2005 software open - what steps are taken in this software to
rebuilt the user faces and then how is it then put on
SHAREPOINT????

Since you are migrating from Access to .Net, I would assume that you
more or less rewrite the front-end code entirely, but you should ask in a
..Net forum about that.

Sharepoint? I know there is a product with that name, but I have very
little idea what it's good for. So I cannot answer that question.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||A great walk thru / how to on the MS Access to SQL Server 2005 was
blogged. I tried it and made my life much easier.

http://cfpayne.wordpress.com/2006/0...ql-server-2005/
Precia

Anns via SQLMonster.com wrote:

Quote:

Originally Posted by

My company currently has about 20-25 Ms Access Database that they want to
replace the FE with .net and the BE on SQL.
>
>
This will be done using Visual Studio 2005. Once the FE is converted to .net
and the BE is SQL they all will be accessed through our intranet (sharepoint).
>
>
I work in Ms Access and intermediate at VBA and just learing SQL through the
ENTERPRISE MANAGER SCREEN.
I am just now looking at what Visual Studio 2005 is, but can some one tell me
how this will all connect?
>
What is the typical route for this process?
>
>
Ms access to SQL - upsizing wizard or SQL importing???
>
>
>
Ms Access FE to .net - summarize how this is done in visual studio (user face
rebuilt) then placed on sharepoint?
>
>
Can anyone sum this up?
>
--
Message posted via http://www.sqlmonster.com

Repl works on VPN, not via internet

I am trying to setup a process in a VB.Net app that allows the user to manually invoke a transactional replication process. This works fine on my development machine within our network/VPN. However, when I disconnect my machine from the VPN, the process
keeps failing with a "Process could not connect to Distributor" error. Unfortunately, our customers/users will not be in our domain...they need to be able to connect & replicate over the internet.
Here is the current setup:
Server
Windows 2003 Server
Sql Server 2000 (sp3)
Client
Windows 2000 Pro or Windows XP Pro
MSDE
Also...from within the network I have to use only the server's name "MyServer" to get this to work. If I use a fully qualified name, like "MyServer.Domain.Com" it fails with the same error.
The server acts as both the publisher and the distributor. The publication is set up to allow anonymous pull subscriptions via FTP. I have a sql login that I have setup and made sure that it is in the Publications PAL.
I have used this example: http://support.microsoft.com/default...;en-us;Q319648 to create the .net process.
From a client machine...I can access the ftp site on the server via:
ftp Server.Domain.Com.
I cannot get to the server with Ping or Tracert. I was told by our network admin that the ability to Ping our server has been disabled.
I think that this must be a server configuration problem...since I can get the whole thing to work when I am on the network. I checked the log files (based on a suggestion from another post) on the server...and it doesn't even appear that a login is attem
pted.
Does anyone have any other suggestions?
thanks
when you are using a vpn you are able to authenticate using NT
authentication. This won't work over the internet. You will have to change
how you are authenticating for this to work.
If you can ftp you have connectivity.
Make the following changes
oSnap.PublisherSecurityMode = SQLINITXLib.SECURITY_TYPE.NT_AUTHENTICATION
to
oSnap.PublisherSecurityMode = SQLINITXLib.SECURITY_TYPE.DB_AUTHENTICATION
oSnap.PublisherPassword="password"
oSnap.PublisherLogin="account"
change
oSnap.DistributorSecurityMode =
SQLINITXLib.SECURITY_TYPE.NT_AUTHENTICATION
to
oSnap.DistributorSecurityMode =
SQLINITXLib.SECURITY_TYPE.DB_AUTHENTICATION
oSnap.DistributorPassword="password"
oSnap.DistributorLogin="account"
Repeat these changes everywhere you see NT_AUTHENTICATION.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"dd" <dd@.discussions.microsoft.com> wrote in message
news:BBA7CF14-42B4-417C-8C4D-A422D520EA0B@.microsoft.com...
> I am trying to setup a process in a VB.Net app that allows the user to
manually invoke a transactional replication process. This works fine on my
development machine within our network/VPN. However, when I disconnect my
machine from the VPN, the process keeps failing with a "Process could not
connect to Distributor" error. Unfortunately, our customers/users will not
be in our domain...they need to be able to connect & replicate over the
internet.
> Here is the current setup:
> Server
> Windows 2003 Server
> Sql Server 2000 (sp3)
> Client
> Windows 2000 Pro or Windows XP Pro
> MSDE
> Also...from within the network I have to use only the server's name
"MyServer" to get this to work. If I use a fully qualified name, like
"MyServer.Domain.Com" it fails with the same error.
> The server acts as both the publisher and the distributor. The
publication is set up to allow anonymous pull subscriptions via FTP. I have
a sql login that I have setup and made sure that it is in the Publications
PAL.
> I have used this example:
http://support.microsoft.com/default...;en-us;Q319648 to create
the .net process.
> From a client machine...I can access the ftp site on the server via:
> ftp Server.Domain.Com.
> I cannot get to the server with Ping or Tracert. I was told by our
network admin that the ability to Ping our server has been disabled.
> I think that this must be a server configuration problem...since I can get
the whole thing to work when I am on the network. I checked the log files
(based on a suggestion from another post) on the server...and it doesn't
even appear that a login is attempted.
> Does anyone have any other suggestions?
> thanks
|||Hilary...
Thanks for the reply. It is good to know that if I can connect via ftp I am doing something right.
Actually, I already made those changes to the example code...changing from NT to DB authentication in each place it was occuring. Though...even on our VPN, I had to change the login and password to the "sa" account so it would work.
We do have a firewall...not sure if that is the problem. And...another note...I have another application running on a PocketPC (with the .Net Compact Framework) that is successful in a merge replication over the internet without using "sa" account...and
it is on the same database I am using for my transactional one that is failing.
"Hilary Cotter" wrote:

> when you are using a vpn you are able to authenticate using NT
> authentication. This won't work over the internet. You will have to change
> how you are authenticating for this to work.
> If you can ftp you have connectivity.
> Make the following changes
> oSnap.PublisherSecurityMode = SQLINITXLib.SECURITY_TYPE.NT_AUTHENTICATION
> to
> oSnap.PublisherSecurityMode = SQLINITXLib.SECURITY_TYPE.DB_AUTHENTICATION
> oSnap.PublisherPassword="password"
> oSnap.PublisherLogin="account"
> change
> oSnap.DistributorSecurityMode =
> SQLINITXLib.SECURITY_TYPE.NT_AUTHENTICATION
> to
> oSnap.DistributorSecurityMode =
> SQLINITXLib.SECURITY_TYPE.DB_AUTHENTICATION
> oSnap.DistributorPassword="password"
> oSnap.DistributorLogin="account"
> Repeat these changes everywhere you see NT_AUTHENTICATION.
>
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "dd" <dd@.discussions.microsoft.com> wrote in message
> news:BBA7CF14-42B4-417C-8C4D-A422D520EA0B@.microsoft.com...
> manually invoke a transactional replication process. This works fine on my
> development machine within our network/VPN. However, when I disconnect my
> machine from the VPN, the process keeps failing with a "Process could not
> connect to Distributor" error. Unfortunately, our customers/users will not
> be in our domain...they need to be able to connect & replicate over the
> internet.
> "MyServer" to get this to work. If I use a fully qualified name, like
> "MyServer.Domain.Com" it fails with the same error.
> publication is set up to allow anonymous pull subscriptions via FTP. I have
> a sql login that I have setup and made sure that it is in the Publications
> PAL.
> http://support.microsoft.com/default...;en-us;Q319648 to create
> the .net process.
> network admin that the ability to Ping our server has been disabled.
> the whole thing to work when I am on the network. I checked the log files
> (based on a suggestion from another post) on the server...and it doesn't
> even appear that a login is attempted.
>
>

Renders with missing data

Anyone seen a situation where a report displays fine using VS.net, but when
you go to render via HTML -- the data shows up incomplete, it has blank cells
in the table'
Any ideas?
Confused as all heck --
JimHello, Jim.
I would assume that your HTML is correct and that there is blank data.
In VS.Net when you use Preview it actually grabs a copy of the data and
caches it for all subsequent previews. So your preview may be working
off older data while your HTML view is going to be working off live
data.
To test this you can delete your cache file. In the directory where
your report.rdl file is there should be another file called
report.rdl.data. Delete this file and the Report Designer will be
forced to rerun the queries.
Regards,
Shane
Jim_OLAP wrote:
> Anyone seen a situation where a report displays fine using VS.net, but when
> you go to render via HTML -- the data shows up incomplete, it has blank cells
> in the table'
> Any ideas?
> Confused as all heck --
> Jim|||Shane,
It actually had to do with security on the cubes, once I opened the
securityfor the cubes -- the data magically popped showed up!!
Thanks,
Jim
"ShaneC" wrote:
> Hello, Jim.
> I would assume that your HTML is correct and that there is blank data.
> In VS.Net when you use Preview it actually grabs a copy of the data and
> caches it for all subsequent previews. So your preview may be working
> off older data while your HTML view is going to be working off live
> data.
> To test this you can delete your cache file. In the directory where
> your report.rdl file is there should be another file called
> report.rdl.data. Delete this file and the Report Designer will be
> forced to rerun the queries.
> Regards,
> Shane
> Jim_OLAP wrote:
> > Anyone seen a situation where a report displays fine using VS.net, but when
> > you go to render via HTML -- the data shows up incomplete, it has blank cells
> > in the table'
> >
> > Any ideas?
> >
> > Confused as all heck --
> >
> > Jim
>

Rendering the ASP.NET local report directly to PDF

Hi,

Since it is not possible to print from a local report in ASP.Net is there anyway to directly render to a PDF or hide the Local report rendering and automatically goto the PDF either in the web page or as a popup.

Thanks

Hi,

You can try this code:

string path = @."D:/Folder/MyFile.pdf";
WebClient client = new WebClient();
Byte[] buffer = client.DownloadData(path);

if (buffer != null)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-length",buffer.Length.ToString());
Response.BinaryWrite(buffer);
}

Hope this helps,

Vivek

|||

Can this be done on a report on a server and a parameter is passed?

For example, when a button is clicked in a page, then it will pass a parameter to SSRS and then, in turn, returns a PDF file. (So there's no need for a report viewer)

I am not sure if its possible. Please advise. Thanks!

Lloyd

|||

Lloyd,

How are you returning the PDF file? SSRS will return only data (I do not have much experience in SSRS), I have worked on Crystal Reports and it exported idrectly to PDF.

If you have data then you can format and show it to PDF. You can change the Response.ContentType as I mentioned before or use some tools like:

http://www.websupergoo.com/abcpdf-1.htm

Hope this helps,

Vivek

|||

Hi!

Thanks for the reply!

I'm thinking if this can be done. When I click the "Print" button, the report will be generated (PDF), and the standard pop up message of browser would come up, asking if the user would want to open or save the generated file.

Lloyd

|||

Lloyd,

You can first call the SSRS on the Print button click and then bind the resulting data to some data bound control, such as a DataGrid or GridView. After the bind, you can change the Response.ContentType property to "pdf". See my blog entry for details:

http://geekswithblogs.com/vivek

You can also try an Open Source PDF Report Server Control:http://sourceforge.net/projects/npdf/

Hope this helps,

Vivek

|||

Try this:

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()

Dim rs As New msfirm_db_stl.ReportingService
'rs.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim myCred As New NetworkCredential("Username", "Password", "Domain")
rs.Credentials = myCred

' Render arguments
Dim result As Byte() = Nothing
Dim reportPath As String = "/ImportedReports/" & Me.ReportName
Dim format As String = Me.ReportFormat
Dim historyID As String = Nothing
Dim devInfo As String = "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>"

' Prepare report parameter.
Dim params() As String
params = Me.Parameters.Split("&")
Dim nParams As Integer = 0
Dim parameters() As msfirm_db_stl.ParameterValue
If params.Length > 0 And Me.Parameters <> String.Empty Then
ReDim parameters(IIf(params.Length > 0, params.Length - 1, 0))
For Each s As String In params
If s <> String.Empty Then
Dim keyval() As String = s.Split("=")
parameters(nParams) = New msfirm_db_stl.ParameterValue
parameters(nParams).Name = keyval(0)
parameters(nParams).Value = keyval(1)
nParams += 1
End If
Next
End If

Dim testparms() As msfirm_db_stl.ReportParameter = rs.GetReportParameters(reportPath, historyID, False, Nothing, Nothing)
If (testparms.Length.ToString) <> (nParams.ToString) Then
Response.Redirect(ConfigurationSettings.AppSettings.Get("ReportServerURL") & "?%2fImportedReports%2f" & Me.ReportName & "&rs%3aCommand=Render&rs%3aFormat=HTML4.0&rc%3aToolbar=True&rc%3aJavaScript=True")
End If

'Set Web Service user credentials
Dim credentials As msfirm_db_stl.DataSourceCredentials() = Nothing
Dim showHideToggle As String = Nothing
Dim encoding As String
Dim mimeType As String
Dim warnings As msfirm_db_stl.Warning() = Nothing
Dim reportHistoryParameters As msfirm_db_stl.ParameterValue() = Nothing
Dim streamIDs As String() = Nothing
Dim sh As New msfirm_db_stl.SessionHeader
rs.SessionHeaderValue = sh

Try
result = rs.Render(reportPath, format, historyID, devInfo, parameters, credentials, showHideToggle, encoding, mimeType, reportHistoryParameters, warnings, streamIDs)
sh.SessionId = rs.SessionHeaderValue.SessionId
Catch ex As SoapException

End Try
'' Write the contents of the report to an MHTML file.
Try
Response.Buffer = True
Select Case Me.ReportFormat
Case "EXCEL"
Response.ContentType = "application/vnd.ms-excel"
Case "HTML4.0", "HTMLOWC"
Response.ContentType = "text/html"
Case "PDF"
Response.ContentType = "Application/PDF"
End Select

'Response.AddHeader("Content-Disposition", "attachment;filename=" & Me.ReportName & ".pdf")
Response.BinaryWrite(result)
Catch ex As Exception

End Try
End Sub

Rendering Reports Straight to the Printer

I've read in the BOL that you can render a report straight to a printer using
render in your VB.Net code, but there are not any examples. I believe it has
something to do with the deviceinfo parameter of the render method. Can
anyone help please?Take a look at http://www.csharphelp.com/archives3/archive545.html.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike Collins" <Mike Collins@.discussions.microsoft.com> wrote in message
news:0EA9C306-7556-4C38-824E-2CB38F3D1837@.microsoft.com...
> I've read in the BOL that you can render a report straight to a printer
using
> render in your VB.Net code, but there are not any examples. I believe it
has
> something to do with the deviceinfo parameter of the render method. Can
> anyone help please?

Rendering report in ASP.Net

I am now trying to render a report in ASP.Net using the reporting service
web service.
When I use the render function I get a SOAP exception ...
The permissions granted to user '"Server1\ASPNET' are insufficient for
performing this operation.
This same code runs fine in a windows form, but I want a web form.
What permissions does this user need to have?
Regards RichardGive the user sufficient permissions via Report Manager.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Wrench" <rwrench@.icsecurity.com> wrote in message
news:u%23d8zL0cEHA.3480@.TK2MSFTNGP11.phx.gbl...
> I am now trying to render a report in ASP.Net using the reporting service
> web service.
> When I use the render function I get a SOAP exception ...
> The permissions granted to user '"Server1\ASPNET' are insufficient for
> performing this operation.
> This same code runs fine in a windows form, but I want a web form.
> What permissions does this user need to have?
> Regards Richard
>
>
>|||Thanks again Ravi
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:uzJCKd0cEHA.2812@.tk2msftngp13.phx.gbl...
> Give the user sufficient permissions via Report Manager.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Richard Wrench" <rwrench@.icsecurity.com> wrote in message
> news:u%23d8zL0cEHA.3480@.TK2MSFTNGP11.phx.gbl...
> > I am now trying to render a report in ASP.Net using the reporting
service
> > web service.
> >
> > When I use the render function I get a SOAP exception ...
> > The permissions granted to user '"Server1\ASPNET' are insufficient for
> > performing this operation.
> >
> > This same code runs fine in a windows form, but I want a web form.
> > What permissions does this user need to have?
> >
> > Regards Richard
> >
> >
> >
> >
> >
>