Link to another report on point labels in Pie Chart

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

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!
>

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

Linear equations?

Is there a way to solve a system of linear equations in Analysis Services?
Let's say I have a table with two columns for all the coefficients:
C12 - 0.30
C13 - 0.70
C21 - 0.15
C23 - 0.10
....
Is there something in Analysis Services that can do this?Can you give a bit more detail on what you are trying to achieve?|||I am trying to calculate cost allocations for budgeting, based on internal costs and a grid of distribution percentages. It comes down to solving a system of linear equations. It would have been great if I can create a report where this system is solved internally everytime the report is run.|||

There are a set of MDX functions for handling linear regression problems. It should be possible for you to use them to define one or more calculated members that take the output of one or more of the functions and calculate the cost allocations. If you look in Books Online at the MDX functions list, you'll see LinRegIntercept, LinRegPoint, LinRegSlope, LinRegVariance, and LinRegR2...

Dave Fackler

|||

And if you want to see an example of how these LinReg functions can be applied - you can check the following article: http://www.mosha.com/msolap/articles/mdxlinreg.htm

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

sql

Line 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

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.

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

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.

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
>

Limiting access to Report Designer Only

Hi,
Has anyone tried to limit access to Report Designer only? We have report
developers that can't have access to Integration Services, Analysis Services,
Report Models, etc. What files or directories can we remove to limit their
access?
Thanks for your help!You do not need to run reporting services to design report with VS.NET. That
is, you can cut all your report developers' access to your reporting
services, they still can design report on their own computer, as long as
report designer is installed along with VS.NET and they have data source to
test it (of coourse they cannot test deployment).
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
> Hi,
> Has anyone tried to limit access to Report Designer only? We have report
> developers that can't have access to Integration Services, Analysis
> Services,
> Report Models, etc. What files or directories can we remove to limit their
> access?
> Thanks for your help!|||Thanks for the reply. We've installed vs.net 2005 but don't see report
designer. How do you install it? Is there a snap-in or plug-in for Report
Designer?
Thanks!
"Norman Yuan" wrote:
> You do not need to run reporting services to design report with VS.NET. That
> is, you can cut all your report developers' access to your reporting
> services, they still can design report on their own computer, as long as
> report designer is installed along with VS.NET and they have data source to
> test it (of coourse they cannot test deployment).
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
> > Hi,
> >
> > Has anyone tried to limit access to Report Designer only? We have report
> > developers that can't have access to Integration Services, Analysis
> > Services,
> > Report Models, etc. What files or directories can we remove to limit their
> > access?
> >
> > Thanks for your help!
>
>|||Hi Norman, we have the same issue. It seems that VS 2005 does not ship with
report designer. Can it be downloaded seperately?
"Norman Yuan" wrote:
> You do not need to run reporting services to design report with VS.NET. That
> is, you can cut all your report developers' access to your reporting
> services, they still can design report on their own computer, as long as
> report designer is installed along with VS.NET and they have data source to
> test it (of coourse they cannot test deployment).
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
> > Hi,
> >
> > Has anyone tried to limit access to Report Designer only? We have report
> > developers that can't have access to Integration Services, Analysis
> > Services,
> > Report Models, etc. What files or directories can we remove to limit their
> > access?
> >
> > Thanks for your help!
>
>|||Install the client tools from RS 2005. It no longer requires having VS. It
comes with it's own VS that gets installed if you don't have it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ron Van Zanten" <RonVanZanten@.discussions.microsoft.com> wrote in message
news:6C6447BE-DFC7-424B-9EAF-F99436A7DD12@.microsoft.com...
> Hi Norman, we have the same issue. It seems that VS 2005 does not ship
> with
> report designer. Can it be downloaded seperately?
> "Norman Yuan" wrote:
>> You do not need to run reporting services to design report with VS.NET.
>> That
>> is, you can cut all your report developers' access to your reporting
>> services, they still can design report on their own computer, as long as
>> report designer is installed along with VS.NET and they have data source
>> to
>> test it (of coourse they cannot test deployment).
>> "clutch" <clutch@.discussions.microsoft.com> wrote in message
>> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
>> > Hi,
>> >
>> > Has anyone tried to limit access to Report Designer only? We have
>> > report
>> > developers that can't have access to Integration Services, Analysis
>> > Services,
>> > Report Models, etc. What files or directories can we remove to limit
>> > their
>> > access?
>> >
>> > Thanks for your help!
>>|||Hi Bruce,
We have installed the client tools from RS 2005 using the sql server 2005
release C2 disk. The problem is we need to be able to limit access to only
use Report Designer for certain developers. We don't want certain developers
to be able to use certain features such as SSIS, Analysis Services, Report
model designer, etc. Make sense? Is there a separate install for RS 2005
client tools?
Thanks for your help!
"Bruce L-C [MVP]" wrote:
> Install the client tools from RS 2005. It no longer requires having VS. It
> comes with it's own VS that gets installed if you don't have it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ron Van Zanten" <RonVanZanten@.discussions.microsoft.com> wrote in message
> news:6C6447BE-DFC7-424B-9EAF-F99436A7DD12@.microsoft.com...
> > Hi Norman, we have the same issue. It seems that VS 2005 does not ship
> > with
> > report designer. Can it be downloaded seperately?
> >
> > "Norman Yuan" wrote:
> >
> >> You do not need to run reporting services to design report with VS.NET.
> >> That
> >> is, you can cut all your report developers' access to your reporting
> >> services, they still can design report on their own computer, as long as
> >> report designer is installed along with VS.NET and they have data source
> >> to
> >> test it (of coourse they cannot test deployment).
> >>
> >> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> >> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
> >> > Hi,
> >> >
> >> > Has anyone tried to limit access to Report Designer only? We have
> >> > report
> >> > developers that can't have access to Integration Services, Analysis
> >> > Services,
> >> > Report Models, etc. What files or directories can we remove to limit
> >> > their
> >> > access?
> >> >
> >> > Thanks for your help!
> >>
> >>
> >>
>
>|||What you can do is they can develop but they cannot deploy. That is easy.
Also you can manage rights to the database which would determine what they
can do. Not sure about Report model designer. I don't know much about that.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:0E6CFB95-93CB-4537-989C-0E13C37A7228@.microsoft.com...
> Hi Bruce,
> We have installed the client tools from RS 2005 using the sql server 2005
> release C2 disk. The problem is we need to be able to limit access to only
> use Report Designer for certain developers. We don't want certain
> developers
> to be able to use certain features such as SSIS, Analysis Services, Report
> model designer, etc. Make sense? Is there a separate install for RS 2005
> client tools?
> Thanks for your help!
> "Bruce L-C [MVP]" wrote:
>> Install the client tools from RS 2005. It no longer requires having VS.
>> It
>> comes with it's own VS that gets installed if you don't have it.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Ron Van Zanten" <RonVanZanten@.discussions.microsoft.com> wrote in
>> message
>> news:6C6447BE-DFC7-424B-9EAF-F99436A7DD12@.microsoft.com...
>> > Hi Norman, we have the same issue. It seems that VS 2005 does not ship
>> > with
>> > report designer. Can it be downloaded seperately?
>> >
>> > "Norman Yuan" wrote:
>> >
>> >> You do not need to run reporting services to design report with
>> >> VS.NET.
>> >> That
>> >> is, you can cut all your report developers' access to your reporting
>> >> services, they still can design report on their own computer, as long
>> >> as
>> >> report designer is installed along with VS.NET and they have data
>> >> source
>> >> to
>> >> test it (of coourse they cannot test deployment).
>> >>
>> >> "clutch" <clutch@.discussions.microsoft.com> wrote in message
>> >> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
>> >> > Hi,
>> >> >
>> >> > Has anyone tried to limit access to Report Designer only? We have
>> >> > report
>> >> > developers that can't have access to Integration Services, Analysis
>> >> > Services,
>> >> > Report Models, etc. What files or directories can we remove to limit
>> >> > their
>> >> > access?
>> >> >
>> >> > Thanks for your help!
>> >>
>> >>
>> >>
>>

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

Limitation of # cubes inside a base Analysis Services

Does anyone

have any idea which is the limitation of # cubes inside a base Analysis Services,

because I created 50 cubes, and when I tried to connect to the base, i was

enable to do that because the CPU was at

100 %.

I think

that is a problem when analysis services tried to read the xmla and print all the cubes.

Tks

Well. There is a point where number of cubes and size of your data requre you to go and get a bigger machine.

It would be wrong to assume you can create any number of cubes and expect from Analysis Services not to use more CPU or memory trying to handle them all. The question what is reasonable. If you think that you got poweful machine with multiple processors and fast I/O and you see Analysis Services cannot handle large number of objects, there could be somehting. As a reference you can use Project REAL that handle large number of objects. http://www.microsoft.com/sql/solutions/bi/projectreal.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hallo Calacean,

the problem, you have accounted is not a SSAS with its limitations, but the client you use.

Some clients read copletely all metadata (available cubes, dimensins, hierarhies, levels, measures etc.) immediately after connection to the database.

Take a time to monitor with the SQL Profiler what commands and queries are sent from your client to the sever. You do find some interesting for you.

|||

Thanks, is

very useful, but i have another question if i don't bother you.

I have a data warehouse with 50 mil. dates. And i have 6 measures group with

relations many 2 many. When i query the cube, first is very slow( and i design aggregations

for all the measures), and second (I have proactive caching setup), when i want to

modify some data from the tables of proactive caching , the proactive caching

is working very god, but it decrease very much the performance of the server,

and the performance of the applications. I forget to mention that I have P4

2Ghz(2CPU), 2GB Memory, and I run Sql Server 2005 and Analysis Services in the

same server.

Limit to number of databases in Analysis Services 2005

We are trying to run a load test on analysis services 2005. We were
going to start with 30 different databases out there and see what the
processing loads were. Analysis Services is stopping us at 25
databases and telling us that there is no more room. We have 260 GB
free on the server. Has anyone run into this before? Is there a limit
to the number of databases you can have? Does it vary by SQL edition?http://msdn2.microsoft.com/en-us/library/ms365363.aspx
<rbergstrom@.spectrumhr.com> wrote in message
news:1154470182.648978.116860@.75g2000cwc.googlegroups.com...
> We are trying to run a load test on analysis services 2005. We were
> going to start with 30 different databases out there and see what the
> processing loads were. Analysis Services is stopping us at 25
> databases and telling us that there is no more room. We have 260 GB
> free on the server. Has anyone run into this before? Is there a limit
> to the number of databases you can have? Does it vary by SQL edition?
>|||Thanks for that link. Now I will ask a dumb question. in the page on
that link it shows Maximum sizes/numbers. The value for Databases in
an instance is 2^31-1 = 2,147,483,647. Is that a total size in bytes?
The number of databases? I don't understand what that is supposed to
represent. Thanks for your help.
Immy wrote:
> http://msdn2.microsoft.com/en-us/library/ms365363.aspx
> <rbergstrom@.spectrumhr.com> wrote in message
> news:1154470182.648978.116860@.75g2000cwc.googlegroups.com...
> > We are trying to run a load test on analysis services 2005. We were
> > going to start with 30 different databases out there and see what the
> > processing loads were. Analysis Services is stopping us at 25
> > databases and telling us that there is no more room. We have 260 GB
> > free on the server. Has anyone run into this before? Is there a limit
> > to the number of databases you can have? Does it vary by SQL edition?
> >

Limit to number of databases in Analysis Services 2005

We are trying to run a load test on analysis services 2005. We were
going to start with 30 different databases out there and see what the
processing loads were. Analysis Services is stopping us at 25
databases and telling us that there is no more room. We have 260 GB
free on the server. Has anyone run into this before? Is there a limit
to the number of databases you can have? Does it vary by SQL edition?http://msdn2.microsoft.com/en-us/library/ms365363.aspx
<rbergstrom@.spectrumhr.com> wrote in message
news:1154470182.648978.116860@.75g2000cwc.googlegroups.com...
> We are trying to run a load test on analysis services 2005. We were
> going to start with 30 different databases out there and see what the
> processing loads were. Analysis Services is stopping us at 25
> databases and telling us that there is no more room. We have 260 GB
> free on the server. Has anyone run into this before? Is there a limit
> to the number of databases you can have? Does it vary by SQL edition?
>|||Thanks for that link. Now I will ask a dumb question. in the page on
that link it shows Maximum sizes/numbers. The value for Databases in
an instance is 2^31-1 = 2,147,483,647. Is that a total size in bytes?
The number of databases? I don't understand what that is supposed to
represent. Thanks for your help.
Immy wrote:[vbcol=seagreen]
> http://msdn2.microsoft.com/en-us/library/ms365363.aspx
> <rbergstrom@.spectrumhr.com> wrote in message
> news:1154470182.648978.116860@.75g2000cwc.googlegroups.com...