Report Error when 2 pages for multiple records

We have a web app, built in .Net, with reporting services as our reporting
tool. The problem we are having is when we have a report that goes to
numerous people and the report is 2 pages long. When we make it 1 page,
legal size, it works fine (avg records are 500-900). When this report is
generated it is created in a pdf format. I can run it on report services
manager and in the viewer it takes approx 10 secs or less to run and render,
but when we create the pdf it spikes the processor up to 90% and if it's a 2
page report it generates an error.PDF's take significantly longer than HTML but it surprises me that a 2 page
report you see much of a difference. Do you have any service packs
installed. If not, my advice is to install SP2.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
> We have a web app, built in .Net, with reporting services as our reporting
> tool. The problem we are having is when we have a report that goes to
> numerous people and the report is 2 pages long. When we make it 1 page,
> legal size, it works fine (avg records are 500-900). When this report is
> generated it is created in a pdf format. I can run it on report services
> manager and in the viewer it takes approx 10 secs or less to run and
> render,
> but when we create the pdf it spikes the processor up to 90% and if it's a
> 2
> page report it generates an error.|||I have all of the service packs installed. This is a 2 page report that
generates approx 950 pages. I have similar reports, but set to legal single
page, that generate over 1000 pages in pdf. The error message I get is:
"Server Error in '/' Application.
The underlying connection was closed: An unexpected error occurred on a
receive.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Net.WebException: The underlying connection was
closed: An unexpected error occurred on a receive.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[WebException: The underlying connection was closed: An unexpected error
occurred on a receive.]
System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
t request) +58
System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
quest request) +5
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) +183
LAMS.SQLReportServer.ReportingService.Render(String Report, String
Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters,
DataSourceCredentials[] Credentials, String ShowHideToggle, String& Encoding,
String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
String[]& StreamIds) +141
LAMS.ReportViewer.RenderPDFReport() +618
LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750"
"Bruce L-C [MVP]" wrote:
> PDF's take significantly longer than HTML but it surprises me that a 2 page
> report you see much of a difference. Do you have any service packs
> installed. If not, my advice is to install SP2.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
> > We have a web app, built in .Net, with reporting services as our reporting
> > tool. The problem we are having is when we have a report that goes to
> > numerous people and the report is 2 pages long. When we make it 1 page,
> > legal size, it works fine (avg records are 500-900). When this report is
> > generated it is created in a pdf format. I can run it on report services
> > manager and in the viewer it takes approx 10 secs or less to run and
> > render,
> > but when we create the pdf it spikes the processor up to 90% and if it's a
> > 2
> > page report it generates an error.
>
>|||OK, we had a failure to communicate. You said a 2 page report and I thought
it was 2 pages long. You mean 2 pages per record.
RS renders everything in RAM. Formats make a big difference in CPU
utilizations. CSV, HTML are very fast. PDF and Excel are much slower and
much much more intensive in resources required. My personal feeling is that
when you are talking about that many pages it is an inappropriate use of RS.
It is just not designed to be outputting 1000 pages of PDF. Users cannot
look at that many pages anyway. You should consider drill through technique.
Show the users what they need to see. I do know that sometimes users need to
pull data into another program but that is not what PDF format is used for.
Excel is another matter (although Excel can't handle 100,000 rows either).
For Excel you could use CSV to get around this. For PDF there is no work
around. More RAM helps but you really are overloading the server when you
are doing this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
news:790D7C48-1AB7-4F2A-A1C3-A1CF679B9B52@.microsoft.com...
>I have all of the service packs installed. This is a 2 page report that
> generates approx 950 pages. I have similar reports, but set to legal
> single
> page, that generate over 1000 pages in pdf. The error message I get is:
> "Server Error in '/' Application.
> The underlying connection was closed: An unexpected error occurred on a
> receive.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about
> the error and where it originated in the code.
> Exception Details: System.Net.WebException: The underlying connection was
> closed: An unexpected error occurred on a receive.
> Source Error:
> An unhandled exception was generated during the execution of the current
> web
> request. Information regarding the origin and location of the exception
> can
> be identified using the exception stack trace below.
> Stack Trace:
> [WebException: The underlying connection was closed: An unexpected error
> occurred on a receive.]
> System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
> t request) +58
> System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
> quest request) +5
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) +183
> LAMS.SQLReportServer.ReportingService.Render(String Report, String
> Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters,
> DataSourceCredentials[] Credentials, String ShowHideToggle, String&
> Encoding,
> String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
> String[]& StreamIds) +141
> LAMS.ReportViewer.RenderPDFReport() +618
> LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +750"
> "Bruce L-C [MVP]" wrote:
>> PDF's take significantly longer than HTML but it surprises me that a 2
>> page
>> report you see much of a difference. Do you have any service packs
>> installed. If not, my advice is to install SP2.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
>> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
>> > We have a web app, built in .Net, with reporting services as our
>> > reporting
>> > tool. The problem we are having is when we have a report that goes to
>> > numerous people and the report is 2 pages long. When we make it 1
>> > page,
>> > legal size, it works fine (avg records are 500-900). When this report
>> > is
>> > generated it is created in a pdf format. I can run it on report
>> > services
>> > manager and in the viewer it takes approx 10 secs or less to run and
>> > render,
>> > but when we create the pdf it spikes the processor up to 90% and if
>> > it's a
>> > 2
>> > page report it generates an error.
>>|||Thanks for the input. The only problem is this is our leasing application
and we have to print mass batch of renewals once a year. I am thinking of
setting it on a schedule but that would remove a data range filter that is in
place and is changable by the user. Any suggestions?
"Bruce L-C [MVP]" wrote:
> OK, we had a failure to communicate. You said a 2 page report and I thought
> it was 2 pages long. You mean 2 pages per record.
> RS renders everything in RAM. Formats make a big difference in CPU
> utilizations. CSV, HTML are very fast. PDF and Excel are much slower and
> much much more intensive in resources required. My personal feeling is that
> when you are talking about that many pages it is an inappropriate use of RS.
> It is just not designed to be outputting 1000 pages of PDF. Users cannot
> look at that many pages anyway. You should consider drill through technique.
> Show the users what they need to see. I do know that sometimes users need to
> pull data into another program but that is not what PDF format is used for.
> Excel is another matter (although Excel can't handle 100,000 rows either).
> For Excel you could use CSV to get around this. For PDF there is no work
> around. More RAM helps but you really are overloading the server when you
> are doing this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> news:790D7C48-1AB7-4F2A-A1C3-A1CF679B9B52@.microsoft.com...
> >I have all of the service packs installed. This is a 2 page report that
> > generates approx 950 pages. I have similar reports, but set to legal
> > single
> > page, that generate over 1000 pages in pdf. The error message I get is:
> >
> > "Server Error in '/' Application.
> > The underlying connection was closed: An unexpected error occurred on a
> > receive.
> > Description: An unhandled exception occurred during the execution of the
> > current web request. Please review the stack trace for more information
> > about
> > the error and where it originated in the code.
> > Exception Details: System.Net.WebException: The underlying connection was
> > closed: An unexpected error occurred on a receive.
> > Source Error:
> > An unhandled exception was generated during the execution of the current
> > web
> > request. Information regarding the origin and location of the exception
> > can
> > be identified using the exception stack trace below.
> >
> > Stack Trace:
> > [WebException: The underlying connection was closed: An unexpected error
> > occurred on a receive.]
> > System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
> > t request) +58
> > System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
> > quest request) +5
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) +183
> > LAMS.SQLReportServer.ReportingService.Render(String Report, String
> > Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters,
> > DataSourceCredentials[] Credentials, String ShowHideToggle, String&
> > Encoding,
> > String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
> > String[]& StreamIds) +141
> > LAMS.ReportViewer.RenderPDFReport() +618
> > LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
> > System.Web.UI.Control.OnLoad(EventArgs e) +67
> > System.Web.UI.Control.LoadRecursive() +35
> > System.Web.UI.Page.ProcessRequestMain() +750"
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> PDF's take significantly longer than HTML but it surprises me that a 2
> >> page
> >> report you see much of a difference. Do you have any service packs
> >> installed. If not, my advice is to install SP2.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> >> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
> >> > We have a web app, built in .Net, with reporting services as our
> >> > reporting
> >> > tool. The problem we are having is when we have a report that goes to
> >> > numerous people and the report is 2 pages long. When we make it 1
> >> > page,
> >> > legal size, it works fine (avg records are 500-900). When this report
> >> > is
> >> > generated it is created in a pdf format. I can run it on report
> >> > services
> >> > manager and in the viewer it takes approx 10 secs or less to run and
> >> > render,
> >> > but when we create the pdf it spikes the processor up to 90% and if
> >> > it's a
> >> > 2
> >> > page report it generates an error.
> >>
> >>
> >>
>
>|||If you can have parameters that allows you to do a subset then schedule the
report multiple times just varying the parameter and print say 100 pages at
a time.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
news:6B4C566B-C41C-49FD-BF58-2FCD7B9656E3@.microsoft.com...
> Thanks for the input. The only problem is this is our leasing application
> and we have to print mass batch of renewals once a year. I am thinking of
> setting it on a schedule but that would remove a data range filter that is
> in
> place and is changable by the user. Any suggestions?
> "Bruce L-C [MVP]" wrote:
>> OK, we had a failure to communicate. You said a 2 page report and I
>> thought
>> it was 2 pages long. You mean 2 pages per record.
>> RS renders everything in RAM. Formats make a big difference in CPU
>> utilizations. CSV, HTML are very fast. PDF and Excel are much slower and
>> much much more intensive in resources required. My personal feeling is
>> that
>> when you are talking about that many pages it is an inappropriate use of
>> RS.
>> It is just not designed to be outputting 1000 pages of PDF. Users cannot
>> look at that many pages anyway. You should consider drill through
>> technique.
>> Show the users what they need to see. I do know that sometimes users need
>> to
>> pull data into another program but that is not what PDF format is used
>> for.
>> Excel is another matter (although Excel can't handle 100,000 rows
>> either).
>> For Excel you could use CSV to get around this. For PDF there is no work
>> around. More RAM helps but you really are overloading the server when you
>> are doing this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
>> news:790D7C48-1AB7-4F2A-A1C3-A1CF679B9B52@.microsoft.com...
>> >I have all of the service packs installed. This is a 2 page report that
>> > generates approx 950 pages. I have similar reports, but set to legal
>> > single
>> > page, that generate over 1000 pages in pdf. The error message I get
>> > is:
>> >
>> > "Server Error in '/' Application.
>> > The underlying connection was closed: An unexpected error occurred on a
>> > receive.
>> > Description: An unhandled exception occurred during the execution of
>> > the
>> > current web request. Please review the stack trace for more information
>> > about
>> > the error and where it originated in the code.
>> > Exception Details: System.Net.WebException: The underlying connection
>> > was
>> > closed: An unexpected error occurred on a receive.
>> > Source Error:
>> > An unhandled exception was generated during the execution of the
>> > current
>> > web
>> > request. Information regarding the origin and location of the exception
>> > can
>> > be identified using the exception stack trace below.
>> >
>> > Stack Trace:
>> > [WebException: The underlying connection was closed: An unexpected
>> > error
>> > occurred on a receive.]
>> > System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
>> > t request) +58
>> > System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
>> > quest request) +5
>> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
>> > methodName, Object[] parameters) +183
>> > LAMS.SQLReportServer.ReportingService.Render(String Report, String
>> > Format, String HistoryID, String DeviceInfo, ParameterValue[]
>> > Parameters,
>> > DataSourceCredentials[] Credentials, String ShowHideToggle, String&
>> > Encoding,
>> > String& MimeType, ParameterValue[]& ParametersUsed, Warning[]&
>> > Warnings,
>> > String[]& StreamIds) +141
>> > LAMS.ReportViewer.RenderPDFReport() +618
>> > LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
>> > System.Web.UI.Control.OnLoad(EventArgs e) +67
>> > System.Web.UI.Control.LoadRecursive() +35
>> > System.Web.UI.Page.ProcessRequestMain() +750"
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> PDF's take significantly longer than HTML but it surprises me that a 2
>> >> page
>> >> report you see much of a difference. Do you have any service packs
>> >> installed. If not, my advice is to install SP2.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
>> >> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
>> >> > We have a web app, built in .Net, with reporting services as our
>> >> > reporting
>> >> > tool. The problem we are having is when we have a report that goes
>> >> > to
>> >> > numerous people and the report is 2 pages long. When we make it 1
>> >> > page,
>> >> > legal size, it works fine (avg records are 500-900). When this
>> >> > report
>> >> > is
>> >> > generated it is created in a pdf format. I can run it on report
>> >> > services
>> >> > manager and in the viewer it takes approx 10 secs or less to run and
>> >> > render,
>> >> > but when we create the pdf it spikes the processor up to 90% and if
>> >> > it's a
>> >> > 2
>> >> > page report it generates an error.
>> >>
>> >>
>> >>
>>|||Thanks a bunch for the info Bruce.
"Bruce L-C [MVP]" wrote:
> If you can have parameters that allows you to do a subset then schedule the
> report multiple times just varying the parameter and print say 100 pages at
> a time.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> news:6B4C566B-C41C-49FD-BF58-2FCD7B9656E3@.microsoft.com...
> > Thanks for the input. The only problem is this is our leasing application
> > and we have to print mass batch of renewals once a year. I am thinking of
> > setting it on a schedule but that would remove a data range filter that is
> > in
> > place and is changable by the user. Any suggestions?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> OK, we had a failure to communicate. You said a 2 page report and I
> >> thought
> >> it was 2 pages long. You mean 2 pages per record.
> >>
> >> RS renders everything in RAM. Formats make a big difference in CPU
> >> utilizations. CSV, HTML are very fast. PDF and Excel are much slower and
> >> much much more intensive in resources required. My personal feeling is
> >> that
> >> when you are talking about that many pages it is an inappropriate use of
> >> RS.
> >> It is just not designed to be outputting 1000 pages of PDF. Users cannot
> >> look at that many pages anyway. You should consider drill through
> >> technique.
> >> Show the users what they need to see. I do know that sometimes users need
> >> to
> >> pull data into another program but that is not what PDF format is used
> >> for.
> >> Excel is another matter (although Excel can't handle 100,000 rows
> >> either).
> >> For Excel you could use CSV to get around this. For PDF there is no work
> >> around. More RAM helps but you really are overloading the server when you
> >> are doing this.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> >> news:790D7C48-1AB7-4F2A-A1C3-A1CF679B9B52@.microsoft.com...
> >> >I have all of the service packs installed. This is a 2 page report that
> >> > generates approx 950 pages. I have similar reports, but set to legal
> >> > single
> >> > page, that generate over 1000 pages in pdf. The error message I get
> >> > is:
> >> >
> >> > "Server Error in '/' Application.
> >> > The underlying connection was closed: An unexpected error occurred on a
> >> > receive.
> >> > Description: An unhandled exception occurred during the execution of
> >> > the
> >> > current web request. Please review the stack trace for more information
> >> > about
> >> > the error and where it originated in the code.
> >> > Exception Details: System.Net.WebException: The underlying connection
> >> > was
> >> > closed: An unexpected error occurred on a receive.
> >> > Source Error:
> >> > An unhandled exception was generated during the execution of the
> >> > current
> >> > web
> >> > request. Information regarding the origin and location of the exception
> >> > can
> >> > be identified using the exception stack trace below.
> >> >
> >> > Stack Trace:
> >> > [WebException: The underlying connection was closed: An unexpected
> >> > error
> >> > occurred on a receive.]
> >> > System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
> >> > t request) +58
> >> > System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
> >> > quest request) +5
> >> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> >> > methodName, Object[] parameters) +183
> >> > LAMS.SQLReportServer.ReportingService.Render(String Report, String
> >> > Format, String HistoryID, String DeviceInfo, ParameterValue[]
> >> > Parameters,
> >> > DataSourceCredentials[] Credentials, String ShowHideToggle, String&
> >> > Encoding,
> >> > String& MimeType, ParameterValue[]& ParametersUsed, Warning[]&
> >> > Warnings,
> >> > String[]& StreamIds) +141
> >> > LAMS.ReportViewer.RenderPDFReport() +618
> >> > LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
> >> > System.Web.UI.Control.OnLoad(EventArgs e) +67
> >> > System.Web.UI.Control.LoadRecursive() +35
> >> > System.Web.UI.Page.ProcessRequestMain() +750"
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> PDF's take significantly longer than HTML but it surprises me that a 2
> >> >> page
> >> >> report you see much of a difference. Do you have any service packs
> >> >> installed. If not, my advice is to install SP2.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> >> >> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
> >> >> > We have a web app, built in .Net, with reporting services as our
> >> >> > reporting
> >> >> > tool. The problem we are having is when we have a report that goes
> >> >> > to
> >> >> > numerous people and the report is 2 pages long. When we make it 1
> >> >> > page,
> >> >> > legal size, it works fine (avg records are 500-900). When this
> >> >> > report
> >> >> > is
> >> >> > generated it is created in a pdf format. I can run it on report
> >> >> > services
> >> >> > manager and in the viewer it takes approx 10 secs or less to run and
> >> >> > render,
> >> >> > but when we create the pdf it spikes the processor up to 90% and if
> >> >> > it's a
> >> >> > 2
> >> >> > page report it generates an error.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>sql

Report does not display the same as in the Preview window in Visual Studio

After formatting the report and making it look like I want too in the
Preview window of Visual Studio. I deploy the report to the web server
and when I open it - the web rendering (formatting) does not duplicate
what I see in the Preview window. It looks like it's adding extra rows
between the objects and is not following the vertical alignment that
was used in Visual Studio.
Does anyone have ideas on what could be causing this?
Thanks..I do. Verify if there are textboxes overlaping each other. In preview
windows this issue do not cause problem, but at render time, it does.
[]s
Renato
"Manuel" <mxgamez@.kelsey-seybold.com> escreveu na mensagem
news:ce53542a.0408260535.724891fd@.posting.google.com...
> After formatting the report and making it look like I want too in the
> Preview window of Visual Studio. I deploy the report to the web server
> and when I open it - the web rendering (formatting) does not duplicate
> what I see in the Preview window. It looks like it's adding extra rows
> between the objects and is not following the vertical alignment that
> was used in Visual Studio.
> Does anyone have ideas on what could be causing this?
> Thanks..|||Thanks... That worked.
"Renato Aloi" <aloi@.jew.com.br> wrote in message news:<OS$E9e3iEHA.2760@.TK2MSFTNGP15.phx.gbl>...
> I do. Verify if there are textboxes overlaping each other. In preview
> windows this issue do not cause problem, but at render time, it does.
> []s
> Renato
> "Manuel" <mxgamez@.kelsey-seybold.com> escreveu na mensagem
> news:ce53542a.0408260535.724891fd@.posting.google.com...
> > After formatting the report and making it look like I want too in the
> > Preview window of Visual Studio. I deploy the report to the web server
> > and when I open it - the web rendering (formatting) does not duplicate
> > what I see in the Preview window. It looks like it's adding extra rows
> > between the objects and is not following the vertical alignment that
> > was used in Visual Studio.
> >
> > Does anyone have ideas on what could be causing this?
> >
> > Thanks..

report does not come up in remote machine

Hello,
I embedded the report I developed to my asp.net web page,
when I run it in my development computer it is running
fine but I the report does not come up when I call web
page in a remote machine. The rest of web page is working
only report object is not coming. What might the problem
be?
Thanks,
Jim.The account used to access report may not have sufficient permissions to
access the report. You may need to give it sufficient privileges from Report
Manager UI.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <anonymous@.discussions.microsoft.com> wrote in message
news:a12801c48721$62e79070$a501280a@.phx.gbl...
> Hello,
> I embedded the report I developed to my asp.net web page,
> when I run it in my development computer it is running
> fine but I the report does not come up when I call web
> page in a remote machine. The rest of web page is working
> only report object is not coming. What might the problem
> be?
> Thanks,
> Jim.
>|||I am actually using the same user. Is report manager
Prograns-> Sql server-> Reporting Services -> Report
Manager? If yes, when I click that it goes to
Http://mylocalhost/Reports and it says "You are not
authorized to view this page"
Any solution?
>--Original Message--
>The account used to access report may not have sufficient
permissions to
>access the report. You may need to give it sufficient
privileges from Report
>Manager UI.
>--
>Ravi Mumulla (Microsoft)
>SQL Server Reporting Services
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"JIM.H." <anonymous@.discussions.microsoft.com> wrote in
message
>news:a12801c48721$62e79070$a501280a@.phx.gbl...
>> Hello,
>> I embedded the report I developed to my asp.net web
page,
>> when I run it in my development computer it is running
>> fine but I the report does not come up when I call web
>> page in a remote machine. The rest of web page is
working
>> only report object is not coming. What might the problem
>> be?
>> Thanks,
>> Jim.
>
>.
>

Report connect to AS cube

I cannot get my report to connect to my datacube. I've got RS running on a
web server and Analysis Services running on another server. The two servers
have an established relationship as i am currently able to run RS reports
against the SQL Server relational db's that exist on the server that is
running AS.
When i try to execute a report against a cube i get "cannot connect to the
server {myserver}. the server is either too busy or not started".
The connection string i am using is:
Provider=MSOLAP.2;Client Cache Size=25;Data Source={myserver};Auto Synch
Period=10000;Initial Catalog={mycatalog}
This all works fine in my dev environment where AS and RS run on the same
server.
What extra step am i missing to get my RS Web server to talk to my AS DB
server?
Thanks for any info.Sorry i do not know the answer for your question. But i am facing one
problem.I am unable to get the query designer, to type the MDX query to get
reports from my analysis server. I am using the Analysis server and web
server on the same machine.
When i am trying to create the report using SQL server relational db, i
am able to get the query designer. Please help me..
Dhar.
"JeffW" wrote:
> I cannot get my report to connect to my datacube. I've got RS running on a
> web server and Analysis Services running on another server. The two servers
> have an established relationship as i am currently able to run RS reports
> against the SQL Server relational db's that exist on the server that is
> running AS.
> When i try to execute a report against a cube i get "cannot connect to the
> server {myserver}. the server is either too busy or not started".
> The connection string i am using is:
> Provider=MSOLAP.2;Client Cache Size=25;Data Source={myserver};Auto Synch
> Period=10000;Initial Catalog={mycatalog}
> This all works fine in my dev environment where AS and RS run on the same
> server.
> What extra step am i missing to get my RS Web server to talk to my AS DB
> server?
> Thanks for any info.
>|||Dahr:
I was able to solve my problem. Turns out, port 2725 was not open between
my web and db servers. once i opened up that port everything runs fine.
As for your issue, if you are running version 1 of RS with sp1, it does not
support an mdx query designer. i believe that capability is scheduled for
the next release of Reporting services. For now, you just have to type the
mdx in, or use another mdx builder to get the query you need, and then
copy/paste it into rs.
Hope that helps.
JeffW
"Dhar" wrote:
> Sorry i do not know the answer for your question. But i am facing one
> problem.I am unable to get the query designer, to type the MDX query to get
> reports from my analysis server. I am using the Analysis server and web
> server on the same machine.
> When i am trying to create the report using SQL server relational db, i
> am able to get the query designer. Please help me..
>
> Dhar.
>
> "JeffW" wrote:
> > I cannot get my report to connect to my datacube. I've got RS running on a
> > web server and Analysis Services running on another server. The two servers
> > have an established relationship as i am currently able to run RS reports
> > against the SQL Server relational db's that exist on the server that is
> > running AS.
> >
> > When i try to execute a report against a cube i get "cannot connect to the
> > server {myserver}. the server is either too busy or not started".
> >
> > The connection string i am using is:
> > Provider=MSOLAP.2;Client Cache Size=25;Data Source={myserver};Auto Synch
> > Period=10000;Initial Catalog={mycatalog}
> >
> > This all works fine in my dev environment where AS and RS run on the same
> > server.
> >
> > What extra step am i missing to get my RS Web server to talk to my AS DB
> > server?
> >
> > Thanks for any info.
> >
> >

report caching

here is the deal- i have a bunch of reports to which i need to add a generic
caching plan. i know how to do this through the report manager web
interface on a per-report-basis. my problem is that i am lazy and don't
want to click through every single report individually setting up the
caching plan. is there a way to do this across all reports in a directory?
please tell me there is...
tia,
jtOn May 4, 5:13 pm, "JTL" <j...@.clickstreamtech.com> wrote:
> here is the deal- i have a bunch of reports to which i need to add a generic
> caching plan. i know how to do this through the report manager web
> interface on a per-report-basis. my problem is that i am lazy and don't
> want to click through every single report individually setting up the
> caching plan. is there a way to do this across all reports in a directory?
> please tell me there is...
> tia,
> jt
As far as I know, aside from modifying the caching plan one report at
a time, there is no other way to change the caching plan. Sorry I
could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hello,
You can perform operations on a report server through the use of the rs
utility (RS.exe).
In this way you can programmatically administer a report server using
Microsoft Visual Basic scripts.
I think this is only way to automate setting configuration for many reports.
Regards,
Radoslaw Lebkowski
MCTS
U¿ytkownik "JTL" <jt@.clickstreamtech.com> napisa³ w wiadomo¶ci
news:O3wJllpjHHA.588@.TK2MSFTNGP06.phx.gbl...
> here is the deal- i have a bunch of reports to which i need to add a
> generic caching plan. i know how to do this through the report manager
> web interface on a per-report-basis. my problem is that i am lazy and
> don't want to click through every single report individually setting up
> the caching plan. is there a way to do this across all reports in a
> directory? please tell me there is...
> tia,
> jt
>sql

Report Builder with Forms Authentication

Hi,

After implementing custom security extension for forms authentication, the report server works fine with Report Manager and web application. However, there is a problem with Report Builder.

It gives SecurityException "That assembly does not allow partially trusted callers.". Its becos I am using my own security assembly for authentication. I resolved this issue by using the following in my assemblyinfo.cs

[assembly: System.Security.Permissions.PermissionSet(System.Security.Permissions.SecurityAction.RequestMinimum, Name="FullTrust")]

However, now when I login to Report Builder it gives me error System.IO.FileNotFoundException. Its not able to find my security assembly.

I also tried giving FullTrust to the assembly using Framework 2.0 Configuration. I read somewhere that the ClickOnce application caches its last called settings in the manifest file and you have to delete the manifest and manually alter the security in the application settings(properties).

Is this true? Is there any solution to this issue? Is this really an issue with clickonce application?

This is really urgent. Any suggestions.

Thanks in advance.

Is there any solution to this?
This is really frustrating. We are duplicating all our security code into CustomSecurity Extension module. At least it stopped giving error at the point, where the call was made to an assembly. Dont know if it will really work, even after moving all the code to extension module.

I just hope someone from MS at least reads this post, if not care to reply.
I hope this helps someone.

Thankssql

Report Builder not appearing in Report Server 2005 Web page

I have provided required permissions, still user not able to view report builder option in his console.

what could be wrong? what needs to be done to provide report builder to users.

Deleep P

Please review the link below and let us know if this fixes your issue.

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

|||

Thanks for that hint. I have an issue now regarding rights of system users. Now they have delete rights from Root directory. What needs to be done to avert this. I want system user be able to only modify his folders and contents.

Deleep P

|||

Double-click on My Computer, right-click on the root-drive in question and select properties and then select the security tab. Highlight the Users group [ ex: Users(Servername\Users) ] ensure that only the Special Permission box has a checkmark in it. Then click on the Advanced button and this will bring you to the permission tab where you can specify the rights you wish your users to have on the root drive.

|||

I think i misled you, after opening the webpage as follows "http://<report_server _ip>/reports " I get "HOME' page. Here i am creating folders. My intention is to create separate directories in the name of different teams first. Then provide complete access to the team within their folder. One team should not delete the folder created for another team from the home page. currently for all report server users i have given "System user" access through site SITE SETTING IN THE HOME PAGE. After clicking on the SITE SETTINGS I selected configure site wide security and provided "system user" rights to all report server users. Plus all users will have "folder view" rights on the HOME folder. this is provided through HOME PAGE, PROPERTIES, SECURITY, NEW ROLE ASSIGNMENT.

Report Builder not appearing in Report Server 2005 Web page

I have provided required permissions, still user not able to view report builder option in his console.

what could be wrong? what needs to be done to provide report builder to users.

Deleep P

Please review the link below and let us know if this fixes your issue.

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

|||

Thanks for that hint. I have an issue now regarding rights of system users. Now they have delete rights from Root directory. What needs to be done to avert this. I want system user be able to only modify his folders and contents.

Deleep P

|||

Double-click on My Computer, right-click on the root-drive in question and select properties and then select the security tab. Highlight the Users group [ ex: Users(Servername\Users) ] ensure that only the Special Permission box has a checkmark in it. Then click on the Advanced button and this will bring you to the permission tab where you can specify the rights you wish your users to have on the root drive.

|||

I think i misled you, after opening the webpage as follows "http://<report_server _ip>/reports " I get "HOME' page. Here i am creating folders. My intention is to create separate directories in the name of different teams first. Then provide complete access to the team within their folder. One team should not delete the folder created for another team from the home page. currently for all report server users i have given "System user" access through site SITE SETTING IN THE HOME PAGE. After clicking on the SITE SETTINGS I selected configure site wide security and provided "system user" rights to all report server users. Plus all users will have "folder view" rights on the HOME folder. this is provided through HOME PAGE, PROPERTIES, SECURITY, NEW ROLE ASSIGNMENT.

Report Builder and Joins

Is there a way to use the online report builder web app and do table joins?
If so, how?
If not, just let me know.
Thanks.The report builder in SSRS 2005 is not a web app, it's actually a click-once
smart client application. You can have joined tabled but relationships
should be defined in the report model you create to use in the report builder.
"Kevin Antel" wrote:
> Is there a way to use the online report builder web app and do table joins?
> If so, how?
> If not, just let me know.
> Thanks.
>
>

Report Builder - filtering data

We have a web application that supports muliple companies (around 500). All
tables in our SQL Server database have a CompanyId field. We want to use
SSRS Report Builder to let end users create Ad Hoc reports. We need to
build a Model/Data View that allows an end user to veiw data from their
company only. How would we filter the data so that our end users do not see
other companies data in the Model that we design?
We can not allow the end user to create a filter for CompanyID at run time.I am trying to do the exact same thing (as I'm sure are many others), so any
assistance from Microsoft on this topic would be greatly appreciated...
Michael Carr
"Eva M." <Eva M.@.discussions.microsoft.com> wrote in message
news:7C18DD4A-8D07-46CC-A837-CAA2D0D5B156@.microsoft.com...
> We have a web application that supports muliple companies (around 500).
> All
> tables in our SQL Server database have a CompanyId field. We want to use
> SSRS Report Builder to let end users create Ad Hoc reports. We need to
> build a Model/Data View that allows an end user to veiw data from their
> company only. How would we filter the data so that our end users do not
> see
> other companies data in the Model that we design?
> We can not allow the end user to create a filter for CompanyID at run
> time.
>

Reporitng Services Web Service and Credentials

I have developed an asp.net, vb.net web app and have integrated reporting services. Right now I am using url access but am not to crazy about showing the parameters in the querystring. I am using a dynamic stored procedure to get client data. I would like to use the rs web service to programatically set the parameters and send them invisably to the web service. Since the web app is not using windows authentication I would like to pass the parameters using a hard coded account that has been set up with browse privilages in the report manager. Is it possible to hard code the credentials that are sent to the reporting service instead of the System.Net.CredentialsCache.DefaultCredentials? The report returns a bar graph which I am hoping to display on the page. Reading some posts about some problems returning images I might be posting some more questions.

Are there any good walkthroughs or code examples using reporting services web service other than MSDN's limited supply?

Thank you for your time!
--
- preisifigured out the first part

rs.Credentials = New System.Net.NetworkCredential("username", "password", "domain")

Now when i try and render my graph the image can't be found.|||this is not an answer to your question but infact a question to you. can you share with us about how far you have gotten in getting this RS thing to work. i mean i have created some reports which accept a couple of parameters. now i need to create a windows service that calls the reportservice everyday, and prints the report. which is a little similar to what you have done. xcept for the windows service part. so could you share some of your xperience ?

thanks.
dinakar

Replication/Admin Help

We run a small business with a LAN of 2 pcs, a laptop pc, and a web server that runs Win2k Server with Exchange on it. My pc is used for most of the development and it also houses SQL Server (Developer) 2k. We have SQL Server (Developer) installed on the other network pc as well.

Here's the problem: We sometimes have to take my pc with us to use at different sites (with no internet connectivity at the time). When this happens, any data access on our web site is 'down' because our web data is in the sql server db on my machine. I want to replicate the db on the other pc so that we can take that machine to the different sites. I am having trouble getting this done.

Can someone give me some direction? Is there a good tutorial or a book or whatever somewhere? I am really in need of some sql server admin knowledgebase.

Thanks!!Have you considered merge replication? you could then publish to your network sites from either computer with transactional publications and have the two "master" databases have a merge publication between them. When the machine goes off site, the other will continue to provide data to the site and when the other machine returns, any update made to it can be merged with the local machine.

if this will do the trick, books online should have all you need as far as setting it up goes...|||Have you considered merge replication? you could then publish to your network sites from either computer with transactional publications and have the two "master" databases have a merge publication between them. When the machine goes off site, the other will continue to provide data to the site and when the other machine returns, any update made to it can be merged with the local machine.

if this will do the trick, books online should have all you need as far as setting it up goes...