Filter

Hello

I Was wondering if anybody is using the filters to filter data? I've tried and have varying success with the results.
I wanted to create filters on several of the fields. The user clicks the filters to see the corresponding results..the user can also click nothing in the filters and view report..how do we do both using parameters?.
Can somebody help me please...

Thanks for your valuable time.
Sankar

What you are describing is inline filters, which are not available in the current versions of Reporting Services. You can use parameters for this purpose. If you want an 'all' value for the parameters, you will have to do a bit of work. This blog has a technique: http://blogs.msdn.com/chrishays/archive/2004/07/27/AllParameterValue.aspx.

Filegroups Properties

Hello
I am fairly new to sql server and need some help:-
We have a database with several file groups e.g primarry,
data1,data2,data3,index1,index2,index3 etc. Each file group has one file
associated with this and they are on seperated disks.
Is there any sql code that will display each table or index and its
allocated filegroup?
Basically I want to get a list of what is allocated to each file group, it
will take me hours within enterprise manager looking at each table.
Thanks for your help.
Jason - Hull, EnglandYes, See sysindexes system table...there is a column groupid, join this wit
h
sysfilegroups... If a clustered index exists in a filegroup then it means th
e
table data also exists in the same filegroup since clustered index and table
data are the same...If a table does not have a clustered index, we will not
know which filegroup it exists in any system table, but you can find out if
you script the table...
HTH..
"new_sql_dba" wrote:

> Hello
> I am fairly new to sql server and need some help:-
> We have a database with several file groups e.g primarry,
> data1,data2,data3,index1,index2,index3 etc. Each file group has one file
> associated with this and they are on seperated disks.
> Is there any sql code that will display each table or index and its
> allocated filegroup?
> Basically I want to get a list of what is allocated to each file group, it
> will take me hours within enterprise manager looking at each table.
> Thanks for your help.
> Jason - Hull, England|||Thanks for your help
How do you script the table?
"Ranga" wrote:
[vbcol=seagreen]
> Yes, See sysindexes system table...there is a column groupid, join this w
ith
> sysfilegroups... If a clustered index exists in a filegroup then it means
the
> table data also exists in the same filegroup since clustered index and tab
le
> data are the same...If a table does not have a clustered index, we will no
t
> know which filegroup it exists in any system table, but you can find out i
f
> you script the table...
> HTH..
> "new_sql_dba" wrote:
>|||For instance EM, right-click the table. Or QA, the same.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"new_sql_dba" <newsqldba@.discussions.microsoft.com> wrote in message
news:29285C84-0A23-4276-B6C2-ADF5B665F41C@.microsoft.com...[vbcol=seagreen]
> Thanks for your help
> How do you script the table?
>
> "Ranga" wrote:
>

Filegroups Properties

Hello
I am fairly new to sql server and need some help:-
We have a database with several file groups e.g primarry,
data1,data2,data3,index1,index2,index3 etc. Each file group has one file
associated with this and they are on seperated disks.
Is there any sql code that will display each table or index and its
allocated filegroup?
Basically I want to get a list of what is allocated to each file group, it
will take me hours within enterprise manager looking at each table.
Thanks for your help.
Jason - Hull, England
Yes, See sysindexes system table...there is a column groupid, join this with
sysfilegroups... If a clustered index exists in a filegroup then it means the
table data also exists in the same filegroup since clustered index and table
data are the same...If a table does not have a clustered index, we will not
know which filegroup it exists in any system table, but you can find out if
you script the table...
HTH..
"new_sql_dba" wrote:

> Hello
> I am fairly new to sql server and need some help:-
> We have a database with several file groups e.g primarry,
> data1,data2,data3,index1,index2,index3 etc. Each file group has one file
> associated with this and they are on seperated disks.
> Is there any sql code that will display each table or index and its
> allocated filegroup?
> Basically I want to get a list of what is allocated to each file group, it
> will take me hours within enterprise manager looking at each table.
> Thanks for your help.
> Jason - Hull, England
|||Thanks for your help
How do you script the table?
"Ranga" wrote:
[vbcol=seagreen]
> Yes, See sysindexes system table...there is a column groupid, join this with
> sysfilegroups... If a clustered index exists in a filegroup then it means the
> table data also exists in the same filegroup since clustered index and table
> data are the same...If a table does not have a clustered index, we will not
> know which filegroup it exists in any system table, but you can find out if
> you script the table...
> HTH..
> "new_sql_dba" wrote:
|||For instance EM, right-click the table. Or QA, the same.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"new_sql_dba" <newsqldba@.discussions.microsoft.com> wrote in message
news:29285C84-0A23-4276-B6C2-ADF5B665F41C@.microsoft.com...[vbcol=seagreen]
> Thanks for your help
> How do you script the table?
>
> "Ranga" wrote: