Report Builder button missing - exec rep defs ticked & rep build ticked

I can see report builder in IE (I am report admin), but my users are not able to, despite having ticked 'report builder' against their name in folder security.

They have
Browser, Report Builder

Why can't they see it?

"Site Settings - Security - Config sys wide role defs - sys user " has "execute report defs" ticked.

Anyone, hmm?

They also need to be listed as System Users under Site Settings. In Report Manager (IE) click on Site Settings / Configure Site-Wide Security / Add a new role assignment with the userid and grant them System User status. Have the user refresh IE and they should see the Report Builder icon.

|||Confused....

We currently use AD groups to control user access to the RS.

An AD group is assigned one or more roles. e.g. 'browser','content manager'

How is it they are able to access the RS if they are not part of 'system user'?|||the solution:

create an AD group called report builder - add all your users who require RB access to this in IE, report manager: site settings - site wide security - new role assignment - enter ADReportBuilderGroupname and tick "system user"

Report Builder button missing - exec rep defs ticked & rep build ticked

I can see report builder in IE (I am report admin), but my users are not able to, despite having ticked 'report builder' against their name in folder security.

They have
Browser, Report Builder

Why can't they see it?

"Site Settings - Security - Config sys wide role defs - sys user " has "execute report defs" ticked.

Anyone, hmm?

They also need to be listed as System Users under Site Settings. In Report Manager (IE) click on Site Settings / Configure Site-Wide Security / Add a new role assignment with the userid and grant them System User status. Have the user refresh IE and they should see the Report Builder icon.

|||Confused....

We currently use AD groups to control user access to the RS.

An AD group is assigned one or more roles. e.g. 'browser','content manager'

How is it they are able to access the RS if they are not part of 'system user'?|||the solution:

create an AD group called report builder - add all your users who require RB access to this in IE, report manager: site settings - site wide security - new role assignment - enter ADReportBuilderGroupname and tick "system user"

report builder and stored procedure

I am trying to build a report model. I have a stored procedure that return a
result set. I created a Named Query to exec the stored procedure. But when
I clicked OK, it gave me this error: Please help.
TITLE: Microsoft Visual Studio
--
Cannot create the named query using the specified query definition.
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
--
ADDITIONAL INFORMATION:
Incorrect syntax near the keyword 'EXEC'.
The following statement executed when creating named query:
SELECT [EBB].*
FROM
(
EXEC EDJUNK
)
AS [EBB] (Microsoft.AnalysisServices.Controls)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
--
Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
--
BUTTONS:
OK
--dear Ed when u use exec u can't use this format: SELECT * FROM (EXEC SP)
cause exec doesn't return resultset(look in BOL).
if u want 2 use SP just write the name of the sp and it work...
"Ed" wrote:
> I am trying to build a report model. I have a stored procedure that return a
> result set. I created a Named Query to exec the stored procedure. But when
> I clicked OK, it gave me this error: Please help.
> TITLE: Microsoft Visual Studio
> --
> Cannot create the named query using the specified query definition.
>
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> Incorrect syntax near the keyword 'EXEC'.
> The following statement executed when creating named query:
> SELECT [EBB].*
> FROM
> (
> EXEC EDJUNK
> )
> AS [EBB] (Microsoft.AnalysisServices.Controls)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> --
> Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
> --
> BUTTONS:
> OK
> --
>|||Thanks...I will try
"ש×?×?×?" wrote:
> dear Ed when u use exec u can't use this format: SELECT * FROM (EXEC SP)
> cause exec doesn't return resultset(look in BOL).
> if u want 2 use SP just write the name of the sp and it work...
> "Ed" wrote:
> > I am trying to build a report model. I have a stored procedure that return a
> > result set. I created a Named Query to exec the stored procedure. But when
> > I clicked OK, it gave me this error: Please help.
> >
> > TITLE: Microsoft Visual Studio
> > --
> >
> > Cannot create the named query using the specified query definition.
> >
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > Incorrect syntax near the keyword 'EXEC'.
> > The following statement executed when creating named query:
> >
> > SELECT [EBB].*
> > FROM
> > (
> > EXEC EDJUNK
> > )
> > AS [EBB] (Microsoft.AnalysisServices.Controls)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> >
> > --
> >
> > Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
> >
> > --
> > BUTTONS:
> >
> > OK
> > --
> >|||Aloha, I tried just put in the sp name and when I clicked ok, it gave me this
error:
TITLE: Microsoft Visual Studio
--
Cannot create the named query using the specified query definition.
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
--
ADDITIONAL INFORMATION:
Line 6: Incorrect syntax near ')'.
The following statement executed when creating named query:
SELECT [Retail Items Qty By Sites].*
FROM
(
RETAIL_ITEM_QTY
)
AS [Retail Items Qty By Sites] (Microsoft.AnalysisServices.Controls)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
--
Line 6: Incorrect syntax near ')'. (Microsoft SQL Server, Error: 170)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=170&LinkId=20476
--
BUTTONS:
OK
--
"ש×?×?×?" wrote:
> dear Ed when u use exec u can't use this format: SELECT * FROM (EXEC SP)
> cause exec doesn't return resultset(look in BOL).
> if u want 2 use SP just write the name of the sp and it work...
> "Ed" wrote:
> > I am trying to build a report model. I have a stored procedure that return a
> > result set. I created a Named Query to exec the stored procedure. But when
> > I clicked OK, it gave me this error: Please help.
> >
> > TITLE: Microsoft Visual Studio
> > --
> >
> > Cannot create the named query using the specified query definition.
> >
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > Incorrect syntax near the keyword 'EXEC'.
> > The following statement executed when creating named query:
> >
> > SELECT [EBB].*
> > FROM
> > (
> > EXEC EDJUNK
> > )
> > AS [EBB] (Microsoft.AnalysisServices.Controls)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> >
> > --
> >
> > Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
> >
> > --
> > BUTTONS:
> >
> > OK
> > --
> >|||hi do u have already this sp?
is your datasource correct?
"Ed" wrote:
> Aloha, I tried just put in the sp name and when I clicked ok, it gave me this
> error:
> TITLE: Microsoft Visual Studio
> --
> Cannot create the named query using the specified query definition.
>
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> Line 6: Incorrect syntax near ')'.
> The following statement executed when creating named query:
> SELECT [Retail Items Qty By Sites].*
> FROM
> (
> RETAIL_ITEM_QTY
> )
> AS [Retail Items Qty By Sites] (Microsoft.AnalysisServices.Controls)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> --
> Line 6: Incorrect syntax near ')'. (Microsoft SQL Server, Error: 170)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=170&LinkId=20476
> --
> BUTTONS:
> OK
> --
>
> "ש×?×?×?" wrote:
> > dear Ed when u use exec u can't use this format: SELECT * FROM (EXEC SP)
> > cause exec doesn't return resultset(look in BOL).
> > if u want 2 use SP just write the name of the sp and it work...
> >
> > "Ed" wrote:
> >
> > > I am trying to build a report model. I have a stored procedure that return a
> > > result set. I created a Named Query to exec the stored procedure. But when
> > > I clicked OK, it gave me this error: Please help.
> > >
> > > TITLE: Microsoft Visual Studio
> > > --
> > >
> > > Cannot create the named query using the specified query definition.
> > >
> > >
> > > For help, click:
> > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> > >
> > > --
> > > ADDITIONAL INFORMATION:
> > >
> > > Incorrect syntax near the keyword 'EXEC'.
> > > The following statement executed when creating named query:
> > >
> > > SELECT [EBB].*
> > > FROM
> > > (
> > > EXEC EDJUNK
> > > )
> > > AS [EBB] (Microsoft.AnalysisServices.Controls)
> > >
> > > For help, click:
> > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> > >
> > > --
> > >
> > > Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
> > >
> > > For help, click:
> > > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
> > >
> > > --
> > > BUTTONS:
> > >
> > > OK
> > > --
> > >|||Yes...it even works when I clicked the run button in where I built the name
query.
"ש×?×?×?" wrote:
> hi do u have already this sp?
> is your datasource correct?
> "Ed" wrote:
> > Aloha, I tried just put in the sp name and when I clicked ok, it gave me this
> > error:
> >
> > TITLE: Microsoft Visual Studio
> > --
> >
> > Cannot create the named query using the specified query definition.
> >
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > Line 6: Incorrect syntax near ')'.
> > The following statement executed when creating named query:
> >
> > SELECT [Retail Items Qty By Sites].*
> > FROM
> > (
> > RETAIL_ITEM_QTY
> > )
> > AS [Retail Items Qty By Sites] (Microsoft.AnalysisServices.Controls)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> >
> > --
> >
> > Line 6: Incorrect syntax near ')'. (Microsoft SQL Server, Error: 170)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=170&LinkId=20476
> >
> > --
> > BUTTONS:
> >
> > OK
> > --
> >
> >
> > "ש×?×?×?" wrote:
> >
> > > dear Ed when u use exec u can't use this format: SELECT * FROM (EXEC SP)
> > > cause exec doesn't return resultset(look in BOL).
> > > if u want 2 use SP just write the name of the sp and it work...
> > >
> > > "Ed" wrote:
> > >
> > > > I am trying to build a report model. I have a stored procedure that return a
> > > > result set. I created a Named Query to exec the stored procedure. But when
> > > > I clicked OK, it gave me this error: Please help.
> > > >
> > > > TITLE: Microsoft Visual Studio
> > > > --
> > > >
> > > > Cannot create the named query using the specified query definition.
> > > >
> > > >
> > > > For help, click:
> > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> > > >
> > > > --
> > > > ADDITIONAL INFORMATION:
> > > >
> > > > Incorrect syntax near the keyword 'EXEC'.
> > > > The following statement executed when creating named query:
> > > >
> > > > SELECT [EBB].*
> > > > FROM
> > > > (
> > > > EXEC EDJUNK
> > > > )
> > > > AS [EBB] (Microsoft.AnalysisServices.Controls)
> > > >
> > > > For help, click:
> > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> > > >
> > > > --
> > > >
> > > > Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
> > > >
> > > > For help, click:
> > > > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
> > > >
> > > > --
> > > > BUTTONS:
> > > >
> > > > OK
> > > > --
> > > >|||Hi Ed
Make sure your command type is set to Stored Procedure and not Text.
"Ed" wrote:
> Yes...it even works when I clicked the run button in where I built the name
> query.
> "ש×?×?×?" wrote:
> > hi do u have already this sp?
> > is your datasource correct?
> >
> > "Ed" wrote:
> >
> > > Aloha, I tried just put in the sp name and when I clicked ok, it gave me this
> > > error:
> > >
> > > TITLE: Microsoft Visual Studio
> > > --
> > >
> > > Cannot create the named query using the specified query definition.
> > >
> > >
> > > For help, click:
> > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> > >
> > > --
> > > ADDITIONAL INFORMATION:
> > >
> > > Line 6: Incorrect syntax near ')'.
> > > The following statement executed when creating named query:
> > >
> > > SELECT [Retail Items Qty By Sites].*
> > > FROM
> > > (
> > > RETAIL_ITEM_QTY
> > > )
> > > AS [Retail Items Qty By Sites] (Microsoft.AnalysisServices.Controls)
> > >
> > > For help, click:
> > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> > >
> > > --
> > >
> > > Line 6: Incorrect syntax near ')'. (Microsoft SQL Server, Error: 170)
> > >
> > > For help, click:
> > > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=170&LinkId=20476
> > >
> > > --
> > > BUTTONS:
> > >
> > > OK
> > > --
> > >
> > >
> > > "ש×?×?×?" wrote:
> > >
> > > > dear Ed when u use exec u can't use this format: SELECT * FROM (EXEC SP)
> > > > cause exec doesn't return resultset(look in BOL).
> > > > if u want 2 use SP just write the name of the sp and it work...
> > > >
> > > > "Ed" wrote:
> > > >
> > > > > I am trying to build a report model. I have a stored procedure that return a
> > > > > result set. I created a Named Query to exec the stored procedure. But when
> > > > > I clicked OK, it gave me this error: Please help.
> > > > >
> > > > > TITLE: Microsoft Visual Studio
> > > > > --
> > > > >
> > > > > Cannot create the named query using the specified query definition.
> > > > >
> > > > >
> > > > > For help, click:
> > > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> > > > >
> > > > > --
> > > > > ADDITIONAL INFORMATION:
> > > > >
> > > > > Incorrect syntax near the keyword 'EXEC'.
> > > > > The following statement executed when creating named query:
> > > > >
> > > > > SELECT [EBB].*
> > > > > FROM
> > > > > (
> > > > > EXEC EDJUNK
> > > > > )
> > > > > AS [EBB] (Microsoft.AnalysisServices.Controls)
> > > > >
> > > > > For help, click:
> > > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> > > > >
> > > > > --
> > > > >
> > > > > Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
> > > > >
> > > > > For help, click:
> > > > > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
> > > > >
> > > > > --
> > > > > BUTTONS:
> > > > >
> > > > > OK
> > > > > --
> > > > >|||I didn't see a place I can specify sp or text when I created the named query.
"Shawn Kralj" wrote:
> Hi Ed
> Make sure your command type is set to Stored Procedure and not Text.
> "Ed" wrote:
> > Yes...it even works when I clicked the run button in where I built the name
> > query.
> >
> > "ש×?×?×?" wrote:
> >
> > > hi do u have already this sp?
> > > is your datasource correct?
> > >
> > > "Ed" wrote:
> > >
> > > > Aloha, I tried just put in the sp name and when I clicked ok, it gave me this
> > > > error:
> > > >
> > > > TITLE: Microsoft Visual Studio
> > > > --
> > > >
> > > > Cannot create the named query using the specified query definition.
> > > >
> > > >
> > > > For help, click:
> > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> > > >
> > > > --
> > > > ADDITIONAL INFORMATION:
> > > >
> > > > Line 6: Incorrect syntax near ')'.
> > > > The following statement executed when creating named query:
> > > >
> > > > SELECT [Retail Items Qty By Sites].*
> > > > FROM
> > > > (
> > > > RETAIL_ITEM_QTY
> > > > )
> > > > AS [Retail Items Qty By Sites] (Microsoft.AnalysisServices.Controls)
> > > >
> > > > For help, click:
> > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> > > >
> > > > --
> > > >
> > > > Line 6: Incorrect syntax near ')'. (Microsoft SQL Server, Error: 170)
> > > >
> > > > For help, click:
> > > > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=170&LinkId=20476
> > > >
> > > > --
> > > > BUTTONS:
> > > >
> > > > OK
> > > > --
> > > >
> > > >
> > > > "ש×?×?×?" wrote:
> > > >
> > > > > dear Ed when u use exec u can't use this format: SELECT * FROM (EXEC SP)
> > > > > cause exec doesn't return resultset(look in BOL).
> > > > > if u want 2 use SP just write the name of the sp and it work...
> > > > >
> > > > > "Ed" wrote:
> > > > >
> > > > > > I am trying to build a report model. I have a stored procedure that return a
> > > > > > result set. I created a Named Query to exec the stored procedure. But when
> > > > > > I clicked OK, it gave me this error: Please help.
> > > > > >
> > > > > > TITLE: Microsoft Visual Studio
> > > > > > --
> > > > > >
> > > > > > Cannot create the named query using the specified query definition.
> > > > > >
> > > > > >
> > > > > > For help, click:
> > > > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> > > > > >
> > > > > > --
> > > > > > ADDITIONAL INFORMATION:
> > > > > >
> > > > > > Incorrect syntax near the keyword 'EXEC'.
> > > > > > The following statement executed when creating named query:
> > > > > >
> > > > > > SELECT [EBB].*
> > > > > > FROM
> > > > > > (
> > > > > > EXEC EDJUNK
> > > > > > )
> > > > > > AS [EBB] (Microsoft.AnalysisServices.Controls)
> > > > > >
> > > > > > For help, click:
> > > > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> > > > > >
> > > > > > --
> > > > > >
> > > > > > Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
> > > > > >
> > > > > > For help, click:
> > > > > > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
> > > > > >
> > > > > > --
> > > > > > BUTTONS:
> > > > > >
> > > > > > OK
> > > > > > --
> > > > > >