[quoted text, click to view] On Aug 10, 8:16 am, panzer <pan...@discussions.microsoft.com> wrote:
> i'm beginner and i'm trying to do the same thing, but i don't know how to=
do
> it. can you please describe in more details how to do this
>
> i created parameter "search", and parameter "partners" that should be
> efected by "search", then i do't know where and how to change dataset of
> "partners"
>
> thx
> An=9Ee =8Eolnir
>
>
>
>
>
> "EMartinez" wrote:
> > On Jul 27, 9:44 am, Scott Burke <ScottBu...@discussions.microsoft.com>
> > wrote:
> > > I have a report that has one Parameter.
> > > Open the Parameter and you get 1500 records.
> > > how to I serch the Parameter??????
> > > There is not auto-complete on a Parameter.
>
> > If I am understanding you correctly, I would suggest using 2
> > parameters. One that is a textbox that accepts a character string. The
> > second that is dependent on the first and does a filter of the
> > original 1500 records based on a like statement (etc) of the 1st
> > parameter's value. Hope this helps.
>
> > Regards,
>
> > Enrique Martinez
> > Sr. Software Consultant
Select the 'Report' tab and then 'Report Parameters...' from the drop-
down menu. Take note of the 'Dataset' for 'partners.' Now cancel out
of the dialog and select the 'Data' tab. To the right of 'Dataset:'
select the dataset that you saw in the 'partners' parameter dialog.
Select the 'Edit Selected Dataset' [...] button to the right of the
drop down list of the Dataset. Select the 'Parameters' tab and select
the first parameters value below the 'Value' column that you want to
associate with 'partners.' The 'Value' expression should be something
like: '=3DParameters!search.Value.' Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
