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
> > >
> > >
> >
> >
>

Hi to all,Please help me

Hi i want to hide a particular row in crystal report. how could i do that.

thnx
trivikramYou should ask over at the Crystal forum: http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=77.

Hi availability & DR for Large No. of DBs

Hi,
I want some help for this particular scenario.
I have more than 350 Databases growing on an average of 5 Databases per month.
I am concernd about the DR Strategy to be adopted.
Can any one help meall databases are on the same server

Help_Creating Archive Table

I have a table called customers that store information about the particular customer. I would like to have a table called Archive so that when I delete a Customer that have not been active for a specific time then the deleted information will be automatically be inserted into the Archive table. Do I need to create the archive table with the same numbers of columns as exactly as the customer table?

I need some basic idea about how this should be implemented.

Any input will be appreciated.
Thanks in advanceDo you use foreign keys? If so - you have to move customer activity history to archive table too. Structure of table could be the same, unless you want to know when data were moved to archive or any other additional information. And do not use removed ids again....|||Thank you snail for the reply
I have just created the Archive table. The primary key of the Customer Table is a foreign key in the archive table. I have added three more columns in the Archive Table namely Comments,ArchiveDate and EmployeeName, these three columns are not in the customer Table.Can this be possible? as this colums are not in the Customer Table. These columns are important because when a customer is deleted I want to be able to enter the reason why a specific customer was deleted. What did u mean by ids, are you talking about Identity Seed or?
Again I have trouble formulating the query that will insert the deleted columns into the Archive Table. Need additional Info
Thanks for the help so far|||well, if you got two identical tables you could write a trigger that fires on a deleted record from the customers table you can use
INSETED OF DELETE trigger

or if you got two different tables you can write a store procedure for deleting so it can insert the required record into the archive table with
the supplied fields first you have to insert to the achive table
using
insert into achive(field1,field2)
select field1,field2 from customers where customerid = @.custID

then update the record in the achive using
update achive set field6 = @.employeeName ...
where customerid = @.custID

to it then delete the record from the customers table.|||Thank u elamor for the reply. I am going to use Store Procedure, the idea is clear, I think with these info I know where to start, definately I might be posting my query here for deburg if ?

Help: Table name displaying twice in SQL Statement inside SQL Server Enterprise Manager

For some reason whenever I look at the SQL statement of a particular table, the table name displays twice.
For example,
SELECT * FROM State State
Even when I execute this statement, it still returns the correct results. It does this for all tables in this particular database. I also check another database and thoses display the table names in the SQL statements correctly.
Does anyone know why the table name would display twice in a table inside of a particular database?

How (where) are these statements being generated? All this is doing is creating an alias for the table with its own name, so this won't hurt anything. It's much like doing:
SELECT A.Field1 FROM State A
Marcie|||

datagridgirl wrote:

How (where) are these statements being generated? All this is doing is creating an alias for the table with its own name, so this won't hurt anything. It's much like doing:
SELECT A.Field1 FROM State A
Marcie

It just came up whenever I look at the SQL statement (SQL Pane) after "Returning All Rows" of a particular table. I guess it is not a big deal. I just don't know why it would do that.|||

voodoo9055 wrote:

It just came up whenever I look at the SQL statement (SQL Pane) after "Returning All Rows" of a particular table. I guess it is not a big deal. I just don't know why it would do that.

I'm curious now...in what tool? I'm not seeing this behavior in either VS.NET (via Server Explorer) or Enterprise Manager...
Marcie|||

datagridgirl wrote:

voodoo9055 wrote:

It just came up whenever I look at the SQL statement (SQL Pane) after "Returning All Rows" of a particular table. I guess it is not a big deal. I just don't know why it would do that.

I'm curious now...in what tool? I'm not seeing this behavior in either VS.NET (via Server Explorer) or Enterprise Manager...
Marcie

Enterprise Manager.
It displays that way for one of my databases. The rest display normally.