New SP2 Excel Render Bug (Excel Formulas)

Hi,
I have a report that converts expression to Excel formulas. The Excel
formulas in a table are incorrectly rendered in a way that the references
are all off by 6 or so cells. When I set the "Omit Formulas" device setting
to true the values are correct, though there are no formulas. I don't
remember this failure in SP1.
Thanks,
Bryan
PS. Is there a way to make "OmitFormulas=true" static when the request is
made from the report manager?BTW, This bug only happens when requesting the render from the report
server. It doesn't happen in VS.NET.
"BDB" <reply@.to.group.com> wrote in message
news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have a report that converts expression to Excel formulas. The Excel
> formulas in a table are incorrectly rendered in a way that the references
> are all off by 6 or so cells. When I set the "Omit Formulas" device
> setting to true the values are correct, though there are no formulas. I
> don't remember this failure in SP1.
> Thanks,
> Bryan
> PS. Is there a way to make "OmitFormulas=true" static when the request is
> made from the report manager?
>|||Setting the DeviceInfo defaults has been added in SQL 2005 RS but is not
available with SQL 2000. As for the bug, nothing has changed in this area so
I would imagine it happened with SP1 as well.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"BDB" <reply@.to.group.com> wrote in message
news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
> BTW, This bug only happens when requesting the render from the report
> server. It doesn't happen in VS.NET.
> "BDB" <reply@.to.group.com> wrote in message
> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The Excel
>> formulas in a table are incorrectly rendered in a way that the references
>> are all off by 6 or so cells. When I set the "Omit Formulas" device
>> setting to true the values are correct, though there are no formulas. I
>> don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the request
>> is made from the report manager?
>|||No, I've tested both ways. This bug was introduced in SP2.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:ePzjhGpSFHA.2324@.TK2MSFTNGP10.phx.gbl...
> Setting the DeviceInfo defaults has been added in SQL 2005 RS but is not
> available with SQL 2000. As for the bug, nothing has changed in this area
> so I would imagine it happened with SP1 as well.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "BDB" <reply@.to.group.com> wrote in message
> news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
>> BTW, This bug only happens when requesting the render from the report
>> server. It doesn't happen in VS.NET.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The Excel
>> formulas in a table are incorrectly rendered in a way that the
>> references are all off by 6 or so cells. When I set the "Omit Formulas"
>> device setting to true the values are correct, though there are no
>> formulas. I don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the request
>> is made from the report manager?
>>
>|||Can you post or send me your RDL (remove the online. part in my e-mail
address)?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"BDB" <reply@.to.group.com> wrote in message
news:uFBYKQqSFHA.3552@.TK2MSFTNGP10.phx.gbl...
> No, I've tested both ways. This bug was introduced in SP2.
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:ePzjhGpSFHA.2324@.TK2MSFTNGP10.phx.gbl...
>> Setting the DeviceInfo defaults has been added in SQL 2005 RS but is not
>> available with SQL 2000. As for the bug, nothing has changed in this area
>> so I would imagine it happened with SP1 as well.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
>> BTW, This bug only happens when requesting the render from the report
>> server. It doesn't happen in VS.NET.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The Excel
>> formulas in a table are incorrectly rendered in a way that the
>> references are all off by 6 or so cells. When I set the "Omit
>> Formulas" device setting to true the values are correct, though there
>> are no formulas. I don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the request
>> is made from the report manager?
>>
>>
>|||Sure. Thank you.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%2376cRJrSFHA.3300@.TK2MSFTNGP10.phx.gbl...
> Can you post or send me your RDL (remove the online. part in my e-mail
> address)?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "BDB" <reply@.to.group.com> wrote in message
> news:uFBYKQqSFHA.3552@.TK2MSFTNGP10.phx.gbl...
>> No, I've tested both ways. This bug was introduced in SP2.
>>
>> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> news:ePzjhGpSFHA.2324@.TK2MSFTNGP10.phx.gbl...
>> Setting the DeviceInfo defaults has been added in SQL 2005 RS but is not
>> available with SQL 2000. As for the bug, nothing has changed in this
>> area so I would imagine it happened with SP1 as well.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
>> BTW, This bug only happens when requesting the render from the report
>> server. It doesn't happen in VS.NET.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The Excel
>> formulas in a table are incorrectly rendered in a way that the
>> references are all off by 6 or so cells. When I set the "Omit
>> Formulas" device setting to true the values are correct, though there
>> are no formulas. I don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the
>> request is made from the report manager?
>>
>>
>>
>|||This issue was resolved by rebuilding and redeploying the RDL.
Much thinks to Brian Welcker for his help.
Bryan
"BDB" <reply@.to.group.com> wrote in message
news:OZrPaFzSFHA.3308@.TK2MSFTNGP14.phx.gbl...
> Sure. Thank you.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%2376cRJrSFHA.3300@.TK2MSFTNGP10.phx.gbl...
>> Can you post or send me your RDL (remove the online. part in my e-mail
>> address)?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:uFBYKQqSFHA.3552@.TK2MSFTNGP10.phx.gbl...
>> No, I've tested both ways. This bug was introduced in SP2.
>>
>> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> news:ePzjhGpSFHA.2324@.TK2MSFTNGP10.phx.gbl...
>> Setting the DeviceInfo defaults has been added in SQL 2005 RS but is
>> not available with SQL 2000. As for the bug, nothing has changed in
>> this area so I would imagine it happened with SP1 as well.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
>> BTW, This bug only happens when requesting the render from the report
>> server. It doesn't happen in VS.NET.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The
>> Excel formulas in a table are incorrectly rendered in a way that the
>> references are all off by 6 or so cells. When I set the "Omit
>> Formulas" device setting to true the values are correct, though there
>> are no formulas. I don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the
>> request is made from the report manager?
>>
>>
>>
>>
>