Though it has been well-documented in the community since SP1 was released, I'd like to reiterate that many of us are having critical issues related to element hiding and excel export.
I, for one, have built a highly dynamic reporting system that relies heavily on the use visibility for showing/hiding subreports. My users require export to excel.
The question to Microsoft is: Can you fix this issue that was introduced in SP1? Please provide us with an SP1a update that will allow elements to be hidden & thus NOT show up in the excel export...just as it works in the HTML & PDF renderings.
Regards,
Todd SmartIt may be too much work to "re-tool", but have you considered DTS services?
However, I too, am waiting for a fix on Excel exporting!
-KB
"Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
> Though it has been well-documented in the community since SP1 was
released, I'd like to reiterate that many of us are having critical issues
related to element hiding and excel export.
> I, for one, have built a highly dynamic reporting system that relies
heavily on the use visibility for showing/hiding subreports. My users
require export to excel.
> The question to Microsoft is: Can you fix this issue that was introduced
in SP1? Please provide us with an SP1a update that will allow elements to
be hidden & thus NOT show up in the excel export...just as it works in the
HTML & PDF renderings.
>
> Regards,
> Todd Smart|||I'm not sure what you want us to do. You would rather have items that are
hidden and can never be toggled?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
> Though it has been well-documented in the community since SP1 was
> released, I'd like to reiterate that many of us are having critical issues
> related to element hiding and excel export.
> I, for one, have built a highly dynamic reporting system that relies
> heavily on the use visibility for showing/hiding subreports. My users
> require export to excel.
> The question to Microsoft is: Can you fix this issue that was introduced
> in SP1? Please provide us with an SP1a update that will allow elements to
> be hidden & thus NOT show up in the excel export...just as it works in the
> HTML & PDF renderings.
>
> Regards,
> Todd Smart|||Hi Brian,
If I have a subreport (or any other element for that matter) that is hidden due to an expression result of [True], that subreport should not be rendered in the Excel export. It should not even have an Excel cell associated with it.
In other words, I would want the render of Excel to work just like the HTML & PDF render works...and how it worked prior to SP1.
Regards,
Todd
"Brian Welcker [MSFT]" wrote:
> I'm not sure what you want us to do. You would rather have items that are
> hidden and can never be toggled?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
> news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
> > Though it has been well-documented in the community since SP1 was
> > released, I'd like to reiterate that many of us are having critical issues
> > related to element hiding and excel export.
> >
> > I, for one, have built a highly dynamic reporting system that relies
> > heavily on the use visibility for showing/hiding subreports. My users
> > require export to excel.
> >
> > The question to Microsoft is: Can you fix this issue that was introduced
> > in SP1? Please provide us with an SP1a update that will allow elements to
> > be hidden & thus NOT show up in the excel export...just as it works in the
> > HTML & PDF renderings.
> >
> >
> > Regards,
> >
> > Todd Smart
>
>|||OK, we'll take a look at this and if it is a regression, we will fix it in
SP2.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
news:423C4612-1C70-4178-9DCA-321019F859E0@.microsoft.com...
> Hi Brian,
> If I have a subreport (or any other element for that matter) that is
> hidden due to an expression result of [True], that subreport should not be
> rendered in the Excel export. It should not even have an Excel cell
> associated with it.
> In other words, I would want the render of Excel to work just like the
> HTML & PDF render works...and how it worked prior to SP1.
>
> Regards,
> Todd
> "Brian Welcker [MSFT]" wrote:
>> I'm not sure what you want us to do. You would rather have items that are
>> hidden and can never be toggled?
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
>> news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
>> > Though it has been well-documented in the community since SP1 was
>> > released, I'd like to reiterate that many of us are having critical
>> > issues
>> > related to element hiding and excel export.
>> >
>> > I, for one, have built a highly dynamic reporting system that relies
>> > heavily on the use visibility for showing/hiding subreports. My users
>> > require export to excel.
>> >
>> > The question to Microsoft is: Can you fix this issue that was
>> > introduced
>> > in SP1? Please provide us with an SP1a update that will allow elements
>> > to
>> > be hidden & thus NOT show up in the excel export...just as it works in
>> > the
>> > HTML & PDF renderings.
>> >
>> >
>> > Regards,
>> >
>> > Todd Smart
>>|||Brian, are there any work arounds ? I am also finding that visible tables are
not being displayed in the export to excel, and the start of the table data
appears several rows down (80 rows) .
Regards
Stuart
"Brian Welcker [MSFT]" wrote:
> OK, we'll take a look at this and if it is a regression, we will fix it in
> SP2.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
> news:423C4612-1C70-4178-9DCA-321019F859E0@.microsoft.com...
> > Hi Brian,
> >
> > If I have a subreport (or any other element for that matter) that is
> > hidden due to an expression result of [True], that subreport should not be
> > rendered in the Excel export. It should not even have an Excel cell
> > associated with it.
> >
> > In other words, I would want the render of Excel to work just like the
> > HTML & PDF render works...and how it worked prior to SP1.
> >
> >
> > Regards,
> >
> > Todd
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> I'm not sure what you want us to do. You would rather have items that are
> >> hidden and can never be toggled?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
> >> news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
> >> > Though it has been well-documented in the community since SP1 was
> >> > released, I'd like to reiterate that many of us are having critical
> >> > issues
> >> > related to element hiding and excel export.
> >> >
> >> > I, for one, have built a highly dynamic reporting system that relies
> >> > heavily on the use visibility for showing/hiding subreports. My users
> >> > require export to excel.
> >> >
> >> > The question to Microsoft is: Can you fix this issue that was
> >> > introduced
> >> > in SP1? Please provide us with an SP1a update that will allow elements
> >> > to
> >> > be hidden & thus NOT show up in the excel export...just as it works in
> >> > the
> >> > HTML & PDF renderings.
> >> >
> >> >
> >> > Regards,
> >> >
> >> > Todd Smart
> >>
> >>
> >>
>
>
