Difference between .rdl and .rdlc files

What is the difference between reports created using Business Intelligence Projects Template and the reports created using .rdlc file which is present in the various file types displayed. Why SSRS needs to be installed when you can create reports using .rdlc file.

The way I understand it, .rdl is a server controlled report and .rdlc is a client-side controlled report. You have to deploy an .rdl file to a report server and access it using that server. With a .rdlc report, you can create the report and use a ReportViewer control to run the report in your application.

|||

RDL files are created by the SQL Server 2005 version of Report Designer. RDLC files are created by the Visual Studio 2005 version of Report Designer.

RDL and RDLC formats have the same XML schema. However, in RDLC files, some values (such as query text) are allowed to be empty, which means that they are not immediately ready to be published to a Report Server. The missing values can be entered by opening the RDLC file using the SQL Server 2005 version of Report Designer. (You have to rename .rdlc to .rdl first.)

RDL files are fully compatible with the ReportViewer control runtime. However, RDL files do not contain some information that the design-time of the ReportViewer control depends on for automatically generating data-binding code. Bymanually binding data, RDL files can be used in the ReportViewer control.

Note that the ReportViewer control does not contain any logic for connecting to databases or executing queries. By separating out such logic, the ReportViewer has been made compatible with all data sources, including non-database data sources. However this means that when an RDL file is used by the ReportViewer control, the SQL related information in the RDL file is simply ignored by the control. It is the host application's responsibility to connect to databases, execute queries and supply data to the ReportViewer control in the form of ADO.NET DataTables.

|||

Thanks Tamer Fathy. But I have certain doubts. I can build reports using the .rdlc files provided by VS 2005. The data could be fetched from any database.To display the report, we have got the reportviewer. The reports as far as I understand will be hosted on the application server not on Report Server as in case of
SSRS 2005. So what are the additional advantages of SSRS 2005 and what are the components that I should install to receive the benefits? I have got sql server 2000 as my backend.

Thanks in advance

|||

you don't need reporting service as you use rdlc read this areticle and see the samples

http://www.gotreportviewer.com/

|||

Thanks Tamer Fathy. But I did not understand the following abstract from the article you asked me to go through.

Q: Why doesn't the ReportViewer control support parameter prompting in local mode?

A: The ReportViewer control does not prompt for parameters when in local mode. It prompts for parameters when it is connected to a Report Server.

In local mode it does not make sense for ReportViewer to prompt for parameters. The rationale is as follows: The most common use of report parameters is to pass to queries as values of query parameters. But unlike the Report Server, the ReportViewer control does not execute queries itself. Rather, queries are executed by the host application, and the result is passed to the ReportViewer control. So the ReportViewer control does not have the opportunity to set query parameters. Applications should take advantage of the parameterization features of Visual Studio data wizards instead.

|||

You welcome any time :),

concerning your question it was easy, this is the difference between the RDL and RDLC in case you need to pass parameters to your reports if you use RDLC which in client side processing as get the data from the database and assign it to the report you need to handle the passing of the parameters by developing the form which get the parameters from the user and then use it in your query then when you get the results you pass it to the report to display.

but if you use server side processing you can use the report viewer control (custom control used to view reports in your application (web or windows)) to handle the parameti hope i explain it in good way and i help you

|||

Thanks Tamer Fathy. But I have one more doubt. Making use of .rdlc file type and the reportviewer provided by VS2005 instead of SSRS 2005 would mean that the reports will be on the application server rather than being hosted on the reportserver since I won't be having a seprate report server. Will this affect the performance of my application server?

Thanks in advance.

|||

no this will not affect your application performance as it wil be as you query the data base for specific data

Did the Crystal reports Support Web

Hi this is murali,
can i know did the crystal Reports Supports Web Database.
I want to connect a web database to display as reports.Refer here
www.businessobjects.com

Development Tools

Are there any tools (other than Visual Studio.NET) that will allow me to
build SQL Reporting Services Reports? I just want to build some simple
reports and don't need (or want) to install the Visual Studio.NET.SQL Server 2005 will include a new tool called "Report Builder" that is
intended for end-users. It doesn't depend on VS.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <John@.discussions.microsoft.com> wrote in message
news:43A3C15E-9042-4204-BB90-CFA8A0BE86EA@.microsoft.com...
> Are there any tools (other than Visual Studio.NET) that will allow me to
> build SQL Reporting Services Reports? I just want to build some simple
> reports and don't need (or want) to install the Visual Studio.NET.

Development server vs Live server deployment

How do you guys handle this? I want to create and develop our reports on our
development report services server with its own SQL server 2005 server...
then later when they are tested and working deploy them to our live server
with a completly different instance of SQL Server 2005 (enterprise edition)
and have them run there on its report services server with its data source
as itself... how would you go about doing this? thanks! Also is there a way
to change the database and database server at runtime (say in a VB.NET
application?) thanks!Smokey,
Check this page :
http://msdn2.microsoft.com/en-us/library/ms160854.aspx
for "PublishSampleReports.rss"
This should answer your "how would you go about doing this" part of the
question...
Andrei.
"Smokey Grindle" <nospam@.dontspamme.com> wrote in message
news:%23fQIZjOOHHA.1248@.TK2MSFTNGP03.phx.gbl...
> How do you guys handle this? I want to create and develop our reports on
> our development report services server with its own SQL server 2005
> server... then later when they are tested and working deploy them to our
> live server with a completly different instance of SQL Server 2005
> (enterprise edition) and have them run there on its report services server
> with its data source as itself... how would you go about doing this?
> thanks! Also is there a way to change the database and database server at
> runtime (say in a VB.NET application?) thanks!
>|||any idea how you would change the dataset's database and database server at
runtime of a report?
"Andrei" <andrei.toma@.era-environmental.com> wrote in message
news:O4ukonOOHHA.2236@.TK2MSFTNGP02.phx.gbl...
> Smokey,
> Check this page :
> http://msdn2.microsoft.com/en-us/library/ms160854.aspx
> for "PublishSampleReports.rss"
> This should answer your "how would you go about doing this" part of the
> question...
> Andrei.
> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
> news:%23fQIZjOOHHA.1248@.TK2MSFTNGP03.phx.gbl...
>> How do you guys handle this? I want to create and develop our reports on
>> our development report services server with its own SQL server 2005
>> server... then later when they are tested and working deploy them to our
>> live server with a completly different instance of SQL Server 2005
>> (enterprise edition) and have them run there on its report services
>> server with its data source as itself... how would you go about doing
>> this? thanks! Also is there a way to change the database and database
>> server at runtime (say in a VB.NET application?) thanks!
>|||Are you supporting multiple databases with the same structure or is this
just going from development to production? If you use shared datasources
then you configure it once on each server and after that you are good to go.
The reports go against the shared datasource which defaults to not being
overwritten so when you deploy it is left alone.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smokey Grindle" <nospam@.dontspamme.com> wrote in message
news:eRK0myOOHHA.3212@.TK2MSFTNGP02.phx.gbl...
> any idea how you would change the dataset's database and database server
> at runtime of a report?
> "Andrei" <andrei.toma@.era-environmental.com> wrote in message
> news:O4ukonOOHHA.2236@.TK2MSFTNGP02.phx.gbl...
>> Smokey,
>> Check this page :
>> http://msdn2.microsoft.com/en-us/library/ms160854.aspx
>> for "PublishSampleReports.rss"
>> This should answer your "how would you go about doing this" part of the
>> question...
>> Andrei.
>> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
>> news:%23fQIZjOOHHA.1248@.TK2MSFTNGP03.phx.gbl...
>> How do you guys handle this? I want to create and develop our reports on
>> our development report services server with its own SQL server 2005
>> server... then later when they are tested and working deploy them to our
>> live server with a completly different instance of SQL Server 2005
>> (enterprise edition) and have them run there on its report services
>> server with its data source as itself... how would you go about doing
>> this? thanks! Also is there a way to change the database and database
>> server at runtime (say in a VB.NET application?) thanks!
>>
>|||multiple databases, We have this structure in our application...
Our Live server can have multiple databases with the same exact schema (we
have a Live system with real time data, and a testing system with weekly
data from the live system for testing out stuff) when we log into our
application you select the server and which database you are going to work
with... in crystal reports we manually changed the mappings in the report to
get it to work with the different databases on the server then ran the
report, just wondering how you can do something similar in reporting server.
90% of the time the reports are ran in the live system, but we still have to
support the other 10% and dont want to make copies of reports for each
database, because techincally, someone could make another database at any
point in time with the same schema
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uiAgLBSOHHA.4848@.TK2MSFTNGP04.phx.gbl...
> Are you supporting multiple databases with the same structure or is this
> just going from development to production? If you use shared datasources
> then you configure it once on each server and after that you are good to
> go. The reports go against the shared datasource which defaults to not
> being overwritten so when you deploy it is left alone.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
> news:eRK0myOOHHA.3212@.TK2MSFTNGP02.phx.gbl...
>> any idea how you would change the dataset's database and database server
>> at runtime of a report?
>> "Andrei" <andrei.toma@.era-environmental.com> wrote in message
>> news:O4ukonOOHHA.2236@.TK2MSFTNGP02.phx.gbl...
>> Smokey,
>> Check this page :
>> http://msdn2.microsoft.com/en-us/library/ms160854.aspx
>> for "PublishSampleReports.rss"
>> This should answer your "how would you go about doing this" part of the
>> question...
>> Andrei.
>> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
>> news:%23fQIZjOOHHA.1248@.TK2MSFTNGP03.phx.gbl...
>> How do you guys handle this? I want to create and develop our reports
>> on our development report services server with its own SQL server 2005
>> server... then later when they are tested and working deploy them to
>> our live server with a completly different instance of SQL Server 2005
>> (enterprise edition) and have them run there on its report services
>> server with its data source as itself... how would you go about doing
>> this? thanks! Also is there a way to change the database and database
>> server at runtime (say in a VB.NET application?) thanks!
>>
>>
>

developing reports for Exchange 2003

Has anyone had experience with developing reports based off items in
Exchange 2003? Is it possible to use reporting services to connect to
Exchange to report on types of emails or does another type of connection
have to made? Any insight would be much appreciated. Thanks.
--
****************************************
Andy S.
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
****************************************You might want to download the new "SQL Server 2000 Report Pack for
Microsoft Exchange":
http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
It is a set of 13 Microsoft Exchange-based reports with a sample database
that lets you easily visualize and author managed reports for e-mail
administration.
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andy S." <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
news:eMSHKeipEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Has anyone had experience with developing reports based off items in
> Exchange 2003? Is it possible to use reporting services to connect to
> Exchange to report on types of emails or does another type of connection
> have to made? Any insight would be much appreciated. Thanks.
> --
> ****************************************
> Andy S.
> andymcdba1@.NOMORESPAM.yahoo.com
> Please remove NOMORESPAM before replying.
> ****************************************
>
>|||Thanks, I saw that. However, if you notice, this SQL Server Report Pack is
for a 3rd party app developed by Super Software for their tool that exports
Exchange code.
What I really need to figure out is how to create a reporting service
connection to Exchange instead of having to figure out how to create a .NET
application that uses a CDO type connection. I keep seeing something about
an Exchange OLE DB Provider but no instructions on how to add it to the
available providers in reporting services or how to access the store in
Exchange with it.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:uPxFW2jpEHA.1992@.TK2MSFTNGP09.phx.gbl...
> You might want to download the new "SQL Server 2000 Report Pack for
> Microsoft Exchange":
>
http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
> It is a set of 13 Microsoft Exchange-based reports with a sample database
> that lets you easily visualize and author managed reports for e-mail
> administration.
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Andy S." <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
> news:eMSHKeipEHA.2764@.TK2MSFTNGP11.phx.gbl...
> > Has anyone had experience with developing reports based off items in
> > Exchange 2003? Is it possible to use reporting services to connect to
> > Exchange to report on types of emails or does another type of connection
> > have to made? Any insight would be much appreciated. Thanks.
> >
> > --
> > ****************************************
> > Andy S.
> > andymcdba1@.NOMORESPAM.yahoo.com
> >
> > Please remove NOMORESPAM before replying.
> >
> > ****************************************
> >
> >
> >
> >
>|||The Exchange OLEDB provider only works on the Exchange Server itself so you
would have to run Reporting Services on your Exchange Server. Your other
option is to find a WebDAV OLEDB provider (I believe there are some freeware
ones) and you could use that as well from Reporting Services.
--
Looking for a good book on programming Exchange, Outlook, ADSI and
SharePoint? Check out http://www.microsoft.com/MSPress/books/5517.asp
"Andy S." <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
news:e%23d2CUmpEHA.1296@.TK2MSFTNGP12.phx.gbl...
> Thanks, I saw that. However, if you notice, this SQL Server Report Pack
> is
> for a 3rd party app developed by Super Software for their tool that
> exports
> Exchange code.
> What I really need to figure out is how to create a reporting service
> connection to Exchange instead of having to figure out how to create a
> .NET
> application that uses a CDO type connection. I keep seeing something
> about
> an Exchange OLE DB Provider but no instructions on how to add it to the
> available providers in reporting services or how to access the store in
> Exchange with it.
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:uPxFW2jpEHA.1992@.TK2MSFTNGP09.phx.gbl...
>> You might want to download the new "SQL Server 2000 Report Pack for
>> Microsoft Exchange":
> http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
>> It is a set of 13 Microsoft Exchange-based reports with a sample database
>> that lets you easily visualize and author managed reports for e-mail
>> administration.
>> --
>> Robert M. Bruckner
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Andy S." <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
>> news:eMSHKeipEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> > Has anyone had experience with developing reports based off items in
>> > Exchange 2003? Is it possible to use reporting services to connect to
>> > Exchange to report on types of emails or does another type of
>> > connection
>> > have to made? Any insight would be much appreciated. Thanks.
>> >
>> > --
>> > ****************************************
>> > Andy S.
>> > andymcdba1@.NOMORESPAM.yahoo.com
>> >
>> > Please remove NOMORESPAM before replying.
>> >
>> > ****************************************
>> >
>> >
>> >
>> >
>>
>

develop RS2000 report through V Studio.NET 2005

Hi all, is it possible to create RS2000 format reports through Visual Studio
.NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
reports as my ERP system only supports SQL server 2000.No. If you need to develop RS 2000 reports then you need some version of VS
2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will not
work with rhe RS 2000 report designer. RS 2005 comes with its own version of
VS and not purchase of VS is needed.
Also, note that RS 2005 can be installed using SQL Server 2000. However, as
I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
> Hi all, is it possible to create RS2000 format reports through Visual
> Studio
> .NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
> reports as my ERP system only supports SQL server 2000.|||Bruce, thank you for your reply.
My problem is, I will not purchase SQL 2005 until my ERP system is going to
support SQL 2005. But I do not want to purchase Studio .NET 2003 because I
need to use Studio .NET 2005 in near future.
Can I buy Studio .NET 2003 now and upgrade to .NET 2005 for free in near
future, say half year?
Any suggestion?
"Bruce L-C [MVP]" wrote:
> No. If you need to develop RS 2000 reports then you need some version of VS
> 2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will not
> work with rhe RS 2000 report designer. RS 2005 comes with its own version of
> VS and not purchase of VS is needed.
> Also, note that RS 2005 can be installed using SQL Server 2000. However, as
> I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
> news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
> > Hi all, is it possible to create RS2000 format reports through Visual
> > Studio
> > .NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
> > reports as my ERP system only supports SQL server 2000.
>
>|||You do not need to buy anything expensive for the VS 2003 requirement. Just
get VB.Net 2003 ($100).
I don't know about upgrades.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
news:8E045A08-069B-4395-AAD8-7FC57055B66A@.microsoft.com...
> Bruce, thank you for your reply.
> My problem is, I will not purchase SQL 2005 until my ERP system is going
> to
> support SQL 2005. But I do not want to purchase Studio .NET 2003 because I
> need to use Studio .NET 2005 in near future.
> Can I buy Studio .NET 2003 now and upgrade to .NET 2005 for free in near
> future, say half year?
> Any suggestion?
> "Bruce L-C [MVP]" wrote:
>> No. If you need to develop RS 2000 reports then you need some version of
>> VS
>> 2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will
>> not
>> work with rhe RS 2000 report designer. RS 2005 comes with its own version
>> of
>> VS and not purchase of VS is needed.
>> Also, note that RS 2005 can be installed using SQL Server 2000. However,
>> as
>> I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
>> news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
>> > Hi all, is it possible to create RS2000 format reports through Visual
>> > Studio
>> > .NET 2005? I am going to purchase Visual Studio .NET for developing
>> > RS2000
>> > reports as my ERP system only supports SQL server 2000.
>>

develop reports(public on report server 1.0) in vs2005 ?

as title,is anyway to translate two different format rdl files?
thx !

I'm not 100% sure I understand your question, but I think you are asking if you can create reports using Visual Studio 2005 that will run under SSRS 2000: Please correct me if I've misunderstood.

The answer to your question is "no". SSRS 2005 uses an updated RDL schema that 2000 doesn't understand. If you use VS 2005 to create a report, you use the updated schema, therefore 2000 won't work.

I've started a list of these questions / answers at the following location if you want to contribute and/or read:

http://blogs.msdn.com/bimusings/archive/2005/12/13/503110.aspx

|||

---

thank you.

But translate between two schema is possible ,right?

Hope some experient program such tool:).

thanks again and your blog.

|||

By the way,ask the other question.

I need develop rs2000's report.but after i install vs2005,i cant do it again in vs2003,something is broken and raise error.

can i develop rs2000's report with vs2005 installed environment? how?

thanks very much!

|||

A translation between the 2003/10 RDL namespace and the 2005/01 RDL namespace is done for instance automatically by loading a report in report designer and saving it. It is performed implicitly when uploading a report on a RS 2005 report server.

A translation from 2005/01 back to 2003/10 is doable (e.g. with a XSLT), but I'm not aware of any publicly available tool at this point. There are not many differences between the 2003/10 and the 2005/01 RDL schemas - you can look at the specs at: http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx

You can also download the XSDs at:
http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition/reportdefinition.xsd

http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition/ReportDefinition.xsd

-- Robert

Develop in VS2005 and deployment to SQL 2000

I find I can use VS2005 to develop reports of Reporting Service and the
datasource of reports is from SQL2000.
Can I develop these report to SQL2000 after I developed?If you get Reporting Services, you will get Report Designer as a template in
VS.NET. Check how to obtain RS at
http://www.microsoft.com/sql/report...y/default.mspx.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>I find I can use VS2005 to develop reports of Reporting Service and the
>datasource of reports is from SQL2000.
> Can I develop these report to SQL2000 after I developed?
>|||Thanks,
I have licence of SQL Server Standard, there is no problem about licence.
My problem is technique issue.
If the report is desgined in VS2005, then I deployment it to Sql2000, will
it be OK?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> glsD:%23AjCbjKzF
HA.1092@.TK2MSFTNGP10.phx.gbl...
> If you get Reporting Services, you will get Report Designer as a template
> in VS.NET. Check how to obtain RS at
> http://www.microsoft.com/sql/report...y/default.mspx.
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www.SolidQualityLearning.com
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>|||Hi
No. The file format has changed and AFAIK, you can not tell it at design
time what version you are building for.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:un%23yFqKzFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Thanks,
> I have licence of SQL Server Standard, there is no problem about licence.
> My problem is technique issue.
> If the report is desgined in VS2005, then I deployment it to Sql2000, will
> it be OK?
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si>
> glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>|||Hi,
I have read your question a couple of times and am unsure if you are
referring to the server-based Reporting Services or the new report
controls which are included in Visual Studio 2005.
If you want to use server-based Reporting Services then I believe
Mike's answer is correct, since the RDL format has changed between
RS2000 and RS2005.
If you want to use the new report controls, which don't depend on
server-based Reporting Services, I think you are likely to be ok. I
should mention that it's a scenario I haven't tested personally.
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 16:21:50 +0800, "ad" <flying@.wfes.tcc.edu.tw>
wrote:

>Thanks,
>I have licence of SQL Server Standard, there is no problem about licence.
>My problem is technique issue.
>If the report is desgined in VS2005, then I deployment it to Sql2000, will
>it be OK?
>
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> gl
sD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>

Develop in VS2005 and deployment to SQL 2000

I find I can use VS2005 to develop reports of Reporting Service and the
datasource of reports is from SQL2000.
Can I develop these report to SQL2000 after I developed?
If you get Reporting Services, you will get Report Designer as a template in
VS.NET. Check how to obtain RS at
http://www.microsoft.com/sql/reporti.../default.mspx.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>I find I can use VS2005 to develop reports of Reporting Service and the
>datasource of reports is from SQL2000.
> Can I develop these report to SQL2000 after I developed?
>
|||Thanks,
I have licence of SQL Server Standard, there is no problem about licence.
My problem is technique issue.
If the report is desgined in VS2005, then I deployment it to Sql2000, will
it be OK?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx .gbl...
> If you get Reporting Services, you will get Report Designer as a template
> in VS.NET. Check how to obtain RS at
> http://www.microsoft.com/sql/reporti.../default.mspx.
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www.SolidQualityLearning.com
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>
|||Hi
No. The file format has changed and AFAIK, you can not tell it at design
time what version you are building for.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:un%23yFqKzFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Thanks,
> I have licence of SQL Server Standard, there is no problem about licence.
> My problem is technique issue.
> If the report is desgined in VS2005, then I deployment it to Sql2000, will
> it be OK?
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si >
> glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx .gbl...
>
|||Hi,
I have read your question a couple of times and am unsure if you are
referring to the server-based Reporting Services or the new report
controls which are included in Visual Studio 2005.
If you want to use server-based Reporting Services then I believe
Mike's answer is correct, since the RDL format has changed between
RS2000 and RS2005.
If you want to use the new report controls, which don't depend on
server-based Reporting Services, I think you are likely to be ok. I
should mention that it's a scenario I haven't tested personally.
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 16:21:50 +0800, "ad" <flying@.wfes.tcc.edu.tw>
wrote:

>Thanks,
>I have licence of SQL Server Standard, there is no problem about licence.
>My problem is technique issue.
>If the report is desgined in VS2005, then I deployment it to Sql2000, will
>it be OK?
>
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx .gbl...
>

Develop in VS2005 and deployment to SQL 2000

I find I can use VS2005 to develop reports of Reporting Service and the
datasource of reports is from SQL2000.
Can I develop these report to SQL2000 after I developed?If you get Reporting Services, you will get Report Designer as a template in
VS.NET. Check how to obtain RS at
http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>I find I can use VS2005 to develop reports of Reporting Service and the
>datasource of reports is from SQL2000.
> Can I develop these report to SQL2000 after I developed?
>|||Thanks,
I have licence of SQL Server Standard, there is no problem about licence.
My problem is technique issue.
If the report is desgined in VS2005, then I deployment it to Sql2000, will
it be OK?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> ¼¶¼g©ó¶l¥ó·s»D:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
> If you get Reporting Services, you will get Report Designer as a template
> in VS.NET. Check how to obtain RS at
> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www.SolidQualityLearning.com
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I find I can use VS2005 to develop reports of Reporting Service and the
>>datasource of reports is from SQL2000.
>> Can I develop these report to SQL2000 after I developed?
>>
>|||Hi
No. The file format has changed and AFAIK, you can not tell it at design
time what version you are building for.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:un%23yFqKzFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Thanks,
> I have licence of SQL Server Standard, there is no problem about licence.
> My problem is technique issue.
> If the report is desgined in VS2005, then I deployment it to Sql2000, will
> it be OK?
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si>
> ¼¶¼g©ó¶l¥ó·s»D:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>> If you get Reporting Services, you will get Report Designer as a template
>> in VS.NET. Check how to obtain RS at
>> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor
>> www.SolidQualityLearning.com
>> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
>> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I find I can use VS2005 to develop reports of Reporting Service and the
>>datasource of reports is from SQL2000.
>> Can I develop these report to SQL2000 after I developed?
>>
>>
>|||Hi,
I have read your question a couple of times and am unsure if you are
referring to the server-based Reporting Services or the new report
controls which are included in Visual Studio 2005.
If you want to use server-based Reporting Services then I believe
Mike's answer is correct, since the RDL format has changed between
RS2000 and RS2005.
If you want to use the new report controls, which don't depend on
server-based Reporting Services, I think you are likely to be ok. I
should mention that it's a scenario I haven't tested personally.
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 16:21:50 +0800, "ad" <flying@.wfes.tcc.edu.tw>
wrote:
>Thanks,
>I have licence of SQL Server Standard, there is no problem about licence.
>My problem is technique issue.
>If the report is desgined in VS2005, then I deployment it to Sql2000, will
>it be OK?
>
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> ¼¶¼g©ó¶l¥ó·s»D:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>> If you get Reporting Services, you will get Report Designer as a template
>> in VS.NET. Check how to obtain RS at
>> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor
>> www.SolidQualityLearning.com
>> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
>> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I find I can use VS2005 to develop reports of Reporting Service and the
>>datasource of reports is from SQL2000.
>> Can I develop these report to SQL2000 after I developed?
>>
>>
>

Dev/Learning Environment

I haven't used RS yet as we have leaned on Crystal Reports but I want to
learn and design in RS. We already have a live intranet RS page or two
developed by former employees hence I want to fill that gap of knowledge.
My questions :
While playing and designing, is it better to take my SQL dev box and add RS,
IIS, .net etc or should I just to tap into the live server that's already set
up? Any risks to running dev on the live box?
The data would reside on a third sql server.
Thanks for any best practice advice you can spare.
--
Mike
If data falls in the woods and nobody is there to see it ...... ?One gotcha that I had was getting SharePoint to use RS. Apparenlty I needed
to install some additional DLL to allow SharePoint to display RS as web
parts and for about an hour I had production SP down as things didn't go
smoothly.
I know you didn't mention SP - but in case you are gong to look forward to
it as your web portal.
"Tigermikefl" <Tigermikefl@.discussions.microsoft.com> wrote in message
news:23619A8F-2482-4CAA-9241-9C854FCE7898@.microsoft.com...
>I haven't used RS yet as we have leaned on Crystal Reports but I want to
> learn and design in RS. We already have a live intranet RS page or two
> developed by former employees hence I want to fill that gap of knowledge.
> My questions :
> While playing and designing, is it better to take my SQL dev box and add
> RS,
> IIS, .net etc or should I just to tap into the live server that's already
> set
> up? Any risks to running dev on the live box?
> The data would reside on a third sql server.
> Thanks for any best practice advice you can spare.
> --
> Mike
> If data falls in the woods and nobody is there to see it ...... ?

Determining which email failed.

I have a data driven subscription which delivers multiple reports to
multiple subscribers.
For the most part, it works great.
But, sometimes there is a failure in the delivery.
Ie 10 reports were to be delivered to XXX@.xx.com.
It says that 8 were successful, and 2 failed.
Unfortunately, I cannot seem to determine which of the 10 failed.
This causes me no end of grief, as I cannot know which to resend.
I've tried looking at the log files to no avail.
Is there any way to determine which ones failed?As far as I understand the most straightforward method would be examination
the mail server logs.
Still quite a challenge.
"Zresse" <zresse@.yahoo.com> wrote in message
news:1128518677.725131.233550@.f14g2000cwb.googlegroups.com...
>I have a data driven subscription which delivers multiple reports to
> multiple subscribers.
> For the most part, it works great.
> But, sometimes there is a failure in the delivery.
> Ie 10 reports were to be delivered to XXX@.xx.com.
> It says that 8 were successful, and 2 failed.
> Unfortunately, I cannot seem to determine which of the 10 failed.
> This causes me no end of grief, as I cannot know which to resend.
> I've tried looking at the log files to no avail.
> Is there any way to determine which ones failed?
>|||Hey, Guess who?