Report Error, Help!

Hi
I have beening trying to build a report with 2 parameters. When I run it
under VS.net, it all went well, but after I deploy it to the server, I got
the message as following: Reporting Services Error--The path of the item ''
is not valid. The full path must be less than 260 characters long, must start
with slash; other restrictions apply. Check the documentation for complete
set of restrictions. (rsInvalidItemPath) Get Online Help
what went wrong, please help. TIAYou sure have to post your URL to help you.
Jens Suessmeyer.
"wd1153" <wd1153@.discussions.microsoft.com> schrieb im Newsbeitrag
news:5138A906-7AA9-4D7A-A1B5-E3C9756BE7E1@.microsoft.com...
> Hi
> I have beening trying to build a report with 2 parameters. When I run it
> under VS.net, it all went well, but after I deploy it to the server, I got
> the message as following: Reporting Services Error--The path of the item
> ''
> is not valid. The full path must be less than 260 characters long, must
> start
> with slash; other restrictions apply. Check the documentation for complete
> set of restrictions. (rsInvalidItemPath) Get Online Help
> what went wrong, please help. TIA
>
>|||Sorry, the URL as following:
http://localhost/reportserver?%2fRev_Stats%2fRev_Stats&rs:Command=Render
"Jens Sü�meyer" wrote:
> You sure have to post your URL to help you.
> Jens Suessmeyer.
>
> "wd1153" <wd1153@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:5138A906-7AA9-4D7A-A1B5-E3C9756BE7E1@.microsoft.com...
> > Hi
> >
> > I have beening trying to build a report with 2 parameters. When I run it
> > under VS.net, it all went well, but after I deploy it to the server, I got
> > the message as following: Reporting Services Error--The path of the item
> > ''
> > is not valid. The full path must be less than 260 characters long, must
> > start
> > with slash; other restrictions apply. Check the documentation for complete
> > set of restrictions. (rsInvalidItemPath) Get Online Help
> > what went wrong, please help. TIA
> >
> >
> >
>
>

Report Designer using Report Model as data source

can we use Report Designer to build reports off a Model?See my replies to the post RS.exe Script utility and Forms Authentication
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dan Krish" <DanKrish@.discussions.microsoft.com> wrote in message
news:2C2DD0D5-F184-46ED-9311-9DCA8602B1D5@.microsoft.com...
> can we use Report Designer to build reports off a Model?
>

Report Designer crashes when accessing Access DB via ODBC

Hi:
I am trying to build a report off of a stand alone MS Access 2000 database. I can create the Data Source using the "Driver do Microsoft Access" driver, version 4.00.6019.00.
When I go to create the query to create the Dataset, I right click to add a table, I can see the table list and check the table I want to use. It is at this point the Visual Studio crashes, closes and send off the error report to Microsoft.
What's up? Why is this happening? I can write reports to my heart's content using an IBM ODBC driver against our DB2 database on an AS/400. One would think that writing reports using all MS products this should go very smooth.
Thanks in advance.
Bruce.Did you try the "Microsoft Jet 4.0 OLE DB Provider" which is designed to
work with Access?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"bwschiek@.hotmail.com" <bwschiekhotmailcom@.discussions.microsoft.com> wrote
in message news:EE8C1C06-2779-4069-9004-0E6DF55969CE@.microsoft.com...
> Hi:
> I am trying to build a report off of a stand alone MS Access 2000
database. I can create the Data Source using the "Driver do Microsoft
Access" driver, version 4.00.6019.00.
> When I go to create the query to create the Dataset, I right click to add
a table, I can see the table list and check the table I want to use. It is
at this point the Visual Studio crashes, closes and send off the error
report to Microsoft.
> What's up? Why is this happening? I can write reports to my heart's
content using an IBM ODBC driver against our DB2 database on an AS/400. One
would think that writing reports using all MS products this should go very
smooth.
> Thanks in advance.
> Bruce.|||Hi Robert:
Thanks. That did the trick.
I had been using the ODBC connection that caused VS to crash for the last year with Crystal Reports with no issues. Curious...
Thanks again.
Bruce.
"Robert Bruckner [MSFT]" wrote:
> Did you try the "Microsoft Jet 4.0 OLE DB Provider" which is designed to
> work with Access?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "bwschiek@.hotmail.com" <bwschiekhotmailcom@.discussions.microsoft.com> wrote
> in message news:EE8C1C06-2779-4069-9004-0E6DF55969CE@.microsoft.com...
> > Hi:
> >
> > I am trying to build a report off of a stand alone MS Access 2000
> database. I can create the Data Source using the "Driver do Microsoft
> Access" driver, version 4.00.6019.00.
> >
> > When I go to create the query to create the Dataset, I right click to add
> a table, I can see the table list and check the table I want to use. It is
> at this point the Visual Studio crashes, closes and send off the error
> report to Microsoft.
> >
> > What's up? Why is this happening? I can write reports to my heart's
> content using an IBM ODBC driver against our DB2 database on an AS/400. One
> would think that writing reports using all MS products this should go very
> smooth.
> >
> > Thanks in advance.
> >
> > Bruce.
>
>

Report Design help for Newb - Regarding Date Paramaters

I have been trying very hard for days now to build a report using VS 2003.net
I just need to query an order table by a date range. ie) from date a to
date b. The order table contains PO's and have recorded dates. I just need
an example of how to report based upon date range. Seems simple enough,
just cant figure it out.I assume you mean you want the user to be able to specify the date range?
If you currently have a sql statement that returns all orders and have a
report that displays that data, simply modify the sql statement and specify:
where datefield between @.startdate and @.enddate
That will automatically create report parameters. When you preview the
report, it will prompt you to type in start and end dates.
For more info, just do searches for query parameters and report parameters.
Mike G.
"tdodd" <tdodd@.discussions.microsoft.com> wrote in message
news:6A7F2EE5-FAFA-4852-B771-35FBC9431D71@.microsoft.com...
>I have been trying very hard for days now to build a report using VS
>2003.net
> I just need to query an order table by a date range. ie) from date a to
> date b. The order table contains PO's and have recorded dates. I just
> need
> an example of how to report based upon date range. Seems simple enough,
> just cant figure it out.

Report Building

Can you build reports using SQL Express w/o SQL 2005. If so how, the online books are not making this very clear.You can use Microsoft SQL Server 2005 Express Edition with Advanced Services.

But this is only capable for local relational data:

-Run SQL Server Reporting Services reports on local relational data.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=4C6BA9FD-319A-4887-BC75-3B02B5E48A40

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
sql

Report Builder?

I have a table with no Primary Key and during build the report model,
the message show me : Table dose not have a primary key.
So, the table wants to build as a report model must have primary key?
If I want the table that has no primary key and build as report model,
how could I do?
Thanks for any advice!
AngiIt is possible to manually create an entity, bind it to the table, add
fields etc.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angi" <enchiw@.msn.com> wrote in message
news:ua5mb4BtFHA.2912@.TK2MSFTNGP09.phx.gbl...
>I have a table with no Primary Key and during build the report model,
> the message show me : Table dose not have a primary key.
> So, the table wants to build as a report model must have primary key?
> If I want the table that has no primary key and build as report model,
> how could I do?
> Thanks for any advice!
> Angi
>

Report builder using SQL SERVER 2005

Hi All!!

Can any body help me out in how to build reports using SQL SERVER 2005.
I will be very thankfull for that

Thanks
Biresh Singh

Hi Biresh,

There are a number of webcasts, sample reports and other documentation available at http://msdn.microsoft.com/sql/bi/reporting/.

Regards,

Mike Wachal
SQL Express team

|||

can u also tell me what is the size of the database. If i have crores of records in a table. Can sql server holds that amount of data.

Please reply.I will be very thankfull for that

Thanks

Biresh Singh

|||

Hi!!

Can any one tell me that if i build report in SQL EXPRESS 2005 and deploying it.And now the problem comes while intergating my report with my application bulid in .NET Framework 1.1. I am using VS.NET 2003. Can i integrate my report with NET Framework 1.1

Please reply.

I will be very thankfull for that

thanks

Biresh singh

Report Builder Filter drop down list - when the list is more than 500 values

Hi All,

I build a model (either from Cube or from tables) and open it in report builder. When I select a FIELTER on field which has few distinct values like state code, I get a drop down list. But when I select a filter on 'Dept Name', the drop down list on filter disapears. I have to manually key the filter value.

Can any one help me in getting a drop down list on filter, when distinct values in that column are more than few hundred.

Regards

Bobba

This is controlled by a property InstanceSelection, that can be set on each attribute of a dimension (within the dimension Editor).

The cube/dimension wizard initially sets this property, but then it can be changed as required.

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

Report Builder and confirmed dimension

Hi Experts,

I have build a cube and placed report builder on it. I have a Dimensional model with two fact table. When i try to create a report it allows me to select measures from only one fact. It doesnt allow me to create report from two different fact and two different dimensions.

Please help

Regards

Neeraj

Hi, you can't never do that in report builder, because [Report Builder] model does not work with more them one fact table.|||

I believe Loobo is correct in stating that Report Builder doesn't accept more than one measure group/fact table. Report Builder seems to be focused on more of a relational database model which does not always work well with Analysis Services.

Thanks,
Bryan Smith

|||Thank You Guys for that Insight.

Report Builder and confirmed dimension

Hi Experts,

I have build a cube and placed report builder on it. I have a Dimensional model with two fact table. When i try to create a report it allows me to select measures from only one fact. It doesnt allow me to create report from two different fact and two different dimensions.

Please help

Regards

Neeraj

Hi, you can't never do that in report builder, because [Report Builder] model does not work with more them one fact table.|||

I believe Loobo is correct in stating that Report Builder doesn't accept more than one measure group/fact table. Report Builder seems to be focused on more of a relational database model which does not always work well with Analysis Services.

Thanks,
Bryan Smith

|||Thank You Guys for that Insight.

report builder ad hoc reporting

Using SS2000 data with RS2005. If I build a report with report builder, is
there a way to see what query the report builder is using to generate the
report? I've built a model and created a report from the model. If I create a
query in query analyzer to check the results that are generated by the report
builder report, I'm off by quite a bit. If I could see the query that the
report builder is generating maybe I could figure out where the problem is.
Thanks,
--
Dan D.Take a look at the RDL file. You can either save this file to disk using the
Report Builder File : Save To File menu option.
"Dan D." wrote:
> Using SS2000 data with RS2005. If I build a report with report builder, is
> there a way to see what query the report builder is using to generate the
> report? I've built a model and created a report from the model. If I create a
> query in query analyzer to check the results that are generated by the report
> builder report, I'm off by quite a bit. If I could see the query that the
> report builder is generating maybe I could figure out where the problem is.
> Thanks,
> --
> Dan D.|||I tried that. I searched for the word 'query' and the only thing I saw was a
section that had the column names. Do you think the query itself is in there?
Thanks,
--
Dan D.
"Bruce Johnson [MSFT]" wrote:
> Take a look at the RDL file. You can either save this file to disk using the
> Report Builder File : Save To File menu option.
>
> "Dan D." wrote:
> > Using SS2000 data with RS2005. If I build a report with report builder, is
> > there a way to see what query the report builder is using to generate the
> > report? I've built a model and created a report from the model. If I create a
> > query in query analyzer to check the results that are generated by the report
> > builder report, I'm off by quite a bit. If I could see the query that the
> > report builder is generating maybe I could figure out where the problem is.
> >
> > Thanks,
> > --
> > Dan D.|||use the profiler to see the query executed by report builder against your
database.
Also report builder can log the query:
http://blogs.msdn.com/bobmeyers/archive/2006/07/05/657125.aspx
good luck.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:E2DDBECB-7F70-486D-9555-EA2112810DCA@.microsoft.com...
> Using SS2000 data with RS2005. If I build a report with report builder, is
> there a way to see what query the report builder is using to generate the
> report? I've built a model and created a report from the model. If I
> create a
> query in query analyzer to check the results that are generated by the
> report
> builder report, I'm off by quite a bit. If I could see the query that the
> report builder is generating maybe I could figure out where the problem
> is.
> Thanks,
> --
> Dan D.|||infact the complex query is already in the report model. you will get just
the simple query of all the columns and the filter condition. You can have a
look at the report model table as well.
Amarnath
"Dan D." wrote:
> Using SS2000 data with RS2005. If I build a report with report builder, is
> there a way to see what query the report builder is using to generate the
> report? I've built a model and created a report from the model. If I create a
> query in query analyzer to check the results that are generated by the report
> builder report, I'm off by quite a bit. If I could see the query that the
> report builder is generating maybe I could figure out where the problem is.
> Thanks,
> --
> Dan D.|||Will this work for Oracle as well. We have installed SP2, so are not
using linked tables - going against Oracle directly.
- Steve
Jeje wrote:
> use the profiler to see the query executed by report builder against your
> database.
> Also report builder can log the query:
> http://blogs.msdn.com/bobmeyers/archive/2006/07/05/657125.aspx
> good luck.
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:E2DDBECB-7F70-486D-9555-EA2112810DCA@.microsoft.com...
> > Using SS2000 data with RS2005. If I build a report with report builder, is
> > there a way to see what query the report builder is using to generate the
> > report? I've built a model and created a report from the model. If I
> > create a
> > query in query analyzer to check the results that are generated by the
> > report
> > builder report, I'm off by quite a bit. If I could see the query that the
> > report builder is generating maybe I could figure out where the problem
> > is.
> >
> > Thanks,
> > --
> > Dan D.

Report Builder - Formatting numeric output - help

Hi -

I've worked a lot with SSRS 2000 - just starting with 2005. Report Builder is very cool. I build a Report Model - then built some reports biased on the model - all went well including filtering until I attempted to format the numeric data - specifically monetary data. I right clicked on the field in the designer and format was an option - but when I select format - all the numeric options are grayed out an unelectable.

The really interesting this is that if I then create a calculated field biased on tow of the numeric fields - like Total Sales Amount \ Total Orders - I CAN then format that new calculated field field. So - of course I then attempted to alter the formula of on of the base fields - like Total Sales Amount = Total Sales Amount * 1 to see if that would work - no - it did not.

I am stumped?

I am having the same problem with the Totals in a Matrix (cross-tab) report. Did you or anyone every find a solution?

Thanks in advance.

|||

Jim From Florida wrote:

I am having the same problem with the Totals in a Matrix (cross-tab) report. Did you or anyone every find a solution?

Thanks in advance.

Is this a matrix report baised on a Report Mode for ad hoc reporting - or a regular report matrix? I have had no problems formatting fields in regular matrix reports...

To answer your question - I have not resolved the Ad Hoc report model formating issue...

Report Builder - Formatting numeric output - help

Hi -

I've worked a lot with SSRS 2000 - just starting with 2005. Report Builder is very cool. I build a Report Model - then built some reports biased on the model - all went well including filtering until I attempted to format the numeric data - specifically monetary data. I right clicked on the field in the designer and format was an option - but when I select format - all the numeric options are grayed out an unelectable.

The really interesting this is that if I then create a calculated field biased on tow of the numeric fields - like Total Sales Amount \ Total Orders - I CAN then format that new calculated field field. So - of course I then attempted to alter the formula of on of the base fields - like Total Sales Amount = Total Sales Amount * 1 to see if that would work - no - it did not.

I am stumped?

I am having the same problem with the Totals in a Matrix (cross-tab) report. Did you or anyone every find a solution?

Thanks in advance.

|||

Jim From Florida wrote:

I am having the same problem with the Totals in a Matrix (cross-tab) report. Did you or anyone every find a solution?

Thanks in advance.

Is this a matrix report baised on a Report Mode for ad hoc reporting - or a regular report matrix? I have had no problems formatting fields in regular matrix reports...

To answer your question - I have not resolved the Ad Hoc report model formating issue...

Report Builder

Is Report Builder capable of building any complex reports that Visual Studio Report Designer can build?

What are the limitations of using Report Builder with SQL Server Databases?

Report Designer is the tool for building complex reports. In Report Builder you can only build simple reports such as a single table, matrix or graph.

The value in report builder is in creating fast ad-hoc reports without having to specify a query first. Report Builder is designed to work with SQL databases, but you have to create a model of your database first. You can do this automatically in Report Manager and then customize your model using Model Designer

Report and styles question

Hi:
I have to define several style guidelines to build a set of reports with the
same visual styles.
I want my reports to have tables and I want the odd rows WHITE and the even
rows RED (by example)... how can I do this kind of thing?
About the deployment of my styles: I have to configure any report I will
implement with the same styles one by one?
There is no way to apply a style template (like a cascading style sheet or
XSL) to all my reports or to define my reports using something like
Model-View-Controller design?
Thanks in advance
ErnestoGreen Bar Report
----
See the sample rdl at the end of this message. It shows how this can be
accomplished for groups and detail rows.
Style Templates
----
SQL Server 2000 Reporting Services has somewhat limited style template
support. Improving support in this area is being looked at for inclusion in
a future release.
Until then you have the following options:
1. You can approximate this behavior by creating the specific report you
want and then placing it in C:\ProgramFiles\Microsoft SQL
Server\80\Tools\Report Designer\ProjectItems\ReportProject directory. These
reports "templates" will show up in Report Designer's Add New Item dialog
along with the Report Wizard, Report, and Data Source templates when
you add a new report to a project.
2. For simple wizard-created reports, you can control the style via
modifying the wizard style templates (there's an XML config file for this
documented in the help)
3. If you're wanting to modify the style dynamically after the reports are
created, you could store style information in your database and then query
for that information in your report, setting style properties based on the
query results (e.g. FontFamily
=First(Fields!DetailRowFontFamily.Value,"StyleDataSet"))
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
news:%23AOSqt8XEHA.3012@.tk2msftngp13.phx.gbl...
> Hi:
> I have to define several style guidelines to build a set of reports with
the
> same visual styles.
> I want my reports to have tables and I want the odd rows WHITE and the
even
> rows RED (by example)... how can I do this kind of thing?
> About the deployment of my styles: I have to configure any report I will
> implement with the same styles one by one?
> There is no way to apply a style template (like a cascading style sheet or
> XSL) to all my reports or to define my reports using something like
> Model-View-Controller design?
> Thanks in advance
>
> Ernesto
>
>
Green Bar Report Sample
----
--
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table1">
<Height>0.75in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Country</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Company Name</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>textbox4</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="CompanyName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>=iif(RowNumber(Nothing) Mod 2,
"PaleGreen", "White")</BackgroundColor>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>CompanyName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!CompanyName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<DataSetName>DataSet1</DataSetName>
<Width>4.33333in</Width>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="Country">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>=iif(RunningValue(Fields!Country.Value,CountDistinct,Nothin
g) Mod 2, "Cornsilk", "White")</BackgroundColor>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>Country</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!Country.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox11</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<Grouping Name="CountryGroup">
<GroupExpressions>
<GroupExpression>=Fields!Country.Value</GroupExpression>
</GroupExpressions>
<PageBreakAtEnd>true</PageBreakAtEnd>
</Grouping>
</TableGroup>
</TableGroups>
<TableColumns>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>0.875in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>b688b025-197a-46a6-ad1e-97cfe7c0d320</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=localhost;initial
catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="CustomerID">
<DataField>CustomerID</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="CompanyName">
<DataField>CompanyName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ContactName">
<DataField>ContactName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ContactTitle">
<DataField>ContactTitle</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Address">
<DataField>Address</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="City">
<DataField>City</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Region">
<DataField>Region</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="PostalCode">
<DataField>PostalCode</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Country">
<DataField>Country</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Phone">
<DataField>Phone</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Fax">
<DataField>Fax</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>select * from customers</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>0848d9be-0d3d-4002-8752-e94ca66164e0</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>|||Bruce,
thanks for your help
Saludos
Ernesto
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:esd85S9XEHA.2408@.tk2msftngp13.phx.gbl...
> Green Bar Report
> ----
> See the sample rdl at the end of this message. It shows how this can be
> accomplished for groups and detail rows.
> Style Templates
> ----
> SQL Server 2000 Reporting Services has somewhat limited style template
> support. Improving support in this area is being looked at for inclusion
in
> a future release.
> Until then you have the following options:
> 1. You can approximate this behavior by creating the specific report you
> want and then placing it in C:\ProgramFiles\Microsoft SQL
> Server\80\Tools\Report Designer\ProjectItems\ReportProject directory.
These
> reports "templates" will show up in Report Designer's Add New Item dialog
> along with the Report Wizard, Report, and Data Source templates when
> you add a new report to a project.
>
> 2. For simple wizard-created reports, you can control the style via
> modifying the wizard style templates (there's an XML config file for this
> documented in the help)
> 3. If you're wanting to modify the style dynamically after the reports
are
> created, you could store style information in your database and then query
> for that information in your report, setting style properties based on the
> query results (e.g. FontFamily
> =First(Fields!DetailRowFontFamily.Value,"StyleDataSet"))
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
> news:%23AOSqt8XEHA.3012@.tk2msftngp13.phx.gbl...
> > Hi:
> >
> > I have to define several style guidelines to build a set of reports with
> the
> > same visual styles.
> >
> > I want my reports to have tables and I want the odd rows WHITE and the
> even
> > rows RED (by example)... how can I do this kind of thing?
> >
> > About the deployment of my styles: I have to configure any report I will
> > implement with the same styles one by one?
> >
> > There is no way to apply a style template (like a cascading style sheet
or
> > XSL) to all my reports or to define my reports using something like
> > Model-View-Controller design?
> >
> > Thanks in advance
> >
> >
> >
> > Ernesto
> >
> >
> >
> Green Bar Report Sample
> ----
--
> --
> <?xml version="1.0" encoding="utf-8"?>
> <Report
>
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
> tion"
>
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <RightMargin>1in</RightMargin>
> <Body>
> <ReportItems>
> <Table Name="table1">
> <Height>0.75in</Height>
> <Style />
> <Header>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox1">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>5</ZIndex>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>Country</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox2">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>4</ZIndex>
> <rd:DefaultName>textbox2</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>Company Name</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Header>
> <Details>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox4">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>1</ZIndex>
> <rd:DefaultName>textbox4</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="CompanyName">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <BackgroundColor>=iif(RowNumber(Nothing) Mod 2,
> "PaleGreen", "White")</BackgroundColor>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <rd:DefaultName>CompanyName</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=Fields!CompanyName.Value</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Details>
> <DataSetName>DataSet1</DataSetName>
> <Width>4.33333in</Width>
> <TableGroups>
> <TableGroup>
> <Header>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="Country">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
>
<BackgroundColor>=iif(RunningValue(Fields!Country.Value,CountDistinct,Nothin
> g) Mod 2, "Cornsilk", "White")</BackgroundColor>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>3</ZIndex>
> <rd:DefaultName>Country</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=Fields!Country.Value</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox11">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>2</ZIndex>
> <rd:DefaultName>textbox11</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> <RepeatOnNewPage>true</RepeatOnNewPage>
> </Header>
> <Grouping Name="CountryGroup">
> <GroupExpressions>
> <GroupExpression>=Fields!Country.Value</GroupExpression>
> </GroupExpressions>
> <PageBreakAtEnd>true</PageBreakAtEnd>
> </Grouping>
> </TableGroup>
> </TableGroups>
> <TableColumns>
> <TableColumn>
> <Width>2.16667in</Width>
> </TableColumn>
> <TableColumn>
> <Width>2.16667in</Width>
> </TableColumn>
> </TableColumns>
> </Table>
> </ReportItems>
> <Style />
> <Height>0.875in</Height>
> </Body>
> <TopMargin>1in</TopMargin>
> <DataSources>
> <DataSource Name="Northwind">
> <rd:DataSourceID>b688b025-197a-46a6-ad1e-97cfe7c0d320</rd:DataSourceID>
> <ConnectionProperties>
> <DataProvider>SQL</DataProvider>
> <ConnectString>data source=localhost;initial
> catalog=Northwind</ConnectString>
> <IntegratedSecurity>true</IntegratedSecurity>
> </ConnectionProperties>
> </DataSource>
> </DataSources>
> <Width>6.5in</Width>
> <DataSets>
> <DataSet Name="DataSet1">
> <Fields>
> <Field Name="CustomerID">
> <DataField>CustomerID</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="CompanyName">
> <DataField>CompanyName</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="ContactName">
> <DataField>ContactName</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="ContactTitle">
> <DataField>ContactTitle</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Address">
> <DataField>Address</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="City">
> <DataField>City</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Region">
> <DataField>Region</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="PostalCode">
> <DataField>PostalCode</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Country">
> <DataField>Country</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Phone">
> <DataField>Phone</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Fax">
> <DataField>Fax</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> </Fields>
> <Query>
> <DataSourceName>Northwind</DataSourceName>
> <CommandText>select * from customers</CommandText>
> <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> </Query>
> </DataSet>
> </DataSets>
> <LeftMargin>1in</LeftMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <rd:DrawGrid>true</rd:DrawGrid>
> <rd:ReportID>0848d9be-0d3d-4002-8752-e94ca66164e0</rd:ReportID>
> <BottomMargin>1in</BottomMargin>
> <Language>en-US</Language>
> </Report>
>

Report - preview looks fine, but exporting to PDF splits controls!!!Help!!

Hi, I've build correctly my report using the most efficient tools. I've made the preview and it worked just fine!However, when I export to PDF, it splits the report heigth into two pages, having the columns of my table and other controls splitted.

I'm already using the font size as 7 or 8 (depends), really small, I've tried hard to reduce their size, however the result remains the same...no resolution!!

Is there anybody who may have or had this situation?Any guests or help?Thanks a lot!

is your report in landscape or potrait layout?

|||I've tried both, however the problem remains. I guess I'll try to change a little bit the report to see any change...Thanks anyway!|||

hi

I had a similar situation when i exported my report to PDF and it inserted blank spaces and spilt the report. My solution was not to change the font but the margin size of the report. Try changing the size of the margins and see if it works...

hope this helps.

|||

Hi,

It may not be just the margin size but more combination of margin and paper size. Drag the back ground paper smaller untill it fits within the size of you paper less the margin.

You can also try printing the report. Does this give the same result as export to pdf. Putting a borad arround the page can help see where the edge is.

hope this helps

dkldev

|||Reorganizing the controls solved out the problem. The issu now is, that I have a footer on which ir presents the current and total nr of pages, such as "page 1 of 2", and the report appears always with 2 pages, even if the report only has one page. The preview shows one page, and the footer shows "page 1 of 1", however, if I export to PDF appears "1 of 2! and the second page only has the footer saying "page 2 of 2"...any guess?Thanks a lot for helping!|||

http://blogs.msdn.com/bwelcker/archive/2005/08/19/Alien-Lanes-_2800_Logical-and-Physical-Pagination-Rules_2900_.aspx

hope this helps