Hide Certain reports from users

Hi All,
Is it any way to hide a particular report from listing in the report folder?
My actual problem is I deployed 2 reports in the report server and one of
them is a subreport. And I want the users should able to run only the main
report and not the subreport.
TIA,
SamuelIn report manager go to the properties page, the general sub tab there is a
check box for 'Hide in List View'. When a users browses to that folder in
the report manger (using list view, not detail view) then they will not see
that item.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Samuel" <samuel@.photoninfotech.com> wrote in message
news:ui1uXhybEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> Is it any way to hide a particular report from listing in the report
folder?
> My actual problem is I deployed 2 reports in the report server and one of
> them is a subreport. And I want the users should able to run only the main
> report and not the subreport.
> TIA,
> Samuel
>|||Hi Daniel,
I already tried that option too. But I want to restrict the user in both
views. Is any way to hide reports in details view?
Or Can I deploy subreport in a different directory and refer it in the main
report?
Thanks,
Samuel
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23nz1AO0bEHA.2944@.TK2MSFTNGP11.phx.gbl...
> In report manager go to the properties page, the general sub tab there is
a
> check box for 'Hide in List View'. When a users browses to that folder in
> the report manger (using list view, not detail view) then they will not
see
> that item.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Samuel" <samuel@.photoninfotech.com> wrote in message
> news:ui1uXhybEHA.384@.TK2MSFTNGP10.phx.gbl...
> > Hi All,
> >
> > Is it any way to hide a particular report from listing in the report
> folder?
> > My actual problem is I deployed 2 reports in the report server and one
of
> > them is a subreport. And I want the users should able to run only the
main
> > report and not the subreport.
> >
> > TIA,
> > Samuel
> >
> >
>|||I think you can put the subreport in a sub directory. However the directory
will still be visible to users. There is no way to completly hide the
report outside of using permissions, but then the users could not run the
report.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Samuel" <samuel@.photoninfotech.com> wrote in message
news:ejH7Eu6bEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hi Daniel,
> I already tried that option too. But I want to restrict the user in both
> views. Is any way to hide reports in details view?
> Or Can I deploy subreport in a different directory and refer it in the
main
> report?
> Thanks,
> Samuel
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:%23nz1AO0bEHA.2944@.TK2MSFTNGP11.phx.gbl...
> > In report manager go to the properties page, the general sub tab there
is
> a
> > check box for 'Hide in List View'. When a users browses to that folder
in
> > the report manger (using list view, not detail view) then they will not
> see
> > that item.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Samuel" <samuel@.photoninfotech.com> wrote in message
> > news:ui1uXhybEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > Hi All,
> > >
> > > Is it any way to hide a particular report from listing in the report
> > folder?
> > > My actual problem is I deployed 2 reports in the report server and one
> of
> > > them is a subreport. And I want the users should able to run only the
> main
> > > report and not the subreport.
> > >
> > > TIA,
> > > Samuel
> > >
> > >
> >
> >
>

Hide a Row or Column in Detail but show in Subtotal

It there a way I can hide a ROW in detail but show subtotal.
Example
c1 c2 c3 c4 Total
Project Task1 Actual 8 7 6 4 25
Schedule 8 8 8 8 32
Task2 Actual 2 2 2 2 8
Schedule 3 3 3 3 12
Total Project Actual 10 9 8 6 33
Schedule 11 11 11 11 44
Difference -1 -2 -3 -5 -11
Difference is the Row not in Task Group but I want difference to show in
subtotal. Is there a way to hide whole row on detial but show in Subtotal. I
tried Inscope. I can get blank row in detail and difference in subtotal. But
it does takes whole row space for each task. I am trying to hide the ROW
somehow to minimize the space.
c1 c2 c3 c4 Total
Project Task1 Actual 8 7 6 4 25
Schedule 8 8 8 8 32
Task2 Actual 2 2 2 2 8
Schedule 3 3 3 3 12
Total Project Actual 10 9 8 6 33
Schedule 11 11 11 11 44
Difference -1 -2 -3 -5 -11
Thanks for response
--
Gaurav Wason
gwason@.gmail.com
MCP - Project Server
Project Made Easy
Project Archive Tool
Project Owner Tool
http://projectmadeeasy.comOn Mar 19, 9:40 pm, Gaurav Wason <gwa...@.gmail.com> wrote:
> It there a way I can hide a ROW in detail but show subtotal.
> Example
> c1 c2 c3 c4 Total
> Project Task1 Actual 8 7 6 4 25
> Schedule 8 8 8 8 32
> Task2 Actual 2 2 2 2 8
> Schedule 3 3 3 3 12
> Total Project Actual 10 9 8 6 33
> Schedule 11 11 11 11 44
> Difference -1 -2 -3 -5 -11
> Difference is the Row not in Task Group but I want difference to show in
> subtotal. Is there a way to hide whole row on detial but show in Subtotal. I
> tried Inscope. I can get blank row in detail and difference in subtotal. But
> it does takes whole row space for each task. I am trying to hide the ROW
> somehow to minimize the space.
> c1 c2 c3 c4 Total
> Project Task1 Actual 8 7 6 4 25
> Schedule 8 8 8 8 32
> Task2 Actual 2 2 2 2 8
> Schedule 3 3 3 3 12
> Total Project Actual 10 9 8 6 33
> Schedule 11 11 11 11 44
> Difference -1 -2 -3 -5 -11
> Thanks for response
> --
> Gaurav Wason
> gwa...@.gmail.com
> MCP - Project Server
> Project Made Easy
> Project Archive Tool
> Project Owner Toolhttp://projectmadeeasy.com
As far as I know there is not a way around this: particularly, if you
are doing the Difference as part of the table. You might, however, try
doing the difference either in the stored procedure or query that is
sourcing the report and include it in a separate textbox below the
table -or- use a separate text box below the table and include an
expression there that includes an aggregate with a reference to the
dataset (or reference to a separate dataset that determines the
difference). Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer