Exporting to Excel

I am having problems exporting to excel. When I try to export a report from
the SQL Server Reporting Services website the conditional color formating
doesn't come acrost. The nonconditional color formating comes acrost just
fine. If I try to export the same report from Visual Studio the formaing
exports just fine. What am I doing wrong or how can i get this to work.I read somewhere (though I can't remember where) that not all colours will
export to excel. Try changing the colour you are using for your conditional
hilighting to the same colour as that which you already have displayed in
excel. All my conditional colours display fine - though I don't have any
non-conditional colours if that makes sense.
"KO" wrote:
> I am having problems exporting to excel. When I try to export a report from
> the SQL Server Reporting Services website the conditional color formating
> doesn't come acrost. The nonconditional color formating comes acrost just
> fine. If I try to export the same report from Visual Studio the formaing
> exports just fine. What am I doing wrong or how can i get this to work.|||I've came across this issue recently. It not necessarily that the colors
don't come across. In the process formulas/functions are converted to an
Excel equivalent if one is found. The formulas/functions that get translated
are those that use report item expressions, not field expressions.
Otherwise, the result of the expression is stored in a cell as a constant
value.
For example, if a textbox contains an expression like
=Sum(Fields!UnitPrice.Value * Fields!OrderQty.Value) there is no equivalent
to that in Excel. So if you are using an IIF function in the color property
and your doing a test on a field: =IIF(Fields!UnitPrice.Value > 1500, Red,
Black) Excel doesn't know how to translate the Field expression. So it goes
with the first color Red and all the values in that column come out red.|||Hi russsage,
i've the same issue but i refer to ReportITems and not to Field...
can you give me some more tips?
Many thanks
"russsage" wrote:
> I've came across this issue recently. It not necessarily that the colors
> don't come across. In the process formulas/functions are converted to an
> Excel equivalent if one is found. The formulas/functions that get translated
> are those that use report item expressions, not field expressions.
> Otherwise, the result of the expression is stored in a cell as a constant
> value.
> For example, if a textbox contains an expression like
> =Sum(Fields!UnitPrice.Value * Fields!OrderQty.Value) there is no equivalent
> to that in Excel. So if you are using an IIF function in the color property
> and your doing a test on a field: =IIF(Fields!UnitPrice.Value > 1500, Red,
> Black) Excel doesn't know how to translate the Field expression. So it goes
> with the first color Red and all the values in that column come out red.|||I also had a color problem and hide/visible problem when exporting to excel.
I found that you must surround your settings in quotes otherwise you can get
unexpected results...
=IIF(Fields!UnitPrice.Value > 1500, "Red", "Black")
I have even had to set a standard value like this ="Visible". I know it
sounds wierd but it has worked in some instances for me.
Also... ditto on the color translation to excel. If the color is not in your
default excel palette then excel will mangle it and try to set it to the
nearest color. Some of my red shades end up as purple in excel. It can make
a nice report in RS look very ugly in excel.
Bill
russsage wrote:
>I've came across this issue recently. It not necessarily that the colors
>don't come across. In the process formulas/functions are converted to an
>Excel equivalent if one is found. The formulas/functions that get translated
>are those that use report item expressions, not field expressions.
>Otherwise, the result of the expression is stored in a cell as a constant
>value.
>For example, if a textbox contains an expression like
>=Sum(Fields!UnitPrice.Value * Fields!OrderQty.Value) there is no equivalent
>to that in Excel. So if you are using an IIF function in the color property
>and your doing a test on a field: =IIF(Fields!UnitPrice.Value > 1500, Red,
>Black) Excel doesn't know how to translate the Field expression. So it goes
>with the first color Red and all the values in that column come out red.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1