Showing posts with label folder. Show all posts
Showing posts with label folder. Show all posts

Thursday, March 29, 2012

credentials

I am using RS2000. I have created some reports and publish to the server. A
folder has been created at /home/test1 in report manger and granted the
access right to user A.
I created a .net application with impersonation = false, how can I call the
reports under test1 inside this application by using the RS2000 control? what
I mean is how to pass the A's credential to reporting services so that I can
access the report.
Can anyone give me some suggestion? Thanks a lot!Hi, Ry
When you say "using the RS2000 control" do you mean the sample report
viewer control for ASP.NET?
If so, then the control should be using the URL access method to create
HTTP GET requests (it creates URL querystrings) that fetch the report
and display them in an IFRAME.
So when the control points the IFRAME to the ReportServer and folder
where the report is located, it's the same as if the current user
opened a browser and tried to view the ReportServer directly
(http://servername/ReportServer?/home/test1/testReport¶m1=SomeValue).
The Report Server uses windows authentication, so your application is
not actually performing the authentication for the reports and folders,
it's all done by the Report Server.
If you were using the RS web service to make proxy calls to render the
report, then you would need to provide user context information to the
Web Service, so it would authenticate. You would use
DefaultCredentials to pass your current application's user to the
Report Server via the web service Credentials property.
Hope that points you in the right direction.
Regards,
Thiago Silva
MCAD.NET
Ry wrote:
> I am using RS2000. I have created some reports and publish to the server. A
> folder has been created at /home/test1 in report manger and granted the
> access right to user A.
> I created a .net application with impersonation = false, how can I call the
> reports under test1 inside this application by using the RS2000 control? what
> I mean is how to pass the A's credential to reporting services so that I can
> access the report.
> Can anyone give me some suggestion? Thanks a lot!

Monday, March 19, 2012

Creating SSRS folders?

New ssrs istall.
When I attempt to open report manager, i just get
SQL Server Reporting Services
Home
with no option for creating a folder etc, like i have on development
When I attempt to deploy to ther server I get :
Deploying to http://amsqlclusterxx/reportserver/
Error rsItemAlreadyExists : The item '/Retailer' already exists.
How do I create an ssrs reports folder?
Also, and this is strange, but in vs.net I had to create a new shared
datasource after removing the old one on the report with the same
name. The report renders fine when I do an f5 pointing to a new
datasource, but I no longer have the RUN "!" icon available while in
the data tag to run my query. Why is this?
Thanks for any help or information.Hello,
I suppose that user which you use to connect to Report Manager has
insufficient permissions.
Check if this situation takes place also if you use user account which is a
member of the server's Administrators group (BUILTIN\Administrators).
Or maybe you have in IIS configured anonymouse access to Report Manager
Site.
Does RS ask for login credentials when you open Report Manager?
Best Regards,
Radoslaw Lebkowski
Uzytkownik "jobs" <jobs@.webdos.com> napisal w wiadomosci
news:1193850825.364868.47100@.19g2000hsx.googlegroups.com...
> New ssrs istall.
> When I attempt to open report manager, i just get
> SQL Server Reporting Services
> Home
> with no option for creating a folder etc, like i have on development
> When I attempt to deploy to ther server I get :
> Deploying to http://amsqlclusterxx/reportserver/
> Error rsItemAlreadyExists : The item '/Retailer' already exists.
> How do I create an ssrs reports folder?
> Also, and this is strange, but in vs.net I had to create a new shared
> datasource after removing the old one on the report with the same
> name. The report renders fine when I do an f5 pointing to a new
> datasource, but I no longer have the RUN "!" icon available while in
> the data tag to run my query. Why is this?
> Thanks for any help or information.
>

Thursday, March 8, 2012

Creating report folder hierarchy in VS.NET

Is it possible to create (or duplicate) the report server Report Manager
folder hierarchy in the VS.NET development IDE? There does not appear to be
an option to add a Folder to the Solution Explorer tree, and if I drag a
folder from the file system into the tree I receive an Access Denied message
when I try to open it.
I would like to be able to create a deployment hierarchy, because now all
reports deploy to the project root on the Report Server, and I have to move
them to the correct folder.
Thanks,
TimFolders are not supported in Report Designer.
It is in our wish list for future version.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tim Dreyling" <TimDreyling@.discussions.microsoft.com> wrote in message
news:3F148B87-78EB-4E61-8D04-BA286EAB13A3@.microsoft.com...
> Is it possible to create (or duplicate) the report server Report Manager
> folder hierarchy in the VS.NET development IDE? There does not appear to
> be
> an option to add a Folder to the Solution Explorer tree, and if I drag a
> folder from the file system into the tree I receive an Access Denied
> message
> when I try to open it.
> I would like to be able to create a deployment hierarchy, because now all
> reports deploy to the project root on the Report Server, and I have to
> move
> them to the correct folder.
> Thanks,
> Tim|||To build a deployment hierarchie you could add several projects to your
solution and enter a different deployment folder for each of the projects.
Hth,
Pieter
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:%23Yt2JPlrEHA.376@.TK2MSFTNGP14.phx.gbl...
> Folders are not supported in Report Designer.
> It is in our wish list for future version.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Tim Dreyling" <TimDreyling@.discussions.microsoft.com> wrote in message
> news:3F148B87-78EB-4E61-8D04-BA286EAB13A3@.microsoft.com...
>> Is it possible to create (or duplicate) the report server Report Manager
>> folder hierarchy in the VS.NET development IDE? There does not appear to
>> be
>> an option to add a Folder to the Solution Explorer tree, and if I drag a
>> folder from the file system into the tree I receive an Access Denied
>> message
>> when I try to open it.
>> I would like to be able to create a deployment hierarchy, because now all
>> reports deploy to the project root on the Report Server, and I have to
>> move
>> them to the correct folder.
>> Thanks,
>> Tim
>|||Thanks for the answers. I will give it a shot.
"Pieter van Maasdam" wrote:
> To build a deployment hierarchie you could add several projects to your
> solution and enter a different deployment folder for each of the projects.
> Hth,
> Pieter
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> news:%23Yt2JPlrEHA.376@.TK2MSFTNGP14.phx.gbl...
> > Folders are not supported in Report Designer.
> > It is in our wish list for future version.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
> > "Tim Dreyling" <TimDreyling@.discussions.microsoft.com> wrote in message
> > news:3F148B87-78EB-4E61-8D04-BA286EAB13A3@.microsoft.com...
> >> Is it possible to create (or duplicate) the report server Report Manager
> >> folder hierarchy in the VS.NET development IDE? There does not appear to
> >> be
> >> an option to add a Folder to the Solution Explorer tree, and if I drag a
> >> folder from the file system into the tree I receive an Access Denied
> >> message
> >> when I try to open it.
> >>
> >> I would like to be able to create a deployment hierarchy, because now all
> >> reports deploy to the project root on the Report Server, and I have to
> >> move
> >> them to the correct folder.
> >>
> >> Thanks,
> >> Tim
> >
> >
>
>

Saturday, February 25, 2012

Creating New Packages - Saving in Project Folder Unnecessarily

In BI Dev Studio, I have a Project/Solution created successfully, which has got say 5 packages working fine. I created a new package by Right Clicking on a solution explorer and selecting "New SSIS Package". System has given itself a default name and I decided to leave the BI Dev Studio WITHOUT SAVING project / solution.

Even though I haven't saved the project / solution still it left a package in project folder with a name "Package1.dtsx". I think this is a bug? Any ideas please?

Thanks

SuthaThis is true. I am sure this is a bug.Tongue Tied|||If it is a bug, it is one common to all VS products, and has been since VS .Net came out. The IDE will always create files on disk first. You must supply the filename upfront for a solution, project or file, although in the later case in can be inferred as it is here. I'd rather it save it for me, than me forget and loose work. VS will also save the package every time you execute it as well.|||Daran, thanks.

I understand your argument. I suppose if it is unnecessary we can delete manaually, rather than losing hours of work incase of any disaster. Tongue Tied