Hello. I am new to SQL Server Reporting Services. The short explanation of what I want to do: In a pie chart, I have turned on point labels. I want each of the point labels to be a link. When you click on the link, you are taken to another report (in table format) that is more information about the data in that wedge of the pie.
If that is unclear, maybe it will help if I explain what I'm trying to do. The pie chart is a chart showing the status of developer issues in an issue tracking database. (Open, In-Progress, Awaiting Verification, Closed, Rejected, etc.) Each wedge of the pie has a point label that shows the number of issues that fall into the category (8 issues opened, 12 issues IP, etc.) When I click on the label that shows the number, I want to be taken to a table that shows what the issues in that category are.
Is this possible with SQL Server Reporting Services? Thanks in advance.Yes. Check out Chart Properties Dialog -> Values -> Edit -> Edit Chart Value
dialog box -> Action tab. You can choose Jump To Report option here and
specify the target report. You can also pass parameters to the target report
from this location.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Justin30519" <Justin30519@.discussions.microsoft.com> wrote in message
news:BC5B49B6-2B72-4D9C-A4B0-0CA3356E8114@.microsoft.com...
> Hello. I am new to SQL Server Reporting Services. The short explanation of
what I want to do: In a pie chart, I have turned on point labels. I want
each of the point labels to be a link. When you click on the link, you are
taken to another report (in table format) that is more information about the
data in that wedge of the pie.
> If that is unclear, maybe it will help if I explain what I'm trying to do.
The pie chart is a chart showing the status of developer issues in an issue
tracking database. (Open, In-Progress, Awaiting Verification, Closed,
Rejected, etc.) Each wedge of the pie has a point label that shows the
number of issues that fall into the category (8 issues opened, 12 issues IP,
etc.) When I click on the label that shows the number, I want to be taken to
a table that shows what the issues in that category are.
> Is this possible with SQL Server Reporting Services? Thanks in advance.|||Thank you very much for your reply. It was very helpful. My report works now.
Justin
Showing posts with label reporting. Show all posts
Showing posts with label reporting. Show all posts
Wednesday, March 28, 2012
Link to a report directory
I know how to link to Reporting Services, and how to link to a specific
report; is there any way to link to a specific directory? I'd like to send
my CRM users to a specific directory for CRM reports.
When I try http://RSSRV/ReportServer, I get to the general Report Server
directory; however, when I try http://RSSRV/ReportServer/CRM%20Reports/, I
get an error.
Thanks in advance!Put a ? in there:
http://RSSRV/ReportServer?/CRM%20Reports/
The path is actually a parameter.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Paul McBride" <pmcbride@.comcast.net> wrote in message
news:O%23jNhoF3EHA.480@.TK2MSFTNGP10.phx.gbl...
>I know how to link to Reporting Services, and how to link to a specific
> report; is there any way to link to a specific directory? I'd like to send
> my CRM users to a specific directory for CRM reports.
> When I try http://RSSRV/ReportServer, I get to the general Report Server
> directory; however, when I try http://RSSRV/ReportServer/CRM%20Reports/, I
> get an error.
> Thanks in advance!
>
report; is there any way to link to a specific directory? I'd like to send
my CRM users to a specific directory for CRM reports.
When I try http://RSSRV/ReportServer, I get to the general Report Server
directory; however, when I try http://RSSRV/ReportServer/CRM%20Reports/, I
get an error.
Thanks in advance!Put a ? in there:
http://RSSRV/ReportServer?/CRM%20Reports/
The path is actually a parameter.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Paul McBride" <pmcbride@.comcast.net> wrote in message
news:O%23jNhoF3EHA.480@.TK2MSFTNGP10.phx.gbl...
>I know how to link to Reporting Services, and how to link to a specific
> report; is there any way to link to a specific directory? I'd like to send
> my CRM users to a specific directory for CRM reports.
> When I try http://RSSRV/ReportServer, I get to the general Report Server
> directory; however, when I try http://RSSRV/ReportServer/CRM%20Reports/, I
> get an error.
> Thanks in advance!
>
Friday, March 23, 2012
Link Reports to System.Data.DataSets?
The mechanism to link a Crystal Report to data is by giving it a
System.Data.DataSet, I was wondering if this same option is possible in
Reporting Services.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!Today you have to create a data processing extension. In the future
(Widbey/Yukon) there will be a webform control and winform control that
would allow this. If you don't want to create a data processing extension
then the dataset needs to be generated from RS (either embed the SQL or call
a stored procedure). I suggest first looking at using RS without a data
processing extension and make sure you understand RS capabilities then if
you decide you have to do it with a data processing extension.
Remember, RS is a different architecture than Crystal so there will be
plenty of places where you need to approach things differently.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> The mechanism to link a Crystal Report to data is by giving it a
> System.Data.DataSet, I was wondering if this same option is possible in
> Reporting Services.
> --
> Sergio Florez M.
> Miembro activo de www.alianzadev.net
> Medellín, Colombia.
> El que persevera insiste!!!
>|||Thank you. The point is that not allowing to generate the reports from a
system.data.DataSet mean that reports can be rendered from data tha only
exists in memory and this is something that Crystal allows and that one of
my customers supposedly needs.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or
call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > Medellín, Colombia.
> > El que persevera insiste!!!
> >
> >
>|||uhh... I meant:
Thank you. The point is that not allowing to generate the reports from a
system.data.DataSet mean that reports can't be rendered from data that only
exists in memory and this is something that Crystal allows and that one of
my customers supposedly needs.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or
call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > Medellín, Colombia.
> > El que persevera insiste!!!
> >
> >
>|||Well, you can do it, it is just more complex, version 2 this will be much
simplier.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
news:OPn72Nn0EHA.2192@.TK2MSFTNGP14.phx.gbl...
> uhh... I meant:
> Thank you. The point is that not allowing to generate the reports from a
> system.data.DataSet mean that reports can't be rendered from data that
only
> exists in memory and this is something that Crystal allows and that one of
> my customers supposedly needs.
> --
> Sergio Florez M.
> Miembro activo de www.alianzadev.net
> Medellín, Colombia.
> El que persevera insiste!!!
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> > Today you have to create a data processing extension. In the future
> > (Widbey/Yukon) there will be a webform control and winform control that
> > would allow this. If you don't want to create a data processing
extension
> > then the dataset needs to be generated from RS (either embed the SQL or
> call
> > a stored procedure). I suggest first looking at using RS without a data
> > processing extension and make sure you understand RS capabilities then
if
> > you decide you have to do it with a data processing extension.
> >
> > Remember, RS is a different architecture than Crystal so there will be
> > plenty of places where you need to approach things differently.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> > news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > > The mechanism to link a Crystal Report to data is by giving it a
> > > System.Data.DataSet, I was wondering if this same option is possible
in
> > > Reporting Services.
> > >
> > > --
> > > Sergio Florez M.
> > > Miembro activo de www.alianzadev.net
> > > Medellín, Colombia.
> > > El que persevera insiste!!!
> > >
> > >
> >
> >
>|||Hi
I am not sure that I fully understand your suggestions. I have an ASP.NET
application that uses a web form to update an XML dataset. I would like to be
able to produce a report from the dataset and ideally I would like to
serialize it and pass it as a data source to an RS web service but RS does
not seem to support this. I could serialise and persist to SQL Server as a
single ntext field that could then be queried to return a complete XML
document. Again RS does not seem to handle this. I do not wish to create a
full set of SQL Server tables to persist the dataset at the field level just
to produce the report (there are rather a lot of items).
You indicated that a "data processing extension" might help with this. Could
you possibly expand a little more or point me in the right direction?
Thanks
"Bruce L-C [MVP]" wrote:
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > MedellÃn, Colombia.
> > El que persevera insiste!!!
> >
> >
>
>|||I have had some further thoughts and I would be interested to know if the
following approach might work:
1. Create a web-service report that accepts a string parameter and uses a
stored procedure as a data source to which it passess the parameter.
2. Write the stored procedure to accept a parameter of type ntext which it
passes to sp_xml_preparedocument and then generates the required output using
OPENXML().
3. From the asp.net application, serialise the xml from the dataset as a
string and pass as a parameter to the web-service report.
Thanks
"njr" wrote:
> Hi
> I am not sure that I fully understand your suggestions. I have an ASP.NET
> application that uses a web form to update an XML dataset. I would like to be
> able to produce a report from the dataset and ideally I would like to
> serialize it and pass it as a data source to an RS web service but RS does
> not seem to support this. I could serialise and persist to SQL Server as a
> single ntext field that could then be queried to return a complete XML
> document. Again RS does not seem to handle this. I do not wish to create a
> full set of SQL Server tables to persist the dataset at the field level just
> to produce the report (there are rather a lot of items).
> You indicated that a "data processing extension" might help with this. Could
> you possibly expand a little more or point me in the right direction?
> Thanks
> "Bruce L-C [MVP]" wrote:
> > Today you have to create a data processing extension. In the future
> > (Widbey/Yukon) there will be a webform control and winform control that
> > would allow this. If you don't want to create a data processing extension
> > then the dataset needs to be generated from RS (either embed the SQL or call
> > a stored procedure). I suggest first looking at using RS without a data
> > processing extension and make sure you understand RS capabilities then if
> > you decide you have to do it with a data processing extension.
> >
> > Remember, RS is a different architecture than Crystal so there will be
> > plenty of places where you need to approach things differently.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> > news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > > The mechanism to link a Crystal Report to data is by giving it a
> > > System.Data.DataSet, I was wondering if this same option is possible in
> > > Reporting Services.
> > >
> > > --
> > > Sergio Florez M.
> > > Miembro activo de www.alianzadev.net
> > > MedellÃn, Colombia.
> > > El que persevera insiste!!!
> > >
> > >
> >
> >
> >
System.Data.DataSet, I was wondering if this same option is possible in
Reporting Services.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!Today you have to create a data processing extension. In the future
(Widbey/Yukon) there will be a webform control and winform control that
would allow this. If you don't want to create a data processing extension
then the dataset needs to be generated from RS (either embed the SQL or call
a stored procedure). I suggest first looking at using RS without a data
processing extension and make sure you understand RS capabilities then if
you decide you have to do it with a data processing extension.
Remember, RS is a different architecture than Crystal so there will be
plenty of places where you need to approach things differently.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> The mechanism to link a Crystal Report to data is by giving it a
> System.Data.DataSet, I was wondering if this same option is possible in
> Reporting Services.
> --
> Sergio Florez M.
> Miembro activo de www.alianzadev.net
> Medellín, Colombia.
> El que persevera insiste!!!
>|||Thank you. The point is that not allowing to generate the reports from a
system.data.DataSet mean that reports can be rendered from data tha only
exists in memory and this is something that Crystal allows and that one of
my customers supposedly needs.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or
call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > Medellín, Colombia.
> > El que persevera insiste!!!
> >
> >
>|||uhh... I meant:
Thank you. The point is that not allowing to generate the reports from a
system.data.DataSet mean that reports can't be rendered from data that only
exists in memory and this is something that Crystal allows and that one of
my customers supposedly needs.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or
call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > Medellín, Colombia.
> > El que persevera insiste!!!
> >
> >
>|||Well, you can do it, it is just more complex, version 2 this will be much
simplier.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
news:OPn72Nn0EHA.2192@.TK2MSFTNGP14.phx.gbl...
> uhh... I meant:
> Thank you. The point is that not allowing to generate the reports from a
> system.data.DataSet mean that reports can't be rendered from data that
only
> exists in memory and this is something that Crystal allows and that one of
> my customers supposedly needs.
> --
> Sergio Florez M.
> Miembro activo de www.alianzadev.net
> Medellín, Colombia.
> El que persevera insiste!!!
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> > Today you have to create a data processing extension. In the future
> > (Widbey/Yukon) there will be a webform control and winform control that
> > would allow this. If you don't want to create a data processing
extension
> > then the dataset needs to be generated from RS (either embed the SQL or
> call
> > a stored procedure). I suggest first looking at using RS without a data
> > processing extension and make sure you understand RS capabilities then
if
> > you decide you have to do it with a data processing extension.
> >
> > Remember, RS is a different architecture than Crystal so there will be
> > plenty of places where you need to approach things differently.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> > news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > > The mechanism to link a Crystal Report to data is by giving it a
> > > System.Data.DataSet, I was wondering if this same option is possible
in
> > > Reporting Services.
> > >
> > > --
> > > Sergio Florez M.
> > > Miembro activo de www.alianzadev.net
> > > Medellín, Colombia.
> > > El que persevera insiste!!!
> > >
> > >
> >
> >
>|||Hi
I am not sure that I fully understand your suggestions. I have an ASP.NET
application that uses a web form to update an XML dataset. I would like to be
able to produce a report from the dataset and ideally I would like to
serialize it and pass it as a data source to an RS web service but RS does
not seem to support this. I could serialise and persist to SQL Server as a
single ntext field that could then be queried to return a complete XML
document. Again RS does not seem to handle this. I do not wish to create a
full set of SQL Server tables to persist the dataset at the field level just
to produce the report (there are rather a lot of items).
You indicated that a "data processing extension" might help with this. Could
you possibly expand a little more or point me in the right direction?
Thanks
"Bruce L-C [MVP]" wrote:
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > MedellÃn, Colombia.
> > El que persevera insiste!!!
> >
> >
>
>|||I have had some further thoughts and I would be interested to know if the
following approach might work:
1. Create a web-service report that accepts a string parameter and uses a
stored procedure as a data source to which it passess the parameter.
2. Write the stored procedure to accept a parameter of type ntext which it
passes to sp_xml_preparedocument and then generates the required output using
OPENXML().
3. From the asp.net application, serialise the xml from the dataset as a
string and pass as a parameter to the web-service report.
Thanks
"njr" wrote:
> Hi
> I am not sure that I fully understand your suggestions. I have an ASP.NET
> application that uses a web form to update an XML dataset. I would like to be
> able to produce a report from the dataset and ideally I would like to
> serialize it and pass it as a data source to an RS web service but RS does
> not seem to support this. I could serialise and persist to SQL Server as a
> single ntext field that could then be queried to return a complete XML
> document. Again RS does not seem to handle this. I do not wish to create a
> full set of SQL Server tables to persist the dataset at the field level just
> to produce the report (there are rather a lot of items).
> You indicated that a "data processing extension" might help with this. Could
> you possibly expand a little more or point me in the right direction?
> Thanks
> "Bruce L-C [MVP]" wrote:
> > Today you have to create a data processing extension. In the future
> > (Widbey/Yukon) there will be a webform control and winform control that
> > would allow this. If you don't want to create a data processing extension
> > then the dataset needs to be generated from RS (either embed the SQL or call
> > a stored procedure). I suggest first looking at using RS without a data
> > processing extension and make sure you understand RS capabilities then if
> > you decide you have to do it with a data processing extension.
> >
> > Remember, RS is a different architecture than Crystal so there will be
> > plenty of places where you need to approach things differently.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> > news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > > The mechanism to link a Crystal Report to data is by giving it a
> > > System.Data.DataSet, I was wondering if this same option is possible in
> > > Reporting Services.
> > >
> > > --
> > > Sergio Florez M.
> > > Miembro activo de www.alianzadev.net
> > > MedellÃn, Colombia.
> > > El que persevera insiste!!!
> > >
> > >
> >
> >
> >
Wednesday, March 21, 2012
LineHeight property
I am use Reporting services 2000 SP2 and discover that the LineHeight property rendered correctly only in renderers for HTML output. PDF renderer, TIFF renderer and client side printing client do not render changes in this property at all.
Is it bug in Reporting services 2000?
Can someone try to change LineHeight property in SQL Server 2005 Reporting services and verify rendering output?
The LineHeight property is only supported in HTML output (since there is direct support for LineHeight in HTML). The behavior is the same in SSRS 2000 and SSRS 2005.
-- Robert
Line Graph One Data Point
Re: SQL Svr 2000
VS.NET 2003, with SQL Reporting Services (RS)
I have a graph that is requested to be a line graph, with data starting in Jan (hence one data point).
The graph lines are not showing, but markers do show.
Can a line graph, in RS, produce lines when there is only one month's data.
If so, pray tell, how?
Y axis is a count of projects by Complexity levels.
X axis are the months, which will range from Jan to Dec, when all the data is in.
I need to show Jan results.
A line chart "connects" data points. If there is only one data point at all, there will be no line.
-- Robert
sqlLine graph on bar chart
Does anyone know if it is possible to create a graph where a line is on top
of a bar chart?
I'm using reporting services 2000, cheers
bobThis is not possible unless you have a 3rd party program such as Dundas
"bobfoc" <Greg.conn@.nospam.nospam> wrote in message
news:uB8GP9Q6FHA.2092@.TK2MSFTNGP12.phx.gbl...
> Does anyone know if it is possible to create a graph where a line is on
> top of a bar chart?
> I'm using reporting services 2000, cheers
> bob
>|||Hi Bob,
Can you be more specific? Do you need to create stacked values or
duplicate values bar - line charts?
You can download and try Nevron Chart for .NET from:
http://www.nevron.com
The evaluation is fully featured and you will be able to create
spectacular charts.
Regards,
Christo Bahchevanov
Nevron - Visualize Your Success|||And this works with reporting services yes?
Greg
"Christo Bahchevanov" <christo@.nevron.com> wrote in message
news:1133452933.814425.96550@.g14g2000cwa.googlegroups.com...
> Hi Bob,
> Can you be more specific? Do you need to create stacked values or
> duplicate values bar - line charts?
> You can download and try Nevron Chart for .NET from:
> http://www.nevron.com
> The evaluation is fully featured and you will be able to create
> spectacular charts.
> Regards,
> Christo Bahchevanov
> Nevron - Visualize Your Success
>|||Hi Greg,
Nevron Chart can be used as part of any program that want to generate
dynamic, data driven charts.
Feel free to download the free evaluation from http://www.nevron.com
Regards,
Christo Bahchevanov
Nevron - Visualize Your Success
of a bar chart?
I'm using reporting services 2000, cheers
bobThis is not possible unless you have a 3rd party program such as Dundas
"bobfoc" <Greg.conn@.nospam.nospam> wrote in message
news:uB8GP9Q6FHA.2092@.TK2MSFTNGP12.phx.gbl...
> Does anyone know if it is possible to create a graph where a line is on
> top of a bar chart?
> I'm using reporting services 2000, cheers
> bob
>|||Hi Bob,
Can you be more specific? Do you need to create stacked values or
duplicate values bar - line charts?
You can download and try Nevron Chart for .NET from:
http://www.nevron.com
The evaluation is fully featured and you will be able to create
spectacular charts.
Regards,
Christo Bahchevanov
Nevron - Visualize Your Success|||And this works with reporting services yes?
Greg
"Christo Bahchevanov" <christo@.nevron.com> wrote in message
news:1133452933.814425.96550@.g14g2000cwa.googlegroups.com...
> Hi Bob,
> Can you be more specific? Do you need to create stacked values or
> duplicate values bar - line charts?
> You can download and try Nevron Chart for .NET from:
> http://www.nevron.com
> The evaluation is fully featured and you will be able to create
> spectacular charts.
> Regards,
> Christo Bahchevanov
> Nevron - Visualize Your Success
>|||Hi Greg,
Nevron Chart can be used as part of any program that want to generate
dynamic, data driven charts.
Feel free to download the free evaluation from http://www.nevron.com
Regards,
Christo Bahchevanov
Nevron - Visualize Your Success
Monday, March 19, 2012
Line Column Charts
Is it possible to generate a line column chart in Reporting services.
It is possible in Excel. But I haven't found a way in reporting
services.Please check this previous posting (it also contains a sample RDL):
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"DavidR" <david.reller@.ato.gov.au> wrote in message
news:49eca18c.0409131955.7fe6de8e@.posting.google.com...
> Is it possible to generate a line column chart in Reporting services.
> It is possible in Excel. But I haven't found a way in reporting
> services.|||Thanks Robert
Next question is how does one add a secondary Y axis scale and title
like it is possible in Excel.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message news:<OwzDi8gmEHA.324@.TK2MSFTNGP11.phx.gbl>...
> Please check this previous posting (it also contains a sample RDL):
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "DavidR" <david.reller@.ato.gov.au> wrote in message
> news:49eca18c.0409131955.7fe6de8e@.posting.google.com...
> > Is it possible to generate a line column chart in Reporting services.
> > It is possible in Excel. But I haven't found a way in reporting
> > services.|||Secondary Y-axis is not natively supported in RS 2000, but is on the list
for inclusion in a future release. Some workarounds for RS 2000 are
discussed here:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=687c54df-a60c-4484-8d2b-3159cbc924d1&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"DavidR" <david.reller@.ato.gov.au> wrote in message
news:49eca18c.0409142149.7a9dc1d2@.posting.google.com...
> Thanks Robert
> Next question is how does one add a secondary Y axis scale and title
> like it is possible in Excel.
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:<OwzDi8gmEHA.324@.TK2MSFTNGP11.phx.gbl>...
> > Please check this previous posting (it also contains a sample RDL):
> >
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "DavidR" <david.reller@.ato.gov.au> wrote in message
> > news:49eca18c.0409131955.7fe6de8e@.posting.google.com...
> > > Is it possible to generate a line column chart in Reporting services.
> > > It is possible in Excel. But I haven't found a way in reporting
> > > services.
It is possible in Excel. But I haven't found a way in reporting
services.Please check this previous posting (it also contains a sample RDL):
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"DavidR" <david.reller@.ato.gov.au> wrote in message
news:49eca18c.0409131955.7fe6de8e@.posting.google.com...
> Is it possible to generate a line column chart in Reporting services.
> It is possible in Excel. But I haven't found a way in reporting
> services.|||Thanks Robert
Next question is how does one add a secondary Y axis scale and title
like it is possible in Excel.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message news:<OwzDi8gmEHA.324@.TK2MSFTNGP11.phx.gbl>...
> Please check this previous posting (it also contains a sample RDL):
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "DavidR" <david.reller@.ato.gov.au> wrote in message
> news:49eca18c.0409131955.7fe6de8e@.posting.google.com...
> > Is it possible to generate a line column chart in Reporting services.
> > It is possible in Excel. But I haven't found a way in reporting
> > services.|||Secondary Y-axis is not natively supported in RS 2000, but is on the list
for inclusion in a future release. Some workarounds for RS 2000 are
discussed here:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=687c54df-a60c-4484-8d2b-3159cbc924d1&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"DavidR" <david.reller@.ato.gov.au> wrote in message
news:49eca18c.0409142149.7a9dc1d2@.posting.google.com...
> Thanks Robert
> Next question is how does one add a secondary Y axis scale and title
> like it is possible in Excel.
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:<OwzDi8gmEHA.324@.TK2MSFTNGP11.phx.gbl>...
> > Please check this previous posting (it also contains a sample RDL):
> >
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "DavidR" <david.reller@.ato.gov.au> wrote in message
> > news:49eca18c.0409131955.7fe6de8e@.posting.google.com...
> > > Is it possible to generate a line column chart in Reporting services.
> > > It is possible in Excel. But I haven't found a way in reporting
> > > services.
Line Chart data points
Hello all,
I hope one of the gurus here can help me out.
I have a line chart in reporting services (sp2) with month on x-axis, year on
y-axis with aggregate monthly totals for datapoints. The user selects a date
range, say January 2004 to June 2005. The chart produces one line for each
year but since 2005 has not ended yet, there should be no data for the end of
the year but the chart is putting datapoints with a zero value on the chart.
When I put the same query in a matrix, those months don't show up because
there is no data (duh). How can I get those data points off the chart?
Looking forward to any help and many thanks in advance.
Cheers!Hi Wendy, I am still pretty new at this. But I would think an IIF statement
in the Filter tab of the Chart properties might work. I guessing here, but
that is the first thing that pop in my head when I read your post. Thanks and
have a great day, Kerrie
Wendy j wrote:
>Hello all,
>I hope one of the gurus here can help me out.
>I have a line chart in reporting services (sp2) with month on x-axis, year on
>y-axis with aggregate monthly totals for datapoints. The user selects a date
>range, say January 2004 to June 2005. The chart produces one line for each
>year but since 2005 has not ended yet, there should be no data for the end of
>the year but the chart is putting datapoints with a zero value on the chart.
>When I put the same query in a matrix, those months don't show up because
>there is no data (duh). How can I get those data points off the chart?
>Looking forward to any help and many thanks in advance.
>Cheers!
Message posted via http://www.sqlmonster.com|||Hi Kerrie,
Thanks for your reply! I thought the same thing initially but since the
points technically don't exist they cannot be filtered out. It is almost as
if the chart is 'filling in the blank' with a value of zero.
Wendy
Kerrie S wrote:
>Hi Wendy, I am still pretty new at this. But I would think an IIF statement
>in the Filter tab of the Chart properties might work. I guessing here, but
>that is the first thing that pop in my head when I read your post. Thanks and
>have a great day, Kerrie
>>Hello all,
>>I hope one of the gurus here can help me out.
>[quoted text clipped - 7 lines]
>>Looking forward to any help and many thanks in advance.
>>Cheers!
Message posted via http://www.sqlmonster.com|||Sorry I could not be more help. I hope someone answer you, I am curious to
know.
Wendy j wrote:
>Hi Kerrie,
>Thanks for your reply! I thought the same thing initially but since the
>points technically don't exist they cannot be filtered out. It is almost as
>if the chart is 'filling in the blank' with a value of zero.
>Wendy
>>Hi Wendy, I am still pretty new at this. But I would think an IIF statement
>>in the Filter tab of the Chart properties might work. I guessing here, but
>[quoted text clipped - 6 lines]
>>Looking forward to any help and many thanks in advance.
>>Cheers!
Message posted via http://www.sqlmonster.com|||It sounds like you are running into the issue described in the following KB
article: http://support.microsoft.com/kb/883675
However, this was definitely fixed on RS 2000 SP2. Are you sure you have SP2
installed for Report Designer and on the report server?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kerrie S via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:541C109219A03@.SQLMonster.com...
> Sorry I could not be more help. I hope someone answer you, I am curious to
> know.
> Wendy j wrote:
>>Hi Kerrie,
>>Thanks for your reply! I thought the same thing initially but since the
>>points technically don't exist they cannot be filtered out. It is almost
>>as
>>if the chart is 'filling in the blank' with a value of zero.
>>Wendy
>>Hi Wendy, I am still pretty new at this. But I would think an IIF
>>statement
>>in the Filter tab of the Chart properties might work. I guessing here,
>>but
>>[quoted text clipped - 6 lines]
>>Looking forward to any help and many thanks in advance.
>>Cheers!
>
> --
> Message posted via http://www.sqlmonster.com
I hope one of the gurus here can help me out.
I have a line chart in reporting services (sp2) with month on x-axis, year on
y-axis with aggregate monthly totals for datapoints. The user selects a date
range, say January 2004 to June 2005. The chart produces one line for each
year but since 2005 has not ended yet, there should be no data for the end of
the year but the chart is putting datapoints with a zero value on the chart.
When I put the same query in a matrix, those months don't show up because
there is no data (duh). How can I get those data points off the chart?
Looking forward to any help and many thanks in advance.
Cheers!Hi Wendy, I am still pretty new at this. But I would think an IIF statement
in the Filter tab of the Chart properties might work. I guessing here, but
that is the first thing that pop in my head when I read your post. Thanks and
have a great day, Kerrie
Wendy j wrote:
>Hello all,
>I hope one of the gurus here can help me out.
>I have a line chart in reporting services (sp2) with month on x-axis, year on
>y-axis with aggregate monthly totals for datapoints. The user selects a date
>range, say January 2004 to June 2005. The chart produces one line for each
>year but since 2005 has not ended yet, there should be no data for the end of
>the year but the chart is putting datapoints with a zero value on the chart.
>When I put the same query in a matrix, those months don't show up because
>there is no data (duh). How can I get those data points off the chart?
>Looking forward to any help and many thanks in advance.
>Cheers!
Message posted via http://www.sqlmonster.com|||Hi Kerrie,
Thanks for your reply! I thought the same thing initially but since the
points technically don't exist they cannot be filtered out. It is almost as
if the chart is 'filling in the blank' with a value of zero.
Wendy
Kerrie S wrote:
>Hi Wendy, I am still pretty new at this. But I would think an IIF statement
>in the Filter tab of the Chart properties might work. I guessing here, but
>that is the first thing that pop in my head when I read your post. Thanks and
>have a great day, Kerrie
>>Hello all,
>>I hope one of the gurus here can help me out.
>[quoted text clipped - 7 lines]
>>Looking forward to any help and many thanks in advance.
>>Cheers!
Message posted via http://www.sqlmonster.com|||Sorry I could not be more help. I hope someone answer you, I am curious to
know.
Wendy j wrote:
>Hi Kerrie,
>Thanks for your reply! I thought the same thing initially but since the
>points technically don't exist they cannot be filtered out. It is almost as
>if the chart is 'filling in the blank' with a value of zero.
>Wendy
>>Hi Wendy, I am still pretty new at this. But I would think an IIF statement
>>in the Filter tab of the Chart properties might work. I guessing here, but
>[quoted text clipped - 6 lines]
>>Looking forward to any help and many thanks in advance.
>>Cheers!
Message posted via http://www.sqlmonster.com|||It sounds like you are running into the issue described in the following KB
article: http://support.microsoft.com/kb/883675
However, this was definitely fixed on RS 2000 SP2. Are you sure you have SP2
installed for Report Designer and on the report server?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kerrie S via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:541C109219A03@.SQLMonster.com...
> Sorry I could not be more help. I hope someone answer you, I am curious to
> know.
> Wendy j wrote:
>>Hi Kerrie,
>>Thanks for your reply! I thought the same thing initially but since the
>>points technically don't exist they cannot be filtered out. It is almost
>>as
>>if the chart is 'filling in the blank' with a value of zero.
>>Wendy
>>Hi Wendy, I am still pretty new at this. But I would think an IIF
>>statement
>>in the Filter tab of the Chart properties might work. I guessing here,
>>but
>>[quoted text clipped - 6 lines]
>>Looking forward to any help and many thanks in advance.
>>Cheers!
>
> --
> Message posted via http://www.sqlmonster.com
Monday, March 12, 2012
Limits in Reporting Services
I read a post from one of the MVPs that stated "If you mean that the result
set has 90,000 records or 180,000 records then you have the wrong product. RS
is not designed to generate reports that are 1500+ pages."
Is there documentation available about the limits of RS (i.e. max number of
records, max number of pages, etc.)? I realize that it depends on the amount
of memory available, but I'd like to get the limits for the 2 GB process
maximum (numbers for 3GB with the /3GB option would be nice also).
Additionally, how is this affected by multiple users? Is it a sum total of
all requests or are the requests queued?
I looked in the docs first for this info and wasn't able to find it.
Thanks for your help."brett" wrote:
> I read a post from one of the MVPs that stated "If you mean that the result
> set has 90,000 records or 180,000 records then you have the wrong product. RS
> is not designed to generate reports that are 1500+ pages."
> Is there documentation available about the limits of RS (i.e. max number of
> records, max number of pages, etc.)? I realize that it depends on the amount
> of memory available, but I'd like to get the limits for the 2 GB process
> maximum (numbers for 3GB with the /3GB option would be nice also).
> Additionally, how is this affected by multiple users? Is it a sum total of
> all requests or are the requests queued?
> I looked in the docs first for this info and wasn't able to find it.
> Thanks for your help.
Hi Brett,
Are you outputting to pdf files. I have recently experienced a similar
problem where the reports timeout and don't work if there are over 4000
pages. We tried throttling the memory allocated to SQL on the box as well as
changing memory limits in the config file within Reporting services but that
has not seemed to do the trick.|||I am not aware of any document like that. PDF and Excel rendering take a lot
of processing power. Rendering to CSV is much much faster (I had a case
where Excel took 5 minutes and the same data rendered as CSV in about 15
seconds). That is a possible work around for you for large datasets.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"brett" <brett@.discussions.microsoft.com> wrote in message
news:5318C3D8-3051-45C4-AC1B-2D206C7AC2E8@.microsoft.com...
> I read a post from one of the MVPs that stated "If you mean that the
result
> set has 90,000 records or 180,000 records then you have the wrong product.
RS
> is not designed to generate reports that are 1500+ pages."
> Is there documentation available about the limits of RS (i.e. max number
of
> records, max number of pages, etc.)? I realize that it depends on the
amount
> of memory available, but I'd like to get the limits for the 2 GB process
> maximum (numbers for 3GB with the /3GB option would be nice also).
> Additionally, how is this affected by multiple users? Is it a sum total
of
> all requests or are the requests queued?
> I looked in the docs first for this info and wasn't able to find it.
> Thanks for your help.|||Rob,
Our application renders to the gui first, so that's where we are
encountering our problem. It's clearly a memory issue. I'm able to render
over 7K+ pages in the GUI, but then we get the OutOfMemory exception when we
go above that.
When I up the process memory limit to 3GB, I'm able to render more pages so
it's clearly a memory issue as the exception states.
I'm trying to get documentation so we can understand what the limits are so
we can tell our users what to expect. Telling them "don't run big reports"
isn't acceptable:)
"rob" wrote:
>
> "brett" wrote:
> > I read a post from one of the MVPs that stated "If you mean that the result
> > set has 90,000 records or 180,000 records then you have the wrong product. RS
> > is not designed to generate reports that are 1500+ pages."
> >
> > Is there documentation available about the limits of RS (i.e. max number of
> > records, max number of pages, etc.)? I realize that it depends on the amount
> > of memory available, but I'd like to get the limits for the 2 GB process
> > maximum (numbers for 3GB with the /3GB option would be nice also).
> >
> > Additionally, how is this affected by multiple users? Is it a sum total of
> > all requests or are the requests queued?
> >
> > I looked in the docs first for this info and wasn't able to find it.
> >
> > Thanks for your help.
>
> Hi Brett,
> Are you outputting to pdf files. I have recently experienced a similar
> problem where the reports timeout and don't work if there are over 4000
> pages. We tried throttling the memory allocated to SQL on the box as well as
> changing memory limits in the config file within Reporting services but that
> has not seemed to do the trick.|||Thanks for the feedback Bruce.
What we are wrestling with is there is a max amount of data the RS can
render and it's tied to memory. When our customers ask how big of a machine
they need to buy, we need to be able to give them some guidance based on
their data sets. We also need to be able to tell them (or prevent them in
code) what size of reports they can run.
If it's not documented, we'll have to test different memory configurations
and datasets...not a great use of resources.
"Bruce L-C [MVP]" wrote:
> I am not aware of any document like that. PDF and Excel rendering take a lot
> of processing power. Rendering to CSV is much much faster (I had a case
> where Excel took 5 minutes and the same data rendered as CSV in about 15
> seconds). That is a possible work around for you for large datasets.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "brett" <brett@.discussions.microsoft.com> wrote in message
> news:5318C3D8-3051-45C4-AC1B-2D206C7AC2E8@.microsoft.com...
> > I read a post from one of the MVPs that stated "If you mean that the
> result
> > set has 90,000 records or 180,000 records then you have the wrong product.
> RS
> > is not designed to generate reports that are 1500+ pages."
> >
> > Is there documentation available about the limits of RS (i.e. max number
> of
> > records, max number of pages, etc.)? I realize that it depends on the
> amount
> > of memory available, but I'd like to get the limits for the 2 GB process
> > maximum (numbers for 3GB with the /3GB option would be nice also).
> >
> > Additionally, how is this affected by multiple users? Is it a sum total
> of
> > all requests or are the requests queued?
> >
> > I looked in the docs first for this info and wasn't able to find it.
> >
> > Thanks for your help.
>
>|||One potential for large Excel data is to render it in CSV and specify ANSII
format (rather than the default of Unicode which Report Manager uses). Excel
doesn't handle Unicode CSV. If rendered in ANSII CSV then Excel will
appropriate put it in the correct columns. Might be a good solution for
people that want a data dump to perform their own analysis on.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"brett" <brett@.discussions.microsoft.com> wrote in message
news:290F0D39-1C39-436E-9597-75208873EEA3@.microsoft.com...
> Thanks for the feedback Bruce.
> What we are wrestling with is there is a max amount of data the RS can
> render and it's tied to memory. When our customers ask how big of a
machine
> they need to buy, we need to be able to give them some guidance based on
> their data sets. We also need to be able to tell them (or prevent them in
> code) what size of reports they can run.
> If it's not documented, we'll have to test different memory configurations
> and datasets...not a great use of resources.
> "Bruce L-C [MVP]" wrote:
> > I am not aware of any document like that. PDF and Excel rendering take a
lot
> > of processing power. Rendering to CSV is much much faster (I had a case
> > where Excel took 5 minutes and the same data rendered as CSV in about 15
> > seconds). That is a possible work around for you for large datasets.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "brett" <brett@.discussions.microsoft.com> wrote in message
> > news:5318C3D8-3051-45C4-AC1B-2D206C7AC2E8@.microsoft.com...
> > > I read a post from one of the MVPs that stated "If you mean that the
> > result
> > > set has 90,000 records or 180,000 records then you have the wrong
product.
> > RS
> > > is not designed to generate reports that are 1500+ pages."
> > >
> > > Is there documentation available about the limits of RS (i.e. max
number
> > of
> > > records, max number of pages, etc.)? I realize that it depends on the
> > amount
> > > of memory available, but I'd like to get the limits for the 2 GB
process
> > > maximum (numbers for 3GB with the /3GB option would be nice also).
> > >
> > > Additionally, how is this affected by multiple users? Is it a sum
total
> > of
> > > all requests or are the requests queued?
> > >
> > > I looked in the docs first for this info and wasn't able to find it.
> > >
> > > Thanks for your help.
> >
> >
> >|||We've actually had certain reports bring a server down because it was
taking so much memory and CPU time. Interestingly, the PDF format of
the same report didn't take very long nor did it bring the machine down.
Bruce L-C [MVP] wrote:
> I am not aware of any document like that. PDF and Excel rendering take a lot
> of processing power. Rendering to CSV is much much faster (I had a case
> where Excel took 5 minutes and the same data rendered as CSV in about 15
> seconds). That is a possible work around for you for large datasets.
>|||Our customer requirement is for the reports to be rendered in PDF format so
the CSV is not an option. There is also a logo graphic that is on each page
that adds to the problem as well.
"Bruce L-C [MVP]" wrote:
> One potential for large Excel data is to render it in CSV and specify ANSII
> format (rather than the default of Unicode which Report Manager uses). Excel
> doesn't handle Unicode CSV. If rendered in ANSII CSV then Excel will
> appropriate put it in the correct columns. Might be a good solution for
> people that want a data dump to perform their own analysis on.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "brett" <brett@.discussions.microsoft.com> wrote in message
> news:290F0D39-1C39-436E-9597-75208873EEA3@.microsoft.com...
> > Thanks for the feedback Bruce.
> >
> > What we are wrestling with is there is a max amount of data the RS can
> > render and it's tied to memory. When our customers ask how big of a
> machine
> > they need to buy, we need to be able to give them some guidance based on
> > their data sets. We also need to be able to tell them (or prevent them in
> > code) what size of reports they can run.
> >
> > If it's not documented, we'll have to test different memory configurations
> > and datasets...not a great use of resources.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > I am not aware of any document like that. PDF and Excel rendering take a
> lot
> > > of processing power. Rendering to CSV is much much faster (I had a case
> > > where Excel took 5 minutes and the same data rendered as CSV in about 15
> > > seconds). That is a possible work around for you for large datasets.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "brett" <brett@.discussions.microsoft.com> wrote in message
> > > news:5318C3D8-3051-45C4-AC1B-2D206C7AC2E8@.microsoft.com...
> > > > I read a post from one of the MVPs that stated "If you mean that the
> > > result
> > > > set has 90,000 records or 180,000 records then you have the wrong
> product.
> > > RS
> > > > is not designed to generate reports that are 1500+ pages."
> > > >
> > > > Is there documentation available about the limits of RS (i.e. max
> number
> > > of
> > > > records, max number of pages, etc.)? I realize that it depends on the
> > > amount
> > > > of memory available, but I'd like to get the limits for the 2 GB
> process
> > > > maximum (numbers for 3GB with the /3GB option would be nice also).
> > > >
> > > > Additionally, how is this affected by multiple users? Is it a sum
> total
> > > of
> > > > all requests or are the requests queued?
> > > >
> > > > I looked in the docs first for this info and wasn't able to find it.
> > > >
> > > > Thanks for your help.
> > >
> > >
> > >
>
>|||I agree with the MVP - a 4000+ page report is really just a fancy
data-feed.
I often have customers request such reports, and my typical response is
that Sql Reporting Services is not the right tool for the job. Just
because you "Can" do something doesnt mean that you should.
Also, assuming you do get this working, if you legitimately have a
4000+ page PDF report, then I have sympathy for the end-user who tries
to open it in Adobe Acrobat. I have seen Adobe Acrobat opening
sub-500 page PDF documents bring a high-end PC to its knees, so I am
fearful of what a 4000 page doc would be like.
There are plenty of alternatives...split the report into 40 PDF
documents @. 100 pages, extract the data to file, then use a 3rd party
PDF renderer to create the file, convince the users to accept an
ETL-generated CSV file, etc.
TIP: If you are the admin of a Sql Reporting Services instance, set a
report development standard for report developers to limit the number
of rows in a DataSet and the number of Pages rendered.
Typically my max threshold for data in a report DataSet is 5000 rows @.
5 columns (or equivilent). Also, my guideline for report-length is to
restrict report output to < 100 pages.
I hope this helps.
Lance Hunt
http://weblogs.asp.net/lhunt/|||"There are more reporting requirements in heaven and on earth, Lance,
than are dreamt of in your reporting architecture."|||We are working on supporting larger report sizes but yes, if you want to do
a pure data dump, Reporting Services is not the best tool for the job.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <lancehunt@.gmail.com> wrote in message
news:1116022906.085455.213970@.f14g2000cwb.googlegroups.com...
>I agree with the MVP - a 4000+ page report is really just a fancy
> data-feed.
> I often have customers request such reports, and my typical response is
> that Sql Reporting Services is not the right tool for the job. Just
> because you "Can" do something doesnt mean that you should.
> Also, assuming you do get this working, if you legitimately have a
> 4000+ page PDF report, then I have sympathy for the end-user who tries
> to open it in Adobe Acrobat. I have seen Adobe Acrobat opening
> sub-500 page PDF documents bring a high-end PC to its knees, so I am
> fearful of what a 4000 page doc would be like.
> There are plenty of alternatives...split the report into 40 PDF
> documents @. 100 pages, extract the data to file, then use a 3rd party
> PDF renderer to create the file, convince the users to accept an
> ETL-generated CSV file, etc.
> TIP: If you are the admin of a Sql Reporting Services instance, set a
> report development standard for report developers to limit the number
> of rows in a DataSet and the number of Pages rendered.
> Typically my max threshold for data in a report DataSet is 5000 rows @.
> 5 columns (or equivilent). Also, my guideline for report-length is to
> restrict report output to < 100 pages.
> I hope this helps.
> Lance Hunt
> http://weblogs.asp.net/lhunt/
>|||What other third party PDF rendering tool you would suggest? How do I split
current PDF report into many pages thru Reporting Services? I got the same
report that genearats more than 2500 pages and RS threw out 'OutofMemory'
execption. THanks.
-Chuck
"Lance" wrote:
> I agree with the MVP - a 4000+ page report is really just a fancy
> data-feed.
> I often have customers request such reports, and my typical response is
> that Sql Reporting Services is not the right tool for the job. Just
> because you "Can" do something doesnt mean that you should.
> Also, assuming you do get this working, if you legitimately have a
> 4000+ page PDF report, then I have sympathy for the end-user who tries
> to open it in Adobe Acrobat. I have seen Adobe Acrobat opening
> sub-500 page PDF documents bring a high-end PC to its knees, so I am
> fearful of what a 4000 page doc would be like.
> There are plenty of alternatives...split the report into 40 PDF
> documents @. 100 pages, extract the data to file, then use a 3rd party
> PDF renderer to create the file, convince the users to accept an
> ETL-generated CSV file, etc.
> TIP: If you are the admin of a Sql Reporting Services instance, set a
> report development standard for report developers to limit the number
> of rows in a DataSet and the number of Pages rendered.
> Typically my max threshold for data in a report DataSet is 5000 rows @.
> 5 columns (or equivilent). Also, my guideline for report-length is to
> restrict report output to < 100 pages.
> I hope this helps.
> Lance Hunt
> http://weblogs.asp.net/lhunt/
>|||Hi,
Since there's a conclusion here that reporting services is not the right
tool to work around for generating reports that have like more than 150 K
records, is there any solution to this? I mean even if we were to use excel,
excel files only support 65K plus records right?
Thanks
"brett" wrote:
> I read a post from one of the MVPs that stated "If you mean that the result
> set has 90,000 records or 180,000 records then you have the wrong product. RS
> is not designed to generate reports that are 1500+ pages."
> Is there documentation available about the limits of RS (i.e. max number of
> records, max number of pages, etc.)? I realize that it depends on the amount
> of memory available, but I'd like to get the limits for the 2 GB process
> maximum (numbers for 3GB with the /3GB option would be nice also).
> Additionally, how is this affected by multiple users? Is it a sum total of
> all requests or are the requests queued?
> I looked in the docs first for this info and wasn't able to find it.
> Thanks for your help.|||There are at least a few different ways to do this, but I recommend
starting at the end-user and working backwards.
If this report ultimately only needs to be machine-readable, then
choose a data-format such as XML, CSV, MDB (access). Then, work
backwards to figure-out the best technology to deliver this file(s).
If your end-users require this to be a human-readable report, then what
format do they want it in? HTML, Excel, XML, PDF, plain-text, etc.
Also, its unlikely that any person would need to read the entire report
top-to-bottom in one session, so figure-out how they plan to use the
report and break it up accordingly. Possibly this report could be
broken-down into several hundred HTML pages with a table-of-contents to
enable navigation. You may be able to use something such as XML-FO to
help automate this, or a simple XSL and a VBS script to chunk the data.
Hope this helps...
Lance Hunt
http://www.lance-hunt.net/|||It would be fascinating to learn the motivation behind this rather odd
requirement.|||That was me. RS does everything in memory (RAM). This makes sense from a
performance viewpoint but when you get to large amounts of data then that
really makes a difference. The other issue is just efficiency of rendering.
Rendering to PDF and Excel is much slower than HTML or CSV. They have
emphasized fidelity rather than performance. If doing large amounts to Excel
then the following will be very very fast. You need to have a link to do
this because Report Manager defaults to unicode which Excel puts all in one
column. In RS 2005 you will be able to configure Report Manager to use ASCII
CSV export.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Very nice and very fast.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"et_ck" <etck@.discussions.microsoft.com> wrote in message
news:09627F24-3E35-4ABC-A353-DED4A8865DEF@.microsoft.com...
> Hi,
> Since there's a conclusion here that reporting services is not the right
> tool to work around for generating reports that have like more than 150 K
> records, is there any solution to this? I mean even if we were to use
> excel,
> excel files only support 65K plus records right?
> Thanks
> "brett" wrote:
>> I read a post from one of the MVPs that stated "If you mean that the
>> result
>> set has 90,000 records or 180,000 records then you have the wrong
>> product. RS
>> is not designed to generate reports that are 1500+ pages."
>> Is there documentation available about the limits of RS (i.e. max number
>> of
>> records, max number of pages, etc.)? I realize that it depends on the
>> amount
>> of memory available, but I'd like to get the limits for the 2 GB process
>> maximum (numbers for 3GB with the /3GB option would be nice also).
>> Additionally, how is this affected by multiple users? Is it a sum total
>> of
>> all requests or are the requests queued?
>> I looked in the docs first for this info and wasn't able to find it.
>> Thanks for your help.|||I'm with the masses here... what the hell would you do with a 400
page printed report? It's pointless, no-one will read through it. Yo
need to find out what your customer wants to do with it
Personally I'm a fan of exception reports where you actually buil
logic into your report rather than just spewing data from
database
Likewise, with reporting services you could build a summary repor
where the user can interactively drill to more detail which would b
a subset of your 4000 pages|||This is probably some braindead legal requirement, even the most
hideous of paper wasters would not ask for something like this.
set has 90,000 records or 180,000 records then you have the wrong product. RS
is not designed to generate reports that are 1500+ pages."
Is there documentation available about the limits of RS (i.e. max number of
records, max number of pages, etc.)? I realize that it depends on the amount
of memory available, but I'd like to get the limits for the 2 GB process
maximum (numbers for 3GB with the /3GB option would be nice also).
Additionally, how is this affected by multiple users? Is it a sum total of
all requests or are the requests queued?
I looked in the docs first for this info and wasn't able to find it.
Thanks for your help."brett" wrote:
> I read a post from one of the MVPs that stated "If you mean that the result
> set has 90,000 records or 180,000 records then you have the wrong product. RS
> is not designed to generate reports that are 1500+ pages."
> Is there documentation available about the limits of RS (i.e. max number of
> records, max number of pages, etc.)? I realize that it depends on the amount
> of memory available, but I'd like to get the limits for the 2 GB process
> maximum (numbers for 3GB with the /3GB option would be nice also).
> Additionally, how is this affected by multiple users? Is it a sum total of
> all requests or are the requests queued?
> I looked in the docs first for this info and wasn't able to find it.
> Thanks for your help.
Hi Brett,
Are you outputting to pdf files. I have recently experienced a similar
problem where the reports timeout and don't work if there are over 4000
pages. We tried throttling the memory allocated to SQL on the box as well as
changing memory limits in the config file within Reporting services but that
has not seemed to do the trick.|||I am not aware of any document like that. PDF and Excel rendering take a lot
of processing power. Rendering to CSV is much much faster (I had a case
where Excel took 5 minutes and the same data rendered as CSV in about 15
seconds). That is a possible work around for you for large datasets.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"brett" <brett@.discussions.microsoft.com> wrote in message
news:5318C3D8-3051-45C4-AC1B-2D206C7AC2E8@.microsoft.com...
> I read a post from one of the MVPs that stated "If you mean that the
result
> set has 90,000 records or 180,000 records then you have the wrong product.
RS
> is not designed to generate reports that are 1500+ pages."
> Is there documentation available about the limits of RS (i.e. max number
of
> records, max number of pages, etc.)? I realize that it depends on the
amount
> of memory available, but I'd like to get the limits for the 2 GB process
> maximum (numbers for 3GB with the /3GB option would be nice also).
> Additionally, how is this affected by multiple users? Is it a sum total
of
> all requests or are the requests queued?
> I looked in the docs first for this info and wasn't able to find it.
> Thanks for your help.|||Rob,
Our application renders to the gui first, so that's where we are
encountering our problem. It's clearly a memory issue. I'm able to render
over 7K+ pages in the GUI, but then we get the OutOfMemory exception when we
go above that.
When I up the process memory limit to 3GB, I'm able to render more pages so
it's clearly a memory issue as the exception states.
I'm trying to get documentation so we can understand what the limits are so
we can tell our users what to expect. Telling them "don't run big reports"
isn't acceptable:)
"rob" wrote:
>
> "brett" wrote:
> > I read a post from one of the MVPs that stated "If you mean that the result
> > set has 90,000 records or 180,000 records then you have the wrong product. RS
> > is not designed to generate reports that are 1500+ pages."
> >
> > Is there documentation available about the limits of RS (i.e. max number of
> > records, max number of pages, etc.)? I realize that it depends on the amount
> > of memory available, but I'd like to get the limits for the 2 GB process
> > maximum (numbers for 3GB with the /3GB option would be nice also).
> >
> > Additionally, how is this affected by multiple users? Is it a sum total of
> > all requests or are the requests queued?
> >
> > I looked in the docs first for this info and wasn't able to find it.
> >
> > Thanks for your help.
>
> Hi Brett,
> Are you outputting to pdf files. I have recently experienced a similar
> problem where the reports timeout and don't work if there are over 4000
> pages. We tried throttling the memory allocated to SQL on the box as well as
> changing memory limits in the config file within Reporting services but that
> has not seemed to do the trick.|||Thanks for the feedback Bruce.
What we are wrestling with is there is a max amount of data the RS can
render and it's tied to memory. When our customers ask how big of a machine
they need to buy, we need to be able to give them some guidance based on
their data sets. We also need to be able to tell them (or prevent them in
code) what size of reports they can run.
If it's not documented, we'll have to test different memory configurations
and datasets...not a great use of resources.
"Bruce L-C [MVP]" wrote:
> I am not aware of any document like that. PDF and Excel rendering take a lot
> of processing power. Rendering to CSV is much much faster (I had a case
> where Excel took 5 minutes and the same data rendered as CSV in about 15
> seconds). That is a possible work around for you for large datasets.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "brett" <brett@.discussions.microsoft.com> wrote in message
> news:5318C3D8-3051-45C4-AC1B-2D206C7AC2E8@.microsoft.com...
> > I read a post from one of the MVPs that stated "If you mean that the
> result
> > set has 90,000 records or 180,000 records then you have the wrong product.
> RS
> > is not designed to generate reports that are 1500+ pages."
> >
> > Is there documentation available about the limits of RS (i.e. max number
> of
> > records, max number of pages, etc.)? I realize that it depends on the
> amount
> > of memory available, but I'd like to get the limits for the 2 GB process
> > maximum (numbers for 3GB with the /3GB option would be nice also).
> >
> > Additionally, how is this affected by multiple users? Is it a sum total
> of
> > all requests or are the requests queued?
> >
> > I looked in the docs first for this info and wasn't able to find it.
> >
> > Thanks for your help.
>
>|||One potential for large Excel data is to render it in CSV and specify ANSII
format (rather than the default of Unicode which Report Manager uses). Excel
doesn't handle Unicode CSV. If rendered in ANSII CSV then Excel will
appropriate put it in the correct columns. Might be a good solution for
people that want a data dump to perform their own analysis on.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"brett" <brett@.discussions.microsoft.com> wrote in message
news:290F0D39-1C39-436E-9597-75208873EEA3@.microsoft.com...
> Thanks for the feedback Bruce.
> What we are wrestling with is there is a max amount of data the RS can
> render and it's tied to memory. When our customers ask how big of a
machine
> they need to buy, we need to be able to give them some guidance based on
> their data sets. We also need to be able to tell them (or prevent them in
> code) what size of reports they can run.
> If it's not documented, we'll have to test different memory configurations
> and datasets...not a great use of resources.
> "Bruce L-C [MVP]" wrote:
> > I am not aware of any document like that. PDF and Excel rendering take a
lot
> > of processing power. Rendering to CSV is much much faster (I had a case
> > where Excel took 5 minutes and the same data rendered as CSV in about 15
> > seconds). That is a possible work around for you for large datasets.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "brett" <brett@.discussions.microsoft.com> wrote in message
> > news:5318C3D8-3051-45C4-AC1B-2D206C7AC2E8@.microsoft.com...
> > > I read a post from one of the MVPs that stated "If you mean that the
> > result
> > > set has 90,000 records or 180,000 records then you have the wrong
product.
> > RS
> > > is not designed to generate reports that are 1500+ pages."
> > >
> > > Is there documentation available about the limits of RS (i.e. max
number
> > of
> > > records, max number of pages, etc.)? I realize that it depends on the
> > amount
> > > of memory available, but I'd like to get the limits for the 2 GB
process
> > > maximum (numbers for 3GB with the /3GB option would be nice also).
> > >
> > > Additionally, how is this affected by multiple users? Is it a sum
total
> > of
> > > all requests or are the requests queued?
> > >
> > > I looked in the docs first for this info and wasn't able to find it.
> > >
> > > Thanks for your help.
> >
> >
> >|||We've actually had certain reports bring a server down because it was
taking so much memory and CPU time. Interestingly, the PDF format of
the same report didn't take very long nor did it bring the machine down.
Bruce L-C [MVP] wrote:
> I am not aware of any document like that. PDF and Excel rendering take a lot
> of processing power. Rendering to CSV is much much faster (I had a case
> where Excel took 5 minutes and the same data rendered as CSV in about 15
> seconds). That is a possible work around for you for large datasets.
>|||Our customer requirement is for the reports to be rendered in PDF format so
the CSV is not an option. There is also a logo graphic that is on each page
that adds to the problem as well.
"Bruce L-C [MVP]" wrote:
> One potential for large Excel data is to render it in CSV and specify ANSII
> format (rather than the default of Unicode which Report Manager uses). Excel
> doesn't handle Unicode CSV. If rendered in ANSII CSV then Excel will
> appropriate put it in the correct columns. Might be a good solution for
> people that want a data dump to perform their own analysis on.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "brett" <brett@.discussions.microsoft.com> wrote in message
> news:290F0D39-1C39-436E-9597-75208873EEA3@.microsoft.com...
> > Thanks for the feedback Bruce.
> >
> > What we are wrestling with is there is a max amount of data the RS can
> > render and it's tied to memory. When our customers ask how big of a
> machine
> > they need to buy, we need to be able to give them some guidance based on
> > their data sets. We also need to be able to tell them (or prevent them in
> > code) what size of reports they can run.
> >
> > If it's not documented, we'll have to test different memory configurations
> > and datasets...not a great use of resources.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > I am not aware of any document like that. PDF and Excel rendering take a
> lot
> > > of processing power. Rendering to CSV is much much faster (I had a case
> > > where Excel took 5 minutes and the same data rendered as CSV in about 15
> > > seconds). That is a possible work around for you for large datasets.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "brett" <brett@.discussions.microsoft.com> wrote in message
> > > news:5318C3D8-3051-45C4-AC1B-2D206C7AC2E8@.microsoft.com...
> > > > I read a post from one of the MVPs that stated "If you mean that the
> > > result
> > > > set has 90,000 records or 180,000 records then you have the wrong
> product.
> > > RS
> > > > is not designed to generate reports that are 1500+ pages."
> > > >
> > > > Is there documentation available about the limits of RS (i.e. max
> number
> > > of
> > > > records, max number of pages, etc.)? I realize that it depends on the
> > > amount
> > > > of memory available, but I'd like to get the limits for the 2 GB
> process
> > > > maximum (numbers for 3GB with the /3GB option would be nice also).
> > > >
> > > > Additionally, how is this affected by multiple users? Is it a sum
> total
> > > of
> > > > all requests or are the requests queued?
> > > >
> > > > I looked in the docs first for this info and wasn't able to find it.
> > > >
> > > > Thanks for your help.
> > >
> > >
> > >
>
>|||I agree with the MVP - a 4000+ page report is really just a fancy
data-feed.
I often have customers request such reports, and my typical response is
that Sql Reporting Services is not the right tool for the job. Just
because you "Can" do something doesnt mean that you should.
Also, assuming you do get this working, if you legitimately have a
4000+ page PDF report, then I have sympathy for the end-user who tries
to open it in Adobe Acrobat. I have seen Adobe Acrobat opening
sub-500 page PDF documents bring a high-end PC to its knees, so I am
fearful of what a 4000 page doc would be like.
There are plenty of alternatives...split the report into 40 PDF
documents @. 100 pages, extract the data to file, then use a 3rd party
PDF renderer to create the file, convince the users to accept an
ETL-generated CSV file, etc.
TIP: If you are the admin of a Sql Reporting Services instance, set a
report development standard for report developers to limit the number
of rows in a DataSet and the number of Pages rendered.
Typically my max threshold for data in a report DataSet is 5000 rows @.
5 columns (or equivilent). Also, my guideline for report-length is to
restrict report output to < 100 pages.
I hope this helps.
Lance Hunt
http://weblogs.asp.net/lhunt/|||"There are more reporting requirements in heaven and on earth, Lance,
than are dreamt of in your reporting architecture."|||We are working on supporting larger report sizes but yes, if you want to do
a pure data dump, Reporting Services is not the best tool for the job.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <lancehunt@.gmail.com> wrote in message
news:1116022906.085455.213970@.f14g2000cwb.googlegroups.com...
>I agree with the MVP - a 4000+ page report is really just a fancy
> data-feed.
> I often have customers request such reports, and my typical response is
> that Sql Reporting Services is not the right tool for the job. Just
> because you "Can" do something doesnt mean that you should.
> Also, assuming you do get this working, if you legitimately have a
> 4000+ page PDF report, then I have sympathy for the end-user who tries
> to open it in Adobe Acrobat. I have seen Adobe Acrobat opening
> sub-500 page PDF documents bring a high-end PC to its knees, so I am
> fearful of what a 4000 page doc would be like.
> There are plenty of alternatives...split the report into 40 PDF
> documents @. 100 pages, extract the data to file, then use a 3rd party
> PDF renderer to create the file, convince the users to accept an
> ETL-generated CSV file, etc.
> TIP: If you are the admin of a Sql Reporting Services instance, set a
> report development standard for report developers to limit the number
> of rows in a DataSet and the number of Pages rendered.
> Typically my max threshold for data in a report DataSet is 5000 rows @.
> 5 columns (or equivilent). Also, my guideline for report-length is to
> restrict report output to < 100 pages.
> I hope this helps.
> Lance Hunt
> http://weblogs.asp.net/lhunt/
>|||What other third party PDF rendering tool you would suggest? How do I split
current PDF report into many pages thru Reporting Services? I got the same
report that genearats more than 2500 pages and RS threw out 'OutofMemory'
execption. THanks.
-Chuck
"Lance" wrote:
> I agree with the MVP - a 4000+ page report is really just a fancy
> data-feed.
> I often have customers request such reports, and my typical response is
> that Sql Reporting Services is not the right tool for the job. Just
> because you "Can" do something doesnt mean that you should.
> Also, assuming you do get this working, if you legitimately have a
> 4000+ page PDF report, then I have sympathy for the end-user who tries
> to open it in Adobe Acrobat. I have seen Adobe Acrobat opening
> sub-500 page PDF documents bring a high-end PC to its knees, so I am
> fearful of what a 4000 page doc would be like.
> There are plenty of alternatives...split the report into 40 PDF
> documents @. 100 pages, extract the data to file, then use a 3rd party
> PDF renderer to create the file, convince the users to accept an
> ETL-generated CSV file, etc.
> TIP: If you are the admin of a Sql Reporting Services instance, set a
> report development standard for report developers to limit the number
> of rows in a DataSet and the number of Pages rendered.
> Typically my max threshold for data in a report DataSet is 5000 rows @.
> 5 columns (or equivilent). Also, my guideline for report-length is to
> restrict report output to < 100 pages.
> I hope this helps.
> Lance Hunt
> http://weblogs.asp.net/lhunt/
>|||Hi,
Since there's a conclusion here that reporting services is not the right
tool to work around for generating reports that have like more than 150 K
records, is there any solution to this? I mean even if we were to use excel,
excel files only support 65K plus records right?
Thanks
"brett" wrote:
> I read a post from one of the MVPs that stated "If you mean that the result
> set has 90,000 records or 180,000 records then you have the wrong product. RS
> is not designed to generate reports that are 1500+ pages."
> Is there documentation available about the limits of RS (i.e. max number of
> records, max number of pages, etc.)? I realize that it depends on the amount
> of memory available, but I'd like to get the limits for the 2 GB process
> maximum (numbers for 3GB with the /3GB option would be nice also).
> Additionally, how is this affected by multiple users? Is it a sum total of
> all requests or are the requests queued?
> I looked in the docs first for this info and wasn't able to find it.
> Thanks for your help.|||There are at least a few different ways to do this, but I recommend
starting at the end-user and working backwards.
If this report ultimately only needs to be machine-readable, then
choose a data-format such as XML, CSV, MDB (access). Then, work
backwards to figure-out the best technology to deliver this file(s).
If your end-users require this to be a human-readable report, then what
format do they want it in? HTML, Excel, XML, PDF, plain-text, etc.
Also, its unlikely that any person would need to read the entire report
top-to-bottom in one session, so figure-out how they plan to use the
report and break it up accordingly. Possibly this report could be
broken-down into several hundred HTML pages with a table-of-contents to
enable navigation. You may be able to use something such as XML-FO to
help automate this, or a simple XSL and a VBS script to chunk the data.
Hope this helps...
Lance Hunt
http://www.lance-hunt.net/|||It would be fascinating to learn the motivation behind this rather odd
requirement.|||That was me. RS does everything in memory (RAM). This makes sense from a
performance viewpoint but when you get to large amounts of data then that
really makes a difference. The other issue is just efficiency of rendering.
Rendering to PDF and Excel is much slower than HTML or CSV. They have
emphasized fidelity rather than performance. If doing large amounts to Excel
then the following will be very very fast. You need to have a link to do
this because Report Manager defaults to unicode which Excel puts all in one
column. In RS 2005 you will be able to configure Report Manager to use ASCII
CSV export.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Very nice and very fast.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"et_ck" <etck@.discussions.microsoft.com> wrote in message
news:09627F24-3E35-4ABC-A353-DED4A8865DEF@.microsoft.com...
> Hi,
> Since there's a conclusion here that reporting services is not the right
> tool to work around for generating reports that have like more than 150 K
> records, is there any solution to this? I mean even if we were to use
> excel,
> excel files only support 65K plus records right?
> Thanks
> "brett" wrote:
>> I read a post from one of the MVPs that stated "If you mean that the
>> result
>> set has 90,000 records or 180,000 records then you have the wrong
>> product. RS
>> is not designed to generate reports that are 1500+ pages."
>> Is there documentation available about the limits of RS (i.e. max number
>> of
>> records, max number of pages, etc.)? I realize that it depends on the
>> amount
>> of memory available, but I'd like to get the limits for the 2 GB process
>> maximum (numbers for 3GB with the /3GB option would be nice also).
>> Additionally, how is this affected by multiple users? Is it a sum total
>> of
>> all requests or are the requests queued?
>> I looked in the docs first for this info and wasn't able to find it.
>> Thanks for your help.|||I'm with the masses here... what the hell would you do with a 400
page printed report? It's pointless, no-one will read through it. Yo
need to find out what your customer wants to do with it
Personally I'm a fan of exception reports where you actually buil
logic into your report rather than just spewing data from
database
Likewise, with reporting services you could build a summary repor
where the user can interactively drill to more detail which would b
a subset of your 4000 pages|||This is probably some braindead legal requirement, even the most
hideous of paper wasters would not ask for something like this.
Friday, March 9, 2012
Limiting Access with Forms Authentication
All,
I have successfully implemented a forms authentication model for
reporting services in our dev environment. I took the code directly
from the MSDN whitepaper "Using Forms Authentication in Reporting
Services", although I did modify the authentication portion to use an
in house Oracle solution. How do I go about ensuring that only certain
groups (departments) have access to certain folders in the report
manager? Is this possible with a forms authentication solution?
ThanksSearch the below URL for 'forms authentication groups'. I found quite a few
results:
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs
Adrian M.
MCP
"Will" <wlansing@.rlcarriers.com> wrote in message
news:1109799138.404265.258540@.z14g2000cwz.googlegroups.com...
> All,
> I have successfully implemented a forms authentication model for
> reporting services in our dev environment. I took the code directly
> from the MSDN whitepaper "Using Forms Authentication in Reporting
> Services", although I did modify the authentication portion to use an
> in house Oracle solution. How do I go about ensuring that only certain
> groups (departments) have access to certain folders in the report
> manager? Is this possible with a forms authentication solution?
> Thanks
>
I have successfully implemented a forms authentication model for
reporting services in our dev environment. I took the code directly
from the MSDN whitepaper "Using Forms Authentication in Reporting
Services", although I did modify the authentication portion to use an
in house Oracle solution. How do I go about ensuring that only certain
groups (departments) have access to certain folders in the report
manager? Is this possible with a forms authentication solution?
ThanksSearch the below URL for 'forms authentication groups'. I found quite a few
results:
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs
Adrian M.
MCP
"Will" <wlansing@.rlcarriers.com> wrote in message
news:1109799138.404265.258540@.z14g2000cwz.googlegroups.com...
> All,
> I have successfully implemented a forms authentication model for
> reporting services in our dev environment. I took the code directly
> from the MSDN whitepaper "Using Forms Authentication in Reporting
> Services", although I did modify the authentication portion to use an
> in house Oracle solution. How do I go about ensuring that only certain
> groups (departments) have access to certain folders in the report
> manager? Is this possible with a forms authentication solution?
> Thanks
>
Wednesday, March 7, 2012
LIMITED PIE CHART LEGEND ?
Hi,
I have a problem with Reporting services pie chart legend which is
limited in character
Does it exists a solution to write more text on pie charts legend ?
Thx !Hi rebeupaname,
Depending upon what you're after, you could either:
1) drop a textbox onto the chart and position it near the legend to add
supplemental info, or
2) use an expression for the series label to change the text inside of
the legend
Does this help?
Matt A
Reporting Services Newsletter at www.reportarchitex.com
rebeuapaname@.hotmail.com wrote:
> Hi,
> I have a problem with Reporting services pie chart legend which is
> limited in character
> Does it exists a solution to write more text on pie charts legend ?
> Thx !|||Thank you vert much, i have resolved the problem
But another limitation of PIE CHARTS make me loose time :
I'am looking for a maner to GROUP little values of a graph in one
categorie called "OTHER". For example all value under 1% will be
grouped in the "OTHER" category
Do you understand what i want to say ?
Thx
I have a problem with Reporting services pie chart legend which is
limited in character
Does it exists a solution to write more text on pie charts legend ?
Thx !Hi rebeupaname,
Depending upon what you're after, you could either:
1) drop a textbox onto the chart and position it near the legend to add
supplemental info, or
2) use an expression for the series label to change the text inside of
the legend
Does this help?
Matt A
Reporting Services Newsletter at www.reportarchitex.com
rebeuapaname@.hotmail.com wrote:
> Hi,
> I have a problem with Reporting services pie chart legend which is
> limited in character
> Does it exists a solution to write more text on pie charts legend ?
> Thx !|||Thank you vert much, i have resolved the problem
But another limitation of PIE CHARTS make me loose time :
I'am looking for a maner to GROUP little values of a graph in one
categorie called "OTHER". For example all value under 1% will be
grouped in the "OTHER" category
Do you understand what i want to say ?
Thx
Subscribe to:
Posts (Atom)