Hi All,
I need to add more search criteria in the report for refining search (Such
as like, not like, exclude, bigger than, etc.), Could reporting services
realize it? And how?
Thanks a lot
BillYes, you could pull this off. Might be messy. You would in essence create
parameters that contained your criteria.
Param1
Param1_Criteria
Param1_Value
So PARAM1 would be selecting say a field in the data, say Order quantity.
Param1_Criteria would be a selection of the different operators(<, >, =,
LIKE).
Param1_value would be your value: (100, 200, WALNUT)
Then, I would suggest using filters(unless you are running against a SQL
Server DB, then using the actual SQL might be okay). But in the filters just
construct your filter based on the parameters to get you the correct result
set. The filters could be a bit complicated, but you should be able to
figure it out. If not, just reply, and I can offer more advice.
"Bill" wrote:
> Hi All,
> I need to add more search criteria in the report for refining search (Such
> as like, not like, exclude, bigger than, etc.), Could reporting services
> realize it? And how?
> Thanks a lot
> Bill
>
>|||I would create stored procedures that encapsulates your query. This approach
gives you more freedom inside stored procudure to manipulate user supplied
parmaters befotr using them in query.
Frankly, there is no limit to what you can do with SQL SELECT once inside
stored procedure.
"Bill" wrote:
> Hi All,
> I need to add more search criteria in the report for refining search (Such
> as like, not like, exclude, bigger than, etc.), Could reporting services
> realize it? And how?
> Thanks a lot
> Bill
>
>|||Personally I would use stored procedures. The user supplied parameters can
be manipulated prior to using them in SQL statements. Frankly, there is
nothing you couldn't do inside stored procredure.
"Bill" wrote:
> Hi All,
> I need to add more search criteria in the report for refining search (Such
> as like, not like, exclude, bigger than, etc.), Could reporting services
> realize it? And how?
> Thanks a lot
> Bill
>
>
Showing posts with label criteria. Show all posts
Showing posts with label criteria. Show all posts
Monday, March 12, 2012
Friday, February 24, 2012
How to add a Date selector in the report?
Hi All,
How could I add a date selector in the search criteria of datetime field in
the report? It should be a basic function of any report, right?
Thanks a lot.
BillWell, you'd think. It is a highly requested item. If you want to have a
calendar to pick dates you will have to create your own asp application and
then use either web services or URL integration to integrate your
application with RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bill" <huangxiaohua@.hotmail.com> wrote in message
news:edCDYBZuEHA.2536@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> How could I add a date selector in the search criteria of datetime field
> in
> the report? It should be a basic function of any report, right?
> Thanks a lot.
> Bill
>|||Thanks for your reply.
Where could I find any sample for this case?
Bill
"Bruce L-C [MVP]" wrote:
> Well, you'd think. It is a highly requested item. If you want to have a
> calendar to pick dates you will have to create your own asp application and
> then use either web services or URL integration to integrate your
> application with RS.
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bill" <huangxiaohua@.hotmail.com> wrote in message
> news:edCDYBZuEHA.2536@.TK2MSFTNGP11.phx.gbl...
> > Hi All,
> >
> > How could I add a date selector in the search criteria of datetime field
> > in
> > the report? It should be a basic function of any report, right?
> >
> > Thanks a lot.
> > Bill
> >
> >
>
>|||Read up on URL integration in the BOL and make sure you know how to do that.
Once you know how to do that then you can write your own page to pass the
parameters. But note that you can end up with dealing with security issues
if the page is on another server. I think that if it is on the same server
then integrated security should still work transparently for you.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"How to add a Date selector in the reort" <How to add a Date selector in the
reort@.discussions.microsoft.com> wrote in message
news:B3B6F726-B18B-42D8-9E86-F30CAF4FF2E4@.microsoft.com...
> Thanks for your reply.
> Where could I find any sample for this case?
> Bill
>
> "Bruce L-C [MVP]" wrote:
> > Well, you'd think. It is a highly requested item. If you want to have a
> > calendar to pick dates you will have to create your own asp application
and
> > then use either web services or URL integration to integrate your
> > application with RS.
> >
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bill" <huangxiaohua@.hotmail.com> wrote in message
> > news:edCDYBZuEHA.2536@.TK2MSFTNGP11.phx.gbl...
> > > Hi All,
> > >
> > > How could I add a date selector in the search criteria of datetime
field
> > > in
> > > the report? It should be a basic function of any report, right?
> > >
> > > Thanks a lot.
> > > Bill
> > >
> > >
> >
> >
> >
How could I add a date selector in the search criteria of datetime field in
the report? It should be a basic function of any report, right?
Thanks a lot.
BillWell, you'd think. It is a highly requested item. If you want to have a
calendar to pick dates you will have to create your own asp application and
then use either web services or URL integration to integrate your
application with RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bill" <huangxiaohua@.hotmail.com> wrote in message
news:edCDYBZuEHA.2536@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> How could I add a date selector in the search criteria of datetime field
> in
> the report? It should be a basic function of any report, right?
> Thanks a lot.
> Bill
>|||Thanks for your reply.
Where could I find any sample for this case?
Bill
"Bruce L-C [MVP]" wrote:
> Well, you'd think. It is a highly requested item. If you want to have a
> calendar to pick dates you will have to create your own asp application and
> then use either web services or URL integration to integrate your
> application with RS.
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bill" <huangxiaohua@.hotmail.com> wrote in message
> news:edCDYBZuEHA.2536@.TK2MSFTNGP11.phx.gbl...
> > Hi All,
> >
> > How could I add a date selector in the search criteria of datetime field
> > in
> > the report? It should be a basic function of any report, right?
> >
> > Thanks a lot.
> > Bill
> >
> >
>
>|||Read up on URL integration in the BOL and make sure you know how to do that.
Once you know how to do that then you can write your own page to pass the
parameters. But note that you can end up with dealing with security issues
if the page is on another server. I think that if it is on the same server
then integrated security should still work transparently for you.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"How to add a Date selector in the reort" <How to add a Date selector in the
reort@.discussions.microsoft.com> wrote in message
news:B3B6F726-B18B-42D8-9E86-F30CAF4FF2E4@.microsoft.com...
> Thanks for your reply.
> Where could I find any sample for this case?
> Bill
>
> "Bruce L-C [MVP]" wrote:
> > Well, you'd think. It is a highly requested item. If you want to have a
> > calendar to pick dates you will have to create your own asp application
and
> > then use either web services or URL integration to integrate your
> > application with RS.
> >
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bill" <huangxiaohua@.hotmail.com> wrote in message
> > news:edCDYBZuEHA.2536@.TK2MSFTNGP11.phx.gbl...
> > > Hi All,
> > >
> > > How could I add a date selector in the search criteria of datetime
field
> > > in
> > > the report? It should be a basic function of any report, right?
> > >
> > > Thanks a lot.
> > > Bill
> > >
> > >
> >
> >
> >
Subscribe to:
Posts (Atom)