filter detail section of matrix report

Hi,
is there a way to filter details section of the report created using Matrix report type?
I just want to see rows that contain positive numbers.

Thanks,
Igor

Have you tried using the filter tab in the matrix properties dialog box.

I'd be careful though as each matrix cell is an aggregation of 1 or more detail rows. Depending on the nature of the source data and whether any aggregation is actually occuring you'll want to watch out for filtering underlying negative values vs a negative result of an aggregate.

Can you not do this in the source query?

Filter date for ToDay, some problem with time.

I all.

In a talbe I've a datatime field. for example it contain '16-4-2007 10:45'.

I like to write a SQL that return all record with the date field equals '16-4-2007' (it's not important the time). how to?

thank you.

Try this query to retrive data

select

*from clientswhere clientAddressbetween'2007-04-12 00:00:00.000'and'2007-04-12 23:59:59.999'

The alternative query is

select

*from clientswhere clientAddress>='2007-04-12'and clientAddress<'2007-04-13'

The time format is yyyy-MM-dd and time. Since you are saving time in DB the query should be framed as above

Hope this will help you

|||

try this syntax

print

convert(varchar(20),convert(datetime,'16-04-2006 16:45',105),105)

how it works: convert string to date time with correct format for date string and next convert date time back to string with format you need.

See help for CONVERT in T-SQL help for more format info.

filed name as a column

How can I display filed name as a column, can any body help...
There is one table name School and it contain 4 records and in the future
might be it will increase but I want to display that records as a column
like this
1........... First School
2........... Second School
3............Third School
4............Fourth School
now I want like this
First School Second School Third School
Fourth School
45 99 0
0
99 22 1
0
Thanks
Thats a crosstab thing which could be handled with y CASE statement:
http://www.paladn.com/dynamic-crosstabs.htm
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Roy" <roy@.hotmail.com> wrote in message
news:uJ4ZN2fgFHA.1148@.TK2MSFTNGP12.phx.gbl...
> How can I display filed name as a column, can any body help...
> There is one table name School and it contain 4 records and in the future
> might be it will increase but I want to display that records as a column
> like this
> 1........... First School
> 2........... Second School
> 3............Third School
> 4............Fourth School
> now I want like this
> First School Second School Third School
> Fourth School
> 45 99 0
> 0
> 99 22 1
> 0
> Thanks
>

File Storage to DB

Our company is planning to store the projects they have been creating for
years. The projects contain many different kinds of files (Adobe, Microsoft
Office e.t.c). The storage and the interface application should allow the
projects (Hundereds of Analysis documents also) to be reviewed, modified and
saved back in the same original format. Initial data will be around 1 TB and
expected to grow.
Is this something an SQL Server Database can handle ?. What would be the
good Software-Hardware suggestion ? Software to allow the above mentioned
modifications ?
Thanks for any input.I would take a serious look at SQL 2008 and the new FileStream datatype as
it sounds perfect for this type of application.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:698AAA6B-3B03-4379-8E4E-34BC400972CB@.microsoft.com...
> Our company is planning to store the projects they have been creating for
> years. The projects contain many different kinds of files (Adobe,
> Microsoft
> Office e.t.c). The storage and the interface application should allow the
> projects (Hundereds of Analysis documents also) to be reviewed, modified
> and
> saved back in the same original format. Initial data will be around 1 TB
> and
> expected to grow.
> Is this something an SQL Server Database can handle ?. What would be the
> good Software-Hardware suggestion ? Software to allow the above mentioned
> modifications ?
> Thanks for any input.
>|||Thanks Andrew for a quick response. FileStream datatype would help me to
stored the data but how about retrieve, modify and save ? Do I need a third
party application that will help me do this ? If so, any suggestions ?
What about hardware ? What will be an efficient setup this kind of work ?
Thanks again.
"Andrew J. Kelly" wrote:
> I would take a serious look at SQL 2008 and the new FileStream datatype as
> it sounds perfect for this type of application.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:698AAA6B-3B03-4379-8E4E-34BC400972CB@.microsoft.com...
> > Our company is planning to store the projects they have been creating for
> > years. The projects contain many different kinds of files (Adobe,
> > Microsoft
> > Office e.t.c). The storage and the interface application should allow the
> > projects (Hundereds of Analysis documents also) to be reviewed, modified
> > and
> > saved back in the same original format. Initial data will be around 1 TB
> > and
> > expected to grow.
> >
> > Is this something an SQL Server Database can handle ?. What would be the
> > good Software-Hardware suggestion ? Software to allow the above mentioned
> > modifications ?
> >
> > Thanks for any input.
> >
>|||"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:BEC98495-7594-43ED-BD3C-3102F4D61591@.microsoft.com...
> Thanks Andrew for a quick response. FileStream datatype would help me to
> stored the data but how about retrieve, modify and save ? Do I need a
> third
> party application that will help me do this ? If so, any suggestions ?
> What about hardware ? What will be an efficient setup this kind of work ?
>
> Thanks again.
>
If you aren't planning to develop your own application then take a look at
one of the Content Management System (CMS) offerings on the market. Choose a
complete solution rather than trying to choose a DBMS first.
--
David Portas|||As David stated SQL Server is only a database, it is not an application.
Many applications work with SQL Server but you can not use it as is for your
intended purpose.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:BEC98495-7594-43ED-BD3C-3102F4D61591@.microsoft.com...
> Thanks Andrew for a quick response. FileStream datatype would help me to
> stored the data but how about retrieve, modify and save ? Do I need a
> third
> party application that will help me do this ? If so, any suggestions ?
> What about hardware ? What will be an efficient setup this kind of work ?
>
> Thanks again.
>
> "Andrew J. Kelly" wrote:
>> I would take a serious look at SQL 2008 and the new FileStream datatype
>> as
>> it sounds perfect for this type of application.
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "DXC" <DXC@.discussions.microsoft.com> wrote in message
>> news:698AAA6B-3B03-4379-8E4E-34BC400972CB@.microsoft.com...
>> > Our company is planning to store the projects they have been creating
>> > for
>> > years. The projects contain many different kinds of files (Adobe,
>> > Microsoft
>> > Office e.t.c). The storage and the interface application should allow
>> > the
>> > projects (Hundereds of Analysis documents also) to be reviewed,
>> > modified
>> > and
>> > saved back in the same original format. Initial data will be around 1
>> > TB
>> > and
>> > expected to grow.
>> >
>> > Is this something an SQL Server Database can handle ?. What would be
>> > the
>> > good Software-Hardware suggestion ? Software to allow the above
>> > mentioned
>> > modifications ?
>> >
>> > Thanks for any input.
>> >
>>