all groups > sql server reporting services > april 2005 >
You're in the

sql server reporting services

group:

Excel rendering problem(s)


RE: Excel rendering problem(s) Tzepesh
4/22/2005 10:44:06 AM
sql server reporting services:
I 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


[quoted text, click to view]
Excel rendering problem(s) Razvan Popov
4/22/2005 5:44:42 PM
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

AddThis Social Bookmark Button