REPORTING SERVICES 2005 AND VISUAL STUDIO 2003

Hi everyone
I would like to put the following question...
I have a machine with XP Pro SP2, MSSQL 2000, Reporting Services 2000
and V.S. 2003, could I Install Rep Serv 2005 and create reports on an
MSQL2000 Database?
Do I need to Install Visual Studio 2005 ?
Thanks a lot
MiltosRS 2005 comes with a version of VS 2005. You do not have to purchase it.
Just install the BI tools from the SQL Server 2005 disk. RS 2005 can use SQL
Server 2000 db for its object/metadata (as long as you have the SQL Server
2005 license) the biggest issue is installing side by side on the database
with RS 2000. The other issue is IIS. One part of IIS (RS 2000) needs to
stay at 1.1, the other needs to be at 2.0. So you upgrade IIS with 2.0
framework and then you have to get the initial sites back to 1.1.
I believe all of this is possible but it is non-trivial.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<milmen@.tellas.gr> wrote in message
news:1155895924.922028.277620@.m79g2000cwm.googlegroups.com...
> Hi everyone
> I would like to put the following question...
> I have a machine with XP Pro SP2, MSSQL 2000, Reporting Services 2000
> and V.S. 2003, could I Install Rep Serv 2005 and create reports on an
> MSQL2000 Database?
> Do I need to Install Visual Studio 2005 ?
> Thanks a lot
> Miltos
>|||I have the same predicament.
I have worked on a project created in VS 2003 Framework 1.1, SQL 2000,
RS2000
The client wanted to upgrade SQL to 2005 but now I have difficulties
running my application which runs on Framework 1.1 to call RS2005 now
using Framework 2.
So to solve it, I downgraded RS back to 2000.|||There was no reason to downgrade RS. There are two ways to be integrating:
URL Integration and Web Services. Both are still available to you from your
application. The web server has to be told which sites are still running
1.1, then the sites used by RS 2005 use 2.0.
Also, his case was that he wanted to have RS 2000 and RS 2005 side by side.
That does not seem to be the case for you. Your situation seemed to be one
of integration which should not be a problem at all.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"rGenius" <ruellacaste@.gmail.com> wrote in message
news:1156490695.127315.56360@.b28g2000cwb.googlegroups.com...
>I have the same predicament.
> I have worked on a project created in VS 2003 Framework 1.1, SQL 2000,
> RS2000
> The client wanted to upgrade SQL to 2005 but now I have difficulties
> running my application which runs on Framework 1.1 to call RS2005 now
> using Framework 2.
> So to solve it, I downgraded RS back to 2000.
>

Reporting services

Hi,
I could not find any information about the MSSQL Express/Workgroup
The question is: if this version contains the Reporting services?
Marcin S.All versions of SQL 2005 will come with Reporting Services
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
> Hi,
> I could not find any information about the MSSQL Express/Workgroup
> The question is: if this version contains the Reporting services?
>
> --
> Marcin S.|||Have a look at the SQL Server 2005 Reporting Services Feature Matrix
http://www.microsoft.com/sql/2005/p...rsfeatures.mspx
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
> Hi,
> I could not find any information about the MSSQL Express/Workgroup
> The question is: if this version contains the Reporting services?
>
> --
> Marcin S.|||Hi,
Ok, but wath about SQL 2000 server?
Marcin S.
"Wayne Snyder" wrote:

> All versions of SQL 2005 will come with Reporting Services
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
>
>

Reporting services

Hi,
I could not find any information about the MSSQL Express/Workgroup
The question is: if this version contains the Reporting services?
Marcin S.
All versions of SQL 2005 will come with Reporting Services
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
> Hi,
> I could not find any information about the MSSQL Express/Workgroup
> The question is: if this version contains the Reporting services?
>
> --
> Marcin S.
|||Have a look at the SQL Server 2005 Reporting Services Feature Matrix
http://www.microsoft.com/sql/2005/pr...sfeatures.mspx
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
> Hi,
> I could not find any information about the MSSQL Express/Workgroup
> The question is: if this version contains the Reporting services?
>
> --
> Marcin S.
|||Hi,
Ok, but wath about SQL 2000 server?
Marcin S.
"Wayne Snyder" wrote:

> All versions of SQL 2005 will come with Reporting Services
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
>
>

Reporting services

Hi,
I could not find any information about the MSSQL Express/Workgroup
The question is: if this version contains the Reporting services?
--
Marcin S.All versions of SQL 2005 will come with Reporting Services
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
> Hi,
> I could not find any information about the MSSQL Express/Workgroup
> The question is: if this version contains the Reporting services?
>
> --
> Marcin S.|||Have a look at the SQL Server 2005 Reporting Services Feature Matrix
http://www.microsoft.com/sql/2005/productinfo/rsfeatures.mspx
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
> Hi,
> I could not find any information about the MSSQL Express/Workgroup
> The question is: if this version contains the Reporting services?
>
> --
> Marcin S.|||Hi,
Ok, but wath about SQL 2000 server?
--
Marcin S.
"Wayne Snyder" wrote:
> All versions of SQL 2005 will come with Reporting Services
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
> > Hi,
> >
> > I could not find any information about the MSSQL Express/Workgroup
> >
> > The question is: if this version contains the Reporting services?
> >
> >
> > --
> > Marcin S.
>
>

Reporting Problem

my app uses MSSQL 2k + VB 6.0+Crystal Reports 4.6

ive a table of the form

table PIC
(
studentid smallint,
studentname varchar(50),
studentpic image
)

i want to generate an id card for the students using the info from this table, using Crystal reports

the problem is that the image is not displayed in the crystal report
all other fields are present

is this any problem with the image data type and crystal report?

i do welcome suggestions from ur end to tackle this problem
thanks in advanceIt's not a problem with the image data type. You need to "read" the contents of the field into a file and have an image placeholder on the CR designer to link it to the file at runtime.|||thanks for the information

but how can i generate the id cards of 100 students say, by this method

cud u pl tell how to read all images from DB and pass the filename to Crystal Reports, once i click 'Generate ID Cards' Button

regards

Reporting Log Problem

Every so often I find reporting services logs (C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\LogFiles) in excess of 33 mb. For example
there are 135 log files from today with the name similar to
ReportServerService__05_19_2005_09_11_25.log and are all between 33 and 34 mb
in size. I only use reporting services for MOM 2005 reporting. What are
these logs for and can they be deleted without causing problems?
Thank you,
KevinThis is a known issue (Bug #: 304241 -
http://support.microsoft.com/kb/885286/) and is fixed in Reporting Services
SP2
http://www.microsoft.com/downloads/details.aspx?FamilyID=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:7E421675-8157-49BC-9557-CE04152CD77C@.microsoft.com...
> Every so often I find reporting services logs (C:\Program Files\Microsoft
> SQL
> Server\MSSQL\Reporting Services\LogFiles) in excess of 33 mb. For example
> there are 135 log files from today with the name similar to
> ReportServerService__05_19_2005_09_11_25.log and are all between 33 and 34
> mb
> in size. I only use reporting services for MOM 2005 reporting. What are
> these logs for and can they be deleted without causing problems?
> Thank you,
> Kevin|||thank you! Can I delete these logs?
"Jasper Smith" wrote:
> This is a known issue (Bug #: 304241 -
> http://support.microsoft.com/kb/885286/) and is fixed in Reporting Services
> SP2
> http://www.microsoft.com/downloads/details.aspx?FamilyID=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
> news:7E421675-8157-49BC-9557-CE04152CD77C@.microsoft.com...
> > Every so often I find reporting services logs (C:\Program Files\Microsoft
> > SQL
> > Server\MSSQL\Reporting Services\LogFiles) in excess of 33 mb. For example
> > there are 135 log files from today with the name similar to
> > ReportServerService__05_19_2005_09_11_25.log and are all between 33 and 34
> > mb
> > in size. I only use reporting services for MOM 2005 reporting. What are
> > these logs for and can they be deleted without causing problems?
> >
> > Thank you,
> >
> > Kevin
>
>|||Yes, technically the logs can be deleted w/out affecting RS.
--
Adrian M.
MCP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:3FB18D84-1D41-483E-AA2D-FDB9A0519FC9@.microsoft.com...
> thank you! Can I delete these logs?
> "Jasper Smith" wrote:
>> This is a known issue (Bug #: 304241 -
>> http://support.microsoft.com/kb/885286/) and is fixed in Reporting
>> Services
>> SP2
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
>> news:7E421675-8157-49BC-9557-CE04152CD77C@.microsoft.com...
>> > Every so often I find reporting services logs (C:\Program
>> > Files\Microsoft
>> > SQL
>> > Server\MSSQL\Reporting Services\LogFiles) in excess of 33 mb. For
>> > example
>> > there are 135 log files from today with the name similar to
>> > ReportServerService__05_19_2005_09_11_25.log and are all between 33 and
>> > 34
>> > mb
>> > in size. I only use reporting services for MOM 2005 reporting. What
>> > are
>> > these logs for and can they be deleted without causing problems?
>> >
>> > Thank you,
>> >
>> > Kevin
>>