No designer. Ouch!

We are about to propose to a client that they use Reporting Services instead
of such things like crystal Reports, but it is my understanding that they
would also have to buy VS.NET inorder to design new reports.
Is this correct or are Mirosoft going to be providing a standalone report
designer with Reporting Services, one that doesn't reply on VS?
Thanks in advanceToday you have to buy VS, any version. The cheapest way to do this is VB.Net
($100). As far as cost you are most likely still way ahead of alternatives.
With version 2 (hopefully late summer) it will ship with a version of VS
specifically for RS. I.e. RS designer is still an add-on to VS (they get to
leverage all the nice features of VS) but you won't have to purchase a
version of VS to use the designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Gravy" <Gravy@.discussions.microsoft.com> wrote in message
news:9BBA50F5-6860-45BF-B7BB-45A3C09C12D2@.microsoft.com...
> We are about to propose to a client that they use Reporting Services
instead
> of such things like crystal Reports, but it is my understanding that they
> would also have to buy VS.NET inorder to design new reports.
> Is this correct or are Mirosoft going to be providing a standalone report
> designer with Reporting Services, one that doesn't reply on VS?
> Thanks in advance
>|||Here's a related question...
On our development machines, we have VS .NET 2003 loaded and use it to
create the reports solution/project and all the RDLs. We then need to copy
all the RDLs, RDSs, etc. to each of our customers' production computer. The
catch is that the reports may need to be modified on each customer's
computer.
So, we thought we would install VB .NET ($100) on each customer computer and
copy all the report files. The question is: Since we created the reports
solution, project, and RDLs in VS .NET 2003, will we be able to open the
solution, make changes to the RDLs, and deploy to the local Report Server
using the VB .NET that's loaded on the customer computer?
Hope that make sense.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OoLG8BVDFHA.2232@.TK2MSFTNGP14.phx.gbl...
> Today you have to buy VS, any version. The cheapest way to do this is
VB.Net
> ($100). As far as cost you are most likely still way ahead of
alternatives.
> With version 2 (hopefully late summer) it will ship with a version of VS
> specifically for RS. I.e. RS designer is still an add-on to VS (they get
to
> leverage all the nice features of VS) but you won't have to purchase a
> version of VS to use the designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Gravy" <Gravy@.discussions.microsoft.com> wrote in message
> news:9BBA50F5-6860-45BF-B7BB-45A3C09C12D2@.microsoft.com...
> > We are about to propose to a client that they use Reporting Services
> instead
> > of such things like crystal Reports, but it is my understanding that
they
> > would also have to buy VS.NET inorder to design new reports.
> >
> > Is this correct or are Mirosoft going to be providing a standalone
report
> > designer with Reporting Services, one that doesn't reply on VS?
> >
> > Thanks in advance
> >
> >
>|||Yes, you can do what you propose. However, VS.Net may not be necessary on
the customers' computers. Since RDL is XML, you can use any application
capable of editing XML to modify the reports. To deploy, you can write a
simple application which uses the RS SOAP API. There is some code in the
samples which does this.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"MrBill" <mrbill@.nospam.com> wrote in message
news:#IwpmbWDFHA.3504@.TK2MSFTNGP12.phx.gbl...
> Here's a related question...
> On our development machines, we have VS .NET 2003 loaded and use it to
> create the reports solution/project and all the RDLs. We then need to
copy
> all the RDLs, RDSs, etc. to each of our customers' production computer.
The
> catch is that the reports may need to be modified on each customer's
> computer.
> So, we thought we would install VB .NET ($100) on each customer computer
and
> copy all the report files. The question is: Since we created the reports
> solution, project, and RDLs in VS .NET 2003, will we be able to open the
> solution, make changes to the RDLs, and deploy to the local Report Server
> using the VB .NET that's loaded on the customer computer?
> Hope that make sense.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OoLG8BVDFHA.2232@.TK2MSFTNGP14.phx.gbl...
> > Today you have to buy VS, any version. The cheapest way to do this is
> VB.Net
> > ($100). As far as cost you are most likely still way ahead of
> alternatives.
> > With version 2 (hopefully late summer) it will ship with a version of VS
> > specifically for RS. I.e. RS designer is still an add-on to VS (they get
> to
> > leverage all the nice features of VS) but you won't have to purchase a
> > version of VS to use the designer.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Gravy" <Gravy@.discussions.microsoft.com> wrote in message
> > news:9BBA50F5-6860-45BF-B7BB-45A3C09C12D2@.microsoft.com...
> > > We are about to propose to a client that they use Reporting Services
> > instead
> > > of such things like crystal Reports, but it is my understanding that
> they
> > > would also have to buy VS.NET inorder to design new reports.
> > >
> > > Is this correct or are Mirosoft going to be providing a standalone
> report
> > > designer with Reporting Services, one that doesn't reply on VS?
> > >
> > > Thanks in advance
> > >
> > >
> >
> >
>|||take a look at 90 degree software - they have exactly that.
"Gravy" wrote:
> We are about to propose to a client that they use Reporting Services instead
> of such things like crystal Reports, but it is my understanding that they
> would also have to buy VS.NET inorder to design new reports.
> Is this correct or are Mirosoft going to be providing a standalone report
> designer with Reporting Services, one that doesn't reply on VS?
> Thanks in advance
>|||Is your client using SQL 2000 or SQL 2005? If they are using SQL 2005 - then
they will already have a report designer INCLUDED and will not need to buy
from 90 degrees software. 90 degrees appears to have a nice report
designer - but it better be for 850 bucks!
=-Chris
"Tips" <Tips@.discussions.microsoft.com> wrote in message
news:68D157EC-75D1-41F1-BD0A-5B96F506880D@.microsoft.com...
> take a look at 90 degree software - they have exactly that.
> "Gravy" wrote:
>> We are about to propose to a client that they use Reporting Services
>> instead
>> of such things like crystal Reports, but it is my understanding that they
>> would also have to buy VS.NET inorder to design new reports.
>> Is this correct or are Mirosoft going to be providing a standalone report
>> designer with Reporting Services, one that doesn't reply on VS?
>> Thanks in advance
>>|||Plus, if someone is just getting into they should definitely go with RS
2005. The additional features and performance are worth it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris Conner" <Chris.Conner@.NOSPAMPolarisLibrary.com> wrote in message
news:e28sUlg%23GHA.3312@.TK2MSFTNGP02.phx.gbl...
> Is your client using SQL 2000 or SQL 2005? If they are using SQL 2005 -
> then they will already have a report designer INCLUDED and will not need
> to buy from 90 degrees software. 90 degrees appears to have a nice report
> designer - but it better be for 850 bucks!
> =-Chris
> "Tips" <Tips@.discussions.microsoft.com> wrote in message
> news:68D157EC-75D1-41F1-BD0A-5B96F506880D@.microsoft.com...
>> take a look at 90 degree software - they have exactly that.
>> "Gravy" wrote:
>> We are about to propose to a client that they use Reporting Services
>> instead
>> of such things like crystal Reports, but it is my understanding that
>> they
>> would also have to buy VS.NET inorder to design new reports.
>> Is this correct or are Mirosoft going to be providing a standalone
>> report
>> designer with Reporting Services, one that doesn't reply on VS?
>> Thanks in advance
>>
>

No Data-Driven Subscription button

I have created a report and published it on the reporting server. My connection is working, and I have followed the steps in the BOL tutorial for "Defining a Data-Driven Subscription" i.e. Credentials stored securely on report server, using windows credentials when connecting to the data source. When I click on "Subscriptions", I only see "New Subscriptions". However, when I look at other reports (not even created by me), I see the option to create data driven subscriptions. Can somebody tell me what I need to do to see this?I got it; the report cannot be in the "My Reports" folder.

No Data Selected message back to .Net

Hi All
We have a .net application calling some reporting services reports and we
pass the parameters to the reports from the application.
When no data is selected, is there any way to pass a paramter or something
back to the .net application so that we can display a 'No data selected'
message within the .net application.
Thanks
PeteI don't know if you can hook into this at the report level, but the data
regions (table, subreport, matrix, etc.) have a NoRows property that can
display a message if the source data set is empty.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"P" <P@.discussions.microsoft.com> wrote in message
news:B52C45F6-E67A-42B9-8517-3107FA071C93@.microsoft.com...
> Hi All
> We have a .net application calling some reporting services reports and we
> pass the parameters to the reports from the application.
> When no data is selected, is there any way to pass a paramter or something
> back to the .net application so that we can display a 'No data selected'
> message within the .net application.
> Thanks
> Pete

No Access to the PropertiesTab

Hello Community
I've setup a Reporting Server with different reports and users, most of
the features work fine. I'm now tring to add a user which is able to
modifiy the security roles assignment for his reports. I granted him
Content Manager, but I couldn't even access the PropertiesTab from
Reports or Folders.
Is it possible to grant a user the right to modifiy the security
settings from his reports?
Thanks for any helpFound the Solution: The user need access (at least Browser) to the Root
Folder of Reporting Service..
ulrich@.webrevolution.ch schrieb:
> Hello Community
> I've setup a Reporting Server with different reports and users, most of
> the features work fine. I'm now tring to add a user which is able to
> modifiy the security roles assignment for his reports. I granted him
> Content Manager, but I couldn't even access the PropertiesTab from
> Reports or Folders.
> Is it possible to grant a user the right to modifiy the security
> settings from his reports?
> Thanks for any help

Nightly Data Structure Refresh

We are receiving a reporting database from a vendor nightly. We want to
upload this data and structures to SQL Server nightly. We want it to be as
flexible as possible - if the vendor adds/deletes a table/column, the import
job should handle that.
Apparently, the Import/Export wizard in SQL Server and the Upsizing Wizard
in Access both require you to specify what tables to import. This would
prohibit the job from creating new tables/columns on the fly. Any
suggestions for a solution to this problem?
Thanks for the help...Backup and restore?
Transfer Objects Task ?
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"Steve R" <SteveR@.discussions.microsoft.com> wrote in message
news:116327AF-3861-4406-845A-020093FAF674@.microsoft.com...
> We are receiving a reporting database from a vendor nightly. We want to
> upload this data and structures to SQL Server nightly. We want it to be
> as
> flexible as possible - if the vendor adds/deletes a table/column, the
> import
> job should handle that.
> Apparently, the Import/Export wizard in SQL Server and the Upsizing Wizard
> in Access both require you to specify what tables to import. This would
> prohibit the job from creating new tables/columns on the fly. Any
> suggestions for a solution to this problem?
> Thanks for the help...
>|||Couple of questions:
1. Are you trying to append this information to an existing reporting
database, or are you simply discarding a database daily and replacing
it with this new reporting db?
2. What format is the reporting db in (Access, SQL Server)?
3. How much control do you have over the vendor deliverable? Do you
have administrative rights on the box from whence the data comes, or is
it some form of EDI?
Stu|||1. We want to discard the database daily and replace it with the new db.
2. The vendor delivers an Access database, which we want to upload/import
into SQL Server.
3. We do not have control over the vendor's deliverable. As far as we are
concerned, it is only a file to be FTP'ed to us nightly. We will process
from there.
"Stu" wrote:

> Couple of questions:
> 1. Are you trying to append this information to an existing reporting
> database, or are you simply discarding a database daily and replacing
> it with this new reporting db?
> 2. What format is the reporting db in (Access, SQL Server)?
> 3. How much control do you have over the vendor deliverable? Do you
> have administrative rights on the box from whence the data comes, or is
> it some form of EDI?
> Stu
>|||We are starting with the Access database and I am not sure how a backup and
restore would work with this. The Transfer Objects Task only works from one
SQL Server to another, correct?
"Darren Green" wrote:

> Backup and restore?
> Transfer Objects Task ?
> --
> Darren Green
> http://www.sqldts.com
> http://www.sqlis.com
> "Steve R" <SteveR@.discussions.microsoft.com> wrote in message
> news:116327AF-3861-4406-845A-020093FAF674@.microsoft.com...
>
>|||I needed to handle something similar a while back.
Here are the steps that I did:
1) Created a DTS and this import looks today.
2) Exported the DTS to VB.
3) Cleaned up the DTS for to add a new task would be calling a procedure.
4) For each table in Access get the field name.
5) Call the procedure to add each field to the DTS (in VB code)
I know this is a breif explaination of what I did, but if you want more info
let me know.
Rick
"Steve R" <SteveR@.discussions.microsoft.com> wrote in message
news:180C1DD5-7261-474E-B560-723CFAF56010@.microsoft.com...
> 1. We want to discard the database daily and replace it with the new db.
> 2. The vendor delivers an Access database, which we want to upload/import
> into SQL Server.
> 3. We do not have control over the vendor's deliverable. As far as we are
> concerned, it is only a file to be FTP'ed to us nightly. We will process
> from there.
>
> "Stu" wrote:
>|||Is the requirement to merge this with an existing DB or just to load
the vendor's DB onto your server. If it's the latter then just
BACKUP/RESTORE or detach/attach.
If you actually want to merge client schema changes into your own DB
while keeping your existing data then you face quite a challenge.
Suppose the data you already have in your tables violates the
constraints, datatypes or other metadata changes that the client has
made? Do you then want to delete invalid data from your database?
It's certainly possible to automate or semi-automate simple changes
like adding or removing columns. For that you'll probably want a
package with more sophisticated metadata management features than DTS
has. Consider purchasing some third-party ETL tools for the job.
David Portas
SQL Server MVP
--|||I want to load the vendor's DB onto my server from Access to SQL Server. We
will completely replace the data and schema nightly.
Can you do a backup/restore or detach/attach from Access to SQL? if so, can
it be scheduled?
"David Portas" wrote:

> Is the requirement to merge this with an existing DB or just to load
> the vendor's DB onto your server. If it's the latter then just
> BACKUP/RESTORE or detach/attach.
> If you actually want to merge client schema changes into your own DB
> while keeping your existing data then you face quite a challenge.
> Suppose the data you already have in your tables violates the
> constraints, datatypes or other metadata changes that the client has
> made? Do you then want to delete invalid data from your database?
> It's certainly possible to automate or semi-automate simple changes
> like adding or removing columns. For that you'll probably want a
> package with more sophisticated metadata management features than DTS
> has. Consider purchasing some third-party ETL tools for the job.
> --
> David Portas
> SQL Server MVP
> --
>|||I want to load the vendor's DB onto my server from Access to SQL Server. We
will completely replace the data and schema nightly.
Can you do a backup/restore or detach/attach from Access to SQL? if so, can
it be scheduled?
"David Portas" wrote:

> Is the requirement to merge this with an existing DB or just to load
> the vendor's DB onto your server. If it's the latter then just
> BACKUP/RESTORE or detach/attach.
> If you actually want to merge client schema changes into your own DB
> while keeping your existing data then you face quite a challenge.
> Suppose the data you already have in your tables violates the
> constraints, datatypes or other metadata changes that the client has
> made? Do you then want to delete invalid data from your database?
> It's certainly possible to automate or semi-automate simple changes
> like adding or removing columns. For that you'll probably want a
> package with more sophisticated metadata management features than DTS
> has. Consider purchasing some third-party ETL tools for the job.
> --
> David Portas
> SQL Server MVP
> --
>|||I'm not as familiar with Access as I used to be, so take the following
ideas as conceptual only; I think that you can use VBScript to open up
an Access database, and cycle thruhg all of the table and view objects
in that database, generating the appropriate SQL creation statements
for those objects. You'll have to avoid crosstab queries, but I think
those are the only Access views that won't translate into SQL Server (i
could be wrong).
You'll then have to drop the database on SQL Server (if it exists), and
then run the newly created SQL script that you generated to create
those objects. You'll then need to copy data from your tables to your
target database. It can be done, but it'll be a helluva DTS package,
and could take a while to run each time. You could probably accomlish
all of it in a single ActionScript item.
It actually sounds like fun, but then I'm a g :)
Stu

Nightly Data Structure Refresh

We are receiving a reporting database from a vendor nightly. We want to
upload this data and structures to SQL Server nightly. We want it to be as
flexible as possible - if the vendor adds/deletes a table/column, the import
job should handle that.
Apparently, the Import/Export wizard in SQL Server and the Upsizing Wizard
in Access both require you to specify what tables to import. This would
prohibit the job from creating new tables/columns on the fly. Any
suggestions for a solution to this problem?
Thanks for the help...
Backup and restore?
Transfer Objects Task ?
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"Steve R" <SteveR@.discussions.microsoft.com> wrote in message
news:116327AF-3861-4406-845A-020093FAF674@.microsoft.com...
> We are receiving a reporting database from a vendor nightly. We want to
> upload this data and structures to SQL Server nightly. We want it to be
> as
> flexible as possible - if the vendor adds/deletes a table/column, the
> import
> job should handle that.
> Apparently, the Import/Export wizard in SQL Server and the Upsizing Wizard
> in Access both require you to specify what tables to import. This would
> prohibit the job from creating new tables/columns on the fly. Any
> suggestions for a solution to this problem?
> Thanks for the help...
>
|||Couple of questions:
1. Are you trying to append this information to an existing reporting
database, or are you simply discarding a database daily and replacing
it with this new reporting db?
2. What format is the reporting db in (Access, SQL Server)?
3. How much control do you have over the vendor deliverable? Do you
have administrative rights on the box from whence the data comes, or is
it some form of EDI?
Stu
|||1. We want to discard the database daily and replace it with the new db.
2. The vendor delivers an Access database, which we want to upload/import
into SQL Server.
3. We do not have control over the vendor's deliverable. As far as we are
concerned, it is only a file to be FTP'ed to us nightly. We will process
from there.
"Stu" wrote:

> Couple of questions:
> 1. Are you trying to append this information to an existing reporting
> database, or are you simply discarding a database daily and replacing
> it with this new reporting db?
> 2. What format is the reporting db in (Access, SQL Server)?
> 3. How much control do you have over the vendor deliverable? Do you
> have administrative rights on the box from whence the data comes, or is
> it some form of EDI?
> Stu
>
|||We are starting with the Access database and I am not sure how a backup and
restore would work with this. The Transfer Objects Task only works from one
SQL Server to another, correct?
"Darren Green" wrote:

> Backup and restore?
> Transfer Objects Task ?
> --
> Darren Green
> http://www.sqldts.com
> http://www.sqlis.com
> "Steve R" <SteveR@.discussions.microsoft.com> wrote in message
> news:116327AF-3861-4406-845A-020093FAF674@.microsoft.com...
>
>
|||I needed to handle something similar a while back.
Here are the steps that I did:
1) Created a DTS and this import looks today.
2) Exported the DTS to VB.
3) Cleaned up the DTS for to add a new task would be calling a procedure.
4) For each table in Access get the field name.
5) Call the procedure to add each field to the DTS (in VB code)
I know this is a breif explaination of what I did, but if you want more info
let me know.
Rick
"Steve R" <SteveR@.discussions.microsoft.com> wrote in message
news:180C1DD5-7261-474E-B560-723CFAF56010@.microsoft.com...[vbcol=seagreen]
> 1. We want to discard the database daily and replace it with the new db.
> 2. The vendor delivers an Access database, which we want to upload/import
> into SQL Server.
> 3. We do not have control over the vendor's deliverable. As far as we are
> concerned, it is only a file to be FTP'ed to us nightly. We will process
> from there.
>
> "Stu" wrote:
|||Is the requirement to merge this with an existing DB or just to load
the vendor's DB onto your server. If it's the latter then just
BACKUP/RESTORE or detach/attach.
If you actually want to merge client schema changes into your own DB
while keeping your existing data then you face quite a challenge.
Suppose the data you already have in your tables violates the
constraints, datatypes or other metadata changes that the client has
made? Do you then want to delete invalid data from your database?
It's certainly possible to automate or semi-automate simple changes
like adding or removing columns. For that you'll probably want a
package with more sophisticated metadata management features than DTS
has. Consider purchasing some third-party ETL tools for the job.
David Portas
SQL Server MVP
|||I want to load the vendor's DB onto my server from Access to SQL Server. We
will completely replace the data and schema nightly.
Can you do a backup/restore or detach/attach from Access to SQL? if so, can
it be scheduled?
"David Portas" wrote:

> Is the requirement to merge this with an existing DB or just to load
> the vendor's DB onto your server. If it's the latter then just
> BACKUP/RESTORE or detach/attach.
> If you actually want to merge client schema changes into your own DB
> while keeping your existing data then you face quite a challenge.
> Suppose the data you already have in your tables violates the
> constraints, datatypes or other metadata changes that the client has
> made? Do you then want to delete invalid data from your database?
> It's certainly possible to automate or semi-automate simple changes
> like adding or removing columns. For that you'll probably want a
> package with more sophisticated metadata management features than DTS
> has. Consider purchasing some third-party ETL tools for the job.
> --
> David Portas
> SQL Server MVP
> --
>
|||I want to load the vendor's DB onto my server from Access to SQL Server. We
will completely replace the data and schema nightly.
Can you do a backup/restore or detach/attach from Access to SQL? if so, can
it be scheduled?
"David Portas" wrote:

> Is the requirement to merge this with an existing DB or just to load
> the vendor's DB onto your server. If it's the latter then just
> BACKUP/RESTORE or detach/attach.
> If you actually want to merge client schema changes into your own DB
> while keeping your existing data then you face quite a challenge.
> Suppose the data you already have in your tables violates the
> constraints, datatypes or other metadata changes that the client has
> made? Do you then want to delete invalid data from your database?
> It's certainly possible to automate or semi-automate simple changes
> like adding or removing columns. For that you'll probably want a
> package with more sophisticated metadata management features than DTS
> has. Consider purchasing some third-party ETL tools for the job.
> --
> David Portas
> SQL Server MVP
> --
>
|||I'm not as familiar with Access as I used to be, so take the following
ideas as conceptual only; I think that you can use VBScript to open up
an Access database, and cycle thruhg all of the table and view objects
in that database, generating the appropriate SQL creation statements
for those objects. You'll have to avoid crosstab queries, but I think
those are the only Access views that won't translate into SQL Server (i
could be wrong).
You'll then have to drop the database on SQL Server (if it exists), and
then run the newly created SQL script that you generated to create
those objects. You'll then need to copy data from your tables to your
target database. It can be done, but it'll be a helluva DTS package,
and could take a while to run each time. You could probably accomlish
all of it in a single ActionScript item.
It actually sounds like fun, but then I'm a geek
Stu

Next Version of Reporting Services

Hi,
Does anyone know when Microsoft is releasing next version of Reporting
Service with all the issues resolved
PonnurangamSorry, I have seen no date yet for SP2. But if you really mean "next
version", the answer is the first half of 2005; it's in SQL Server 2005.
hth
Eric
Ponnurangam wrote:
> Hi,
> Does anyone know when Microsoft is releasing next version of Reporting
> Service with all the issues resolved
> Ponnurangam

Next version availability

Hello
I'd like to know if the next version of Reporting Services, scheduled for
release along with SQL Server 2005, will be available for previous versions
of SQL Server, specifically, SQL Server 2000?This is my understanding of how it will work. You have to have a license for
SQL Server 2005 in order to run RS 2005. But, the databases used by RS can
reside on a SQL Server 2000 database. If that is not the case I will be
screaming as loud as anyone else.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Matan Holtzer" <MatanHoltzer@.discussions.microsoft.com> wrote in message
news:5FF5E9D1-D69E-482F-BCA9-B171D29FB26B@.microsoft.com...
> Hello
> I'd like to know if the next version of Reporting Services, scheduled for
> release along with SQL Server 2005, will be available for previous
> versions
> of SQL Server, specifically, SQL Server 2000?|||Thanks Bruce
Along with your answer, I took the time and installed RS from SS2005 (latest
Beta) using SS2000 as the database, and it works - at least up to the point
of finishing the installation and initializing. I still have to wait for the
Beta 2 of VS2005 to fully test it.
- Matan -
"Bruce L-C [MVP]" wrote:
> This is my understanding of how it will work. You have to have a license for
> SQL Server 2005 in order to run RS 2005. But, the databases used by RS can
> reside on a SQL Server 2000 database. If that is not the case I will be
> screaming as loud as anyone else.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Matan Holtzer" <MatanHoltzer@.discussions.microsoft.com> wrote in message
> news:5FF5E9D1-D69E-482F-BCA9-B171D29FB26B@.microsoft.com...
> > Hello
> > I'd like to know if the next version of Reporting Services, scheduled for
> > release along with SQL Server 2005, will be available for previous
> > versions
> > of SQL Server, specifically, SQL Server 2000?
>
>

next release or SP2 for Reporting services?

Hi cant seem to find any info on when SP2 or the next release is due? I know
SP1 was June 2004
Thanks Paulahh, just used the infamous "search" button ;)
"Paul" wrote:
> Hi cant seem to find any info on when SP2 or the next release is due? I know
> SP1 was June 2004
> Thanks Paul

Newspaper Columns

Does anyone know how to create Newspaper Columns in Reporting Services? I am
trying to create a company address and phone number directory.
Thanks for any help you can offer.In the Body section of the report, open your properties window. There is a
property under layout called columns. Set the number of columns here.
Then, if you want 2 3" columns w/ 1/2" between them, you would set your
report width to 6.5 and your body width to 3".
msflinx
"GR Pilot" wrote:
> Does anyone know how to create Newspaper Columns in Reporting Services? I am
> trying to create a company address and phone number directory.
> Thanks for any help you can offer.

newline in format string

Can I insert a newline character within a reporting services format string?
I guess \n doesn't work since it is interpreted as a VisualBasic format
string...? Is there an alternative?
Thanks,
Michael CarrvbNewLine
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> Can I insert a newline character within a reporting services format
string?
> I guess \n doesn't work since it is interpreted as a VisualBasic format
> string...? Is there an alternative?
> Thanks,
> Michael Carr
>|||Hmm I think I may have located a bug...
1. If I use vbNewline in the FORMAT STRING, i.e. = "M/dd/yy" & vbNewline &
"h:mm tt", then the vbNewline gets rendered (using the HTML renderer, at
least) out to a linefeed in the HTML textfile which does NOT translate into
a linefeed in the browser.
2. On the other hand, if I use vbNewline in the VALUE itself, i.e. =Format(Fields!Date.Value, "M/dd/yy") & vbNewline & Format(Fields!Date.Value,
"h:mm tt"), then the vbNewline is rendered out as <br/>
This seems to be an inconsistency in the HTML renderer ... ?
Michael Carr
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:eXqVC9weEHA.3680@.TK2MSFTNGP11.phx.gbl...
> vbNewLine
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> > Can I insert a newline character within a reporting services format
> string?
> >
> > I guess \n doesn't work since it is interpreted as a VisualBasic format
> > string...? Is there an alternative?
> >
> > Thanks,
> > Michael Carr
> >
> >
>|||Please clarify the steps to reproduce. I tried the first expression on SP1
and I get <br/>. Here's the expression I used: ="1/1/2004" & vbNewLine &
"12:00:00".
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:OhZEbx0eEHA.2604@.TK2MSFTNGP12.phx.gbl...
> Hmm I think I may have located a bug...
> 1. If I use vbNewline in the FORMAT STRING, i.e. = "M/dd/yy" & vbNewline &
> "h:mm tt", then the vbNewline gets rendered (using the HTML renderer, at
> least) out to a linefeed in the HTML textfile which does NOT translate
into
> a linefeed in the browser.
> 2. On the other hand, if I use vbNewline in the VALUE itself, i.e. => Format(Fields!Date.Value, "M/dd/yy") & vbNewline &
Format(Fields!Date.Value,
> "h:mm tt"), then the vbNewline is rendered out as <br/>
> This seems to be an inconsistency in the HTML renderer ... ?
> Michael Carr
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:eXqVC9weEHA.3680@.TK2MSFTNGP11.phx.gbl...
> > vbNewLine
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Michael Carr" <mcarr@.umich.edu> wrote in message
> > news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> > > Can I insert a newline character within a reporting services format
> > string?
> > >
> > > I guess \n doesn't work since it is interpreted as a VisualBasic
format
> > > string...? Is there an alternative?
> > >
> > > Thanks,
> > > Michael Carr
> > >
> > >
> >
> >
>|||Ravi,
Please see the report below (and attached) for an example. Note that this
renders correctly in the Report Editor Preview, but does not render
correctly in the Report Manager.
<?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>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Date</Value>
�/Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
�Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Date</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="Date">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<Format>= "M/d/yyyy" & vbNewline & "h:mm tt"</Format>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>Date</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!Date.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Date_1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>Date_1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Format(Fields!Date.Value, "M/d/yyyy") & vbNewline &
Format(Fields!Date.Value, "h:mm tt")</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<DataSetName>DataSet1</DataSetName>
<Top>0.5in</Top>
<Width>4.33333in</Width>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox7</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox8</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
<Left>1.125in</Left>
<TableColumns>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="SkyScheduler">
<rd:DataSourceID>6617abfe-bebd-49ae-a365-417ab349c748</rd:DataSourceID>
<DataSourceReference>SkyScheduler</DataSourceReference>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="Date">
<DataField>Date</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>SkyScheduler</DataSourceName>
<CommandText>SELECT CONVERT(smalldatetime, '1/1/2000 3:00pm') AS
Date</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>6c9977cc-7283-416b-a107-65d98a0c8dd2</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:ODeNfFnfEHA.708@.TK2MSFTNGP09.phx.gbl...
> Please clarify the steps to reproduce. I tried the first expression on SP1
> and I get <br/>. Here's the expression I used: ="1/1/2004" & vbNewLine &
> "12:00:00".
begin 666 BRExample.rdl
M/#]X;6P@.=F5R<VEO;CTB,2XP(B!E;F-O9&EN9STB=71F+3@.B/SX-"CQ297!O
M<G0@.>&UL;G,](FAT=' Z+R]S8VAE;6%S+FUI8W)O<V]F="YC;VTO<W%L<V5R
M=F5R+W)E<&]R=&EN9R\R,# S+S$P+W)E<&]R=&1E9FEN:71I;VXB('AM;&YS
M.G)D/2)H='1P.B\O<V-H96UA<RYM:6-R;W-O9G0N8V]M+U-13%-E<G9E<B]R
M97!O<G1I;F<O<F5P;W)T9&5S:6=N97(B/@.T*(" \4FEG:'1-87)G:6X^,6EN
M/"]2:6=H=$UA<F=I;CX-"B @./$)O9'D^#0H@.(" @./%)E<&]R=$ET96US/@.T*
M(" @.(" @./%1A8FQE($YA;64](G1A8FQE,2(^#0H@.(" @.(" @.(#Q(96EG:'0^
M,"XW-6EN/"](96EG:'0^#0H@.(" @.(" @.(#Q3='EL92 O/@.T*(" @.(" @.(" \
M2&5A9&5R/@.T*(" @.(" @.(" @.(#Q486)L95)O=W,^#0H@.(" @.(" @.(" @.(" \
M5&%B;&52;W<^#0H@.(" @.(" @.(" @.(" @.(#Q(96EG:'0^,"XR-6EN/"](96EG
M:'0^#0H@.(" @.(" @.(" @.(" @.(#Q486)L94-E;&QS/@.T*(" @.(" @.(" @.(" @.
M(" @.(#Q486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.(" \4F5P;W)T271E
M;7,^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT8F]X($YA;64](G1E>'1B
M;W@.Q(CX-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4W1Y;&4^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9TQE9G0^,G!T/"]0861D:6YG3&5F
M=#X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT06QI9VX^3&5F=#PO
M5&5X=$%L:6=N/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F="
M;W1T;VT^,G!T/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @./%!A9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H
M=#X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(#Q:26YD97@.^-3PO6DEN9&5X/@.T*(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(#QR9#I$969A=6QT3F%M93YT97AT8F]X,3PO<F0Z1&5F875L
M=$YA;64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./$-A;D=R;W<^=')U93PO
M0V%N1W)O=SX-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \5F%L=64^1&%T93PO
M5F%L=64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#PO5&5X=&)O>#X-"B @.(" @.
M(" @.(" @.(" @.(" @.(#PO4F5P;W)T271E;7,^#0H@.(" @.(" @.(" @.(" @.(" @.
M/"]486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @./%1A8FQE0V5L;#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.
M(" @.(" @./%1E>'1B;W@.@.3F%M93TB=&5X=&)O>#(B/@.T*(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(#Q3='EL93X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q0
M861D:6YG3&5F=#XR<'0\+U!A9&1I;F=,969T/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./%1E>'1!;&EG;CY,969T/"]497AT06QI9VX^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9T)O='1O;3XR<'0\+U!A9&1I;F="
M;W1T;VT^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9U1O<#XR
M<'0\+U!A9&1I;F=4;W ^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D
M9&EN9U)I9VAT/C)P=#PO4&%D9&EN9U)I9VAT/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%I);F1E
M>#XT/"]:26YD97@.^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./')D.D1E9F%U
M;'1.86UE/G1E>'1B;W@.R/"]R9#I$969A=6QT3F%M93X-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \0V%N1W)O=SYT<G5E/"]#86Y'<F]W/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(#Q686QU93Y$871E/"]686QU93X-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @./"]497AT8F]X/@.T*(" @.(" @.(" @.(" @.(" @.(" @./"]297!O
M<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;#X-"B @.(" @.
M(" @.(" @.(" @./"]486)L94-E;&QS/@.T*(" @.(" @.(" @.(" @./"]486)L95)O
M=SX-"B @.(" @.(" @.(" \+U1A8FQE4F]W<SX-"B @.(" @.(" @./"](96%D97(^
M#0H@.(" @.(" @.(#Q$971A:6QS/@.T*(" @.(" @.(" @.(#Q486)L95)O=W,^#0H@.
M(" @.(" @.(" @.(" \5&%B;&52;W<^#0H@.(" @.(" @.(" @.(" @.(#Q(96EG:'0^
M,"XR-6EN/"](96EG:'0^#0H@.(" @.(" @.(" @.(" @.(#Q486)L94-E;&QS/@.T*
M(" @.(" @.(" @.(" @.(" @.(#Q486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.
M(" \4F5P;W)T271E;7,^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT8F]X
M($YA;64](D1A=&4B/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q3='EL93X-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q0861D:6YG3&5F=#XR<'0\+U!A
M9&1I;F=,969T/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./$9O<FUA=#X]
M(")-+V0O>7EY>2(@.)F%M<#L@.=F).97=L:6YE("9A;7 [(")H.FUM('1T(CPO
M1F]R;6%T/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1!;&EG;CY,
M969T/"]497AT06QI9VX^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D
M9&EN9T)O='1O;3XR<'0\+U!A9&1I;F=";W1T;VT^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \4&%D9&EN9U1O<#XR<'0\+U!A9&1I;F=4;W ^#0H@.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9U)I9VAT/C)P=#PO4&%D9&EN
M9U)I9VAT/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @./%I);F1E>#XQ/"]:26YD97@.^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @./')D.D1E9F%U;'1.86UE/D1A=&4\+W)D.D1E9F%U
M;'1.86UE/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q#86Y'<F]W/G1R=64\
M+T-A;D=R;W<^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%9A;'5E/CU&:65L
M9',A1&%T92Y686QU93PO5F%L=64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#PO
M5&5X=&)O>#X-"B @.(" @.(" @.(" @.(" @.(" @.(#PO4F5P;W)T271E;7,^#0H@.
M(" @.(" @.(" @.(" @.(" @./"]486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.
M/%1A8FQE0V5L;#X-"B @.(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M<SX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1B;W@.@.3F%M93TB1&%T95\Q(CX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4W1Y;&4^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \4&%D9&EN9TQE9G0^,G!T/"]0861D:6YG3&5F=#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT06QI9VX^3&5F=#PO5&5X=$%L
M:6=N/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=";W1T;VT^
M,G!T/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.
M/%!A9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H=#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(#QR9#I$969A=6QT3F%M93Y$871E7S$\+W)D.D1E9F%U;'1.86UE
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q#86Y'<F]W/G1R=64\+T-A;D=R
M;W<^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%9A;'5E/CU&;W)M870H1FEE
M;&1S(41A=&4N5F%L=64L(")-+V0O>7EY>2(I("9A;7 [('9B3F5W;&EN92 F
M86UP.R!&;W)M870H1FEE;&1S(41A=&4N5F%L=64L(")H.FUM('1T(BD\+U9A
M;'5E/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" \+U1E>'1B;W@.^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" \+U)E<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(#PO
M5&%B;&5#96QL/@.T*(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;',^#0H@.(" @.
M(" @.(" @.(" \+U1A8FQE4F]W/@.T*(" @.(" @.(" @.(#PO5&%B;&52;W=S/@.T*
M(" @.(" @.(" \+T1E=&%I;',^#0H@.(" @.(" @.(#Q$871A4V5T3F%M93Y$871A
M4V5T,3PO1&%T85-E=$YA;64^#0H@.(" @.(" @.(#Q4;W ^,"XU:6X\+U1O<#X-
M"B @.(" @.(" @./%=I9'1H/C0N,S,S,S-I;CPO5VED=&@.^#0H@.(" @.(" @.(#Q&
M;V]T97(^#0H@.(" @.(" @.(" @./%1A8FQE4F]W<SX-"B @.(" @.(" @.(" @.(#Q4
M86)L95)O=SX-"B @.(" @.(" @.(" @.(" @./$AE:6=H=#XP+C(U:6X\+TAE:6=H
M=#X-"B @.(" @.(" @.(" @.(" @./%1A8FQE0V5L;',^#0H@.(" @.(" @.(" @.(" @.
M(" @./%1A8FQE0V5L;#X-"B @.(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M
M<SX-"B @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1B;W@.@.3F%M93TB=&5X=&)O
M>#<B/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q3='EL93X-"B @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(#Q0861D:6YG3&5F=#XR<'0\+U!A9&1I;F=,969T
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=";W1T;VT^,G!T
M/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A
M9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H=#X-"B @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(#Q:26YD97@.^,SPO6DEN9&5X/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.
M(#QR9#I$969A=6QT3F%M93YT97AT8F]X-SPO<F0Z1&5F875L=$YA;64^#0H@.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @./$-A;D=R;W<^=')U93PO0V%N1W)O=SX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \5F%L=64@.+SX-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @./"]497AT8F]X/@.T*(" @.(" @.(" @.(" @.(" @.(" @./"]297!O
M<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;#X-"B @.(" @.
M(" @.(" @.(" @.(" \5&%B;&5#96QL/@.T*(" @.(" @.(" @.(" @.(" @.(" @./%)E
M<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" \5&5X=&)O>"!.86UE
M/2)T97AT8F]X."(^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%-T>6QE/@.T*
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=,969T/C)P=#PO4&%D
M9&EN9TQE9G0^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9T)O
M='1O;3XR<'0\+U!A9&1I;F=";W1T;VT^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" \4&%D9&EN9U1O<#XR<'0\+U!A9&1I;F=4;W ^#0H@.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" \4&%D9&EN9U)I9VAT/C)P=#PO4&%D9&EN9U)I9VAT
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @./%I);F1E>#XR/"]:26YD97@.^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./')D.D1E9F%U;'1.86UE/G1E>'1B;W@.X/"]R9#I$969A=6QT
M3F%M93X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \0V%N1W)O=SYT<G5E/"]#
M86Y'<F]W/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q686QU92 O/@.T*(" @.
M(" @.(" @.(" @.(" @.(" @.(" \+U1E>'1B;W@.^#0H@.(" @.(" @.(" @.(" @.(" @.
M(" \+U)E<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(#PO5&%B;&5#96QL
M/@.T*(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;',^#0H@.(" @.(" @.(" @.(" \
M+U1A8FQE4F]W/@.T*(" @.(" @.(" @.(#PO5&%B;&52;W=S/@.T*(" @.(" @.(" \
M+T9O;W1E<CX-"B @.(" @.(" @./$QE9G0^,2XQ,C5I;CPO3&5F=#X-"B @.(" @.
M(" @./%1A8FQE0V]L=6UN<SX-"B @.(" @.(" @.(" \5&%B;&5#;VQU;6X^#0H@.
M(" @.(" @.(" @.(" \5VED=&@.^,BXQ-C8V-VEN/"]7:61T:#X-"B @.(" @.(" @.
M(" \+U1A8FQE0V]L=6UN/@.T*(" @.(" @.(" @.(#Q486)L94-O;'5M;CX-"B @.
M(" @.(" @.(" @.(#Q7:61T:#XR+C$V-C8W:6X\+U=I9'1H/@.T*(" @.(" @.(" @.
M(#PO5&%B;&5#;VQU;6X^#0H@.(" @.(" @.(#PO5&%B;&5#;VQU;6YS/@.T*(" @.
M(" @./"]486)L93X-"B @.(" \+U)E<&]R=$ET96US/@.T*(" @.(#Q3='EL92 O
M/@.T*(" @.(#Q(96EG:'0^,FEN/"](96EG:'0^#0H@.(#PO0F]D>3X-"B @./%1O
M<$UA<F=I;CXQ:6X\+U1O<$UA<F=I;CX-"B @./$1A=&%3;W5R8V5S/@.T*(" @.
M(#Q$871A4V]U<F-E($YA;64](E-K>5-C:&5D=6QE<B(^#0H@.(" @.(" \<F0Z
M1&%T85-O=7)C94E$/C8V,3=A8F9E+6)E8F0M-#EA92UA,S8U+30Q-V%B,S0Y
M8S<T.#PO<F0Z1&%T85-O=7)C94E$/@.T*(" @.(" @./$1A=&%3;W5R8V52969E
M<F5N8V4^4VMY4V-H961U;&5R/"]$871A4V]U<F-E4F5F97)E;F-E/@.T*(" @.
M(#PO1&%T85-O=7)C93X-"B @./"]$871A4V]U<F-E<SX-"B @./%=I9'1H/C8N
M-6EN/"]7:61T:#X-"B @./$1A=&%3971S/@.T*(" @.(#Q$871A4V5T($YA;64]
M(D1A=&%3970Q(CX-"B @.(" @.(#Q&:65L9',^#0H@.(" @.(" @.(#Q&:65L9"!.
M86UE/2)$871E(CX-"B @.(" @.(" @.(" \1&%T849I96QD/D1A=&4\+T1A=&%&
M:65L9#X-"B @.(" @.(" @.(" \<F0Z5'EP94YA;64^4WES=&5M+D1A=&54:6UE
M/"]R9#I4>7!E3F%M93X-"B @.(" @.(" @./"]&:65L9#X-"B @.(" @.(#PO1FEE
M;&1S/@.T*(" @.(" @./%%U97)Y/@.T*(" @.(" @.(" \1&%T85-O=7)C94YA;64^
M4VMY4V-H961U;&5R/"]$871A4V]U<F-E3F%M93X-"B @.(" @.(" @./$-O;6UA
M;F1497AT/E-%3$5#5"!#3TY615)4*'-M86QL9&%T971I;64L("<Q+S$O,C P
M," S.C P<&TG*2!!4R!$871E/"]#;VUM86YD5&5X=#X-"B @.(" @.(" @./')D
M.E5S94=E;F5R:6-$97-I9VYE<CYT<G5E/"]R9#I5<V5'96YE<FEC1&5S:6=N
M97(^#0H@.(" @.(" \+U%U97)Y/@.T*(" @.(#PO1&%T85-E=#X-"B @./"]$871A
M4V5T<SX-"B @./$QE9G1-87)G:6X^,6EN/"],969T36%R9VEN/@.T*(" \<F0Z
M4VYA<%1O1W)I9#YT<G5E/"]R9#I3;F%P5&]'<FED/@.T*(" \<F0Z1')A=T=R
M:60^=')U93PO<F0Z1')A=T=R:60^#0H@.(#QR9#I297!O<G1)1#XV8SDY-S=C
M8RTW,C@.S+30Q-F(M83$P-RTV-60Y.&$P8SAD9#(\+W)D.E)E<&]R=$E$/@.T*
M(" \0F]T=&]M36%R9VEN/C%I;CPO0F]T=&]M36%R9VEN/@.T*(" \3&%N9W5A
>9V4^96XM55,\+TQA;F=U86=E/@.T*/"]297!O<G0^
`
end|||Ravi,
Did you get a chance to look at the example I posted?
Michael Carr
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> Ravi,
> Please see the report below (and attached) for an example. Note that this
> renders correctly in the Report Editor Preview, but does not render
> correctly in the Report Manager.|||I will look into this today.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:eOjzh9ShEHA.3864@.TK2MSFTNGP10.phx.gbl...
> Ravi,
> Did you get a chance to look at the example I posted?
> Michael Carr
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> > Ravi,
> >
> > Please see the report below (and attached) for an example. Note that
this
> > renders correctly in the Report Editor Preview, but does not render
> > correctly in the Report Manager.
>|||I have logged this as a bug in HTML renderer which may be fixed in a future
release. Thanks for reporting this issue.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:OXh8fEThEHA.3916@.TK2MSFTNGP11.phx.gbl...
> I will look into this today.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:eOjzh9ShEHA.3864@.TK2MSFTNGP10.phx.gbl...
> > Ravi,
> >
> > Did you get a chance to look at the example I posted?
> >
> > Michael Carr
> >
> > "Michael Carr" <mcarr@.umich.edu> wrote in message
> > news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> > > Ravi,
> > >
> > > Please see the report below (and attached) for an example. Note that
> this
> > > renders correctly in the Report Editor Preview, but does not render
> > > correctly in the Report Manager.
> >
> >
>

Newbie: Object name 'ProductSubCategory' is not valid.

Hi all,
I have just installed Reporting Services in a W2003 server (without VS.Net).
and SQL Server 2000.
I have run the Report Administrator, and after inserting my the windows
admin user and its password, looks like it works.
Then I load the example file Company Sales.rdl which is in the
Samples\Reports folder. looks like it loads perfectly.
But when I click on it in order to see the file, gives me that error:
Error while processing report(rsProcessingAborted). Query execution error
for Sales dataset (rsErrorExecutingCommand).
The object name 'ProductSubCategory' is not valid.
What am I doing wrong?
Any help/hint or whatever will be wellcome.
Thanks in advance,
Ibai Peña"Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
<cut>
> Then I load the example file Company Sales.rdl which is in the
> Samples\Reports folder. looks like it loads perfectly.
> But when I click on it in order to see the file, gives me that error:
> Error while processing report(rsProcessingAborted). Query execution error
> for Sales dataset (rsErrorExecutingCommand).
> The object name 'ProductSubCategory' is not valid.
>
Have you created the Datasource yet? You need to create a data source for
the sample reports to run. The Books Online explains how to and what
settings to use.
Kaisa|||Thank you for your replay.
I was just to post that I have found that the datasource wasn´t defined.
What leads me to the next question:
Is is possible to set a default datasource for all reports?
Thanks,
Ibai Peña
"Kaisa M. Lindahl" wrote:
> "Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
> news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
> <cut>
> > Then I load the example file Company Sales.rdl which is in the
> > Samples\Reports folder. looks like it loads perfectly.
> >
> > But when I click on it in order to see the file, gives me that error:
> >
> > Error while processing report(rsProcessingAborted). Query execution error
> > for Sales dataset (rsErrorExecutingCommand).
> > The object name 'ProductSubCategory' is not valid.
> >
> Have you created the Datasource yet? You need to create a data source for
> the sample reports to run. The Books Online explains how to and what
> settings to use.
> Kaisa
>
>|||RSConfig.exe file. Sorry, sometimes it is better to spend some time before
asking.
Regards,
Ibai Peña
"Ibai Peña" wrote:
> Thank you for your replay.
> I was just to post that I have found that the datasource wasn´t defined.
> What leads me to the next question:
> Is is possible to set a default datasource for all reports?
> Thanks,
> Ibai Peña
> "Kaisa M. Lindahl" wrote:
> > "Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
> > news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
> > <cut>
> > > Then I load the example file Company Sales.rdl which is in the
> > > Samples\Reports folder. looks like it loads perfectly.
> > >
> > > But when I click on it in order to see the file, gives me that error:
> > >
> > > Error while processing report(rsProcessingAborted). Query execution error
> > > for Sales dataset (rsErrorExecutingCommand).
> > > The object name 'ProductSubCategory' is not valid.
> > >
> >
> > Have you created the Datasource yet? You need to create a data source for
> > the sample reports to run. The Books Online explains how to and what
> > settings to use.
> > Kaisa
> >
> >
> >