Enterprise or Standard? Infinite Clickthrough??

We are going to separate reporting services from our database server by
putting RS on a single separate server. We need to know if we can use
Standard or if we have to purchase Enterprise. We have Enterprise for our DB
server. The major differences between the 2 editions are data driven
subscriptions, which we do not need at this time, and infinite clickthrough.
I cannot find a good definition of infinite clickthrough. We have reports
that navigate to other reports. In Standard, is some clickthrough still
available but only up to a certain number of clicks?
Any details would really be appreciated.
StephanieI searched a little on this because I run with Standard and I've never come
up across this limitation. I found out the reason for why I have never
noticed it. It has to do with Report Builder (which I do not use). Here is a
posting by a Program Manager for RS:
>>>>>>>>>>
Infinte Clickthrough is a feature of Report Builder. It allows you to
automatically drill between reports by using the relationships between
entities in the Report Model. The drillthroughs are created "on the fly"
without having to build them beforehand. Workgroup and standard edition only
get pre-defined drillthroughs.
----
Brian Welcker, Microsoft
>>>>>>>>>
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:2CAC3038-95EA-4D0D-9E84-8EDE1DE24D8A@.microsoft.com...
> We are going to separate reporting services from our database server by
> putting RS on a single separate server. We need to know if we can use
> Standard or if we have to purchase Enterprise. We have Enterprise for our
> DB
> server. The major differences between the 2 editions are data driven
> subscriptions, which we do not need at this time, and infinite
> clickthrough.
> I cannot find a good definition of infinite clickthrough. We have reports
> that navigate to other reports. In Standard, is some clickthrough still
> available but only up to a certain number of clicks?
> Any details would really be appreciated.
> Stephanie|||Bruce,
Thanks for the quick response. I read that article, too, and still was a
bit confused. I do not use Report Builder either. I do, however, have
navigation set up to jump from one report to another.
Is it your opinion as well that I should be able to run Reporting Services
Standard Edition on a separate server and still have the ability to use the
Navigation tab and jump from one report to another? If so, would there be a
limit on the number of jumps I can execute? I have a call in to MS but I am
looking for any feedback as well. The cost difference is enough to warrant
some research.
Stephanie
"Bruce L-C [MVP]" wrote:
> I searched a little on this because I run with Standard and I've never come
> up across this limitation. I found out the reason for why I have never
> noticed it. It has to do with Report Builder (which I do not use). Here is a
> posting by a Program Manager for RS:
> >>>>>>>>>>
> Infinte Clickthrough is a feature of Report Builder. It allows you to
> automatically drill between reports by using the relationships between
> entities in the Report Model. The drillthroughs are created "on the fly"
> without having to build them beforehand. Workgroup and standard edition only
> get pre-defined drillthroughs.
>
> ----
> Brian Welcker, Microsoft
> >>>>>>>>>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
>
>
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:2CAC3038-95EA-4D0D-9E84-8EDE1DE24D8A@.microsoft.com...
> > We are going to separate reporting services from our database server by
> > putting RS on a single separate server. We need to know if we can use
> > Standard or if we have to purchase Enterprise. We have Enterprise for our
> > DB
> > server. The major differences between the 2 editions are data driven
> > subscriptions, which we do not need at this time, and infinite
> > clickthrough.
> > I cannot find a good definition of infinite clickthrough. We have reports
> > that navigate to other reports. In Standard, is some clickthrough still
> > available but only up to a certain number of clicks?
> >
> > Any details would really be appreciated.
> >
> > Stephanie
>
>|||I think it was pretty clear that the infinite clickthrough was a report
builder feature. I run standard and have lots of drill through (that is what
jump to report is called). If there is a limit I have not seen it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:7DE14E7D-779B-4068-943B-69BA1D726A51@.microsoft.com...
> Bruce,
> Thanks for the quick response. I read that article, too, and still was a
> bit confused. I do not use Report Builder either. I do, however, have
> navigation set up to jump from one report to another.
> Is it your opinion as well that I should be able to run Reporting Services
> Standard Edition on a separate server and still have the ability to use
> the
> Navigation tab and jump from one report to another? If so, would there be
> a
> limit on the number of jumps I can execute? I have a call in to MS but I
> am
> looking for any feedback as well. The cost difference is enough to
> warrant
> some research.
> Stephanie
> "Bruce L-C [MVP]" wrote:
>> I searched a little on this because I run with Standard and I've never
>> come
>> up across this limitation. I found out the reason for why I have never
>> noticed it. It has to do with Report Builder (which I do not use). Here
>> is a
>> posting by a Program Manager for RS:
>> >>>>>>>>>>
>> Infinte Clickthrough is a feature of Report Builder. It allows you
>> to
>> automatically drill between reports by using the relationships between
>> entities in the Report Model. The drillthroughs are created "on the fly"
>> without having to build them beforehand. Workgroup and standard edition
>> only
>> get pre-defined drillthroughs.
>>
>> ----
>> Brian Welcker, Microsoft
>> >>>>>>>>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>>
>>
>>
>> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> news:2CAC3038-95EA-4D0D-9E84-8EDE1DE24D8A@.microsoft.com...
>> > We are going to separate reporting services from our database server by
>> > putting RS on a single separate server. We need to know if we can use
>> > Standard or if we have to purchase Enterprise. We have Enterprise for
>> > our
>> > DB
>> > server. The major differences between the 2 editions are data driven
>> > subscriptions, which we do not need at this time, and infinite
>> > clickthrough.
>> > I cannot find a good definition of infinite clickthrough. We have
>> > reports
>> > that navigate to other reports. In Standard, is some clickthrough
>> > still
>> > available but only up to a certain number of clicks?
>> >
>> > Any details would really be appreciated.
>> >
>> > Stephanie
>>|||First of all, SSRS is bundled with SQL Server for free. If you have
SQL Enterprise 2005 then you have all the SSRS enterprise features,
including clickthrough reporting.
Infinite Clickthrough is indeed a feature of Report Builder. If you
have a Report Model created for your database, what this allows is
dynamic ad-hoc reports generated by SSRS itself. Basically it allows
you to drill-down indefinitely with the Report Builder dynamically
creating reports which are based off of the fields and relationships
on your database from the Report Model.
Basically, if the report your looking at references data that has a
relationship to another table, those fields will be hyperlinks. If
you click on the hyperlink SSRS will create a report based on the
table refereced by the link you clicked on. This can be done
indefinitely, like a virtual tour of your database. So, for example,
from a customer report you can click on their order total to see a
report showing their orders, from there you can click on a particular
order's details to see the actual items ordered, from there you can
click on a line item to see the item's general details, from there you
can click on the last PO for the item, etc.
You can always create your own reports that you drill-through. There
is no limit to how many of these manual reports you can create or
drill-through. The difference is SSRS will actually do all this for
you if you have Enterprise. This seems like a really basic feature
since all the infrastructure is in place with SSRS standard. We would
like to take advantage of clickthrough reporting but we don't have
enterprise. The cost to upgrade is pretty astronomical for this
feature.|||Thanks for the description.
Just a little clarification of why this matters to the person who posted.
They are putting RS on a different server than the database. It is not free
in that case. You have to have a license for each machine that RS is
installed on. So let's say you have a web farm (which required enterprise).
For each server on the web farm that has RS installed you need an enterprise
license on that server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Matt Penner" <mattpenner2007@.gmail.com> wrote in message
news:1194451200.927016.283220@.z24g2000prh.googlegroups.com...
> First of all, SSRS is bundled with SQL Server for free. If you have
> SQL Enterprise 2005 then you have all the SSRS enterprise features,
> including clickthrough reporting.
> Infinite Clickthrough is indeed a feature of Report Builder. If you
> have a Report Model created for your database, what this allows is
> dynamic ad-hoc reports generated by SSRS itself. Basically it allows
> you to drill-down indefinitely with the Report Builder dynamically
> creating reports which are based off of the fields and relationships
> on your database from the Report Model.
> Basically, if the report your looking at references data that has a
> relationship to another table, those fields will be hyperlinks. If
> you click on the hyperlink SSRS will create a report based on the
> table refereced by the link you clicked on. This can be done
> indefinitely, like a virtual tour of your database. So, for example,
> from a customer report you can click on their order total to see a
> report showing their orders, from there you can click on a particular
> order's details to see the actual items ordered, from there you can
> click on a line item to see the item's general details, from there you
> can click on the last PO for the item, etc.
> You can always create your own reports that you drill-through. There
> is no limit to how many of these manual reports you can create or
> drill-through. The difference is SSRS will actually do all this for
> you if you have Enterprise. This seems like a really basic feature
> since all the infrastructure is in place with SSRS standard. We would
> like to take advantage of clickthrough reporting but we don't have
> enterprise. The cost to upgrade is pretty astronomical for this
> feature.
>|||First of all, SSRS is bundled with SQL Server for free. If you have
SQL Enterprise 2005 then you have all the SSRS enterprise features,
including clickthrough reporting.
Infinite Clickthrough is indeed a feature of Report Builder. If you
have a Report Model created for your database, what this allows is
dynamic ad-hoc reports generated by SSRS itself. Basically it allows
you to drill-down indefinitely with the Report Builder dynamically
creating reports which are based off of the fields and relationships
on your database from the Report Model.
Basically, if the report your looking at references data that has a
relationship to another table, those fields will be hyperlinks. If
you click on the hyperlink SSRS will create a report based on the
table refereced by the link you clicked on. This can be done
indefinitely, like a virtual tour of your database. So, for example,
from a customer report you can click on their order total to see a
report showing their orders, from there you can click on a particular
order's details to see the actual items ordered, from there you can
click on a line item to see the item's general details, from there you
can click on the last PO for the item, etc.
You can always create your own reports that you drill-through. There
is no limit to how many of these manual reports you can create or
drill-through. The difference is SSRS will actually do all this for
you if you have Enterprise. This seems like a really basic feature
since all the infrastructure is in place with SSRS standard. We would
like to take advantage of clickthrough reporting but we don't have
enterprise. The cost to upgrade is pretty astronomical for this
feature.