No, there is no default value. I have managed to work around this issue
using C:isnull=true. However I feel that this is a bug in SRS that should be
fixed seeing as how it only occurs when you use the Format=PDF tag on the
first request then omit it on the second request.
[quoted text, click to view] "Tim Dot NoSpam" wrote:
> Hi Clinton.
>
> Is the default value for C NULL or some non-null value? That's bitten me in
> the posterior a few times.
>
> "Clinton Robinson" <Clinton Robinson@discussions.microsoft.com> wrote in
> message news:AB0336EB-1978-4920-8317-808F30C5CA4A@microsoft.com...
> > Hello all,
> >
> > I have had no luck searching for a solution to this problem on the
> > internet/groups, perhaps somebody here could help me.
> >
> > It seems that SRS is caching the last used parameter when one is omitted
> > when you request a FORMAT in the first query. For example here are the
> > query
> > strings used:
> >
> > In this scenario, the parameters are accepted properly, where C is omitted
> > so it equals NULL.
> >
> > http://.../SQLReportServer?Report&rs:Command=Render&rc:Parameters=true&A=1&B=2&C=3&rs:ClearSession=true
> > http://.../SQLReportServer?Report&rs:Command=Render&rc:Parameters=true&A=1&B=2&rs:ClearSession=true
> >
> > In this scenario, the parameters are incorrect. C is omitted but the
> > value
> > is displayed as C=3 where it should be NULL.
> >
> > http://.../SQLReportServer?Report&rs:Command=Render&rc:Parameters=true&A=1&B=2&C=3&rs:ClearSession=true&Format=PDF
> > http://.../SQLReportServer?Report&rs:Command=Render&rc:Parameters=true&A=1&B=2&rs:ClearSession=true
> >
> > Does anyone have any ideas about this problem?
> >
> > Clint Robinson
> > MCSD.Net
>
>
