data driven subscription with special charater in parameter

Hi all,
I have a report which takes in a name as the parameter. When I run the
report from the server manually using the name Monzón it works fine. But when
that same report runs as part of a data driven subscription, the report comes
out blank. The data source is a sql table.
Any ideas?
Thanks,
MarcusOn Oct 19, 4:05 pm, Marcus K <Marc...@.discussions.microsoft.com>
wrote:
> Hi all,
> I have a report which takes in a name as the parameter. When I run the
> report from the server manually using the name Monz=F3n it works fine. Bu=t when
> that same report runs as part of a data driven subscription, the report c=omes
> out blank. The data source is a sql table.
> Any ideas?
> Thanks,
> Marcus
You might want to check the collation on the database that the table
resides in. I don't believe that the default collation accommodates
espa=F1ol/etc. This link should help.
http://msdn2.microsoft.com/en-us/library/ms190920.aspx
Regards,
Enrique Martinez
Sr. Software Consultant|||On Oct 19, 4:05 pm, Marcus K <Marc...@.discussions.microsoft.com>
wrote:
> Hi all,
> I have a report which takes in a name as the parameter. When I run the
> report from the server manually using the name Monz=F3n it works fine. Bu=t when
> that same report runs as part of a data driven subscription, the report c=omes
> out blank. The data source is a sql table.
> Any ideas?
> Thanks,
> Marcus
You might want to change the collation of the column in the table that
contains Monz=F3n.
This link should help.
http://msdn2.microsoft.com/en-us/library/ms190920.aspx
Regards,
Enrique Martinez
Sr. Software Consultant|||The Collation is SQL_Latin1_General_CP1P_CI_AS, it accepts the ó and returns
it in a query.
BTW. This is not the same server that is running the SRS subscription.
This seems directly related to data driven subscriptions.
Marcus
"EMartinez" wrote:
> On Oct 19, 4:05 pm, Marcus K <Marc...@.discussions.microsoft.com>
> wrote:
> > Hi all,
> >
> > I have a report which takes in a name as the parameter. When I run the
> > report from the server manually using the name Monzón it works fine. But when
> > that same report runs as part of a data driven subscription, the report comes
> > out blank. The data source is a sql table.
> >
> > Any ideas?
> >
> > Thanks,
> > Marcus
>
> You might want to check the collation on the database that the table
> resides in. I don't believe that the default collation accommodates
> español/etc. This link should help.
> http://msdn2.microsoft.com/en-us/library/ms190920.aspx
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>