report builder, which edition of 2005?

My question:
Does the end-user reporting tool (report builder) in Sql Server 2005 exist
in the Standard Version or is it only in the Enterprise Version?
I have found a couple of conflicting articles on the web.
Thanks in advance.Just Enterprise.
Not sure about development version. Previously that version was identical to
enterprise.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
news:FAD2F770-CFA6-4F70-AD0C-662C2A99E7CD@.microsoft.com...
> My question:
> Does the end-user reporting tool (report builder) in Sql Server 2005 exist
> in the Standard Version or is it only in the Enterprise Version?
> I have found a couple of conflicting articles on the web.
> Thanks in advance.|||that is what I thought also but what about this link here. It has a
checkmark for standard...
http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
More research found this information as well.
"This week, at Microsoft TechEd in Orlando, Florida, Microsoft turned a
complete 180 in the way the company will license SQL Server Reporting
Services and Report Builder. Microsoft was planning to include Report Builder
in SQL Server 2005 Enterprise Edition but not Standard Edition or other less
expensive SQL Server SKUs. I thought that was going to be a big mistake for
Microsoft, and many people in the SQL Server community agreed with me. But
this week, Microsoft Senior Vice President of Server Applications Paul
Flessner announced that Reporting Services will be included in all editions
of SQL Server 2005. In addition, the Workgroup and Standard Editions of SQL
Server 2005 will include Report Builder."
taken from this artice:
http://www.windowsitpro.com/SQLServer/Article/ArticleID/46694/46694.html
"Bruce L-C [MVP]" wrote:
> Just Enterprise.
> Not sure about development version. Previously that version was identical to
> enterprise.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
> news:FAD2F770-CFA6-4F70-AD0C-662C2A99E7CD@.microsoft.com...
> > My question:
> > Does the end-user reporting tool (report builder) in Sql Server 2005 exist
> > in the Standard Version or is it only in the Enterprise Version?
> >
> > I have found a couple of conflicting articles on the web.
> >
> > Thanks in advance.
>
>|||Well, how about that. The info I had was not that old but looks like prior
to TechEd they changed their mind.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
news:DF676812-82CA-4228-8EFA-56847C1282B7@.microsoft.com...
> that is what I thought also but what about this link here. It has a
> checkmark for standard...
> http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
> More research found this information as well.
> "This week, at Microsoft TechEd in Orlando, Florida, Microsoft turned a
> complete 180 in the way the company will license SQL Server Reporting
> Services and Report Builder. Microsoft was planning to include Report
> Builder
> in SQL Server 2005 Enterprise Edition but not Standard Edition or other
> less
> expensive SQL Server SKUs. I thought that was going to be a big mistake
> for
> Microsoft, and many people in the SQL Server community agreed with me. But
> this week, Microsoft Senior Vice President of Server Applications Paul
> Flessner announced that Reporting Services will be included in all
> editions
> of SQL Server 2005. In addition, the Workgroup and Standard Editions of
> SQL
> Server 2005 will include Report Builder."
> taken from this artice:
> http://www.windowsitpro.com/SQLServer/Article/ArticleID/46694/46694.html
> "Bruce L-C [MVP]" wrote:
>> Just Enterprise.
>> Not sure about development version. Previously that version was identical
>> to
>> enterprise.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
>> news:FAD2F770-CFA6-4F70-AD0C-662C2A99E7CD@.microsoft.com...
>> > My question:
>> > Does the end-user reporting tool (report builder) in Sql Server 2005
>> > exist
>> > in the Standard Version or is it only in the Enterprise Version?
>> >
>> > I have found a couple of conflicting articles on the web.
>> >
>> > Thanks in advance.
>>|||From the official press release at TechEd 2005:
http://www.microsoft.com/presspass/press/2005/jun05/TechEd2005Day2PR.mspx
"With this CTP, customers and partners will be able to test the business
intelligence components included in SQL Server 2005. To increase customers'
and partners' abilities to utilize business insight capabilities, Flessner
also announced that Microsoft will extend SQL Server 2005 Reporting Services
from Standard and Enterprise Editions to all versions of SQL Server 2005,
including Express and Workgroup Editions. In addition, SQL Server 2005
Report Builder will be available with Workgroup, Standard and Enterprise
Editions."
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uR2C6oPcFHA.2124@.TK2MSFTNGP14.phx.gbl...
> Well, how about that. The info I had was not that old but looks like prior
> to TechEd they changed their mind.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
> news:DF676812-82CA-4228-8EFA-56847C1282B7@.microsoft.com...
>> that is what I thought also but what about this link here. It has a
>> checkmark for standard...
>> http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
>> More research found this information as well.
>> "This week, at Microsoft TechEd in Orlando, Florida, Microsoft turned a
>> complete 180 in the way the company will license SQL Server Reporting
>> Services and Report Builder. Microsoft was planning to include Report
>> Builder
>> in SQL Server 2005 Enterprise Edition but not Standard Edition or other
>> less
>> expensive SQL Server SKUs. I thought that was going to be a big mistake
>> for
>> Microsoft, and many people in the SQL Server community agreed with me.
>> But
>> this week, Microsoft Senior Vice President of Server Applications Paul
>> Flessner announced that Reporting Services will be included in all
>> editions
>> of SQL Server 2005. In addition, the Workgroup and Standard Editions of
>> SQL
>> Server 2005 will include Report Builder."
>> taken from this artice:
>> http://www.windowsitpro.com/SQLServer/Article/ArticleID/46694/46694.html
>> "Bruce L-C [MVP]" wrote:
>> Just Enterprise.
>> Not sure about development version. Previously that version was
>> identical to
>> enterprise.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
>> news:FAD2F770-CFA6-4F70-AD0C-662C2A99E7CD@.microsoft.com...
>> > My question:
>> > Does the end-user reporting tool (report builder) in Sql Server 2005
>> > exist
>> > in the Standard Version or is it only in the Enterprise Version?
>> >
>> > I have found a couple of conflicting articles on the web.
>> >
>> > Thanks in advance.
>>
>|||Robert,
Thank you for the clarification.
"Robert Bruckner [MSFT]" wrote:
> From the official press release at TechEd 2005:
> http://www.microsoft.com/presspass/press/2005/jun05/TechEd2005Day2PR.mspx
> "With this CTP, customers and partners will be able to test the business
> intelligence components included in SQL Server 2005. To increase customers'
> and partners' abilities to utilize business insight capabilities, Flessner
> also announced that Microsoft will extend SQL Server 2005 Reporting Services
> from Standard and Enterprise Editions to all versions of SQL Server 2005,
> including Express and Workgroup Editions. In addition, SQL Server 2005
> Report Builder will be available with Workgroup, Standard and Enterprise
> Editions."
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uR2C6oPcFHA.2124@.TK2MSFTNGP14.phx.gbl...
> > Well, how about that. The info I had was not that old but looks like prior
> > to TechEd they changed their mind.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
> > news:DF676812-82CA-4228-8EFA-56847C1282B7@.microsoft.com...
> >> that is what I thought also but what about this link here. It has a
> >> checkmark for standard...
> >>
> >> http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
> >>
> >> More research found this information as well.
> >>
> >> "This week, at Microsoft TechEd in Orlando, Florida, Microsoft turned a
> >> complete 180 in the way the company will license SQL Server Reporting
> >> Services and Report Builder. Microsoft was planning to include Report
> >> Builder
> >> in SQL Server 2005 Enterprise Edition but not Standard Edition or other
> >> less
> >> expensive SQL Server SKUs. I thought that was going to be a big mistake
> >> for
> >> Microsoft, and many people in the SQL Server community agreed with me.
> >> But
> >> this week, Microsoft Senior Vice President of Server Applications Paul
> >> Flessner announced that Reporting Services will be included in all
> >> editions
> >> of SQL Server 2005. In addition, the Workgroup and Standard Editions of
> >> SQL
> >> Server 2005 will include Report Builder."
> >>
> >> taken from this artice:
> >> http://www.windowsitpro.com/SQLServer/Article/ArticleID/46694/46694.html
> >>
> >> "Bruce L-C [MVP]" wrote:
> >>
> >> Just Enterprise.
> >>
> >> Not sure about development version. Previously that version was
> >> identical to
> >> enterprise.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
> >> news:FAD2F770-CFA6-4F70-AD0C-662C2A99E7CD@.microsoft.com...
> >> > My question:
> >> > Does the end-user reporting tool (report builder) in Sql Server 2005
> >> > exist
> >> > in the Standard Version or is it only in the Enterprise Version?
> >> >
> >> > I have found a couple of conflicting articles on the web.
> >> >
> >> > Thanks in advance.
> >>
> >>
> >>
> >
> >
>
>sql

Report based on temporary table

Hi
I need to create a report based on temporary table in oracle, table does not exist until stored procedure is executed. i am outputing a ref cursor but it shows no fields when i am creating the report.
help needed.
Regards
S RaheemEnter the correct values for which stored procedure will take|||hi am doing something like this

PROCEDURE Missing_Document(d IN OUT docs)
IS
BEGIN
EXECUTE IMMEDIATE 'create global temporary table testing(name varchar2(30))';
EXECUTE IMMEDIATE 'insert into testing values(''dddd'')';
EXECUTE IMMEDIATE 'insert into testing values(''eeee'')';
EXECUTE IMMEDIATE 'insert into testing values(''fffffff'')';
OPEN d FOR 'select * from testing';
END Missing_Document;

docs is a ref cursor|||hi am doing something like this

PROCEDURE Missing_Document(d IN OUT docs)
IS
BEGIN
EXECUTE IMMEDIATE 'create global temporary table testing(name varchar2(30))';
EXECUTE IMMEDIATE 'insert into testing values(''dddd'')';
EXECUTE IMMEDIATE 'insert into testing values(''eeee'')';
EXECUTE IMMEDIATE 'insert into testing values(''fffffff'')';
OPEN d FOR 'select * from testing';
END Missing_Document;

docs is a ref cursor

I got it working now thanks all, but i got a new error in oracle temp tables..

Report Action + multi parameters

Hi

Using Report Action, Can accept multi parameters from Excel Pivot Table?

Exist some way of doing this.

Please help me

thanks for your commentaries

carlos

Your probably better off using an url action instead of report action(which behind the covers is basically the same). Because if you want to specify more than one value you must specify that parameter over and over again at design time(i think), instead of concatenating a string. This because a url with a multivalue parameter looks like this:

http://localhost/ReportServer?%2fCatalog%2fMultiReport&rs:Command=Render&ParameterTest=1&ParameterTest=2

Look at these two links, i think you will get on how to do it in a URL action:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1047470&SiteID=1
http://msdn2.microsoft.com/en-us/library/ms153586.aspx

|||

Hi, thank for the help.

But, When I select several cells, since I do to pass them as parameters to the URL?

Is it possible?

|||

Actions are executed for specific cells based on the co-ordinates of that cell, so I would not expect the Excel user interface to allow you to launch an action when multile cells are selected.

|||

Ok, thank a lot for you help