"Jackson" <jackson_num5@yahoo.com> wrote in message
news:ul5nBFBrFHA.716@TK2MSFTNGP10.phx.gbl...
> I've just started messing around with reporting services and was wondering
> how I can specify a search criteria for a drill-through report?
>
> Currently I have a Main report, so that when a user clicks on a location
> e.g. New York. I'd like my report 2 to show only New York information.
> But
> when i set the parameters for report 2 it doesn't seem to filter anything
> out. It spews the whole report out. Only time it does work is when I
> specify in data views -> criteria -> New York in report 2.
>
>
> What am I doing wrong?
>
> TIA,
>
> Jackson
>
>
>

"Mahesh" <gaware@gmail.com> wrote in message
news:1125353029.345167.225670@o13g2000cwo.googlegroups.com...
> Hi,
> Here in this case you need to send parametes for report 2, that act
> as a filter string in your query/Stored procedure.
> eg. When use clicks on New York, you should send one parameters to the
> query/SP, say ParamLocation=NY. So Query/SP will return results related
> to NY only.
>
> hope this helps you.
>
> Thanks,
> Mahesh
>

"Jackson" <jackson_num5@yahoo.com> wrote in message
news:ePvwoUPrFHA.3720@TK2MSFTNGP14.phx.gbl...
>
> Do you know If I'm able to use stored procedures for a access database? I
> don't seem to see that option but I do see the option for a sql db.
>
> Thanks for all the help,
>
> Jackson
> "Mahesh" <gaware@gmail.com> wrote in message
> news:1125353029.345167.225670@o13g2000cwo.googlegroups.com...
>> Hi,
>> Here in this case you need to send parametes for report 2, that act
>> as a filter string in your query/Stored procedure.
>> eg. When use clicks on New York, you should send one parameters to the
>> query/SP, say ParamLocation=NY. So Query/SP will return results related
>> to NY only.
>>
>> hope this helps you.
>>
>> Thanks,
>> Mahesh
>>
>
>