I have tried this, but I must be doing it wrong because I get no records
returned.
On the Data page, I am filtering the query column "odConvYear" using a "?".
Under dataset parameters, I have the parameter name as "?" and the value as...
=iif(Parameters!Parameter1.Value = "",""," WHERE odConvYear =
:Parameters!Parameter1" )
And, finally, under Report Parameters, I have the name as "Parameter1" and I
have checked "Allow null values."
This returns no records, with an entry or not.
Any ideas what I'm doing wrong?
[quoted text, click to view] "RK Balaji" wrote:
> You can 'Allow Nulls' or 'Allow Blank' on that parameter and use a
> conditional IIF statement in the SQL..
>
> "mistybrian" <mistybrian@discussions.microsoft.com> wrote in message
> news:E92CE0FB-411B-4737-ACB5-DE86EB1EEC10@microsoft.com...
> > I have a query with one paramater (a date field). I would like the
> paramater
> > to be optional... if no date is entered, then all records are returned.
> How
> > would I accomplish this?
> >
> > Thanks in advance!
>
>
This if statement returns no records on a Null entry and I get no records and
an error when I put in an entry...
The value expression for the query parameter ‘?’ contains an error: Input
string was not in a correct format.
Just to double check, if their is no entry for the report parameter, I want
all records returned. Am I on the right track with this?
Thanks!
[quoted text, click to view] "mike" wrote:
> =iif(Parameters!Parameter1.Value = "",""," WHERE odConvYear = " +
> Parameters!Parameter1.Value)
>
>
> "mistybrian" <mistybrian@discussions.microsoft.com> wrote in message
> news:5F75F521-A292-4EA2-867E-4E689700B09A@microsoft.com...
> > I have tried this, but I must be doing it wrong because I get no records
> > returned.
> >
> > On the Data page, I am filtering the query column "odConvYear" using a
> "?".
> >
> > Under dataset parameters, I have the parameter name as "?" and the value
> as...
> >
> > =iif(Parameters!Parameter1.Value = "",""," WHERE odConvYear =
> > :Parameters!Parameter1" )
> >
> > And, finally, under Report Parameters, I have the name as "Parameter1" and
> I
> > have checked "Allow null values."
> >
> > This returns no records, with an entry or not.
> >
> > Any ideas what I'm doing wrong?
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > "RK Balaji" wrote:
> >
> > > You can 'Allow Nulls' or 'Allow Blank' on that parameter and use a
> > > conditional IIF statement in the SQL..
> > >
> > > "mistybrian" <mistybrian@discussions.microsoft.com> wrote in message
> > > news:E92CE0FB-411B-4737-ACB5-DE86EB1EEC10@microsoft.com...
> > > > I have a query with one paramater (a date field). I would like the
> > > paramater
> > > > to be optional... if no date is entered, then all records are
> returned.
> > > How
> > > > would I accomplish this?
> > > >
> > > > Thanks in advance!
> > >
> > >
> > >
>
>
=iif(Parameters!Parameter1.Value = "",""," WHERE odConvYear = " +
Parameters!Parameter1.Value)
[quoted text, click to view] "mistybrian" <mistybrian@discussions.microsoft.com> wrote in message
news:5F75F521-A292-4EA2-867E-4E689700B09A@microsoft.com...
> I have tried this, but I must be doing it wrong because I get no records
> returned.
>
> On the Data page, I am filtering the query column "odConvYear" using a
"?".
>
> Under dataset parameters, I have the parameter name as "?" and the value
as...
>
> =iif(Parameters!Parameter1.Value = "",""," WHERE odConvYear =
> :Parameters!Parameter1" )
>
> And, finally, under Report Parameters, I have the name as "Parameter1" and
I
> have checked "Allow null values."
>
> This returns no records, with an entry or not.
>
> Any ideas what I'm doing wrong?
>
>
>
>
>
>
>
>
>
> "RK Balaji" wrote:
>
> > You can 'Allow Nulls' or 'Allow Blank' on that parameter and use a
> > conditional IIF statement in the SQL..
> >
> > "mistybrian" <mistybrian@discussions.microsoft.com> wrote in message
> > news:E92CE0FB-411B-4737-ACB5-DE86EB1EEC10@microsoft.com...
> > > I have a query with one paramater (a date field). I would like the
> > paramater
> > > to be optional... if no date is entered, then all records are
returned.
> > How
> > > would I accomplish this?
> > >
> > > Thanks in advance!
> >
> >
> >
Don't see what you're looking for? Try a search.
