On 26 Mar, 13:53, "weelin" <wee...@gmail.com> wrote:
> Hello all,
>
> Microsoft provides a report pack of RS reports to use with
> Integration
> Services standard logging.
>
> The link is herehttp://www.microsoft.com/downloads/details.aspx?FamilyID=526e1fce-7ad...
>
> I have been trying to use these reports in the UK and have come
> across
> a problem with the date formatting. The reports seem to expect the
> date formatting in the report parameters to be in US format. I have
> changed all the report language settings to UK - English and the date
> formatting in the datasets that supply the parameter values all use
> ANSI dates (format 102), but I still get date conversion errors when
> trying to return the datasets unless I input the dates in US format.
>
> Any advice on how to get around this issue would be greatly
> appreciated.
>
> Thanks

On 26 Mar, 15:33, "weelin" <wee...@gmail.com> wrote:
> On 26 Mar, 13:53, "weelin" <wee...@gmail.com> wrote:
>
>
>
>
>
> > Hello all,
>
> > Microsoft provides a report pack of RS reports to use with
> > Integration
> > Services standard logging.
>
> > The link is herehttp://www.microsoft.com/downloads/details.aspx?FamilyID=526e1fce-7ad...
>
> > I have been trying to use these reports in the UK and have come
> > across
> > a problem with the date formatting. The reports seem to expect the
> > date formatting in the report parameters to be in US format. I have
> > changed all the report language settings to UK - English and the date
> > formatting in the datasets that supply the parameter values all use
> > ANSI dates (format 102), but I still get date conversion errors when
> > trying to return the datasets unless I input the dates in US format.
>
> > Any advice on how to get around this issue would be greatly
> > appreciated.
>
> > Thanks
>
> As a follow-up, I have found that the only way to run the report is
> via Internat Explorer browser AFTER setting the locale of the browser
> to US-English so that it passes the date parameters in the correct
> format. Obviously, this is not a practical solution, so if anyone has
> found a proper solution, please let me know.
>
> Thanks- Hide quoted text -
>
> - Show quoted text -