Wednesday, March 28, 2012

Report Designer

My company just installed SQL Reporting Services and they've given me
permissions to where I can view the home page of the Reporting Services site.
I'm using Visual Studio.net to develop in but I'm unclear on what I need to
install on my end to create the reports and deploy to the report server.
I've gone through RS demos and have seen the option to create a new report
but I don't appear to have that option so I must need a plug in of some sort.
Any help would be appreciated.In order to write reports you need to install Reporting Services on your
local PC. Once you do, you will see a new folder called Business
Intelligence. This is where you can create new reports.
Good luck.
Michael
"yrmeyer" wrote:
> My company just installed SQL Reporting Services and they've given me
> permissions to where I can view the home page of the Reporting Services site.
> I'm using Visual Studio.net to develop in but I'm unclear on what I need to
> install on my end to create the reports and deploy to the report server.
> I've gone through RS demos and have seen the option to create a new report
> but I don't appear to have that option so I must need a plug in of some sort.
> Any help would be appreciated.|||You can create your reports with out designer using the RDL reader/writer
http://www.rdlcomponents.com
Jerry
"MAGrimsley" wrote:
> In order to write reports you need to install Reporting Services on your
> local PC. Once you do, you will see a new folder called Business
> Intelligence. This is where you can create new reports.
> Good luck.
> Michael
> "yrmeyer" wrote:
> > My company just installed SQL Reporting Services and they've given me
> > permissions to where I can view the home page of the Reporting Services site.
> > I'm using Visual Studio.net to develop in but I'm unclear on what I need to
> > install on my end to create the reports and deploy to the report server.
> > I've gone through RS demos and have seen the option to create a new report
> > but I don't appear to have that option so I must need a plug in of some sort.
> > Any help would be appreciated.|||Thank you.
I've downloaded the Evaluation copy of RS until I can get the software sent
to me by my company. I'm unable to get past the screen where it asks for the
SQL Server Instance. Not sure what it's asking for.
"MAGrimsley" wrote:
> In order to write reports you need to install Reporting Services on your
> local PC. Once you do, you will see a new folder called Business
> Intelligence. This is where you can create new reports.
> Good luck.
> Michael
> "yrmeyer" wrote:
> > My company just installed SQL Reporting Services and they've given me
> > permissions to where I can view the home page of the Reporting Services site.
> > I'm using Visual Studio.net to develop in but I'm unclear on what I need to
> > install on my end to create the reports and deploy to the report server.
> > I've gone through RS demos and have seen the option to create a new report
> > but I don't appear to have that option so I must need a plug in of some sort.
> > Any help would be appreciated.|||You will see this is SQL Server is not installed on the local machine.
"yrmeyer" wrote:
> Thank you.
> I've downloaded the Evaluation copy of RS until I can get the software sent
> to me by my company. I'm unable to get past the screen where it asks for the
> SQL Server Instance. Not sure what it's asking for.
>
> "MAGrimsley" wrote:
> > In order to write reports you need to install Reporting Services on your
> > local PC. Once you do, you will see a new folder called Business
> > Intelligence. This is where you can create new reports.
> >
> > Good luck.
> >
> > Michael
> >
> > "yrmeyer" wrote:
> >
> > > My company just installed SQL Reporting Services and they've given me
> > > permissions to where I can view the home page of the Reporting Services site.
> > > I'm using Visual Studio.net to develop in but I'm unclear on what I need to
> > > install on my end to create the reports and deploy to the report server.
> > > I've gone through RS demos and have seen the option to create a new report
> > > but I don't appear to have that option so I must need a plug in of some sort.
> > > Any help would be appreciated.|||the url of homepage of reporting services site should be looking like
http://server1/reports
Once you've created report in Report Designer you need to open project
properties and specify location of reporting services server which should be
http://server1/reportserver
After specifying the rs server location you can try deploying your report to
report server (search for Deploy command in rep designer menu).
You should also be able to preview your report in report designer preview
tab without deploying.
If it fails to deploy it'll be one of two problems: either rs location is
invalid or you do not have permission to deploy reports on the report server
you specified.
In the second case you need to talk to admin and ask him to give you such
permission.
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"yrmeyer" <yrmeyer@.discussions.microsoft.com> wrote in message
news:79F0319C-587D-46AF-B631-1A7DB2E4AFA7@.microsoft.com...
> My company just installed SQL Reporting Services and they've given me
> permissions to where I can view the home page of the Reporting Services
site.
> I'm using Visual Studio.net to develop in but I'm unclear on what I need
to
> install on my end to create the reports and deploy to the report server.
> I've gone through RS demos and have seen the option to create a new report
> but I don't appear to have that option so I must need a plug in of some
sort.
> Any help would be appreciated.

No comments:

Post a Comment