Creating reports in RS2005

Hi
I was wondering how one can start designing reports in Reporting Services
2005.
Kind regards
RickyOn Feb 20, 6:10 am, "ricky" <r...@.ricky.com> wrote:
> Hi
> I was wondering how one can start designing reports in Reporting Services
> 2005.
> Kind regards
> Ricky
That's a pretty loaded question; but, I'll try to give you a start.
You want to open Visual Studio and create a new Report Server Project.
right click the Reports folder (in the Solution window) and select
'Add New Report.' Then create a datasource connecting to your SQL
Server database and create your connection string via the Edit button.
Then follow through the wizard to build your report. I would suggest
taking a look at Books Online; since it has tutorials and HowTos. Hope
this was somewhat helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Hello
Thank you for you reply, I don't think I was clear in my posting. I was
actually referring to which tools are used? Do I need to obtain a copy of
VS or is there some sort of report designer client in SS2005?
Kind regards
Ricky
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1171975643.358464.131580@.v33g2000cwv.googlegroups.com...
> On Feb 20, 6:10 am, "ricky" <r...@.ricky.com> wrote:
> > Hi
> >
> > I was wondering how one can start designing reports in Reporting
Services
> > 2005.
> >
> > Kind regards
> >
> > Ricky
>
> That's a pretty loaded question; but, I'll try to give you a start.
> You want to open Visual Studio and create a new Report Server Project.
> right click the Reports folder (in the Solution window) and select
> 'Add New Report.' Then create a datasource connecting to your SQL
> Server database and create your connection string via the Edit button.
> Then follow through the wizard to build your report. I would suggest
> taking a look at Books Online; since it has tutorials and HowTos. Hope
> this was somewhat helpful.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||If your RS2005 is part of full SQL Server2005 (not SQL Server Express SP1
Advanced), then the QL Server2005 come with a report designer, called "SQL
Server Business Intelligence Development Studio", which is a flavor of
VS2005. If you also have a version of VS2005 installed, the report designer
would be merged into the VS2005.
"ricky" <ricky@.ricky.com> wrote in message
news:O80QGLPVHHA.3332@.TK2MSFTNGP04.phx.gbl...
> Hello
> Thank you for you reply, I don't think I was clear in my posting. I was
> actually referring to which tools are used? Do I need to obtain a copy of
> VS or is there some sort of report designer client in SS2005?
> Kind regards
> Ricky
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1171975643.358464.131580@.v33g2000cwv.googlegroups.com...
>> On Feb 20, 6:10 am, "ricky" <r...@.ricky.com> wrote:
>> > Hi
>> >
>> > I was wondering how one can start designing reports in Reporting
> Services
>> > 2005.
>> >
>> > Kind regards
>> >
>> > Ricky
>>
>> That's a pretty loaded question; but, I'll try to give you a start.
>> You want to open Visual Studio and create a new Report Server Project.
>> right click the Reports folder (in the Solution window) and select
>> 'Add New Report.' Then create a datasource connecting to your SQL
>> Server database and create your connection string via the Edit button.
>> Then follow through the wizard to build your report. I would suggest
>> taking a look at Books Online; since it has tutorials and HowTos. Hope
>> this was somewhat helpful.
>> Regards,
>> Enrique Martinez
>> Sr. SQL Server Developer
>|||Hello Norman
Thank you for the information. It looks like we haven't got VS2005 so I
better opt for Full SS2005.
Kind regards
Ricky
"Norman Yuan" <NotReal@.NotReal.not> wrote in message
news:%23oB$lvPVHHA.4076@.TK2MSFTNGP05.phx.gbl...
> If your RS2005 is part of full SQL Server2005 (not SQL Server Express SP1
> Advanced), then the QL Server2005 come with a report designer, called "SQL
> Server Business Intelligence Development Studio", which is a flavor of
> VS2005. If you also have a version of VS2005 installed, the report
designer
> would be merged into the VS2005.
> "ricky" <ricky@.ricky.com> wrote in message
> news:O80QGLPVHHA.3332@.TK2MSFTNGP04.phx.gbl...
> > Hello
> >
> > Thank you for you reply, I don't think I was clear in my posting. I was
> > actually referring to which tools are used? Do I need to obtain a copy
of
> > VS or is there some sort of report designer client in SS2005?
> >
> > Kind regards
> >
> > Ricky
> >
> > "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> > news:1171975643.358464.131580@.v33g2000cwv.googlegroups.com...
> >> On Feb 20, 6:10 am, "ricky" <r...@.ricky.com> wrote:
> >> > Hi
> >> >
> >> > I was wondering how one can start designing reports in Reporting
> > Services
> >> > 2005.
> >> >
> >> > Kind regards
> >> >
> >> > Ricky
> >>
> >>
> >>
> >> That's a pretty loaded question; but, I'll try to give you a start.
> >> You want to open Visual Studio and create a new Report Server Project.
> >> right click the Reports folder (in the Solution window) and select
> >> 'Add New Report.' Then create a datasource connecting to your SQL
> >> Server database and create your connection string via the Edit button.
> >> Then follow through the wizard to build your report. I would suggest
> >> taking a look at Books Online; since it has tutorials and HowTos. Hope
> >> this was somewhat helpful.
> >>
> >> Regards,
> >>
> >> Enrique Martinez
> >> Sr. SQL Server Developer
> >>
> >
> >
>|||You do not need to get a seperate VS2005 (unless you also do other .NET
development), SQL Server2005 comes with a VS2005 version for report design
only. Simply place the SQL Server2005 disk into the computer where you want
to design the report (it does not have to be the computer with QSL Server
installed), and install SQL Server client tool only.
"ricky" <ricky@.ricky.com> wrote in message
news:eMi3j5PVHHA.600@.TK2MSFTNGP05.phx.gbl...
> Hello Norman
> Thank you for the information. It looks like we haven't got VS2005 so I
> better opt for Full SS2005.
> Kind regards
> Ricky
> "Norman Yuan" <NotReal@.NotReal.not> wrote in message
> news:%23oB$lvPVHHA.4076@.TK2MSFTNGP05.phx.gbl...
>> If your RS2005 is part of full SQL Server2005 (not SQL Server Express SP1
>> Advanced), then the QL Server2005 come with a report designer, called
>> "SQL
>> Server Business Intelligence Development Studio", which is a flavor of
>> VS2005. If you also have a version of VS2005 installed, the report
> designer
>> would be merged into the VS2005.
>> "ricky" <ricky@.ricky.com> wrote in message
>> news:O80QGLPVHHA.3332@.TK2MSFTNGP04.phx.gbl...
>> > Hello
>> >
>> > Thank you for you reply, I don't think I was clear in my posting. I
>> > was
>> > actually referring to which tools are used? Do I need to obtain a copy
> of
>> > VS or is there some sort of report designer client in SS2005?
>> >
>> > Kind regards
>> >
>> > Ricky
>> >
>> > "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
>> > news:1171975643.358464.131580@.v33g2000cwv.googlegroups.com...
>> >> On Feb 20, 6:10 am, "ricky" <r...@.ricky.com> wrote:
>> >> > Hi
>> >> >
>> >> > I was wondering how one can start designing reports in Reporting
>> > Services
>> >> > 2005.
>> >> >
>> >> > Kind regards
>> >> >
>> >> > Ricky
>> >>
>> >>
>> >>
>> >> That's a pretty loaded question; but, I'll try to give you a start.
>> >> You want to open Visual Studio and create a new Report Server Project.
>> >> right click the Reports folder (in the Solution window) and select
>> >> 'Add New Report.' Then create a datasource connecting to your SQL
>> >> Server database and create your connection string via the Edit button.
>> >> Then follow through the wizard to build your report. I would suggest
>> >> taking a look at Books Online; since it has tutorials and HowTos. Hope
>> >> this was somewhat helpful.
>> >>
>> >> Regards,
>> >>
>> >> Enrique Martinez
>> >> Sr. SQL Server Developer
>> >>
>> >
>> >
>>
>|||Hi Ricky,
On the "untechnical" side of things, you should check out Geoff Snowmans
webcasts on Reporting Services. They serve as a _great_ get-going tutorial.
Find them on his blog at:
http://blogs.msdn.com/gsnowman/archive/2005/10/19/482905.aspx
Jeppe D. Jespersen
Denmark
"ricky" <ricky@.ricky.com> wrote in message
news:eMi3j5PVHHA.600@.TK2MSFTNGP05.phx.gbl...
> Hello Norman
> Thank you for the information. It looks like we haven't got VS2005 so I
> better opt for Full SS2005.
> Kind regards
> Ricky
> "Norman Yuan" <NotReal@.NotReal.not> wrote in message
> news:%23oB$lvPVHHA.4076@.TK2MSFTNGP05.phx.gbl...
>> If your RS2005 is part of full SQL Server2005 (not SQL Server Express SP1
>> Advanced), then the QL Server2005 come with a report designer, called
>> "SQL
>> Server Business Intelligence Development Studio", which is a flavor of
>> VS2005. If you also have a version of VS2005 installed, the report
> designer
>> would be merged into the VS2005.
>> "ricky" <ricky@.ricky.com> wrote in message
>> news:O80QGLPVHHA.3332@.TK2MSFTNGP04.phx.gbl...
>> > Hello
>> >
>> > Thank you for you reply, I don't think I was clear in my posting. I
>> > was
>> > actually referring to which tools are used? Do I need to obtain a copy
> of
>> > VS or is there some sort of report designer client in SS2005?
>> >
>> > Kind regards
>> >
>> > Ricky
>> >
>> > "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
>> > news:1171975643.358464.131580@.v33g2000cwv.googlegroups.com...
>> >> On Feb 20, 6:10 am, "ricky" <r...@.ricky.com> wrote:
>> >> > Hi
>> >> >
>> >> > I was wondering how one can start designing reports in Reporting
>> > Services
>> >> > 2005.
>> >> >
>> >> > Kind regards
>> >> >
>> >> > Ricky
>> >>
>> >>
>> >>
>> >> That's a pretty loaded question; but, I'll try to give you a start.
>> >> You want to open Visual Studio and create a new Report Server Project.
>> >> right click the Reports folder (in the Solution window) and select
>> >> 'Add New Report.' Then create a datasource connecting to your SQL
>> >> Server database and create your connection string via the Edit button.
>> >> Then follow through the wizard to build your report. I would suggest
>> >> taking a look at Books Online; since it has tutorials and HowTos. Hope
>> >> this was somewhat helpful.
>> >>
>> >> Regards,
>> >>
>> >> Enrique Martinez
>> >> Sr. SQL Server Developer
>> >>
>> >
>> >
>>
>