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.

Report Builder Permissions

Hi there,

I created a System Role: Report Builder User (checked "Execute Report Definitions")

Created a folder Home/FolderName/ReportModels

Created a Report Model, deployed it to the above folder.

The are a few users we would like them to run the report model, they belong to a windows group.

I assigned The "Report Builder User" to this Group.

The issue I have that when they run the Report Builder they get a login window (which then doesn't let them to continue).

I managed to overcome this by assiging to this group a "Browser" role at the Home level.

If I remove this assignment and set it in one level underneath the Home folder they can't run the Report Builder.

We don't want them to be able to view the folders at this level, Is there any other option besides setting the Browser role at the Home folder?

Thank you,

Itzhak

I believe users need to have at least Browser permission on all the parent folders of a given folder in addition to the folder itself. So yes, they will need to have permission to the Home folder. However, this will not (by itself) allow them to see subfolders of the Home folder to which they do not have permission. So you should still be able to hide the folders you don't want them to see.

Hope this helps!

|||

That's what I thought.

Yes, it did help.

Thank you,

Itzhak

sql