Interesting Problem/Bug with Logos in the page header

Scenario:

I have a report with a logo in the page header.

This report has 2 parameters: 1) Date 2) Boolean to Show/Hide detail.

When I put in the date and show the report, everything is fine. If I then change the boolean parameter to show or hide the detail, the logo file cannot be found (Displays a red X)

If I export the report like this, the red X is rendered in the export. The logo is not there.

Has anyone else experienced this issue?

Anyone know how to resolve it?

Thanks!

BobP

This is a known bug. The fix will be included in the next release.

Interactive Sort on date field

I have an RS 2005 June CTP report where the data source is an MDX query against AS 2005 June CTP. I'm using Interactive Sort on several columns and it's working fine for the numeric and string fields, but it's sorting the date columns alphabetically instead of chronologically. Is there a way I can specify that these fields are date fields and should be sorted chronologically?
Thanks,
Dirk

Most likely the date field is returned as string through the provider. Try to explicitly convert it with the CDate(...) function in the sort expression. E.g. =CDate(Fields!OrderDate.Value)
-- Robert

|||That did the trick, thanks for the help.|||

I'm also using Interactive Sort on several columns in MSRS 2005,
my problem is with sorting the currency columns (columns with $ sign) - it doesn't work, dallor ammounts are not sorted in accending/decending order. Is there a way I can specify that these fields be sorted as numbers?

Thanks!

|||

It sounds like you are sorting on strings (because the underlying dataset field contains a string rather than a numeric value).

You should sort on a numeric value of the dollar amount - e.g. by changing the dataset query to return the numeric value instead of the string. You can then still apply the currency formatting in the report by using the Format property on textboxes and set it to e.g. C0 (for currency formatting with zero decimals)

-- Robert

Interactive Sort on date field

I have an RS 2005 June CTP report where the data source is an MDX query against AS 2005 June CTP. I'm using Interactive Sort on several columns and it's working fine for the numeric and string fields, but it's sorting the date columns alphabetically instead of chronologically. Is there a way I can specify that these fields are date fields and should be sorted chronologically?
Thanks,
Dirk

Most likely the date field is returned as string through the provider. Try to explicitly convert it with the CDate(...) function in the sort expression. E.g. =CDate(Fields!OrderDate.Value)
-- Robert

|||That did the trick, thanks for the help.|||

I'm also using Interactive Sort on several columns in MSRS 2005,
my problem is with sorting the currency columns (columns with $ sign) - it doesn't work, dallor ammounts are not sorted in accending/decending order. Is there a way I can specify that these fields be sorted as numbers?

Thanks!

|||

It sounds like you are sorting on strings (because the underlying dataset field contains a string rather than a numeric value).

You should sort on a numeric value of the dollar amount - e.g. by changing the dataset query to return the numeric value instead of the string. You can then still apply the currency formatting in the report by using the Format property on textboxes and set it to e.g. C0 (for currency formatting with zero decimals)

-- Robert

Interactive sort not working with snapshot

I'm using SSRS 2005. I have a pretty simple report: it's a table with an
optional date parameter. I have one column designated to allow interactive
sort. When testing the report everything works fine. When I change the report
execution to snapshot, the interactive sort no longer works. The icon will
sometimes change to make it appear as if it is sorted, but the data doesn't
actually get sorted.
Is there some config or option I've missed?
TIAThe interactive sort also does not appear to work when the report is cached.
I know this feature was new for 2005. I'm just wondering if this behavior is
by design, a bug, or a config setting that I'm missing.
Any info appreciated...
"Denise" wrote:
> I'm using SSRS 2005. I have a pretty simple report: it's a table with an
> optional date parameter. I have one column designated to allow interactive
> sort. When testing the report everything works fine. When I change the report
> execution to snapshot, the interactive sort no longer works. The icon will
> sometimes change to make it appear as if it is sorted, but the data doesn't
> actually get sorted.
> Is there some config or option I've missed?
> TIA|||SP1 appears to have fixed this bug. After applying the service pack, all
interactive sorting works, even when the report is executed as a snapshot.
"Denise" wrote:
> The interactive sort also does not appear to work when the report is cached.
> I know this feature was new for 2005. I'm just wondering if this behavior is
> by design, a bug, or a config setting that I'm missing.
> Any info appreciated...
> "Denise" wrote:
> > I'm using SSRS 2005. I have a pretty simple report: it's a table with an
> > optional date parameter. I have one column designated to allow interactive
> > sort. When testing the report everything works fine. When I change the report
> > execution to snapshot, the interactive sort no longer works. The icon will
> > sometimes change to make it appear as if it is sorted, but the data doesn't
> > actually get sorted.
> >
> > Is there some config or option I've missed?
> >
> > TIA

Integration Services log report pack - provided by Microsoft - US date format issue

Hello all,
Microsoft provides a report pack of RS reports to use with
Integration
Services standard logging.
The link is here
http://www.microsoft.com/downloads/details.aspx?FamilyID=526e1fce-7ad5-4a54-b62c-13ffcd114a73&DisplayLang=en#QuickInfoContainer
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.
ThanksOn 26 Mar, 14:31, "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