I can't seem to hit on the right combination of roles/persimssions to
set against the Report Server in order to allow my localhost
implementation to access/browse/upload reports. Is there some deFacto
setting(s) that I should be using?
After installation I was able to upload and browse. The trouble
started when I tried to instantiate a ReportingService object (I
wanted to be able to programatically browse the available reports -
previously uploaded). When I tried this I got an insufficient
privilege error for my generic internet user account. After having
tried a number of combinations I'm really stuck.
Any help appreciated! (how-to links, diagrams, recipes,...)
GlennGlenn,
The right question in this case is "Under what identity am I trying to call
the RS Web service?". For example, if it is from a WinForm app, you need to
set proxy credentials to DefaultCredentials, as follows:
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
Please review the "Using the SOAP API in a Windows Application" and "Using
the SOAP API in a Web Application" for more info.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
news:bc4291aa.0408121414.5d18bff0@.posting.google.com...
> I can't seem to hit on the right combination of roles/persimssions to
> set against the Report Server in order to allow my localhost
> implementation to access/browse/upload reports. Is there some deFacto
> setting(s) that I should be using?
> After installation I was able to upload and browse. The trouble
> started when I tried to instantiate a ReportingService object (I
> wanted to be able to programatically browse the available reports -
> previously uploaded). When I tried this I got an insufficient
> privilege error for my generic internet user account. After having
> tried a number of combinations I'm really stuck.
> Any help appreciated! (how-to links, diagrams, recipes,...)
> Glenn|||Teo, thanks for the response. I have read several of these how-to
articles (and have attempted to implement the code for my
application/WEB page). That's where I encounter the problems.
The article, which you reference, suggests adding impersonation to the
web.config... - already did that. It suggests setting the
ReportingService object credentials to the Default... - already did
that. There's not much else in the article (or others). What I'm
looking for is a little expertise on WEB/IIS 6.0 setup for using the
SQL Reporting Services in a XP Pro, VB.Net 1.1, SQL 2000 environment.
This can't that big a deal - but I'm swamped with other project issues
and have not had the time to research. I'm hoping that someone has
already gone through this and is willing to do some knowledge-sharing.
Thanks,
Glenn
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message news:<eNMBbwMgEHA.396@.TK2MSFTNGP12.phx.gbl>...
> Glenn,
> The right question in this case is "Under what identity am I trying to call
> the RS Web service?". For example, if it is from a WinForm app, you need to
> set proxy credentials to DefaultCredentials, as follows:
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> Please review the "Using the SOAP API in a Windows Application" and "Using
> the SOAP API in a Web Application" for more info.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
> news:bc4291aa.0408121414.5d18bff0@.posting.google.com...
> > I can't seem to hit on the right combination of roles/persimssions to
> > set against the Report Server in order to allow my localhost
> > implementation to access/browse/upload reports. Is there some deFacto
> > setting(s) that I should be using?
> >
> > After installation I was able to upload and browse. The trouble
> > started when I tried to instantiate a ReportingService object (I
> > wanted to be able to programatically browse the available reports -
> > previously uploaded). When I tried this I got an insufficient
> > privilege error for my generic internet user account. After having
> > tried a number of combinations I'm really stuck.
> >
> > Any help appreciated! (how-to links, diagrams, recipes,...)
> >
> > Glenn|||Hi Glenn:
What is the exact error message you get? Is it access denied, or is it
'USERNAME does not have the required permissions' type of error? Do
you have authentication in web.config set to windows and deny
anonymous acess?
I have some information here:
Authentication, Role-based Security, and SQL Reporting Services Web
Services
http://odetocode.com/Articles/216.aspx
Introduction To Role-Based Security In SQL Server Reporting Services
http://odetocode.com/Articles/215.aspx
--
Scott
http://www.OdeToCode.com
On 13 Aug 2004 04:36:02 -0700, gowens@.nixonpeabody.com (Glenn Owens)
wrote:
>Teo, thanks for the response. I have read several of these how-to
>articles (and have attempted to implement the code for my
>application/WEB page). That's where I encounter the problems.
>The article, which you reference, suggests adding impersonation to the
>web.config... - already did that. It suggests setting the
>ReportingService object credentials to the Default... - already did
>that. There's not much else in the article (or others). What I'm
>looking for is a little expertise on WEB/IIS 6.0 setup for using the
>SQL Reporting Services in a XP Pro, VB.Net 1.1, SQL 2000 environment.
>This can't that big a deal - but I'm swamped with other project issues
>and have not had the time to research. I'm hoping that someone has
>already gone through this and is willing to do some knowledge-sharing.
>Thanks,
>Glenn
>sql
Showing posts with label report. Show all posts
Showing posts with label report. Show all posts
Friday, March 30, 2012
Need help ASAP with calendar datetime popup
I have a report created in ssrs. In the sql t script I used the between @.startdate and @.enddate statement for a parameter. In my report parameters dropdown I selected the timedate as my datatype. The report works fine if view it from my developement server the calander loads ok. When I view it from any other system the calender Icon is present but with not work. Any suggestions. Is there anything that needs to be put into the webconfig file to make this work. Javascript??
Hi,
Post your code. Someone will have a look at it.
HTH,
Suprotim Agarwal
--
http://www.dotnetcurry.com
--
Need help ASAP 3414 error SQL 2005 Developer Edition
Hello ,
This morning I was running a report in my ssrs and I had a power failure. My Machine rebooted and I can not connect to my database below is the error log can some one tell me what I need to do to recover I really do not want to have to reinstall everything if possible.
2007-06-15 07:59:49.88 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2007-06-15 07:59:49.88 Server (c) 2005 Microsoft Corporation.
2007-06-15 07:59:49.88 Server All rights reserved.
2007-06-15 07:59:49.88 Server Server process ID is 1600.
2007-06-15 07:59:49.88 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-06-15 07:59:49.90 Server This instance of SQL Server last reported using a process ID of 880 at 6/14/2007 5:36:25 PM (local) 6/14/2007 9:36:25 PM (UTC). This is an informational message only; no user action is required.
2007-06-15 07:59:49.90 Server Registry startup parameters:
2007-06-15 07:59:49.90 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-06-15 07:59:49.90 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-06-15 07:59:49.90 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-06-15 07:59:50.01 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-06-15 07:59:50.01 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-06-15 07:59:50.36 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-06-15 07:59:50.46 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-06-15 07:59:51.16 Server The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality, please start this service.
2007-06-15 07:59:51.25 Server Database Mirroring Transport is disabled in the endpoint configuration.
2007-06-15 07:59:51.29 spid5s Starting up database 'master'.
2007-06-15 07:59:51.70 spid5s WARNING: did not see LOP_CKPT_END.
2007-06-15 07:59:51.70 spid5s Error: 3414, Severity: 21, State: 2.
2007-06-15 07:59:51.70 spid5s An error occurred during recovery, preventing the database 'master' (database ID 1) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
2007-06-15 07:59:51.70 spid5s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
The error message pretty much tells you what to do. It tellsyou to look at the SQL Server books online, it gives you an error code to look up.
A quick search of Google gives a link to Microsoft's support page, which should lead you in the right direction:
http://support.microsoft.com/kb/306366
sqlWednesday, March 28, 2012
Need Help (replication)
Dear All,
I have 2 DB Server, OLTP Server and Report Server.
I want to replicate some tables from OLTP Server to Report Server.
The distributor Database is on Report Server bcos I don't to slow down
the performance of OLTP Server.
But every time the replication is running, the error (see attachement)
always occur on OLTP Server.
Pls somebody give my some suggestion.
Thanks
Robert LieRobert,
Are there triggers on the tables being replicated? If so, do the triggers
need to be executed again on the subscriber? Not sure if this is the cause
of your error but it might be related.
HTH
Jerry
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:u2VvQxMxFHA.736@.tk2msftngp13.phx.gbl...
> Dear All,
> I have 2 DB Server, OLTP Server and Report Server.
> I want to replicate some tables from OLTP Server to Report Server.
> The distributor Database is on Report Server bcos I don't to slow down
> the performance of OLTP Server.
> But every time the replication is running, the error (see attachement)
> always occur on OLTP Server.
> Pls somebody give my some suggestion.
> Thanks
> Robert Lie
>
----
--|||Since I need to use IE to use these forums, I cant see the attached error
file. Please post it.
--
TIA,
ChrisR
"Robert Lie" wrote:
> Dear All,
> I have 2 DB Server, OLTP Server and Report Server.
> I want to replicate some tables from OLTP Server to Report Server.
> The distributor Database is on Report Server bcos I don't to slow down
> the performance of OLTP Server.
> But every time the replication is running, the error (see attachement)
> always occur on OLTP Server.
> Pls somebody give my some suggestion.
> Thanks
> Robert Lie
>|||Here's the error:
Run-time error '-2147217900 (80040e14)'
Maximum soted procedure, function, trigger, or view nesting level
exceeded (limit32)
ChrisR wrote:
> Since I need to use IE to use these forums, I cant see the attached error
> file. Please post it.|||Hai Jerry,
You're right, some tables being replicated have triggers on them.
The problem is I need the triggers to be executed on OTLP server since
the triggers are needed to maintain data integrity of applications that
run on OLTP server.
Do you have alternatives solution on top of that?
Thanks
Robert Lie
Jerry Spivey wrote:
> Robert,
> Are there triggers on the tables being replicated? If so, do the triggers
> need to be executed again on the subscriber? Not sure if this is the caus
e
> of your error but it might be related.
> HTH
> Jerry
> "Robert Lie" <robert.lie24@.gmail.com> wrote in message
> news:u2VvQxMxFHA.736@.tk2msftngp13.phx.gbl...
>
>
> ----
--
>
>
>|||True but are replicating the triggers as well or creating them on the
subscriber(s)? Something to look into.
HTH
Jerry
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:eWomXVXxFHA.2620@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hai Jerry,
> You're right, some tables being replicated have triggers on them.
> The problem is I need the triggers to be executed on OTLP server since the
> triggers are needed to maintain data integrity of applications that run on
> OLTP server.
> Do you have alternatives solution on top of that?
> Thanks
> Robert Lie
> Jerry Spivey wrote:|||Do you mean I'm replicating the triggers to subcriber server (Report
Server) as well or not?
No, I'm not replicating the triggers to subcriber.
Which part do you worry about?
Thanks
Robert Lie
Jerry Spivey wrote:
> True but are replicating the triggers as well or creating them on the
> subscriber(s)? Something to look into.
> HTH
> Jerry
> "Robert Lie" <robert.lie24@.gmail.com> wrote in message
> news:eWomXVXxFHA.2620@.TK2MSFTNGP09.phx.gbl...
>
>|||Robert,
I was looking at the possible cause of your issue being related to the fact
that there might be triggers on the subscriber tables that could possibly be
causing this issue. Are there triggers on the subscribing tables
(sp_helptrigger tablename at subscriber)? Are they required? As a test
what if you removed them (one at a time with a retest)? Agan..I am not
saying this is definitely the cause but it might be.
HTH
Jerry
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:OZjVHYYxFHA.2620@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Do you mean I'm replicating the triggers to subcriber server (Report
> Server) as well or not?
> No, I'm not replicating the triggers to subcriber.
> Which part do you worry about?
> Thanks
> Robert Lie
>
> Jerry Spivey wrote:
I have 2 DB Server, OLTP Server and Report Server.
I want to replicate some tables from OLTP Server to Report Server.
The distributor Database is on Report Server bcos I don't to slow down
the performance of OLTP Server.
But every time the replication is running, the error (see attachement)
always occur on OLTP Server.
Pls somebody give my some suggestion.
Thanks
Robert LieRobert,
Are there triggers on the tables being replicated? If so, do the triggers
need to be executed again on the subscriber? Not sure if this is the cause
of your error but it might be related.
HTH
Jerry
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:u2VvQxMxFHA.736@.tk2msftngp13.phx.gbl...
> Dear All,
> I have 2 DB Server, OLTP Server and Report Server.
> I want to replicate some tables from OLTP Server to Report Server.
> The distributor Database is on Report Server bcos I don't to slow down
> the performance of OLTP Server.
> But every time the replication is running, the error (see attachement)
> always occur on OLTP Server.
> Pls somebody give my some suggestion.
> Thanks
> Robert Lie
>
----
--|||Since I need to use IE to use these forums, I cant see the attached error
file. Please post it.
--
TIA,
ChrisR
"Robert Lie" wrote:
> Dear All,
> I have 2 DB Server, OLTP Server and Report Server.
> I want to replicate some tables from OLTP Server to Report Server.
> The distributor Database is on Report Server bcos I don't to slow down
> the performance of OLTP Server.
> But every time the replication is running, the error (see attachement)
> always occur on OLTP Server.
> Pls somebody give my some suggestion.
> Thanks
> Robert Lie
>|||Here's the error:
Run-time error '-2147217900 (80040e14)'
Maximum soted procedure, function, trigger, or view nesting level
exceeded (limit32)
ChrisR wrote:
> Since I need to use IE to use these forums, I cant see the attached error
> file. Please post it.|||Hai Jerry,
You're right, some tables being replicated have triggers on them.
The problem is I need the triggers to be executed on OTLP server since
the triggers are needed to maintain data integrity of applications that
run on OLTP server.
Do you have alternatives solution on top of that?
Thanks
Robert Lie
Jerry Spivey wrote:
> Robert,
> Are there triggers on the tables being replicated? If so, do the triggers
> need to be executed again on the subscriber? Not sure if this is the caus
e
> of your error but it might be related.
> HTH
> Jerry
> "Robert Lie" <robert.lie24@.gmail.com> wrote in message
> news:u2VvQxMxFHA.736@.tk2msftngp13.phx.gbl...
>
>
> ----
--
>
>
>|||True but are replicating the triggers as well or creating them on the
subscriber(s)? Something to look into.
HTH
Jerry
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:eWomXVXxFHA.2620@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hai Jerry,
> You're right, some tables being replicated have triggers on them.
> The problem is I need the triggers to be executed on OTLP server since the
> triggers are needed to maintain data integrity of applications that run on
> OLTP server.
> Do you have alternatives solution on top of that?
> Thanks
> Robert Lie
> Jerry Spivey wrote:|||Do you mean I'm replicating the triggers to subcriber server (Report
Server) as well or not?
No, I'm not replicating the triggers to subcriber.
Which part do you worry about?
Thanks
Robert Lie
Jerry Spivey wrote:
> True but are replicating the triggers as well or creating them on the
> subscriber(s)? Something to look into.
> HTH
> Jerry
> "Robert Lie" <robert.lie24@.gmail.com> wrote in message
> news:eWomXVXxFHA.2620@.TK2MSFTNGP09.phx.gbl...
>
>|||Robert,
I was looking at the possible cause of your issue being related to the fact
that there might be triggers on the subscriber tables that could possibly be
causing this issue. Are there triggers on the subscribing tables
(sp_helptrigger tablename at subscriber)? Are they required? As a test
what if you removed them (one at a time with a retest)? Agan..I am not
saying this is definitely the cause but it might be.
HTH
Jerry
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:OZjVHYYxFHA.2620@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Do you mean I'm replicating the triggers to subcriber server (Report
> Server) as well or not?
> No, I'm not replicating the triggers to subcriber.
> Which part do you worry about?
> Thanks
> Robert Lie
>
> Jerry Spivey wrote:
Need Help (replication)
Dear All,
I have 2 DB Server, OLTP Server and Report Server.
I want to replicate some tables from OLTP Server to Report Server.
The distributor Database is on Report Server bcos I don't to slow down
the performance of OLTP Server.
But every time the replication is running, the error (see attachement)
always occur on OLTP Server.
Pls somebody give my some suggestion.
Thanks
Robert Lie
Robert,
Are there triggers on the tables being replicated? If so, do the triggers
need to be executed again on the subscriber? Not sure if this is the cause
of your error but it might be related.
HTH
Jerry
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:u2VvQxMxFHA.736@.tk2msftngp13.phx.gbl...
> Dear All,
> I have 2 DB Server, OLTP Server and Report Server.
> I want to replicate some tables from OLTP Server to Report Server.
> The distributor Database is on Report Server bcos I don't to slow down
> the performance of OLTP Server.
> But every time the replication is running, the error (see attachement)
> always occur on OLTP Server.
> Pls somebody give my some suggestion.
> Thanks
> Robert Lie
>
|||Since I need to use IE to use these forums, I cant see the attached error
file. Please post it.
TIA,
ChrisR
"Robert Lie" wrote:
> Dear All,
> I have 2 DB Server, OLTP Server and Report Server.
> I want to replicate some tables from OLTP Server to Report Server.
> The distributor Database is on Report Server bcos I don't to slow down
> the performance of OLTP Server.
> But every time the replication is running, the error (see attachement)
> always occur on OLTP Server.
> Pls somebody give my some suggestion.
> Thanks
> Robert Lie
>
|||Here's the error:
Run-time error '-2147217900 (80040e14)'
Maximum soted procedure, function, trigger, or view nesting level
exceeded (limit32)
ChrisR wrote:
> Since I need to use IE to use these forums, I cant see the attached error
> file. Please post it.
|||Hai Jerry,
You're right, some tables being replicated have triggers on them.
The problem is I need the triggers to be executed on OTLP server since
the triggers are needed to maintain data integrity of applications that
run on OLTP server.
Do you have alternatives solution on top of that?
Thanks
Robert Lie
Jerry Spivey wrote:
> Robert,
> Are there triggers on the tables being replicated? If so, do the triggers
> need to be executed again on the subscriber? Not sure if this is the cause
> of your error but it might be related.
> HTH
> Jerry
> "Robert Lie" <robert.lie24@.gmail.com> wrote in message
> news:u2VvQxMxFHA.736@.tk2msftngp13.phx.gbl...
>
>
> ----
>
>
>
|||True but are replicating the triggers as well or creating them on the
subscriber(s)? Something to look into.
HTH
Jerry
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:eWomXVXxFHA.2620@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hai Jerry,
> You're right, some tables being replicated have triggers on them.
> The problem is I need the triggers to be executed on OTLP server since the
> triggers are needed to maintain data integrity of applications that run on
> OLTP server.
> Do you have alternatives solution on top of that?
> Thanks
> Robert Lie
> Jerry Spivey wrote:
|||Do you mean I'm replicating the triggers to subcriber server (Report
Server) as well or not?
No, I'm not replicating the triggers to subcriber.
Which part do you worry about?
Thanks
Robert Lie
Jerry Spivey wrote:
> True but are replicating the triggers as well or creating them on the
> subscriber(s)? Something to look into.
> HTH
> Jerry
> "Robert Lie" <robert.lie24@.gmail.com> wrote in message
> news:eWomXVXxFHA.2620@.TK2MSFTNGP09.phx.gbl...
>
>
|||Robert,
I was looking at the possible cause of your issue being related to the fact
that there might be triggers on the subscriber tables that could possibly be
causing this issue. Are there triggers on the subscribing tables
(sp_helptrigger tablename at subscriber)? Are they required? As a test
what if you removed them (one at a time with a retest)? Agan..I am not
saying this is definitely the cause but it might be.
HTH
Jerry
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:OZjVHYYxFHA.2620@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Do you mean I'm replicating the triggers to subcriber server (Report
> Server) as well or not?
> No, I'm not replicating the triggers to subcriber.
> Which part do you worry about?
> Thanks
> Robert Lie
>
> Jerry Spivey wrote:
I have 2 DB Server, OLTP Server and Report Server.
I want to replicate some tables from OLTP Server to Report Server.
The distributor Database is on Report Server bcos I don't to slow down
the performance of OLTP Server.
But every time the replication is running, the error (see attachement)
always occur on OLTP Server.
Pls somebody give my some suggestion.
Thanks
Robert Lie
Robert,
Are there triggers on the tables being replicated? If so, do the triggers
need to be executed again on the subscriber? Not sure if this is the cause
of your error but it might be related.
HTH
Jerry
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:u2VvQxMxFHA.736@.tk2msftngp13.phx.gbl...
> Dear All,
> I have 2 DB Server, OLTP Server and Report Server.
> I want to replicate some tables from OLTP Server to Report Server.
> The distributor Database is on Report Server bcos I don't to slow down
> the performance of OLTP Server.
> But every time the replication is running, the error (see attachement)
> always occur on OLTP Server.
> Pls somebody give my some suggestion.
> Thanks
> Robert Lie
>
|||Since I need to use IE to use these forums, I cant see the attached error
file. Please post it.
TIA,
ChrisR
"Robert Lie" wrote:
> Dear All,
> I have 2 DB Server, OLTP Server and Report Server.
> I want to replicate some tables from OLTP Server to Report Server.
> The distributor Database is on Report Server bcos I don't to slow down
> the performance of OLTP Server.
> But every time the replication is running, the error (see attachement)
> always occur on OLTP Server.
> Pls somebody give my some suggestion.
> Thanks
> Robert Lie
>
|||Here's the error:
Run-time error '-2147217900 (80040e14)'
Maximum soted procedure, function, trigger, or view nesting level
exceeded (limit32)
ChrisR wrote:
> Since I need to use IE to use these forums, I cant see the attached error
> file. Please post it.
|||Hai Jerry,
You're right, some tables being replicated have triggers on them.
The problem is I need the triggers to be executed on OTLP server since
the triggers are needed to maintain data integrity of applications that
run on OLTP server.
Do you have alternatives solution on top of that?
Thanks
Robert Lie
Jerry Spivey wrote:
> Robert,
> Are there triggers on the tables being replicated? If so, do the triggers
> need to be executed again on the subscriber? Not sure if this is the cause
> of your error but it might be related.
> HTH
> Jerry
> "Robert Lie" <robert.lie24@.gmail.com> wrote in message
> news:u2VvQxMxFHA.736@.tk2msftngp13.phx.gbl...
>
>
> ----
>
>
>
|||True but are replicating the triggers as well or creating them on the
subscriber(s)? Something to look into.
HTH
Jerry
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:eWomXVXxFHA.2620@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hai Jerry,
> You're right, some tables being replicated have triggers on them.
> The problem is I need the triggers to be executed on OTLP server since the
> triggers are needed to maintain data integrity of applications that run on
> OLTP server.
> Do you have alternatives solution on top of that?
> Thanks
> Robert Lie
> Jerry Spivey wrote:
|||Do you mean I'm replicating the triggers to subcriber server (Report
Server) as well or not?
No, I'm not replicating the triggers to subcriber.
Which part do you worry about?
Thanks
Robert Lie
Jerry Spivey wrote:
> True but are replicating the triggers as well or creating them on the
> subscriber(s)? Something to look into.
> HTH
> Jerry
> "Robert Lie" <robert.lie24@.gmail.com> wrote in message
> news:eWomXVXxFHA.2620@.TK2MSFTNGP09.phx.gbl...
>
>
|||Robert,
I was looking at the possible cause of your issue being related to the fact
that there might be triggers on the subscriber tables that could possibly be
causing this issue. Are there triggers on the subscribing tables
(sp_helptrigger tablename at subscriber)? Are they required? As a test
what if you removed them (one at a time with a retest)? Agan..I am not
saying this is definitely the cause but it might be.
HTH
Jerry
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:OZjVHYYxFHA.2620@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Do you mean I'm replicating the triggers to subcriber server (Report
> Server) as well or not?
> No, I'm not replicating the triggers to subcriber.
> Which part do you worry about?
> Thanks
> Robert Lie
>
> Jerry Spivey wrote:
Need Help !- [Apply] & [OK] buttons wont work in Report Manager
After installing RS, none of the [OK] or {apply] buttons work to make any
security or config changes.
When i click on them nothing at all happens.Do you have anonymous access enabled for the website. Report Manager does
not allow any administrative type functionality as anonymous.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:eaBXkQ84FHA.1864@.TK2MSFTNGP12.phx.gbl...
> After installing RS, none of the [OK] or {apply] buttons work to make any
> security or config changes.
> When i click on them nothing at all happens.
>
>|||No Anonymous allowed.
As a last troubleshooting step i did a default install of IIS, enabled
ASP.Net, Installed RS. Installed RS SP
I am running RS 2000, on Windows 2003
I need to make this work, anu other ideas ?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uUDCIr84FHA.3416@.TK2MSFTNGP15.phx.gbl...
> Do you have anonymous access enabled for the website. Report Manager does
> not allow any administrative type functionality as anonymous.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
> news:eaBXkQ84FHA.1864@.TK2MSFTNGP12.phx.gbl...
>> After installing RS, none of the [OK] or {apply] buttons work to make any
>> security or config changes.
>> When i click on them nothing at all happens.
>>
>|||By default the only user that has these rights have to be part of the
administors group on the server (the local group). You can have other
local/domain groups with a role to do this but you need to do it. Have you
tried from the server logged in as administrator (or as someone in the
administrators group?)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:OA4GFv84FHA.2616@.TK2MSFTNGP12.phx.gbl...
> No Anonymous allowed.
> As a last troubleshooting step i did a default install of IIS, enabled
> ASP.Net, Installed RS. Installed RS SP
> I am running RS 2000, on Windows 2003
> I need to make this work, anu other ideas ?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uUDCIr84FHA.3416@.TK2MSFTNGP15.phx.gbl...
>> Do you have anonymous access enabled for the website. Report Manager does
>> not allow any administrative type functionality as anonymous.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
>> news:eaBXkQ84FHA.1864@.TK2MSFTNGP12.phx.gbl...
>> After installing RS, none of the [OK] or {apply] buttons work to make
>> any security or config changes.
>> When i click on them nothing at all happens.
>>
>>
>|||I had the same problem and here's what I did to fix it. Apparently, my
IIS was configured so that the ASP_NET's webuivalidation.js wasn't able
to load. This somehow prevented any of the buttons on the ReportServer
to work.
And I fixed it based on the same advice given to you by Bruce here. I
think what he means you should TURN ON Anonymous access.
Give this a try...see if you can point your browser to:
http://your-root/aspnet_client/system_web/1_1_4322/WebUIValidation.js
and see if you can see it. (assuming you're using the same version
ASP.NET I am).
I fixed it by going into my IIS settings -> Directory Security -> and
checking the box "Anonymous Access."
David J. Cartwright wrote:
> No Anonymous allowed.
> As a last troubleshooting step i did a default install of IIS, enabled
> ASP.Net, Installed RS. Installed RS SP
> I am running RS 2000, on Windows 2003
> I need to make this work, anu other ideas ?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uUDCIr84FHA.3416@.TK2MSFTNGP15.phx.gbl...
>>Do you have anonymous access enabled for the website. Report Manager does
>>not allow any administrative type functionality as anonymous.
>>
>>--
>>Bruce Loehle-Conger
>>MVP SQL Server Reporting Services
>>"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
>>news:eaBXkQ84FHA.1864@.TK2MSFTNGP12.phx.gbl...
>>After installing RS, none of the [OK] or {apply] buttons work to make any
>>security or config changes.
>>When i click on them nothing at all happens.
>>
>>
>
security or config changes.
When i click on them nothing at all happens.Do you have anonymous access enabled for the website. Report Manager does
not allow any administrative type functionality as anonymous.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:eaBXkQ84FHA.1864@.TK2MSFTNGP12.phx.gbl...
> After installing RS, none of the [OK] or {apply] buttons work to make any
> security or config changes.
> When i click on them nothing at all happens.
>
>|||No Anonymous allowed.
As a last troubleshooting step i did a default install of IIS, enabled
ASP.Net, Installed RS. Installed RS SP
I am running RS 2000, on Windows 2003
I need to make this work, anu other ideas ?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uUDCIr84FHA.3416@.TK2MSFTNGP15.phx.gbl...
> Do you have anonymous access enabled for the website. Report Manager does
> not allow any administrative type functionality as anonymous.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
> news:eaBXkQ84FHA.1864@.TK2MSFTNGP12.phx.gbl...
>> After installing RS, none of the [OK] or {apply] buttons work to make any
>> security or config changes.
>> When i click on them nothing at all happens.
>>
>|||By default the only user that has these rights have to be part of the
administors group on the server (the local group). You can have other
local/domain groups with a role to do this but you need to do it. Have you
tried from the server logged in as administrator (or as someone in the
administrators group?)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:OA4GFv84FHA.2616@.TK2MSFTNGP12.phx.gbl...
> No Anonymous allowed.
> As a last troubleshooting step i did a default install of IIS, enabled
> ASP.Net, Installed RS. Installed RS SP
> I am running RS 2000, on Windows 2003
> I need to make this work, anu other ideas ?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uUDCIr84FHA.3416@.TK2MSFTNGP15.phx.gbl...
>> Do you have anonymous access enabled for the website. Report Manager does
>> not allow any administrative type functionality as anonymous.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
>> news:eaBXkQ84FHA.1864@.TK2MSFTNGP12.phx.gbl...
>> After installing RS, none of the [OK] or {apply] buttons work to make
>> any security or config changes.
>> When i click on them nothing at all happens.
>>
>>
>|||I had the same problem and here's what I did to fix it. Apparently, my
IIS was configured so that the ASP_NET's webuivalidation.js wasn't able
to load. This somehow prevented any of the buttons on the ReportServer
to work.
And I fixed it based on the same advice given to you by Bruce here. I
think what he means you should TURN ON Anonymous access.
Give this a try...see if you can point your browser to:
http://your-root/aspnet_client/system_web/1_1_4322/WebUIValidation.js
and see if you can see it. (assuming you're using the same version
ASP.NET I am).
I fixed it by going into my IIS settings -> Directory Security -> and
checking the box "Anonymous Access."
David J. Cartwright wrote:
> No Anonymous allowed.
> As a last troubleshooting step i did a default install of IIS, enabled
> ASP.Net, Installed RS. Installed RS SP
> I am running RS 2000, on Windows 2003
> I need to make this work, anu other ideas ?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uUDCIr84FHA.3416@.TK2MSFTNGP15.phx.gbl...
>>Do you have anonymous access enabled for the website. Report Manager does
>>not allow any administrative type functionality as anonymous.
>>
>>--
>>Bruce Loehle-Conger
>>MVP SQL Server Reporting Services
>>"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
>>news:eaBXkQ84FHA.1864@.TK2MSFTNGP12.phx.gbl...
>>After installing RS, none of the [OK] or {apply] buttons work to make any
>>security or config changes.
>>When i click on them nothing at all happens.
>>
>>
>
Need help - Server Error in '/ReportServer' Application
I created a report project with the sales report followed by the SQL Server tutorial. But when I tried to publish a report. I got the following problem:
1. The connection could not made to the report server http://machinename/ReportServer
2.
Server Error in '/ReportServer' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot' because access is denied.
Source Error:
[No relevant source lines]
Source File: c:\inetpub\wwwroot\web.config Line: 0
Could anyone give me some ideas to fix this problem?
Thanks
I had a similar problem (same error, different appication) accessing web.config. Permissions on the "wwwroot" folder were denying access. I'm still trying ro figure out which permission it was, but resetting them without restrictions circumvented the error. Also, I put a web.config in the wwwroot folder, but I don't know that this really helped anything yet.
Late response.
|||Can you please let me know if you see any errors in the application or system event log when this problem happens? Also is this on a Windows 2003 server or Windows 2000 server?
This is provided "AS IS" with no warranties, and confers no rights
Thanks.
Ramu_MSFT
|||I have seen no errors in the eventlog pertaining to: "An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot\web.config' because access is denied."
Conditions: XP PRO w/ IIS v5.1; Installed ASP.NET v2.0.50727 (among other software) as suggested by: http://www.asp101.com/articles/sample_chapters/sitepoint_byoaspnet20/chapter1.asp. Used selected startup>>no startup items.
In browser, http://localhost/mypage.htm opens fine. Any *.aspx received error. I could "view [the *.aspx] in browser" output from within Visual Web Development 2005 Express Edition, but not directly in the browser.
HTM worked; ASPX would not. Modified permissions on the files and child folders but could not access web.config at "wwwroot." Threw the web.config from virtual directory into "wwwroot," removed restrictions (permissions) on "wwwroot," , and now I can load my *.aspx from the browswer: http://localhost/mypage.aspx. or http://localhost/virtualfolder/mypage.aspx.
On "wwwroot," I checked "Inherit from parent ...Include these entries...," but did not check "Replace permission entries on all child..." I did not modify any Services logon. Local Security Policies includes Administrators for "Impersonate..." But nothing worked until, and the last thing I did was, modify permissions on the "wwwroot" folder.
This may not apply to you (e.g., different O/S, versions, etc.). I know I have to reset permissions on "wwwroot" for security, but I haven't had time to narrow that down. If you know what the permissions should be for "wwwroot," PLEASE REPLY.
cc.
Need help - Server Error in '/ReportServer' Application
I created a report project with the sales report followed by the SQL Server tutorial. But when I tried to publish a report. I got the following problem:
1. The connection could not made to the report server http://machinename/ReportServer
2.
Server Error in '/ReportServer' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot' because access is denied.
Source Error:
[No relevant source lines]
Source File: c:\inetpub\wwwroot\web.config Line: 0
Could anyone give me some ideas to fix this problem?
Thanks
I had a similar problem (same error, different appication) accessing web.config. Permissions on the "wwwroot" folder were denying access. I'm still trying ro figure out which permission it was, but resetting them without restrictions circumvented the error. Also, I put a web.config in the wwwroot folder, but I don't know that this really helped anything yet.
Late response.
|||Can you please let me know if you see any errors in the application or system event log when this problem happens? Also is this on a Windows 2003 server or Windows 2000 server?
This is provided "AS IS" with no warranties, and confers no rights
Thanks.
Ramu_MSFT
|||I have seen no errors in the eventlog pertaining to: "An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot\web.config' because access is denied."
Conditions: XP PRO w/ IIS v5.1; Installed ASP.NET v2.0.50727 (among other software) as suggested by: http://www.asp101.com/articles/sample_chapters/sitepoint_byoaspnet20/chapter1.asp. Used selected startup>>no startup items.
In browser, http://localhost/mypage.htm opens fine. Any *.aspx received error. I could "view [the *.aspx] in browser" output from within Visual Web Development 2005 Express Edition, but not directly in the browser.
HTM worked; ASPX would not. Modified permissions on the files and child folders but could not access web.config at "wwwroot." Threw the web.config from virtual directory into "wwwroot," removed restrictions (permissions) on "wwwroot," , and now I can load my *.aspx from the browswer: http://localhost/mypage.aspx. or http://localhost/virtualfolder/mypage.aspx.
On "wwwroot," I checked "Inherit from parent ...Include these entries...," but did not check "Replace permission entries on all child..." I did not modify any Services logon. Local Security Policies includes Administrators for "Impersonate..." But nothing worked until, and the last thing I did was, modify permissions on the "wwwroot" folder.
This may not apply to you (e.g., different O/S, versions, etc.). I know I have to reset permissions on "wwwroot" for security, but I haven't had time to narrow that down. If you know what the permissions should be for "wwwroot," PLEASE REPLY.
cc.
Need Help - Quick simple implementation of code
Hi,
I am looking for a very simple and straighforward way of calling an already
deployed report from ASP.net. I simply need a hyperlink that displays the
report on screen if that is possible.
Any help would be tremendously appreciated.Hi Dan.
You can download this ASP.NET demo, it would help you rendering the report.
http://www.rdlcomponents.com/ASPExamples/default.aspx
Thanks
Jerry
"Dan Colgan via SQLMonster.com" wrote:
> Hi,
> I am looking for a very simple and straighforward way of calling an already
> deployed report from ASP.net. I simply need a hyperlink that displays the
> report on screen if that is possible.
> Any help would be tremendously appreciated.
>sql
I am looking for a very simple and straighforward way of calling an already
deployed report from ASP.net. I simply need a hyperlink that displays the
report on screen if that is possible.
Any help would be tremendously appreciated.Hi Dan.
You can download this ASP.NET demo, it would help you rendering the report.
http://www.rdlcomponents.com/ASPExamples/default.aspx
Thanks
Jerry
"Dan Colgan via SQLMonster.com" wrote:
> Hi,
> I am looking for a very simple and straighforward way of calling an already
> deployed report from ASP.net. I simply need a hyperlink that displays the
> report on screen if that is possible.
> Any help would be tremendously appreciated.
>sql
Monday, March 26, 2012
need help
Where can I get the matrix report tutorial in report builder? Thanks
Try:
http://msdn2.microsoft.com/en-gb/library/aa337450.aspx
-Sue
On Tue, 21 Nov 2006 11:37:35 +0800, "Norman Yuan"
<NotReal@.NotReal.not> wrote:
>Where can I get the matrix report tutorial in report builder? Thanks
>
Try:
http://msdn2.microsoft.com/en-gb/library/aa337450.aspx
-Sue
On Tue, 21 Nov 2006 11:37:35 +0800, "Norman Yuan"
<NotReal@.NotReal.not> wrote:
>Where can I get the matrix report tutorial in report builder? Thanks
>
need help
I have installed SQL 2005 reporting services and I configured it using
Reporting Services Configuration. Now I tried to access to report manager
using http://servername/Reports with login I used to start reporting
services. It doesn't work and keep prompting me for login and password. But
no use and I am sure this login is correct and password correct and it
started the reportings services successfully. Can anyone please help how to
solve this problem. Thanks.On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
> I have installed SQL 2005 reporting services and I configured it using
> Reporting Services Configuration. Now I tried to access to report manager
> using http://servername/Reports with login I used to start reporting
> services. It doesn't work and keep prompting me for login and password. But
> no use and I am sure this login is correct and password correct and it
> started the reportings services successfully. Can anyone please help how to
> solve this problem. Thanks.
You might want to check the Virtual Directories and see if the
permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
Information Services >> Web Sites >> Default Web Site >> right-click
the Reports/ReportServer virtual directories >> select Properties >
select the Directory Security tab >> select the top Edit... button >>
select Anonymous access, Allow IIS to control password and Integrated
Windows authentication. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
In fact, it is checked already. Integrade window
authentication, digest authentication ... and basic authenitcation are
checked as well. Only .net passport atuthentication and default domain and
realm are empty. Is this this all right?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1194239797.654239.246180@.19g2000hsx.googlegroups.com...
> On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report manager
>> using http://servername/Reports with login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>
> You might want to check the Virtual Directories and see if the
> permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
> Information Services >> Web Sites >> Default Web Site >> right-click
> the Reports/ReportServer virtual directories >> select Properties >
> select the Directory Security tab >> select the top Edit... button >>
> select Anonymous access, Allow IIS to control password and Integrated
> Windows authentication. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||If you have Window Vista, is need run Internet Explorer with Administrator
privileges.
" Miley Cyrus" <a@.b.com> pí¹e v diskusním pøíspìvku
news:eK30U02HIHA.4808@.TK2MSFTNGP05.phx.gbl...
> Enrique,
> In fact, it is checked already. Integrade window
> authentication, digest authentication ... and basic authenitcation are
> checked as well. Only .net passport atuthentication and default domain and
> realm are empty. Is this this all right?
>
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1194239797.654239.246180@.19g2000hsx.googlegroups.com...
>> On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report
>> manager
>> using http://servername/Reports with login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>>
>> You might want to check the Virtual Directories and see if the
>> permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
>> Information Services >> Web Sites >> Default Web Site >> right-click
>> the Reports/ReportServer virtual directories >> select Properties >
>> select the Directory Security tab >> select the top Edit... button >>
>> select Anonymous access, Allow IIS to control password and Integrated
>> Windows authentication. Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>
Reporting Services Configuration. Now I tried to access to report manager
using http://servername/Reports with login I used to start reporting
services. It doesn't work and keep prompting me for login and password. But
no use and I am sure this login is correct and password correct and it
started the reportings services successfully. Can anyone please help how to
solve this problem. Thanks.On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
> I have installed SQL 2005 reporting services and I configured it using
> Reporting Services Configuration. Now I tried to access to report manager
> using http://servername/Reports with login I used to start reporting
> services. It doesn't work and keep prompting me for login and password. But
> no use and I am sure this login is correct and password correct and it
> started the reportings services successfully. Can anyone please help how to
> solve this problem. Thanks.
You might want to check the Virtual Directories and see if the
permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
Information Services >> Web Sites >> Default Web Site >> right-click
the Reports/ReportServer virtual directories >> select Properties >
select the Directory Security tab >> select the top Edit... button >>
select Anonymous access, Allow IIS to control password and Integrated
Windows authentication. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
In fact, it is checked already. Integrade window
authentication, digest authentication ... and basic authenitcation are
checked as well. Only .net passport atuthentication and default domain and
realm are empty. Is this this all right?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1194239797.654239.246180@.19g2000hsx.googlegroups.com...
> On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report manager
>> using http://servername/Reports with login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>
> You might want to check the Virtual Directories and see if the
> permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
> Information Services >> Web Sites >> Default Web Site >> right-click
> the Reports/ReportServer virtual directories >> select Properties >
> select the Directory Security tab >> select the top Edit... button >>
> select Anonymous access, Allow IIS to control password and Integrated
> Windows authentication. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||If you have Window Vista, is need run Internet Explorer with Administrator
privileges.
" Miley Cyrus" <a@.b.com> pí¹e v diskusním pøíspìvku
news:eK30U02HIHA.4808@.TK2MSFTNGP05.phx.gbl...
> Enrique,
> In fact, it is checked already. Integrade window
> authentication, digest authentication ... and basic authenitcation are
> checked as well. Only .net passport atuthentication and default domain and
> realm are empty. Is this this all right?
>
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1194239797.654239.246180@.19g2000hsx.googlegroups.com...
>> On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report
>> manager
>> using http://servername/Reports with login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>>
>> You might want to check the Virtual Directories and see if the
>> permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
>> Information Services >> Web Sites >> Default Web Site >> right-click
>> the Reports/ReportServer virtual directories >> select Properties >
>> select the Directory Security tab >> select the top Edit... button >>
>> select Anonymous access, Allow IIS to control password and Integrated
>> Windows authentication. Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>
need help
Where can I get the matrix report tutorial in report builder? ThanksTry:
http://msdn2.microsoft.com/en-gb/library/aa337450.aspx
-Sue
On Tue, 21 Nov 2006 11:37:35 +0800, "Norman Yuan"
<NotReal@.NotReal.not> wrote:
>Where can I get the matrix report tutorial in report builder? Thanks
>
http://msdn2.microsoft.com/en-gb/library/aa337450.aspx
-Sue
On Tue, 21 Nov 2006 11:37:35 +0800, "Norman Yuan"
<NotReal@.NotReal.not> wrote:
>Where can I get the matrix report tutorial in report builder? Thanks
>
need help
I have installed SQL 2005 reporting services and I configured it using
Reporting Services Configuration. Now I tried to access to report manager
using http://servername/Reports with login I used to start reporting
services. It doesn't work and keep prompting me for login and password. But
no use and I am sure this login is correct and password correct and it
started the reportings services successfully. Can anyone please help how to
solve this problem. Thanks.On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
> I have installed SQL 2005 reporting services and I configured it using
> Reporting Services Configuration. Now I tried to access to report manager
> using http://servername/Reports with login I used to start reporting
> services. It doesn't work and keep prompting me for login and password. But
> no use and I am sure this login is correct and password correct and it
> started the reportings services successfully. Can anyone please help how to
> solve this problem. Thanks.
You might want to check the Virtual Directories and see if the
permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
Information Services >> Web Sites >> Default Web Site >> right-click
the Reports/ReportServer virtual directories >> select Properties >
select the Directory Security tab >> select the top Edit... button >>
select Anonymous access, Allow IIS to control password and Integrated
Windows authentication. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
In fact, it is checked already. Integrade window
authentication, digest authentication ... and basic authenitcation are
checked as well. Only .net passport atuthentication and default domain and
realm are empty. Is this this all right?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1194239797.654239.246180@.19g2000hsx.googlegroups.com...
> On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report manager
>> using http://servername/Reports with login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>
> You might want to check the Virtual Directories and see if the
> permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
> Information Services >> Web Sites >> Default Web Site >> right-click
> the Reports/ReportServer virtual directories >> select Properties >
> select the Directory Security tab >> select the top Edit... button >>
> select Anonymous access, Allow IIS to control password and Integrated
> Windows authentication. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||If you have Window Vista, is need run Internet Explorer with Administrator
privileges.
" Miley Cyrus" <a@.b.com> pí¹e v diskusním pøíspìvku
news:eK30U02HIHA.4808@.TK2MSFTNGP05.phx.gbl...
> Enrique,
> In fact, it is checked already. Integrade window
> authentication, digest authentication ... and basic authenitcation are
> checked as well. Only .net passport atuthentication and default domain and
> realm are empty. Is this this all right?
>
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1194239797.654239.246180@.19g2000hsx.googlegroups.com...
>> On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report
>> manager
>> using http://servername/Reports with login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>>
>> You might want to check the Virtual Directories and see if the
>> permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
>> Information Services >> Web Sites >> Default Web Site >> right-click
>> the Reports/ReportServer virtual directories >> select Properties >
>> select the Directory Security tab >> select the top Edit... button >>
>> select Anonymous access, Allow IIS to control password and Integrated
>> Windows authentication. Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>sql
Reporting Services Configuration. Now I tried to access to report manager
using http://servername/Reports with login I used to start reporting
services. It doesn't work and keep prompting me for login and password. But
no use and I am sure this login is correct and password correct and it
started the reportings services successfully. Can anyone please help how to
solve this problem. Thanks.On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
> I have installed SQL 2005 reporting services and I configured it using
> Reporting Services Configuration. Now I tried to access to report manager
> using http://servername/Reports with login I used to start reporting
> services. It doesn't work and keep prompting me for login and password. But
> no use and I am sure this login is correct and password correct and it
> started the reportings services successfully. Can anyone please help how to
> solve this problem. Thanks.
You might want to check the Virtual Directories and see if the
permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
Information Services >> Web Sites >> Default Web Site >> right-click
the Reports/ReportServer virtual directories >> select Properties >
select the Directory Security tab >> select the top Edit... button >>
select Anonymous access, Allow IIS to control password and Integrated
Windows authentication. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
In fact, it is checked already. Integrade window
authentication, digest authentication ... and basic authenitcation are
checked as well. Only .net passport atuthentication and default domain and
realm are empty. Is this this all right?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1194239797.654239.246180@.19g2000hsx.googlegroups.com...
> On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report manager
>> using http://servername/Reports with login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>
> You might want to check the Virtual Directories and see if the
> permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
> Information Services >> Web Sites >> Default Web Site >> right-click
> the Reports/ReportServer virtual directories >> select Properties >
> select the Directory Security tab >> select the top Edit... button >>
> select Anonymous access, Allow IIS to control password and Integrated
> Windows authentication. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||If you have Window Vista, is need run Internet Explorer with Administrator
privileges.
" Miley Cyrus" <a@.b.com> pí¹e v diskusním pøíspìvku
news:eK30U02HIHA.4808@.TK2MSFTNGP05.phx.gbl...
> Enrique,
> In fact, it is checked already. Integrade window
> authentication, digest authentication ... and basic authenitcation are
> checked as well. Only .net passport atuthentication and default domain and
> realm are empty. Is this this all right?
>
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1194239797.654239.246180@.19g2000hsx.googlegroups.com...
>> On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report
>> manager
>> using http://servername/Reports with login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>>
>> You might want to check the Virtual Directories and see if the
>> permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
>> Information Services >> Web Sites >> Default Web Site >> right-click
>> the Reports/ReportServer virtual directories >> select Properties >
>> select the Directory Security tab >> select the top Edit... button >>
>> select Anonymous access, Allow IIS to control password and Integrated
>> Windows authentication. Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>sql
Friday, March 23, 2012
Need expression help ASAP
I have a report in ssrs where it has a colum with dates in it I has and other colum with either a $0.00 amount or and amount paid. I need a colum which which calculates only the number of days from the date colum that when the other colum =0 it gives me the total number of days. VS.net SQL 2005 SSRS C#
example of what needed:
Invoice amount | Date of Invoice| Amount received | number days past due
$100.00 06/01/2007 0.00 18 days ( this is what I need)
can some one explain.
Here are my expressions
FormatCurrency(Fields!Grossamtbilled.value)
FormatDateTime(Fields!EXPR1.Value,2)
FormatCurrency(Fields!RCVAMOUNT.Value)
I'm not sure what expression you would use when creating a report, but it would be fairly easy to do it in the original SQL Statement (by using a mixture of the CASE and DateDiff functions).
sqlWednesday, March 21, 2012
Need Date in Days Expression
I have an expression in a ssrs report that is a date can some one tell me how to formati the date to show days
example my expression =FormatDate Time(Fields!BillDate.Value,2)
This shows 02/02/2007 as the date
What i need it to say 33 days how can I format my exprsion in my ssrs report to reflect this..
HI,cpowers:
What is the meaning of 'What i need it to say 33 days how can I format my exprsion in my ssrs report to reflect this..'
Would you please clarify more about your requirement?
Thanks in advance!
sqlNeed current date in ssrs expression
I have a report which has a date like 01/05/2007 for a bill date. I need to create and expression which will take the current date and subtract the number of days from todays date and give a total number of days. How do I get thew current date in the expression.
the billed date expression is =FormatDateTime(Today()) - FormatDateTime(Fields!BILLDATE.value,2) I can not get this to work
Any help would be appreciated
You can execute code within a Report. You may need to do this although I think the reporting expressions should support what you are trying to accomplish. This is a good resource for you anyway though:http://support.microsoft.com/kb/920769
Hope this helps!
Matt
|||Thanks for the link but my expression isnt working in the report can you tell me what is wrong with it.
|||HI,cpowers:
You can try this expression:
= DateDiff("d",Fields!ShippedDate.Value ,Today() )
If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.
I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance
|||Rex Lin,
That works great thanks.. What I am tring to accomplish is a 1-30 31-60 61-90 days aging
I tried to di the following expression-
=DateDiff("d",Fields!ShippedDate.Value,Today()) < 30 for the 1-30 day
=DateDiff('d".Fields!ShippedDate.Value, Today()) >30<61 for the 31-60 day I am getting a true or false instead of the days is there away to modify the expression to give only the number of days that fall within the range
|||
HI,cpowers:
Hope this will meet your requirement:
=iif( DateDiff("d",Fields!ShippedDate.Value,Today())<30,DateDiff("d",Fields!ShippedDate.Value,Today()),"out of range")
|||I am tring to get a total for the amount owed that is over 30days but under 60days. My expression just gives me the word True does not give me the total MASRCVAMOUNT $$ in that date range. Can come one explain or help with expression...=FormatCurrency(Sum(Fields!MASRCVAMOUNT.Value))=DateDiff("d",Fields!Expr1.Value ,Today())>31<60
I also need to no how to get total MASRCVAMOUNT over 120 days
=iif( DateDiff("d",Fields!ShippedDate.Value,Today())<30,DateDiff("d",Fields!ShippedDate.Value,Today()),"out of range") How would I sum the MASCVAMOUNT in this date range and how can I select a between 61-91days these are my two real issues. I have the dates working.
Thanks for all the help I do appreciate it
|||HI，cpowers：
It seems that the goal you need to achieve is not easily for expression. How about deal with it in the sql statement?
|||Thanks for the help Rex Lin,
Ok I added the daging date to my sql script. Every thing saves ok and in my parameters there is now an new entry filter. Before I only had a StartDate, Enddate and Company. Now I have the Startdate , Enddate Company and dAging. I have tried to enter a date in to the dAging but it keeps giving me and error.This script was added in the creation of the ssrs report in the ssrs query builder. Can you explain to me what I may be missing or need to do to get my 1-30 , 31 60, 61-90 and 91 and over amounts.... The field I am collecting the amounts from is MASRECEIVL.MASRCVAMOUNT I am really stuck with this and need any help availible. Thanks
SELECT ' Language Detail by Company' as 'qtr',
COUNT(JOB.JOBID) as 'transcount',
COUNT(DISTINCT JOB.PATIENTID) as 'patient count',
SUM(JOB.LANGUAGE_TCOST) as 'lcost',
SUM(JOB.LANGUAGE_DISC_COST) as 'dlcost',
AVG(JOB.LANGUAGE_DISC) as 'avgLDisc',
SUM(JOB.LANGUAGE_TCOST) + SUM(JOB.LANGUAGE_DISC_COST) as 'LGrossAmtBilled',
SUM(JOB.LANGUAGE_TCOST) / COUNT(DISTINCT JOB.PATIENTID) as 'PatAvgL',
SUM(JOB.LANGUAGE_TCOST) / COUNT(JOB.JOBID) as 'RefAvgL',
SUM(JOB.LANGUAGE_DISC) as 'avgPercentDiscL',
JOB.JURISDICTION,PAYER.PAY_GROUPNAME,PAYER.PAY_COMPANY,PAYER.PAY_CITY,PAYER.PAY_STATE,PAYER.PAY_SALES_STAFF_ID,
JOB.INVOICE_DATE,JOB.PATIENTID,JOB.JOBOUTCOMEID,JOB.SERVICEOUTCOME,INVOICE_AR.INVOICE_NO,INVOICE_AR.INVOICE_DATE AS EXPR1,
INVOICE_AR.AMOUNT_DUE,INVOICE_AR.CLAIMNUMBER,PATIENT.LASTNAME,PATIENT.FIRSTNAME,PATIENT.EMPLOYERNAME,JOB_OUTCOME.DESCRIPTION,
SERVICE_TYPE.DESCRIPTION,PAT_SERVICES_HISTORY.LANG_TYPE,MASRECEIVL.MASRVDATE,MASRECEIVL.MASRCVAMOUNT,REFERRAL_SOURCE.REF_LASTNAME,
REFERRAL_SOURCE.REF_FIRSTNAME,REFERRAL_SOURCE.REF_PHONE,REFERRAL_SOURCE.REF_PHONE_EXT,REFERRAL_SOURCE.REF_FAX,REFERRAL_SOURCE.REF_EMAIL,JOB.INJURYDATE,JOB.APPT_DATE,
SUM(CASE WHEN (JOB_OUTCOME.DESCRIPTION = 'Completed with complaint') THEN 1 ELSE 0 END) AS 'CompletedWithcomplaintItems',
SUM(CASE WHEN (JOB_OUTCOME.DESCRIPTION = 'Completed Successfully') THEN 1 ELSE 0 END) AS 'CompletedSuccessfullyItems',
SUM(CASE WHEN (JOB_OUTCOME.DESCRIPTION = 'Completed with No Charge') THEN 1 ELSE 0 END) AS 'CompletedwithNoChargeItems',
SUM(CASE WHEN (JOB_OUTCOME.DESCRIPTION = 'Completed with No Show') THEN 1 ELSE 0 END) AS 'CompletedwithNoShowItems',
SUM(CASE WHEN (JOB_OUTCOME.DESCRIPTION = 'Completed with Situation') THEN 1 ELSE 0 END) AS 'CompletedWithSituationItems',
SUM(CASE WHEN (JOB_OUTCOME.DESCRIPTION = 'Not Completed') THEN 1 ELSE 0 END) AS 'NotCompletedItems',
SUM(CASE WHEN (JOB_OUTCOME.DESCRIPTION = 'Cancelled Prior to service') THEN 1 ELSE 0 END) AS 'CancelledPriortoserviceItems',
SUM(CASE WHEN (JOB_OUTCOME.DESCRIPTION = 'Cancelled During Service') THEN 1 ELSE 0 END) AS 'CancelledDuringServiceItems',
SUM(CASE WHEN (JOB_OUTCOME.DESCRIPTION = 'Awaiting for completion') THEN 1 ELSE 0 END) AS 'AwaitingforcpmpletionItems',
SUM(CASE WHEN (JOB_OUTCOME.DESCRIPTION = 'Pending for review') THEN 1 ELSE 0 END) AS 'PendingforreviewItems',
SUM(CASE WHEN INVOICE_AR.INVOICE_DATE BETWEEN @.dAgingDate-30 and @.dAgingDate THEN MASRECEIVL.MASRCVAMOUNT Else 0 END) AS Age30,
SUM(CASE WHEN INVOICE_AR.INVOICE_DATE BETWEEN @.dAgingDate-60 and @.dAgingDate-31 THEN MASRECEIVL.MASRCVAMOUNT Else 0 END) AS Age60,
SUM(CASE WHEN INVOICE_AR.INVOICE_DATE BETWEEN @.dAgingDate-90 and @.dAgingDate-61 THEN MASRECEIVL.MASRCVAMOUNT Else 0 END) AS Age90,
SUM(CASE WHEN INVOICE_AR.INVOICE_DATE BETWEEN @.dAgingDate-120 and @.dAgingDate-91 THEN MASRECEIVL.MASRCVAMOUNT Else 0 END) AS Age120
FROM JOB
INNER JOIN INVOICE_AR ON JOB.JOBID = INVOICE_AR.JOBID
LEFT OUTER JOIN PAYER ON PAYER.PAYERID = JOB.PAYERID
LEFT OUTER JOIN MASRECEIVL ON MASRECEIVL.INVOICE_NO = INVOICE_AR.INVOICE_NO
LEFT OUTER JOIN REFERRAL_SOURCE ON REFERRAL_SOURCE.REFERRAL_ID = JOB.ADJUSTERID
LEFT OUTER JOIN STATES ON JOB.JURISDICTION = STATES.INITIALS
LEFT OUTER JOIN PATIENT ON PATIENT.PATIENTID = JOB.PATIENTID
LEFT OUTER JOIN JOB_OUTCOME ON JOB_OUTCOME.JOB_OUTCOME_ID = JOB.JOBOUTCOMEID
LEFT OUTER JOIN SERVICE_TYPE ON SERVICE_TYPE.DESCRIPTION = JOB.SERVICEOUTCOME
LEFT OUTER JOIN PAT_SERVICES_HISTORY ON PAT_SERVICES_HISTORY.PATIENTID = JOB.PATIENTID
WHERE
(INVOICE_AR.AMOUNT_DUE > 0) AND (INVOICE_AR.INVOICE_DATE BETWEEN @.startdate and @.enddate)AND
(MONTH(INVOICE_AR.INVOICE_DATE) IN (1,2,3,4,5,6,7,8,9,10,11,12)) AND (PAYER.PAY_Company like '%' + @.Company + '%') AND
(INVOICE_AR.INVOICE_NO like '%L') AND (MASRECEIVL.MASRCVAMOUNT > 0)
Group By
JOB.JURISDICTION,
PAYER.PAY_GROUPNAME,
PAYER.PAY_COMPANY,
PAYER.PAY_CITY,
PAYER.PAY_STATE,
PAYER.PAY_SALES_STAFF_ID,
JOB.PATIENTID,
JOB.INVOICE_DATE,
JOB.JOBOUTCOMEID,
JOB.SERVICEOUTCOME,
INVOICE_AR.INVOICE_NO,
INVOICE_AR.INVOICE_DATE,
INVOICE_AR.AMOUNT_DUE,
INVOICE_AR.CLAIMNUMBER,
PATIENT.LASTNAME,
PATIENT.FIRSTNAME,
PATIENT.EMPLOYERNAME,
JOB_OUTCOME.DESCRIPTION,
SERVICE_TYPE.DESCRIPTION,
PAT_SERVICES_HISTORY.LANG_TYPE,
MASRECEIVL.MASRVDATE,
MASRECEIVL.MASRCVAMOUNT,
REFERRAL_SOURCE.REF_LASTNAME,
REFERRAL_SOURCE.REF_FIRSTNAME,
REFERRAL_SOURCE.REF_PHONE,
REFERRAL_SOURCE.REF_PHONE_EXT,
REFERRAL_SOURCE.REF_FAX,
REFERRAL_SOURCE.REF_EMAIL,
JOB.INJURYDATE,
JOB.APPT_DATE
Order By 'QTR' asc
|||HI,cpowers:
Your sql statement is quite complicated than i expected. I have created a simple one by using Orders table in the Northwind. It brings out the sum value of 30-60 and 60-90 date intervals
select
sum(case when timespan between 0 and 29 then shipvia end )as zeroToThirty,
sum(case when timespan between 30 and 59 then shipvia end )as ThirtyToSixty
from
(select (datediff(dd,getdate(),orderdate)+4000)as timespan,*
from dbo.orders) as newtable
If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.
I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance
|||Rex Lin,
I am having similar problems, except all I want is to substract current date from the promised date (date that is was suppose to ship) and be able to view only the negetive data. I tried =GETDATE()-Fields!PROMISE.Value
but it would give me an error, then I tried the format you gave cpowers
=DateDiff("d",fields!Promise.Value, Today()) but all it did was give me one number. Am I doing it wrong? What do you recomend? Please advice
Thanks
Need code examples of how to call SSRS reports from winforms app
I'm writing a vb.net winforms app and need to call up reports from SSRS. I
also need to pass in secure parameters into the report and I don't want to
pass the credentials if I don't have to. I was hoping I could call my own
web service where I can pass encrypted data to my web service which would
contain the parameters. then a business object on the server could generate
the credential needed by SSRS and pass both the credentials and decrypted
parameters into the report. Problem is I don't know how to get the report
back to the client. One idea was to render the report on the server side
and then convert its html into a byte stream and pass the byte stream as a
return value for my web service. Then my winform client could convert the
byte stream into an html document. However, I have no idea if this is
possible and need examples for the various parts.
can someone please give me advise (and preferable links to code examples) on
how to solve this problem?
Thanks.
--
moondaddy@.nospam.nospamHello,
The following link might be helpful for you:
http://www.codeproject.com/useritems/SQLRSViewer.asp
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "moondaddy" <moondaddy@.nospam.nospam>
| Subject: Need code examples of how to call SSRS reports from winforms app
| Date: Fri, 29 Apr 2005 00:29:02 -0500
| Lines: 22
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| Message-ID: <ujCUetHTFHA.2756@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: adsl-70-240-196-183.dsl.hstntx.swbell.net
70.240.196.183
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42254
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I'm writing a vb.net winforms app and need to call up reports from SSRS.
I
| also need to pass in secure parameters into the report and I don't want
to
| pass the credentials if I don't have to. I was hoping I could call my
own
| web service where I can pass encrypted data to my web service which would
| contain the parameters. then a business object on the server could
generate
| the credential needed by SSRS and pass both the credentials and decrypted
| parameters into the report. Problem is I don't know how to get the
report
| back to the client. One idea was to render the report on the server side
| and then convert its html into a byte stream and pass the byte stream as
a
| return value for my web service. Then my winform client could convert the
| byte stream into an html document. However, I have no idea if this is
| possible and need examples for the various parts.
|
| can someone please give me advise (and preferable links to code examples)
on
| how to solve this problem?
|
| Thanks.
|
| --
| moondaddy@.nospam.nospam
|
|
|sql
also need to pass in secure parameters into the report and I don't want to
pass the credentials if I don't have to. I was hoping I could call my own
web service where I can pass encrypted data to my web service which would
contain the parameters. then a business object on the server could generate
the credential needed by SSRS and pass both the credentials and decrypted
parameters into the report. Problem is I don't know how to get the report
back to the client. One idea was to render the report on the server side
and then convert its html into a byte stream and pass the byte stream as a
return value for my web service. Then my winform client could convert the
byte stream into an html document. However, I have no idea if this is
possible and need examples for the various parts.
can someone please give me advise (and preferable links to code examples) on
how to solve this problem?
Thanks.
--
moondaddy@.nospam.nospamHello,
The following link might be helpful for you:
http://www.codeproject.com/useritems/SQLRSViewer.asp
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "moondaddy" <moondaddy@.nospam.nospam>
| Subject: Need code examples of how to call SSRS reports from winforms app
| Date: Fri, 29 Apr 2005 00:29:02 -0500
| Lines: 22
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| Message-ID: <ujCUetHTFHA.2756@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: adsl-70-240-196-183.dsl.hstntx.swbell.net
70.240.196.183
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42254
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I'm writing a vb.net winforms app and need to call up reports from SSRS.
I
| also need to pass in secure parameters into the report and I don't want
to
| pass the credentials if I don't have to. I was hoping I could call my
own
| web service where I can pass encrypted data to my web service which would
| contain the parameters. then a business object on the server could
generate
| the credential needed by SSRS and pass both the credentials and decrypted
| parameters into the report. Problem is I don't know how to get the
report
| back to the client. One idea was to render the report on the server side
| and then convert its html into a byte stream and pass the byte stream as
a
| return value for my web service. Then my winform client could convert the
| byte stream into an html document. However, I have no idea if this is
| possible and need examples for the various parts.
|
| can someone please give me advise (and preferable links to code examples)
on
| how to solve this problem?
|
| Thanks.
|
| --
| moondaddy@.nospam.nospam
|
|
|sql
Monday, March 19, 2012
Need Article/Information - 2 databases 1 report
Hi All,
I need to find information on how to get two oracle databases data into one report. The two databases are not really a like, althought they do "talk" to each other and pass data to each other, and their tables are not the same. One is a manufacturing database, the other financial. If anyone can point me in the right direction, that would be great.
I am working with the newer 2005 products.
Thanks in advanced,
Kerrie
Kerrie,
i can't tell you how to collect data from Oracle, but i can tell you how to combine two streams of data. You need to create two reports - one being the main report, the other being a simple one, the simple one then serves as a sub report inside the main report. For instance, if you are showing the data in a table in the main report, then you can embed the subreport in a table cell, and pass values into it as parameters.
Or you can use the existing database link between the two databases (you said they are talking already), and just return all the data in one query. This will make the query slower, but the report will be way easier.
|||Sluggy,
Thanks for the reply, Thats what I will do!
Thanks again,
Kerrie
Need Answer PLS - excel export file size changed on re-save
I have a report that ran and returns a large amount a data. When I export the report to excel it takes 3 minutes to export. The file size when I open the xls file is 24.1MB. I choose save as and give it another name ... then open the xls I just saved and the size is 9.79MB. Why is the file size different on the re-saved file than the originally exported file? This was reported by a user and I didnt believe the file size would change until I tried it myself ...sorry ... forgot to add that I am running RS2005 sp1|||If you have a lot of
string values in the report that can be represented as single byte strings,
that’s probably where Excel is making a difference. In Reporting Services we
always write strings as 2-byte Unicode, but Excel will always try to compress to
single byte when possible.
Subscribe to:
Posts (Atom)