info

Good Morning,
I have a question.
For Use sql reporting services I need on the same server Sql reporting
services and VB .Net?
Can I use Visual basic 6 or Crystal Report to create a report and only than
use Sql Reporting Services to sharing the report?With the current version of SQL RS, the report designer is integrated
with VS. I suppose you could, in theory, build your own RDL file to
create reports, but that would be incredibly tedious. I don't think
there's any way to build the reports with VB6, and, though there are
paid services to do it, there is no easy way to convert CR reports to
RS.
However, if the public beta is indicative, with SQL 2k5, MS has taken
the report designer out and made it a stand-alone app. My impression
is that in that scenario you won't need VS.
Hope that helps!
Brad.
On Thu, 02 Sep 2004 10:51:40 GMT, "Killer" <roninkaiser@.tiscali.it>
wrote:
>Good Morning,
>I have a question.
>For Use sql reporting services I need on the same server Sql reporting
>services and VB .Net?
>Can I use Visual basic 6 or Crystal Report to create a report and only than
>use Sql Reporting Services to sharing the report?
>|||About your second statement. I don't think that is the case (not needing
VS). The only announcement has been some stand-alone controls that can be
used for rendering (winform control and asp.net control). This has nothing
to do with the report designer. I have seen nothing that would indicate that
VS would not be needed to design the report. Think about designing Winforms,
ASP.Net. Writing VB.Net code. All these things can be done without VS
(nothing prevents using notepad) but I sure wouldn't want to try.
Bruce L-C
"Bradley Plett" <plettb@.hotmail.com> wrote in message
news:ivdej01sjfarrdg2u2rcpjcq3d7h0r0vb4@.4ax.com...
> With the current version of SQL RS, the report designer is integrated
> with VS. I suppose you could, in theory, build your own RDL file to
> create reports, but that would be incredibly tedious. I don't think
> there's any way to build the reports with VB6, and, though there are
> paid services to do it, there is no easy way to convert CR reports to
> RS.
> However, if the public beta is indicative, with SQL 2k5, MS has taken
> the report designer out and made it a stand-alone app. My impression
> is that in that scenario you won't need VS.
> Hope that helps!
> Brad.
> On Thu, 02 Sep 2004 10:51:40 GMT, "Killer" <roninkaiser@.tiscali.it>
> wrote:
> >Good Morning,
> >I have a question.
> >For Use sql reporting services I need on the same server Sql reporting
> >services and VB .Net?
> >
> >Can I use Visual basic 6 or Crystal Report to create a report and only
than
> >use Sql Reporting Services to sharing the report?
> >
>|||Having tried out the public beta of SQL 2k5, I can tell you that there
is a stand-alone report designer. Furthermore, when I tried to get
report designer integration into VS, I found (thanks to newsgroup
postings) that the VS integration was no longer even an option.
Certainly VS will be useful when creating applications that use the
new report viewer components, but I haven't been able to get my hands
on those yet to give them a try. :-)
Brad.
On Thu, 2 Sep 2004 10:22:21 -0500, "Bruce Loehle-Conger"
<bruce_lcNOSPAM@.hotmail.com> wrote:
>About your second statement. I don't think that is the case (not needing
>VS). The only announcement has been some stand-alone controls that can be
>used for rendering (winform control and asp.net control). This has nothing
>to do with the report designer. I have seen nothing that would indicate that
>VS would not be needed to design the report. Think about designing Winforms,
>ASP.Net. Writing VB.Net code. All these things can be done without VS
>(nothing prevents using notepad) but I sure wouldn't want to try.
>Bruce L-C
>"Bradley Plett" <plettb@.hotmail.com> wrote in message
>news:ivdej01sjfarrdg2u2rcpjcq3d7h0r0vb4@.4ax.com...
>> With the current version of SQL RS, the report designer is integrated
>> with VS. I suppose you could, in theory, build your own RDL file to
>> create reports, but that would be incredibly tedious. I don't think
>> there's any way to build the reports with VB6, and, though there are
>> paid services to do it, there is no easy way to convert CR reports to
>> RS.
>> However, if the public beta is indicative, with SQL 2k5, MS has taken
>> the report designer out and made it a stand-alone app. My impression
>> is that in that scenario you won't need VS.
>> Hope that helps!
>> Brad.
>> On Thu, 02 Sep 2004 10:51:40 GMT, "Killer" <roninkaiser@.tiscali.it>
>> wrote:
>> >Good Morning,
>> >I have a question.
>> >For Use sql reporting services I need on the same server Sql reporting
>> >services and VB .Net?
>> >
>> >Can I use Visual basic 6 or Crystal Report to create a report and only
>than
>> >use Sql Reporting Services to sharing the report?
>> >
>|||I don't have this installed but based on your response here I went to read
the newsgroup for the beta plus read up on SQL 2005. Several points. SQL
Server 2005 says it ships with VS 2005 (since you can now create stored
procedurs using dotnet that makes sense). From someone elses posting on the
beta newsgroup it seems there is something called Business Intelligence
Development Studio. Given the two statements it seems to me that VS 2005 was
installed and then selecting the menu opens it up with that type of project.
Given that the user hasn't purchased the full package then it will only have
a subset of the functionality. If so then it means that for people that
don't have VS 2005 they won't have to spend the $100 getting. But under the
covers it is still VS. I do know that the controls will ship with VS 2005.
I very well could be wrong but I know how MS reuses functionality (like the
query designer) and I feel it is much more likely to be that the VS that
ships with SQL 2005 allows only creating reports, stored procedures and
other database stuff than for it to be something brand new. I bet that in VS
2005 that you will be able to do all of the same things (create reports,
stored procedures etc).
When you said VS integration was that with Widbey? I wouldn't expect it to
work with anything other than Widbey and even there, there could be a
version mismatch due to the beta process. As I said, I find it highly
doubtful that by release it won't be integrateable (is that a word?) with VS
2005.
Thanks for the correction. I haven't been exploring SQL 2005 much yet. The
newsgroup says the new functionality for RS that I do care about (printing
for instance) will be with beta 3.
Bruce L-C
"Bradley Plett" <plettb@.hotmail.com> wrote in message
news:e7mej0ph9f5rho4a1b1ii8ej1vppbqqh9a@.4ax.com...
> Having tried out the public beta of SQL 2k5, I can tell you that there
> is a stand-alone report designer. Furthermore, when I tried to get
> report designer integration into VS, I found (thanks to newsgroup
> postings) that the VS integration was no longer even an option.
> Certainly VS will be useful when creating applications that use the
> new report viewer components, but I haven't been able to get my hands
> on those yet to give them a try. :-)
> Brad.
> On Thu, 2 Sep 2004 10:22:21 -0500, "Bruce Loehle-Conger"
> <bruce_lcNOSPAM@.hotmail.com> wrote:
> >About your second statement. I don't think that is the case (not needing
> >VS). The only announcement has been some stand-alone controls that can be
> >used for rendering (winform control and asp.net control). This has
nothing
> >to do with the report designer. I have seen nothing that would indicate
that
> >VS would not be needed to design the report. Think about designing
Winforms,
> >ASP.Net. Writing VB.Net code. All these things can be done without VS
> >(nothing prevents using notepad) but I sure wouldn't want to try.
> >
> >Bruce L-C
> >
> >"Bradley Plett" <plettb@.hotmail.com> wrote in message
> >news:ivdej01sjfarrdg2u2rcpjcq3d7h0r0vb4@.4ax.com...
> >> With the current version of SQL RS, the report designer is integrated
> >> with VS. I suppose you could, in theory, build your own RDL file to
> >> create reports, but that would be incredibly tedious. I don't think
> >> there's any way to build the reports with VB6, and, though there are
> >> paid services to do it, there is no easy way to convert CR reports to
> >> RS.
> >>
> >> However, if the public beta is indicative, with SQL 2k5, MS has taken
> >> the report designer out and made it a stand-alone app. My impression
> >> is that in that scenario you won't need VS.
> >>
> >> Hope that helps!
> >> Brad.
> >>
> >> On Thu, 02 Sep 2004 10:51:40 GMT, "Killer" <roninkaiser@.tiscali.it>
> >> wrote:
> >>
> >> >Good Morning,
> >> >I have a question.
> >> >For Use sql reporting services I need on the same server Sql reporting
> >> >services and VB .Net?
> >> >
> >> >Can I use Visual basic 6 or Crystal Report to create a report and only
> >than
> >> >use Sql Reporting Services to sharing the report?
> >> >
> >>
> >
>|||Yes, "Business Intelligence Development Studio" is the new report
designer. It looks a lot like VS, so I'm sure there's a lot of code
reuse, but it's not VS.
Yes, I was using Whidbey, and there is no integration with RS. Here
are a couple of direct quotes from "someone in the know" (i.e. not me!
:-)
----
RS 2005 does no longer require VS for authoring reports and it will
not install into VS2005. When you install SQL 2005 B2, there is an
option to install the Business Intelligence Development Studio with
Report Designer. Then, under the SQL 2005 menu you should find a
shortcut to start the BI Development Studio.
----
There will be RS WinForm and WebForm client side controls for VS 2005
Beta 2. Sorry, they are not yet available in VS 2005 Beta 1. You can
read about it in the bottom half of this announcement:
http://www.microsoft.com/presspass/press/2004/mar04/03-26MicrosoftOLAPReportPR.asp
----
I agree about Beta 3 - I'm really looking forward to it too, since I'm
hoping a number of the features I desperately need will be there.
Brad.
On Thu, 2 Sep 2004 13:05:58 -0500, "Bruce Loehle-Conger"
<bruce_lcNOSPAM@.hotmail.com> wrote:
>I don't have this installed but based on your response here I went to read
>the newsgroup for the beta plus read up on SQL 2005. Several points. SQL
>Server 2005 says it ships with VS 2005 (since you can now create stored
>procedurs using dotnet that makes sense). From someone elses posting on the
>beta newsgroup it seems there is something called Business Intelligence
>Development Studio. Given the two statements it seems to me that VS 2005 was
>installed and then selecting the menu opens it up with that type of project.
>Given that the user hasn't purchased the full package then it will only have
>a subset of the functionality. If so then it means that for people that
>don't have VS 2005 they won't have to spend the $100 getting. But under the
>covers it is still VS. I do know that the controls will ship with VS 2005.
>I very well could be wrong but I know how MS reuses functionality (like the
>query designer) and I feel it is much more likely to be that the VS that
>ships with SQL 2005 allows only creating reports, stored procedures and
>other database stuff than for it to be something brand new. I bet that in VS
>2005 that you will be able to do all of the same things (create reports,
>stored procedures etc).
>When you said VS integration was that with Widbey? I wouldn't expect it to
>work with anything other than Widbey and even there, there could be a
>version mismatch due to the beta process. As I said, I find it highly
>doubtful that by release it won't be integrateable (is that a word?) with VS
>2005.
>Thanks for the correction. I haven't been exploring SQL 2005 much yet. The
>newsgroup says the new functionality for RS that I do care about (printing
>for instance) will be with beta 3.
>Bruce L-C
>
>"Bradley Plett" <plettb@.hotmail.com> wrote in message
>news:e7mej0ph9f5rho4a1b1ii8ej1vppbqqh9a@.4ax.com...
>> Having tried out the public beta of SQL 2k5, I can tell you that there
>> is a stand-alone report designer. Furthermore, when I tried to get
>> report designer integration into VS, I found (thanks to newsgroup
>> postings) that the VS integration was no longer even an option.
>> Certainly VS will be useful when creating applications that use the
>> new report viewer components, but I haven't been able to get my hands
>> on those yet to give them a try. :-)
>> Brad.
>> On Thu, 2 Sep 2004 10:22:21 -0500, "Bruce Loehle-Conger"
>> <bruce_lcNOSPAM@.hotmail.com> wrote:
>> >About your second statement. I don't think that is the case (not needing
>> >VS). The only announcement has been some stand-alone controls that can be
>> >used for rendering (winform control and asp.net control). This has
>nothing
>> >to do with the report designer. I have seen nothing that would indicate
>that
>> >VS would not be needed to design the report. Think about designing
>Winforms,
>> >ASP.Net. Writing VB.Net code. All these things can be done without VS
>> >(nothing prevents using notepad) but I sure wouldn't want to try.
>> >
>> >Bruce L-C
>> >
>> >"Bradley Plett" <plettb@.hotmail.com> wrote in message
>> >news:ivdej01sjfarrdg2u2rcpjcq3d7h0r0vb4@.4ax.com...
>> >> With the current version of SQL RS, the report designer is integrated
>> >> with VS. I suppose you could, in theory, build your own RDL file to
>> >> create reports, but that would be incredibly tedious. I don't think
>> >> there's any way to build the reports with VB6, and, though there are
>> >> paid services to do it, there is no easy way to convert CR reports to
>> >> RS.
>> >>
>> >> However, if the public beta is indicative, with SQL 2k5, MS has taken
>> >> the report designer out and made it a stand-alone app. My impression
>> >> is that in that scenario you won't need VS.
>> >>
>> >> Hope that helps!
>> >> Brad.
>> >>
>> >> On Thu, 02 Sep 2004 10:51:40 GMT, "Killer" <roninkaiser@.tiscali.it>
>> >> wrote:
>> >>
>> >> >Good Morning,
>> >> >I have a question.
>> >> >For Use sql reporting services I need on the same server Sql reporting
>> >> >services and VB .Net?
>> >> >
>> >> >Can I use Visual basic 6 or Crystal Report to create a report and only
>> >than
>> >> >use Sql Reporting Services to sharing the report?
>> >> >
>> >>
>> >
>|||Thank you very much. Very interesting. Looks like I assumed too much.
Well, it better install side by side then with VS2005.
Bruce L-C
"Bradley Plett" <plettb@.hotmail.com> wrote in message
news:6moej0lfsiak5ne60d404afmd5rsj9qr4r@.4ax.com...
> Yes, "Business Intelligence Development Studio" is the new report
> designer. It looks a lot like VS, so I'm sure there's a lot of code
> reuse, but it's not VS.
> Yes, I was using Whidbey, and there is no integration with RS. Here
> are a couple of direct quotes from "someone in the know" (i.e. not me!
> :-)
> ----
> RS 2005 does no longer require VS for authoring reports and it will
> not install into VS2005. When you install SQL 2005 B2, there is an
> option to install the Business Intelligence Development Studio with
> Report Designer. Then, under the SQL 2005 menu you should find a
> shortcut to start the BI Development Studio.
> ----
> There will be RS WinForm and WebForm client side controls for VS 2005
> Beta 2. Sorry, they are not yet available in VS 2005 Beta 1. You can
> read about it in the bottom half of this announcement:
>
http://www.microsoft.com/presspass/press/2004/mar04/03-26MicrosoftOLAPReportPR.asp
> ----
> I agree about Beta 3 - I'm really looking forward to it too, since I'm
> hoping a number of the features I desperately need will be there.
> Brad.
>
> On Thu, 2 Sep 2004 13:05:58 -0500, "Bruce Loehle-Conger"
> <bruce_lcNOSPAM@.hotmail.com> wrote:
> >I don't have this installed but based on your response here I went to
read
> >the newsgroup for the beta plus read up on SQL 2005. Several points. SQL
> >Server 2005 says it ships with VS 2005 (since you can now create stored
> >procedurs using dotnet that makes sense). From someone elses posting on
the
> >beta newsgroup it seems there is something called Business Intelligence
> >Development Studio. Given the two statements it seems to me that VS 2005
was
> >installed and then selecting the menu opens it up with that type of
project.
> >Given that the user hasn't purchased the full package then it will only
have
> >a subset of the functionality. If so then it means that for people that
> >don't have VS 2005 they won't have to spend the $100 getting. But under
the
> >covers it is still VS. I do know that the controls will ship with VS
2005.
> >
> >I very well could be wrong but I know how MS reuses functionality (like
the
> >query designer) and I feel it is much more likely to be that the VS that
> >ships with SQL 2005 allows only creating reports, stored procedures and
> >other database stuff than for it to be something brand new. I bet that in
VS
> >2005 that you will be able to do all of the same things (create reports,
> >stored procedures etc).
> >
> >When you said VS integration was that with Widbey? I wouldn't expect it
to
> >work with anything other than Widbey and even there, there could be a
> >version mismatch due to the beta process. As I said, I find it highly
> >doubtful that by release it won't be integrateable (is that a word?) with
VS
> >2005.
> >
> >Thanks for the correction. I haven't been exploring SQL 2005 much yet.
The
> >newsgroup says the new functionality for RS that I do care about
(printing
> >for instance) will be with beta 3.
> >
> >Bruce L-C
> >
> >
> >"Bradley Plett" <plettb@.hotmail.com> wrote in message
> >news:e7mej0ph9f5rho4a1b1ii8ej1vppbqqh9a@.4ax.com...
> >> Having tried out the public beta of SQL 2k5, I can tell you that there
> >> is a stand-alone report designer. Furthermore, when I tried to get
> >> report designer integration into VS, I found (thanks to newsgroup
> >> postings) that the VS integration was no longer even an option.
> >>
> >> Certainly VS will be useful when creating applications that use the
> >> new report viewer components, but I haven't been able to get my hands
> >> on those yet to give them a try. :-)
> >>
> >> Brad.
> >>
> >> On Thu, 2 Sep 2004 10:22:21 -0500, "Bruce Loehle-Conger"
> >> <bruce_lcNOSPAM@.hotmail.com> wrote:
> >>
> >> >About your second statement. I don't think that is the case (not
needing
> >> >VS). The only announcement has been some stand-alone controls that can
be
> >> >used for rendering (winform control and asp.net control). This has
> >nothing
> >> >to do with the report designer. I have seen nothing that would
indicate
> >that
> >> >VS would not be needed to design the report. Think about designing
> >Winforms,
> >> >ASP.Net. Writing VB.Net code. All these things can be done without VS
> >> >(nothing prevents using notepad) but I sure wouldn't want to try.
> >> >
> >> >Bruce L-C
> >> >
> >> >"Bradley Plett" <plettb@.hotmail.com> wrote in message
> >> >news:ivdej01sjfarrdg2u2rcpjcq3d7h0r0vb4@.4ax.com...
> >> >> With the current version of SQL RS, the report designer is
integrated
> >> >> with VS. I suppose you could, in theory, build your own RDL file to
> >> >> create reports, but that would be incredibly tedious. I don't think
> >> >> there's any way to build the reports with VB6, and, though there are
> >> >> paid services to do it, there is no easy way to convert CR reports
to
> >> >> RS.
> >> >>
> >> >> However, if the public beta is indicative, with SQL 2k5, MS has
taken
> >> >> the report designer out and made it a stand-alone app. My
impression
> >> >> is that in that scenario you won't need VS.
> >> >>
> >> >> Hope that helps!
> >> >> Brad.
> >> >>
> >> >> On Thu, 02 Sep 2004 10:51:40 GMT, "Killer" <roninkaiser@.tiscali.it>
> >> >> wrote:
> >> >>
> >> >> >Good Morning,
> >> >> >I have a question.
> >> >> >For Use sql reporting services I need on the same server Sql
reporting
> >> >> >services and VB .Net?
> >> >> >
> >> >> >Can I use Visual basic 6 or Crystal Report to create a report and
only
> >> >than
> >> >> >use Sql Reporting Services to sharing the report?
> >> >> >
> >> >>
> >> >
> >>
> >
>