Friday, February 17, 2012

Excel rendering problem(s)

I have a report containing a matrix.
The matrix cells contain a textbox with the data to display.
I need that textbox to appear only some times, so i wrote a function that
returns true or false depending on some field value that i pass as
parametter.
The report renders fine as PDF, but when i try to render it as XLS i get a
null refference error.
Does anyone know what the problem is ?
Also in another report i have 3 images in a cell (of a table or a matrix..
behave the same) and i set only one of them visible at a time based on other
fields values
in PDF also works fine, but when i try to render it in excel. Only one of
the images appear, and where the conditions call for one of the other two
images should
appear no image is visible.
The two problems might be related....
Thank you.
RazvanI had the same problem, it is a bug that Microsoft won't fix it.
Here's another one even worse, try exporting a report containing subreports
in Excel. None of the subreports will be rendered.
Needles to say all my clients want all their reports in Excel because it
allows them to easily do adhoc massages to their data.
Microsoft do you hear me, this is pretty basic stuff ! Fix it please!
Tzepesh
"Razvan Popov" wrote:
> I have a report containing a matrix.
> The matrix cells contain a textbox with the data to display.
> I need that textbox to appear only some times, so i wrote a function that
> returns true or false depending on some field value that i pass as
> parametter.
> The report renders fine as PDF, but when i try to render it as XLS i get a
> null refference error.
> Does anyone know what the problem is ?
> Also in another report i have 3 images in a cell (of a table or a matrix..
> behave the same) and i set only one of them visible at a time based on other
> fields values
> in PDF also works fine, but when i try to render it in excel. Only one of
> the images appear, and where the conditions call for one of the other two
> images should
> appear no image is visible.
> The two problems might be related....
> Thank you.
> Razvan
>
>

No comments:

Post a Comment