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
Showing posts with label pages. Show all posts
Showing posts with label pages. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
Report creates extra page
I have a report that should only generate 2 pages but generates 3.
Group 1 of the report has 41 rows
Group 2 of the report has 52 rows
When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
"and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
to page 3.
Is there a limit? Or is there some setting somewhere to control this?
TIAThere is an option under the properties of the table/matrix to "fit on one
page if possible". Also at the top with file, edit, view....there is Report,
then report properties. Under the layout, the length of the page determines
how many objects can fit.
"czac" wrote:
> I have a report that should only generate 2 pages but generates 3.
> Group 1 of the report has 41 rows
> Group 2 of the report has 52 rows
> When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> to page 3.
> Is there a limit? Or is there some setting somewhere to control this?
> TIA|||thanks for the reply, scraejtp.
I checked the "fit on one page if possible", this is checked. Also, with
the Layout properties of the Report, Page width: 11in. Page height:8.5in.
(for Landscape printing) Isnt this just for the printing of the report?
thanks again.
"scraejtp" wrote:
> There is an option under the properties of the table/matrix to "fit on one
> page if possible". Also at the top with file, edit, view....there is Report,
> then report properties. Under the layout, the length of the page determines
> how many objects can fit.
> "czac" wrote:
> > I have a report that should only generate 2 pages but generates 3.
> >
> > Group 1 of the report has 41 rows
> > Group 2 of the report has 52 rows
> >
> > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > to page 3.
> >
> > Is there a limit? Or is there some setting somewhere to control this?
> >
> > TIA|||No, if you change that length it will also change how much can fit on a page.
"czac" wrote:
> thanks for the reply, scraejtp.
> I checked the "fit on one page if possible", this is checked. Also, with
> the Layout properties of the Report, Page width: 11in. Page height:8.5in.
> (for Landscape printing) Isnt this just for the printing of the report?
> thanks again.
>
> "scraejtp" wrote:
> > There is an option under the properties of the table/matrix to "fit on one
> > page if possible". Also at the top with file, edit, view....there is Report,
> > then report properties. Under the layout, the length of the page determines
> > how many objects can fit.
> >
> > "czac" wrote:
> >
> > > I have a report that should only generate 2 pages but generates 3.
> > >
> > > Group 1 of the report has 41 rows
> > > Group 2 of the report has 52 rows
> > >
> > > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > > to page 3.
> > >
> > > Is there a limit? Or is there some setting somewhere to control this?
> > >
> > > TIA|||...well...I changed the Page Height to 11in., that fixed the page 3 issue
but created a problem with printing landscape. Any ideas where to go from
here?
thanks.
"scraejtp" wrote:
> No, if you change that length it will also change how much can fit on a page.
> "czac" wrote:
> > thanks for the reply, scraejtp.
> >
> > I checked the "fit on one page if possible", this is checked. Also, with
> > the Layout properties of the Report, Page width: 11in. Page height:8.5in.
> > (for Landscape printing) Isnt this just for the printing of the report?
> >
> > thanks again.
> >
> >
> > "scraejtp" wrote:
> >
> > > There is an option under the properties of the table/matrix to "fit on one
> > > page if possible". Also at the top with file, edit, view....there is Report,
> > > then report properties. Under the layout, the length of the page determines
> > > how many objects can fit.
> > >
> > > "czac" wrote:
> > >
> > > > I have a report that should only generate 2 pages but generates 3.
> > > >
> > > > Group 1 of the report has 41 rows
> > > > Group 2 of the report has 52 rows
> > > >
> > > > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > > > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > > > to page 3.
> > > >
> > > > Is there a limit? Or is there some setting somewhere to control this?
> > > >
> > > > TIA|||Yes, I said it would also change the landscape. I don't see how else you want
it to fit. It will have to be longer to fit on the page, or make the typing
smaller to fit everything on the same size page. You could try keeping the
page size the same and making the margins less to fit a little more
information on the page.
"czac" wrote:
> ...well...I changed the Page Height to 11in., that fixed the page 3 issue
> but created a problem with printing landscape. Any ideas where to go from
> here?
> thanks.
> "scraejtp" wrote:
> > No, if you change that length it will also change how much can fit on a page.
> >
> > "czac" wrote:
> >
> > > thanks for the reply, scraejtp.
> > >
> > > I checked the "fit on one page if possible", this is checked. Also, with
> > > the Layout properties of the Report, Page width: 11in. Page height:8.5in.
> > > (for Landscape printing) Isnt this just for the printing of the report?
> > >
> > > thanks again.
> > >
> > >
> > > "scraejtp" wrote:
> > >
> > > > There is an option under the properties of the table/matrix to "fit on one
> > > > page if possible". Also at the top with file, edit, view....there is Report,
> > > > then report properties. Under the layout, the length of the page determines
> > > > how many objects can fit.
> > > >
> > > > "czac" wrote:
> > > >
> > > > > I have a report that should only generate 2 pages but generates 3.
> > > > >
> > > > > Group 1 of the report has 41 rows
> > > > > Group 2 of the report has 52 rows
> > > > >
> > > > > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > > > > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > > > > to page 3.
> > > > >
> > > > > Is there a limit? Or is there some setting somewhere to control this?
> > > > >
> > > > > TIA|||I have also had problem w/ xtra page. Sometimes it was due to a textbox
object in the header of my report. The textbox would 'hang' on the margin and
would force and extra page. Adjusting the size and or placement of header
items seemed to fix it. (also footer)
--
U. Tokklas
"scraejtp" wrote:
> Yes, I said it would also change the landscape. I don't see how else you want
> it to fit. It will have to be longer to fit on the page, or make the typing
> smaller to fit everything on the same size page. You could try keeping the
> page size the same and making the margins less to fit a little more
> information on the page.
> "czac" wrote:
> > ...well...I changed the Page Height to 11in., that fixed the page 3 issue
> > but created a problem with printing landscape. Any ideas where to go from
> > here?
> >
> > thanks.
> >
> > "scraejtp" wrote:
> >
> > > No, if you change that length it will also change how much can fit on a page.
> > >
> > > "czac" wrote:
> > >
> > > > thanks for the reply, scraejtp.
> > > >
> > > > I checked the "fit on one page if possible", this is checked. Also, with
> > > > the Layout properties of the Report, Page width: 11in. Page height:8.5in.
> > > > (for Landscape printing) Isnt this just for the printing of the report?
> > > >
> > > > thanks again.
> > > >
> > > >
> > > > "scraejtp" wrote:
> > > >
> > > > > There is an option under the properties of the table/matrix to "fit on one
> > > > > page if possible". Also at the top with file, edit, view....there is Report,
> > > > > then report properties. Under the layout, the length of the page determines
> > > > > how many objects can fit.
> > > > >
> > > > > "czac" wrote:
> > > > >
> > > > > > I have a report that should only generate 2 pages but generates 3.
> > > > > >
> > > > > > Group 1 of the report has 41 rows
> > > > > > Group 2 of the report has 52 rows
> > > > > >
> > > > > > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > > > > > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > > > > > to page 3.
> > > > > >
> > > > > > Is there a limit? Or is there some setting somewhere to control this?
> > > > > >
> > > > > > TIA|||I too had this problem (RS2005) - it is hugely frustrating. The solution for me turned out to be related to the width of my sub reports. To fix it, I had to play with the page width and margins in each of the sub reports (I set the margins to zero in parent and sub reports).
It seemed to be that my sub report changes would not show up when previewing the main report. Once I had saved and previewed the sub reports, then clicked the refresh button when previewing the parent report, the changes finally showed up and the extra page went away... hooray!
Good luck with this nasty proble
From http://www.developmentnow.com/g/115_2005_7_0_0_565515/Report-creates-extra-page.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com
Group 1 of the report has 41 rows
Group 2 of the report has 52 rows
When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
"and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
to page 3.
Is there a limit? Or is there some setting somewhere to control this?
TIAThere is an option under the properties of the table/matrix to "fit on one
page if possible". Also at the top with file, edit, view....there is Report,
then report properties. Under the layout, the length of the page determines
how many objects can fit.
"czac" wrote:
> I have a report that should only generate 2 pages but generates 3.
> Group 1 of the report has 41 rows
> Group 2 of the report has 52 rows
> When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> to page 3.
> Is there a limit? Or is there some setting somewhere to control this?
> TIA|||thanks for the reply, scraejtp.
I checked the "fit on one page if possible", this is checked. Also, with
the Layout properties of the Report, Page width: 11in. Page height:8.5in.
(for Landscape printing) Isnt this just for the printing of the report?
thanks again.
"scraejtp" wrote:
> There is an option under the properties of the table/matrix to "fit on one
> page if possible". Also at the top with file, edit, view....there is Report,
> then report properties. Under the layout, the length of the page determines
> how many objects can fit.
> "czac" wrote:
> > I have a report that should only generate 2 pages but generates 3.
> >
> > Group 1 of the report has 41 rows
> > Group 2 of the report has 52 rows
> >
> > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > to page 3.
> >
> > Is there a limit? Or is there some setting somewhere to control this?
> >
> > TIA|||No, if you change that length it will also change how much can fit on a page.
"czac" wrote:
> thanks for the reply, scraejtp.
> I checked the "fit on one page if possible", this is checked. Also, with
> the Layout properties of the Report, Page width: 11in. Page height:8.5in.
> (for Landscape printing) Isnt this just for the printing of the report?
> thanks again.
>
> "scraejtp" wrote:
> > There is an option under the properties of the table/matrix to "fit on one
> > page if possible". Also at the top with file, edit, view....there is Report,
> > then report properties. Under the layout, the length of the page determines
> > how many objects can fit.
> >
> > "czac" wrote:
> >
> > > I have a report that should only generate 2 pages but generates 3.
> > >
> > > Group 1 of the report has 41 rows
> > > Group 2 of the report has 52 rows
> > >
> > > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > > to page 3.
> > >
> > > Is there a limit? Or is there some setting somewhere to control this?
> > >
> > > TIA|||...well...I changed the Page Height to 11in., that fixed the page 3 issue
but created a problem with printing landscape. Any ideas where to go from
here?
thanks.
"scraejtp" wrote:
> No, if you change that length it will also change how much can fit on a page.
> "czac" wrote:
> > thanks for the reply, scraejtp.
> >
> > I checked the "fit on one page if possible", this is checked. Also, with
> > the Layout properties of the Report, Page width: 11in. Page height:8.5in.
> > (for Landscape printing) Isnt this just for the printing of the report?
> >
> > thanks again.
> >
> >
> > "scraejtp" wrote:
> >
> > > There is an option under the properties of the table/matrix to "fit on one
> > > page if possible". Also at the top with file, edit, view....there is Report,
> > > then report properties. Under the layout, the length of the page determines
> > > how many objects can fit.
> > >
> > > "czac" wrote:
> > >
> > > > I have a report that should only generate 2 pages but generates 3.
> > > >
> > > > Group 1 of the report has 41 rows
> > > > Group 2 of the report has 52 rows
> > > >
> > > > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > > > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > > > to page 3.
> > > >
> > > > Is there a limit? Or is there some setting somewhere to control this?
> > > >
> > > > TIA|||Yes, I said it would also change the landscape. I don't see how else you want
it to fit. It will have to be longer to fit on the page, or make the typing
smaller to fit everything on the same size page. You could try keeping the
page size the same and making the margins less to fit a little more
information on the page.
"czac" wrote:
> ...well...I changed the Page Height to 11in., that fixed the page 3 issue
> but created a problem with printing landscape. Any ideas where to go from
> here?
> thanks.
> "scraejtp" wrote:
> > No, if you change that length it will also change how much can fit on a page.
> >
> > "czac" wrote:
> >
> > > thanks for the reply, scraejtp.
> > >
> > > I checked the "fit on one page if possible", this is checked. Also, with
> > > the Layout properties of the Report, Page width: 11in. Page height:8.5in.
> > > (for Landscape printing) Isnt this just for the printing of the report?
> > >
> > > thanks again.
> > >
> > >
> > > "scraejtp" wrote:
> > >
> > > > There is an option under the properties of the table/matrix to "fit on one
> > > > page if possible". Also at the top with file, edit, view....there is Report,
> > > > then report properties. Under the layout, the length of the page determines
> > > > how many objects can fit.
> > > >
> > > > "czac" wrote:
> > > >
> > > > > I have a report that should only generate 2 pages but generates 3.
> > > > >
> > > > > Group 1 of the report has 41 rows
> > > > > Group 2 of the report has 52 rows
> > > > >
> > > > > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > > > > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > > > > to page 3.
> > > > >
> > > > > Is there a limit? Or is there some setting somewhere to control this?
> > > > >
> > > > > TIA|||I have also had problem w/ xtra page. Sometimes it was due to a textbox
object in the header of my report. The textbox would 'hang' on the margin and
would force and extra page. Adjusting the size and or placement of header
items seemed to fix it. (also footer)
--
U. Tokklas
"scraejtp" wrote:
> Yes, I said it would also change the landscape. I don't see how else you want
> it to fit. It will have to be longer to fit on the page, or make the typing
> smaller to fit everything on the same size page. You could try keeping the
> page size the same and making the margins less to fit a little more
> information on the page.
> "czac" wrote:
> > ...well...I changed the Page Height to 11in., that fixed the page 3 issue
> > but created a problem with printing landscape. Any ideas where to go from
> > here?
> >
> > thanks.
> >
> > "scraejtp" wrote:
> >
> > > No, if you change that length it will also change how much can fit on a page.
> > >
> > > "czac" wrote:
> > >
> > > > thanks for the reply, scraejtp.
> > > >
> > > > I checked the "fit on one page if possible", this is checked. Also, with
> > > > the Layout properties of the Report, Page width: 11in. Page height:8.5in.
> > > > (for Landscape printing) Isnt this just for the printing of the report?
> > > >
> > > > thanks again.
> > > >
> > > >
> > > > "scraejtp" wrote:
> > > >
> > > > > There is an option under the properties of the table/matrix to "fit on one
> > > > > page if possible". Also at the top with file, edit, view....there is Report,
> > > > > then report properties. Under the layout, the length of the page determines
> > > > > how many objects can fit.
> > > > >
> > > > > "czac" wrote:
> > > > >
> > > > > > I have a report that should only generate 2 pages but generates 3.
> > > > > >
> > > > > > Group 1 of the report has 41 rows
> > > > > > Group 2 of the report has 52 rows
> > > > > >
> > > > > > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > > > > > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > > > > > to page 3.
> > > > > >
> > > > > > Is there a limit? Or is there some setting somewhere to control this?
> > > > > >
> > > > > > TIA|||I too had this problem (RS2005) - it is hugely frustrating. The solution for me turned out to be related to the width of my sub reports. To fix it, I had to play with the page width and margins in each of the sub reports (I set the margins to zero in parent and sub reports).
It seemed to be that my sub report changes would not show up when previewing the main report. Once I had saved and previewed the sub reports, then clicked the refresh button when previewing the parent report, the changes finally showed up and the extra page went away... hooray!
Good luck with this nasty proble
From http://www.developmentnow.com/g/115_2005_7_0_0_565515/Report-creates-extra-page.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com
Wednesday, March 21, 2012
Report Builder Problem
I am having trouble with the Report Builder toolbar button is not showing up
on the reports pages of my reporting services.
If I run
http://servername/reportserver/reportbuilder/reportbuilder.application then
it will open the report builder and I can built reports and save back to my
report server. But if I open the report server http://servername/reports.
The toolbar button is not present.
It is a SQL Server 2005 Standard edition Installation running on Windows
Server 2003 as an application server.
I created a user in Reporting Services and gave them Content Manager rights.
Any help in what I need to change for the toolbar to be visible.
MikeMike,
Make sure that the system group that the user belongs (in the site-wide
security) to has Execute Report Definitions checked.
Mike Read wrote:
> I am having trouble with the Report Builder toolbar button is not showing up
> on the reports pages of my reporting services.
> If I run
> http://servername/reportserver/reportbuilder/reportbuilder.application then
> it will open the report builder and I can built reports and save back to my
> report server. But if I open the report server http://servername/reports.
> The toolbar button is not present.
> It is a SQL Server 2005 Standard edition Installation running on Windows
> Server 2003 as an application server.
> I created a user in Reporting Services and gave them Content Manager rights.
> Any help in what I need to change for the toolbar to be visible.
> Mike
on the reports pages of my reporting services.
If I run
http://servername/reportserver/reportbuilder/reportbuilder.application then
it will open the report builder and I can built reports and save back to my
report server. But if I open the report server http://servername/reports.
The toolbar button is not present.
It is a SQL Server 2005 Standard edition Installation running on Windows
Server 2003 as an application server.
I created a user in Reporting Services and gave them Content Manager rights.
Any help in what I need to change for the toolbar to be visible.
MikeMike,
Make sure that the system group that the user belongs (in the site-wide
security) to has Execute Report Definitions checked.
Mike Read wrote:
> I am having trouble with the Report Builder toolbar button is not showing up
> on the reports pages of my reporting services.
> If I run
> http://servername/reportserver/reportbuilder/reportbuilder.application then
> it will open the report builder and I can built reports and save back to my
> report server. But if I open the report server http://servername/reports.
> The toolbar button is not present.
> It is a SQL Server 2005 Standard edition Installation running on Windows
> Server 2003 as an application server.
> I created a user in Reporting Services and gave them Content Manager rights.
> Any help in what I need to change for the toolbar to be visible.
> Mike
Report Builder page header
SSRS 2005. When I create a report in Report Builder from a model, I can add a
title to the report, but it doesn't repeat on subsequent pages. How can I get
it (or something) to repeat at the top of every page?
Thanks
VernI have the exact same question. If anyone could point me in the direction of
the answer in this newsgroup it would be greatly appreciated.
"Vern Rabe" wrote:
> SSRS 2005. When I create a report in Report Builder from a model, I can add a
> title to the report, but it doesn't repeat on subsequent pages. How can I get
> it (or something) to repeat at the top of every page?
> Thanks
> Vern
title to the report, but it doesn't repeat on subsequent pages. How can I get
it (or something) to repeat at the top of every page?
Thanks
VernI have the exact same question. If anyone could point me in the direction of
the answer in this newsgroup it would be greatly appreciated.
"Vern Rabe" wrote:
> SSRS 2005. When I create a report in Report Builder from a model, I can add a
> title to the report, but it doesn't repeat on subsequent pages. How can I get
> it (or something) to repeat at the top of every page?
> Thanks
> Vern
Saturday, February 25, 2012
Report Authentication
This is a newbie question. I have the report viewer component on one of my
aspx pages. When the user tries to open this page, he/she is prompted with a
user/password on the server. How do I set up the reporting services so that
it uses a generic account for all requests from the web. Thanks.
PremWell, the wrong way is to turn on Anonymous access to the Report Server. The
proper way is to create a custom security extension to replace the default
Windows-based security.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Prem" <Prem@.discussions.microsoft.com> wrote in message
news:607E279E-7CC5-4135-BA35-F786EEE2A4E6@.microsoft.com...
> This is a newbie question. I have the report viewer component on one of my
> aspx pages. When the user tries to open this page, he/she is prompted with
a
> user/password on the server. How do I set up the reporting services so
that
> it uses a generic account for all requests from the web. Thanks.
> Prem
>|||Thanks Nell. That works.
"Nell" wrote:
> You need to grant permissions to your users and groups on the report server.
> You can do this at 'http://servername/reports', select the folder you want to
> apply permissions to, then select 'properties' and 'security'. Check out this
> article on Ode to Code for more info.
> http://odetocode.com/Articles/215.aspx
> You need to give browse access to the accounts you want to be able to view
> your reports, if you're using anonymous access then you need to make sure
> that the user you have set up in IIS for anonymous access (usually
> IUSR_computername or IWAM_computername) has this level of access. Don't
> give this account any unnecessary permissions though!
> "Prem" wrote:
> > This is a newbie question. I have the report viewer component on one of my
> > aspx pages. When the user tries to open this page, he/she is prompted with a
> > user/password on the server. How do I set up the reporting services so that
> > it uses a generic account for all requests from the web. Thanks.
> >
> > Prem
> >|||You need to grant permissions to your users and groups on the report server.
You can do this at 'http://servername/reports', select the folder you want to
apply permissions to, then select 'properties' and 'security'. Check out this
article on Ode to Code for more info.
http://odetocode.com/Articles/215.aspx
You need to give browse access to the accounts you want to be able to view
your reports, if you're using anonymous access then you need to make sure
that the user you have set up in IIS for anonymous access (usually
IUSR_computername or IWAM_computername) has this level of access. Don't
give this account any unnecessary permissions though!
"Prem" wrote:
> This is a newbie question. I have the report viewer component on one of my
> aspx pages. When the user tries to open this page, he/she is prompted with a
> user/password on the server. How do I set up the reporting services so that
> it uses a generic account for all requests from the web. Thanks.
> Prem
>
aspx pages. When the user tries to open this page, he/she is prompted with a
user/password on the server. How do I set up the reporting services so that
it uses a generic account for all requests from the web. Thanks.
PremWell, the wrong way is to turn on Anonymous access to the Report Server. The
proper way is to create a custom security extension to replace the default
Windows-based security.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Prem" <Prem@.discussions.microsoft.com> wrote in message
news:607E279E-7CC5-4135-BA35-F786EEE2A4E6@.microsoft.com...
> This is a newbie question. I have the report viewer component on one of my
> aspx pages. When the user tries to open this page, he/she is prompted with
a
> user/password on the server. How do I set up the reporting services so
that
> it uses a generic account for all requests from the web. Thanks.
> Prem
>|||Thanks Nell. That works.
"Nell" wrote:
> You need to grant permissions to your users and groups on the report server.
> You can do this at 'http://servername/reports', select the folder you want to
> apply permissions to, then select 'properties' and 'security'. Check out this
> article on Ode to Code for more info.
> http://odetocode.com/Articles/215.aspx
> You need to give browse access to the accounts you want to be able to view
> your reports, if you're using anonymous access then you need to make sure
> that the user you have set up in IIS for anonymous access (usually
> IUSR_computername or IWAM_computername) has this level of access. Don't
> give this account any unnecessary permissions though!
> "Prem" wrote:
> > This is a newbie question. I have the report viewer component on one of my
> > aspx pages. When the user tries to open this page, he/she is prompted with a
> > user/password on the server. How do I set up the reporting services so that
> > it uses a generic account for all requests from the web. Thanks.
> >
> > Prem
> >|||You need to grant permissions to your users and groups on the report server.
You can do this at 'http://servername/reports', select the folder you want to
apply permissions to, then select 'properties' and 'security'. Check out this
article on Ode to Code for more info.
http://odetocode.com/Articles/215.aspx
You need to give browse access to the accounts you want to be able to view
your reports, if you're using anonymous access then you need to make sure
that the user you have set up in IIS for anonymous access (usually
IUSR_computername or IWAM_computername) has this level of access. Don't
give this account any unnecessary permissions though!
"Prem" wrote:
> This is a newbie question. I have the report viewer component on one of my
> aspx pages. When the user tries to open this page, he/she is prompted with a
> user/password on the server. How do I set up the reporting services so that
> it uses a generic account for all requests from the web. Thanks.
> Prem
>
Report always displays 2 pages
Hi, I have a SQL Reporting service on which I have a footer with the number of page, something like "page 1 of 1". THe thing is, if I preview the report, it displays the nr of pages correctly, however, when I export to PDF; it alwas displays 2 pages, on the 2nd page only displays the footer "page 1 of 2" even if the first page is small and fits that page only. I've tried to reorganize the controls on the report and fit the footer to display only one page, however, no result.. any guess?Thanks a lot!Check the page margins settings in the report's properties.|||Problem solved. I've resized the report width to a less value than the value that I was using and is working!Thanks for the tip!
Subscribe to:
Posts (Atom)