finding a view or sp

According to a developer that worked on my db, there is a view :
xvw_CheckVoucherReport
I cant see it is there any way i can find out it exsist and if so what database on my server it is in?Enterprise Mangler (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_aa_5rg2.asp) would use SQL-DMO (http://msdn.microsoft.com/library/en-us/sqldmo/dmoref_con01_5qup.asp) to show it to you. You could also use SQL Query Analyzer (http://msdn.microsoft.com/library/en-us/qryanlzr/qryanlzr_1zqq.asp) to check the INFORMATION_SCHEMA.VIEWS (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_4pbn.asp) for it.

-PatP|||Select * from Sysobjects should generate all the objects in your database.|||Originally posted by sqlserver2k
Select * from Sysobjects should generate all the objects in your database. Good point, but information_schema views are a lot friendlier and are portable. Why start bad habits (using system tables) when good ones are easier?

-PatP|||I second Pat's proposition ... for not to use SYSTEM TABLES when system supplied SPs and ISVs are provided.

find last data according to date...

hi..
i'm still newbie in SSRS 2005..
i've a problem about it..lets say i have a data like that :
date_rent type_rent
1/1/2006 CAR
1/1/2006 LORRY
1/2/2006 BUS
......
......
......
......
11/2/2006 LORRY
1/3/2006 CAR
3/3/2006 CAR
4/3/2006 BUS
at my report has one input date parameter..if i input the date:
30/03/2006 and i want to find the last of date_rent which refer to
CAR...meaning the result is
3/3/2006...
or if i input the date : 1/2/2006
the result of last of date_rent which refer to CAR...is 1/1/2006
...can anybody help me'
thanks in advance...Try:
SELECT type_rent, MAX(date_rent)
FROM MyTable
WHERE date_rent <= @.InputDate
GROUP BY type_rent
HTH
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"imapeace" wrote:
> hi..
> i'm still newbie in SSRS 2005..
> i've a problem about it..lets say i have a data like that :
> date_rent type_rent
> 1/1/2006 CAR
> 1/1/2006 LORRY
> 1/2/2006 BUS
> ......
> ......
> ......
> ......
> 11/2/2006 LORRY
> 1/3/2006 CAR
> 3/3/2006 CAR
> 4/3/2006 BUS
> at my report has one input date parameter..if i input the date:
> 30/03/2006 and i want to find the last of date_rent which refer to
> CAR...meaning the result is
> 3/3/2006...
> or if i input the date : 1/2/2006
> the result of last of date_rent which refer to CAR...is 1/1/2006
> ...can anybody help me'
> thanks in advance...
>|||Thank you for ur response..
how about if i want to put it in expression'It is because my report
has one table and many functions...every field i used an expression
according to different condition...
-tq
magendo_man (donotspam) wrote:
> Try:
> SELECT type_rent, MAX(date_rent)
> FROM MyTable
> WHERE date_rent <= @.InputDate
> GROUP BY type_rent
> HTH
> --
> Magendo_man
> Freelance SQL Reporting Services developer
> Stirling, Scotland
>
> "imapeace" wrote:
> > hi..
> > i'm still newbie in SSRS 2005..
> > i've a problem about it..lets say i have a data like that :
> >
> > date_rent type_rent
> > 1/1/2006 CAR
> > 1/1/2006 LORRY
> > 1/2/2006 BUS
> > ......
> > ......
> > ......
> > ......
> > 11/2/2006 LORRY
> > 1/3/2006 CAR
> > 3/3/2006 CAR
> > 4/3/2006 BUS
> >
> > at my report has one input date parameter..if i input the date:
> > 30/03/2006 and i want to find the last of date_rent which refer to
> > CAR...meaning the result is
> > 3/3/2006...
> > or if i input the date : 1/2/2006
> > the result of last of date_rent which refer to CAR...is 1/1/2006
> >
> > ...can anybody help me'
> >
> > thanks in advance...
> >
> >|||You could set up a table in which you define detail grouping based on
Fields!type_rent.Value, and filtering Fields!date_rent.Value <=Parameters!InputDate.value. On the detail row you could then have two
textboxes:
1) =Fields!type_rent.Value
2) =Max(Fields!date_rent.Value)
HTH
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"imapeace" wrote:
> Thank you for ur response..
> how about if i want to put it in expression'It is because my report
> has one table and many functions...every field i used an expression
> according to different condition...
> -tq
> magendo_man (donotspam) wrote:
> > Try:
> >
> > SELECT type_rent, MAX(date_rent)
> > FROM MyTable
> > WHERE date_rent <= @.InputDate
> > GROUP BY type_rent
> >
> > HTH
> >
> > --
> >
> > Magendo_man
> >
> > Freelance SQL Reporting Services developer
> > Stirling, Scotland
> >
> >
> > "imapeace" wrote:
> >
> > > hi..
> > > i'm still newbie in SSRS 2005..
> > > i've a problem about it..lets say i have a data like that :
> > >
> > > date_rent type_rent
> > > 1/1/2006 CAR
> > > 1/1/2006 LORRY
> > > 1/2/2006 BUS
> > > ......
> > > ......
> > > ......
> > > ......
> > > 11/2/2006 LORRY
> > > 1/3/2006 CAR
> > > 3/3/2006 CAR
> > > 4/3/2006 BUS
> > >
> > > at my report has one input date parameter..if i input the date:
> > > 30/03/2006 and i want to find the last of date_rent which refer to
> > > CAR...meaning the result is
> > > 3/3/2006...
> > > or if i input the date : 1/2/2006
> > > the result of last of date_rent which refer to CAR...is 1/1/2006
> > >
> > > ...can anybody help me'
> > >
> > > thanks in advance...
> > >
> > >
>

Filters in rdl.

Hi,
I've a big trouble. According the documentation, the <Filters> section of a
rdl file contains a collection of <Filter>. But there is no information how
this collection is handled. It seem that the datasource is filtered based on
every <Filter> with AND.
If you are in the Filters tab of a graph, you can add several <Filter>. The
"and/or" column is greyed and a default AND is used.
My question is how to change this to OR.
My filters have to be like this
City="New York" or
City="New Jersey"
Instead of
City="New York" and
City="New Jersey"
who will never return any rows.
Any idea ?
Thanks.
Regardsm
--
Stéphaneif you select the same column name from the drop down it assumes "OR" if you
select diferent column name it assumes "and"
For e.g
contact id = 1 and when you go to the second line and select contact id you
can see it turns to "or".
if you select AccountName then it turns to "and"
Amarnath
"Suedois" wrote:
> Hi,
> I've a big trouble. According the documentation, the <Filters> section of a
> rdl file contains a collection of <Filter>. But there is no information how
> this collection is handled. It seem that the datasource is filtered based on
> every <Filter> with AND.
> If you are in the Filters tab of a graph, you can add several <Filter>. The
> "and/or" column is greyed and a default AND is used.
> My question is how to change this to OR.
> My filters have to be like this
> City="New York" or
> City="New Jersey"
> Instead of
> City="New York" and
> City="New Jersey"
> who will never return any rows.
> Any idea ?
> Thanks.
> Regardsm
>
> --
> Stéphane|||Thanks for you reply.
Didi you know if it's possible to do an 'or' on different columns ?
I'll try you tips and see what is done in XML file.
Regards,
--
Stéphane
"Amarnath" wrote:
> if you select the same column name from the drop down it assumes "OR" if you
> select diferent column name it assumes "and"
> For e.g
> contact id = 1 and when you go to the second line and select contact id you
> can see it turns to "or".
> if you select AccountName then it turns to "and"
> Amarnath
>
> "Suedois" wrote:
> > Hi,
> >
> > I've a big trouble. According the documentation, the <Filters> section of a
> > rdl file contains a collection of <Filter>. But there is no information how
> > this collection is handled. It seem that the datasource is filtered based on
> > every <Filter> with AND.
> >
> > If you are in the Filters tab of a graph, you can add several <Filter>. The
> > "and/or" column is greyed and a default AND is used.
> >
> > My question is how to change this to OR.
> >
> > My filters have to be like this
> > City="New York" or
> > City="New Jersey"
> > Instead of
> > City="New York" and
> > City="New Jersey"
> > who will never return any rows.
> >
> > Any idea ?
> >
> > Thanks.
> >
> > Regardsm
> >
> >
> >
> > --
> > Stéphane