locked
Can not change filter on model report - UPDATED RRS feed

  • Question

  •  

    I have a very simple report based on a test model.

    The report is filtered via a date field and runs ok.

    If I try to change the filter I get the following error message:

    Operation Failed

    Short time pattern does not include hours and minutes

    Does anyone know how I can correct this?

    Regards

    John

     UPDATE

    This only happens if I try to filter between two dates, a single date works correctly!

    Monday, June 5, 2006 10:08 AM

Answers

  • This is a known issue that will be fixed in SP2. Unfortunately the only way to avoid this error for now is to change your Windows regional settings to use a 12-hour clock.
    Wednesday, June 21, 2006 5:34 PM

All replies

  • Can you please save report that fails to file and post it?
    Monday, June 5, 2006 11:41 PM
  • Alexandre

    This is the rdl for the failing report.

    <?xml version="1.0" encoding="utf-8"?>

    <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

    <Language>en-US</Language>

    <BottomMargin>0.5in</BottomMargin>

    <RightMargin>0.5in</RightMargin>

    <DataSets>

    <DataSet Name="dataSet">

    <Query>

    <DataSourceName>dataSource1</DataSourceName>

    <CommandText>&lt;SemanticQuery xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rb="http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder" xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"&gt;

    &lt;Hierarchies&gt;

    &lt;Hierarchy&gt;

    &lt;BaseEntity&gt;

    &lt;!--Epex Referral--&gt;

    &lt;EntityID&gt;G066c76f8-9856-4acd-8b54-d734971da2c8&lt;/EntityID&gt;

    &lt;/BaseEntity&gt;

    &lt;Groupings&gt;

    &lt;Grouping Name="Epex Referral"&gt;

    &lt;Expression Name="Epex Referral"&gt;

    &lt;EntityRef&gt;

    &lt;!--Epex Referral--&gt;

    &lt;EntityID&gt;G066c76f8-9856-4acd-8b54-d734971da2c8&lt;/EntityID&gt;

    &lt;/EntityRef&gt;

    &lt;/Expression&gt;

    &lt;Details&gt;

    &lt;Expression Name="Created"&gt;

    &lt;AttributeRef&gt;

    &lt;!--Created--&gt;

    &lt;AttributeID&gt;G9a9689b0-64a7-49de-abae-58b8d30322e9&lt;/AttributeID&gt;

    &lt;/AttributeRef&gt;

    &lt;/Expression&gt;

    &lt;Expression Name="Close Date"&gt;

    &lt;AttributeRef&gt;

    &lt;!--Close Date--&gt;

    &lt;AttributeID&gt;G36ac2614-9e79-4c60-9c3e-fc45de7c67ec&lt;/AttributeID&gt;

    &lt;/AttributeRef&gt;

    &lt;/Expression&gt;

    &lt;Expression Name="Patient"&gt;

    &lt;Path&gt;

    &lt;RolePathItem&gt;

    &lt;!--Patient--&gt;

    &lt;RoleID&gt;G036974d5-33a0-4096-bc96-166d82853818&lt;/RoleID&gt;

    &lt;/RolePathItem&gt;

    &lt;/Path&gt;

    &lt;AttributeRef&gt;

    &lt;!--Name--&gt;

    &lt;AttributeID&gt;Gd6622d3c-8a4f-4273-a190-c8834bf90031&lt;/AttributeID&gt;

    &lt;/AttributeRef&gt;

    &lt;/Expression&gt;

    &lt;Expression Name="expr1"&gt;

    &lt;AttributeRef&gt;

    &lt;!--Updated--&gt;

    &lt;AttributeID&gt;Gfee3c95d-eb72-48c3-b372-0e2865ac44c8&lt;/AttributeID&gt;

    &lt;/AttributeRef&gt;

    &lt;/Expression&gt;

    &lt;/Details&gt;

    &lt;/Grouping&gt;

    &lt;/Groupings&gt;

    &lt;Filter&gt;

    &lt;Expression Name="expr2"&gt;

    &lt;Function&gt;

    &lt;FunctionName&gt;And&lt;/FunctionName&gt;

    &lt;Arguments&gt;

    &lt;Expression&gt;

    &lt;Function&gt;

    &lt;FunctionName&gt;GreaterThanOrEquals&lt;/FunctionName&gt;

    &lt;Arguments&gt;

    &lt;Expression&gt;

    &lt;AttributeRef&gt;

    &lt;!--Created--&gt;

    &lt;AttributeID&gt;G9a9689b0-64a7-49de-abae-58b8d30322e9&lt;/AttributeID&gt;

    &lt;/AttributeRef&gt;

    &lt;/Expression&gt;

    &lt;Expression&gt;

    &lt;Literal&gt;

    &lt;DataType&gt;DateTime&lt;/DataType&gt;

    &lt;Value&gt;2005-01-01T00:00:00&lt;/Value&gt;

    &lt;/Literal&gt;

    &lt;/Expression&gt;

    &lt;/Arguments&gt;

    &lt;/Function&gt;

    &lt;/Expression&gt;

    &lt;Expression&gt;

    &lt;Function&gt;

    &lt;FunctionName&gt;LessThanOrEquals&lt;/FunctionName&gt;

    &lt;Arguments&gt;

    &lt;Expression&gt;

    &lt;AttributeRef&gt;

    &lt;!--Created--&gt;

    &lt;AttributeID&gt;G9a9689b0-64a7-49de-abae-58b8d30322e9&lt;/AttributeID&gt;

    &lt;/AttributeRef&gt;

    &lt;/Expression&gt;

    &lt;Expression&gt;

    &lt;Literal&gt;

    &lt;DataType&gt;DateTime&lt;/DataType&gt;

    &lt;Value&gt;2006-01-01T00:00:00&lt;/Value&gt;

    &lt;/Literal&gt;

    &lt;/Expression&gt;

    &lt;/Arguments&gt;

    &lt;/Function&gt;

    &lt;/Expression&gt;

    &lt;/Arguments&gt;

    &lt;/Function&gt;

    &lt;CustomProperties&gt;

    &lt;CustomProperty Name="qd:FilterCondition" /&gt;

    &lt;CustomProperty Name="qd:Filter" /&gt;

    &lt;CustomProperty Name="qd:ContextEntityID"&gt;

    &lt;Value xsi:type="xsd:string"&gt;G066c76f8-9856-4acd-8b54-d734971da2c8&lt;/Value&gt;

    &lt;/CustomProperty&gt;

    &lt;CustomProperty Name="qd:AutoChangeBaseEntity" /&gt;

    &lt;CustomProperty Name="qd:Design"&gt;

    &lt;Value xsi:type="xsd:string"&gt;expr3&lt;/Value&gt;

    &lt;/CustomProperty&gt;

    &lt;/CustomProperties&gt;

    &lt;/Expression&gt;

    &lt;/Filter&gt;

    &lt;/Hierarchy&gt;

    &lt;/Hierarchies&gt;

    &lt;CalculatedAttributes&gt;

    &lt;Expression Name="expr3"&gt;

    &lt;Function&gt;

    &lt;FunctionName&gt;And&lt;/FunctionName&gt;

    &lt;Arguments&gt;

    &lt;Expression&gt;

    &lt;Function&gt;

    &lt;FunctionName&gt;And&lt;/FunctionName&gt;

    &lt;Arguments&gt;

    &lt;Expression&gt;

    &lt;Function&gt;

    &lt;FunctionName&gt;GreaterThanOrEquals&lt;/FunctionName&gt;

    &lt;Arguments&gt;

    &lt;Expression&gt;

    &lt;AttributeRef&gt;

    &lt;!--Created--&gt;

    &lt;AttributeID&gt;G9a9689b0-64a7-49de-abae-58b8d30322e9&lt;/AttributeID&gt;

    &lt;/AttributeRef&gt;

    &lt;/Expression&gt;

    &lt;Expression&gt;

    &lt;Literal&gt;

    &lt;DataType&gt;DateTime&lt;/DataType&gt;

    &lt;Value&gt;2005-01-01T00:00:00&lt;/Value&gt;

    &lt;/Literal&gt;

    &lt;/Expression&gt;

    &lt;/Arguments&gt;

    &lt;/Function&gt;

    &lt;/Expression&gt;

    &lt;Expression&gt;

    &lt;Function&gt;

    &lt;FunctionName&gt;LessThanOrEquals&lt;/FunctionName&gt;

    &lt;Arguments&gt;

    &lt;Expression&gt;

    &lt;AttributeRef&gt;

    &lt;!--Created--&gt;

    &lt;AttributeID&gt;G9a9689b0-64a7-49de-abae-58b8d30322e9&lt;/AttributeID&gt;

    &lt;/AttributeRef&gt;

    &lt;/Expression&gt;

    &lt;Expression&gt;

    &lt;Literal&gt;

    &lt;DataType&gt;DateTime&lt;/DataType&gt;

    &lt;Value&gt;2006-01-01T00:00:00&lt;/Value&gt;

    &lt;/Literal&gt;

    &lt;/Expression&gt;

    &lt;/Arguments&gt;

    &lt;/Function&gt;

    &lt;/Expression&gt;

    &lt;/Arguments&gt;

    &lt;/Function&gt;

    &lt;CustomProperties&gt;

    &lt;CustomProperty Name="qd:FilterCondition" /&gt;

    &lt;/CustomProperties&gt;

    &lt;/Expression&gt;

    &lt;Expression&gt;

    &lt;Null /&gt;

    &lt;CustomPropertes&gt;

    &lt;CustomProperty Name="qd:Unspecified" /&gt;

    &lt;/CustomProperties&gt;

    &lt;/Expression&gt;

    &lt;/Arguments&gt;

    &lt;/Function&gt;

    &lt;CustomProperties&gt;

    &lt;CustomProperty Name="qd:Filter" /&gt;

    &lt;CustomProperty Name="qd:ContextEntityID"&gt;

    &lt;Value xsi:type="xsd:string"&gt;G066c76f8-9856-4acd-8b54-d734971da2c8&lt;/Value&gt;

    &lt;/CustomProperty&gt;

    &lt;CustomProperty Name="qd:AutoChangeBaseEntity" /&gt;

    &lt;/CustomProperties&gt;

    &lt;/Expression&gt;

    &lt;/CalculatedAttributes&gt;

    &lt;/SemanticQuery&gt;</CommandText>

    </Query>

    <Fields>

    <Field Name="EpexReferral">

    <DataField>Epex Referral</DataField>

    </Field>

    <Field Name="Created">

    <DataField>Created</DataField>

    </Field>

    <Field Name="CloseDate">

    <DataField>Close Date</DataField>

    </Field>

    <Field Name="Patient">

    <DataField>Patient</DataField>

    </Field>

    <Field Name="expr1">

    <DataField>expr1</DataField>

    </Field>

    </Fields>

    </DataSet>

    </DataSets>

    <DataSources>

    <DataSource Name="dataSource1">

    <DataSourceReference>/Models/Mars Cutdown</DataSourceReference>

    <rd:DataSourceID>4d1edcd6-3c78-4e68-9566-ef952e495be4</rd:DataSourceID>

    </DataSource>

    </DataSources>

    <PageHeight>11in</PageHeight>

    <LeftMargin>0.5in</LeftMargin>

    <TopMargin>0.5in</TopMargin>

    <Width>7.5in</Width>

    <Body>

    <Height>0in</Height>

    <ReportItems>

    <Textbox Name="Title">

    <Left>0.5in</Left>

    <Top>0.5in</Top>

    <CanGrow>true</CanGrow>

    <Width>6.5in</Width>

    <Value />

    <Style>

    <FontFamily>Tahoma</FontFamily>

    <TextAlign>Left</TextAlign>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontWeight>Normal</FontWeight>

    <FontSize>18pt</FontSize>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    <CustomProperties>

    <CustomProperty>

    <Name>rb:Watermark</Name>

    <Value>Click to add title</Value>

    </CustomProperty>

    </CustomProperties>

    <Height>0.375in</Height>

    </Textbox>

    <Table Name="table">

    <Top>1.25in</Top>

    <Details>

    <TableRows>

    <TableRow>

    <TableCells>

    <TableCell>

    <ReportItems>

    <Textbox Name="Created_Value">

    <DataElementOutput>Output</DataElementOutput>

    <CanGrow>true</CanGrow>

    <Action>

    <Drillthrough>

    <ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>

    <Parameters>

    <Parameter Name="rs:EntityID">

    <Value>G066c76f8-9856-4acd-8b54-d734971da2c8</Value>

    </Parameter>

    <Parameter Name="rs:DrillType">

    <Value>Detail</Value>

    </Parameter>

    <Parameter Name="rs:Command">

    <Value>Drillthrough</Value>

    </Parameter>

    <Parameter Name="DrillthroughSourceQuery">

    <Value>=DataSets!dataSet.RewrittenCommandText</Value>

    </Parameter>

    <Parameter Name="DrillthroughContext">

    <Value>=CreateDrillthroughContext()</Value>

    </Parameter>

    </Parameters>

    </Drillthrough>

    </Action>

    <Value>=Fields!Created.Value</Value>

    <Styl>

    <Language>en-US</Language>

    <BorderColor>

    <Default>LightGrey</Default>

    </BorderColor>

    <BorderStyle>

    <Default>Solid</Default>

    </BorderStyle>

    <FontFamily>Tahoma</FontFamily>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontWeight>Normal</FontWeight>

    <FontSize>8pt</FontSize>

    <Format>d</Format>

    <BackgroundColor>White</BackgroundColor>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    </Textbox>

    </ReportItems>

    </TableCell>

    <TableCell>

    <ReportItems>

    <Textbox Name="CloseDate_Value">

    <DataElementOutput>Output</DataElementOutput>

    <CanGrow>true</CanGrow>

    <Value>=Fields!CloseDate.Value</Value>

    <Style>

    <Language>en-US</Language>

    <BorderColor>

    <Default>LightGrey</Default>

    </BorderColor>

    <BorderStyle>

    <Default>Solid</Default>

    </BorderStyle>

    <FontFamily>Tahoma</FontFamily>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontWeight>Normal</FontWeight>

    <FontSize>8pt</FontSize>

    <Format>d</Format>

    <BackgroundColor>White</BackgroundColor>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    </Textbox>

    </ReportItems>

    </TableCell>

    <TableCell>

    <ReportItems>

    <Textbox Name="Patient_Value">

    <DataElementOutput>Output</DataElementOutput>

    <CanGrow>true</CanGrow>

    <Action>

    <Drillthrough>

    <ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>

    <Parameters>

    <Parameter Name="rs:EntityID">

    <Value>G2ceef5ce-4e09-4806-8e8c-9a4e4e8f35fa</Value>

    </Parameter>

    <Parameter Name="rs:DrillType">

    <Value>Detail</Value>

    </Parameter>

    <Parameter Name="rs:Command">

    <Value>Drillthrough</Value>

    </Parameter>

    <Parameter Name="DrillthroughSourceQuery">

    <Value>=DataSets!dataSet.RewrittenCommandText</Value>

    </Parameter>

    <Parameter Name="DrillthroughContext">

    <Value>=CreateDrillthroughContext()</Value>

    </Parameter>

    </Parameters>

    </Drillthrough>

    </Action>

    <Value>=Fields!Patient.Value</Value>

    <Style>

    <Language>en-US</Language>

    <BorderColor>

    <Default>LightGrey</Default>

    </BorderColor>

    <BorderStyle>

    <Default>Solid</Default>

    </BorderStyle>

    <FontFamily>Tahoma</FontFamily>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontWeight>Normal</FontWeight>

    <FontSize>8pt</FontSize>

    <BackgroundColor>White</BackgroundColor>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    </Textbox>

    </ReportItems>

    </TableCell>

    </TableCells>

    <Height>0.25in</Height>

    </TableRow>

    </TableRows>

    <Grouping Name="table_EpexReferral">

    <GroupExpressions>

    <GroupExpression>=Fields!EpexReferral.Value</GroupExpression>

    </GroupExpressions>

    </Grouping>

    <Sorting>

    <SortBy>

    <SortExpression>=IIf(True, Fields!expr1.Value, Nothing)</SortExpression>

    <Direction>Descending</Direction>

    </SortBy>

    <SortBy>

    <SortExpression>=IIf(True, Fields!Created.Value, Nothing)</SortExpression>

    <Direction>Descending</Direction>

    </SortBy>

    </Sorting>

    </Details>

    <Style />

    <Width>0in</Width>

    <Height>0in</Height>

    <DataSetName>dataSet</DataSetName>

    <TableColumns>

    <TableColumn>

    <Width>0.90092in</Width>

    <Visibility>

    <Hidden>=Fields!Created.IsMissing</Hidden>

    </Visibility>

    </TableColumn>

    <TableColumn>

    <Width>1.06361in</Width>

    <Visibility>

    <Hidden>=Fields!CloseDate.IsMissing</Hidden>

    </Visibility>

    </TableColumn>

    <TableColumn>

    <Width>1.62189in</Width>

    <Visibility>

    <Hidden>=Fields!Patient.IsMissing</Hidden>

    </Visibility>

    </TableColumn>

    </TableColumns>

    <Header>

    <TableRows>

    <TableRow>

    <TableCells>

    <TableCell>

    <ReportItems>

    <Textbox Name="Created_Header">

    <CanGrow>true</CanGrow>

    <UserSort>

    <SortExpression>=Fields!Created.Value</SortExpression>

    <SortExpressionScope>table_EpexReferral</SortExpressionScope>

    </UserSort>

    <Value>Created</Value>

    <Style>

    <Language>en-US</Language>

    <BorderColor>

    <Default>LightGrey</Default>

    </BorderColor>

    <BorderStyle>

    <Default>Solid</Default>

    </BorderStyle>

    <FontFamily>Tahoma</FontFamily>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontWeight>Bold</FontWeight>

    <FontSize>8pt</FontSize>

    <BackgroundColor>#518ae5</BackgroundColor>

    <Color>White</Color>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    </Textbox>

    </ReportItems>

    </TableCell>

    <TableCell>

    <ReportItems>

    <Textbox Name="CloseDate_Header">

    <CanGrow>true</CanGrow>

    <UserSort>

    <SortExpression>=Fields!CloseDate.Value</SortExpression>

    <SortExpressionScope>table_EpexReferral</SortExpressionScope>

    </UserSort>

    <Value>Close Date</Value>

    <Style

    <Language>en-US</Language>

    <BorderColor>

    <Default>LightGrey</Default>

    </BorderColor>

    <BorderStyle>

    <Default>Solid</Default>

    </BorderStyle>

    <FontFamily>Tahoma</FontFamily>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontWeight>Bold</FontWeight>

    <FontSize>8pt</FontSize>

    <BackgroundColor>#518ae5</BackgroundColor>

    <Color>White</Color>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    </Textbox>

    </ReportItems>

    </TableCell>

    <TableCell>

    <ReportItems>

    <Textbox Name="Patient_Header">

    <CanGrow>true</CanGrow>

    <UserSort>

    <SortExpression>=Fields!Patient.Value</SortExpression>

    <SortExpressionScope>table_EpexReferral</SortExpressionScope>

    </UserSort>

    <Value>Patient</Value>

    <Style>

    <Language>en-US</Language>

    <BorderColor>

    <Default>LightGrey</Default>

    </BorderColor>

    <BorderStyle>

    <Default>Solid</Default>

    </BorderStyle>

    <FontFamily>Tahoma</FontFamily>

    <PaddingLeft>2pt</PaddingLeft>

    <PaddingBottom>2pt</PaddingBottom>

    <FontWeight>Bold</FontWeight>

    <FontSize>8pt</FontSize>

    <BackgroundColor>#518ae5</BackgroundColor>

    <Color>White</Color>

    <PaddingRight>2pt</PaddingRight>

    <PaddingTop>2pt</PaddingTop>

    </Style>

    </Textbox>

    </ReportItems>

    </TableCell>

    </TableCells>

    <Height>0.25in</Height>

    </TableRow>

    </TableRows>

    <RepeatOnNewPage>true</RepeatOnNewPage>

    <FixedHeader>true</FixedHeader>

    </Header>

    <Left>0.5in</Left>

    </Table>

    <Textbox Name="TotalRows">

    <Left>0.5in</Left>

    <Top>3in</Top>

    <CanGrow>true</CanGrow>

    <Width>6.5in</Width>

    <Value>=String.Format("Total Epex Referrals" &amp; Chr(58) &amp; " {0}", COUNTROWS("dataSet"))</Value>

    <Style>

    <PaddingLeft>3pt</PaddingLeft>

    <PaddingBottom>3pt</PaddingBottom>

    <FontWeight>Normal</FontWeight>

    <FontSize>8pt</FontSize>

    <PaddingRight>3pt</PaddingRight>

    <PaddingTop>3pt</PaddingTop>

    </Style>

    <CustomProperties>

    <CustomProperty>

    <Name>rb:SpecialContent</Name>

    <Value>TotalRows</Value>

    </CustomProperty>

    </CustomProperties>

    <Height>0.25in</Height>

    </Textbox>

    <Textbox Name="FilterDescription">

    <Left>0.5in</Left>

    <Top>3.5in</Top>

    <CanGrow>true</CanGrow>

    <Width>6.5in</Width>

    <Value>Filter: Epex Referrals with: Created from 01/01/2005 to 01/01/2006</Value>

    <Style>

    <PaddingLeft>3pt</PaddingLeft>

    <PaddingBottom>3pt</PaddingBottom>

    <FontWeight>Normal</FontWeight>

    <FontSize>8pt</FontSize>

    <PaddingRight>3pt</PaddingRight>

    <PaddingTop>3pt</PaddingTop>

    </Style>

    <CustomProperties>

    <CustomProperty>

    <Name>rb:SpecialContent</Name>

    Value>FilterDescription</Value>

    </CustomProperty>

    </CustomProperties>

    <Height>0.25in</Height>

    </Textbox>

    </ReportItems>

    <Style />

    </Body>

    <PageWidth>8.5in</PageWidth>

    </Report>

    Tuesday, June 6, 2006 8:31 AM
  • Is this error happening when you are editing report or when you are running this report? Can you save this report to report server and run it from Report Manager (http://rshost/reports)?

    Thanks!

    Tuesday, June 6, 2006 9:01 PM
  • The report executes with no problems, I only get the error if I try to change the filter.

    What is strange, I can  get around the error by apply to separate date filters, one using Greater Than Or Equal and the other Less Than or Equal.

    This gets around the problem but I would like to offer my end users the option of From and To as this is what the use in other parts of SSRS.

    Regards

    John

     

     

    Wednesday, June 7, 2006 7:49 AM
  • We have the same problem even after installing SP1 and the hotfixes. Has anybody a solution/answer?

    Regards

    Werner

    Wednesday, June 21, 2006 4:56 PM
  • This is a known issue that will be fixed in SP2. Unfortunately the only way to avoid this error for now is to change your Windows regional settings to use a 12-hour clock.
    Wednesday, June 21, 2006 5:34 PM
  • Bob,

    thanks for the immediate answer, when can we approx. expect SP2?

    Regards

    Werner

    Wednesday, June 21, 2006 5:44 PM
  • No committed dates yet, but I believe it's on track for later this year.
    Wednesday, June 21, 2006 6:57 PM
  • Bob,

    i tried to change the format in the regional settings like you said but no changes. We use a german W2003 server... When i select a date field in the report builder filter, select a date from the datetime picker (22.06.2006) and try to save it with the ok button i get a message box saying 'no valid date'...?!?

    Can i change anything in the model to solve the problem? Is this filter problem caused by SP1 (in this case we could think about setting up the SQL Server again)?

    Regards

    Werner

    Thursday, June 22, 2006 12:13 PM