Extra columns in Excel with SP2

I would like to upgrade to Reporting Services service pack 2 so that I can
specify report colours and specify to move the header into Excel's header.
However when we upgrade to Service Pack 2 it causes extra totals columns to
appear at the end of the months in the generated reports. These columns
could possibly acceptable if they were titled as Total however they are not.
Can anybody make any suggestions in how to generate the report in excel
without the additional columns appearing in the excel output? Many thanks.Does anybody have any ideas about how to do this - any guesses even would be
appreciated. Thanks
"Nicola Jones" wrote:
> I would like to upgrade to Reporting Services service pack 2 so that I can
> specify report colours and specify to move the header into Excel's header.
> However when we upgrade to Service Pack 2 it causes extra totals columns to
> appear at the end of the months in the generated reports. These columns
> could possibly acceptable if they were titled as Total however they are not.
> Can anybody make any suggestions in how to generate the report in excel
> without the additional columns appearing in the excel output? Many thanks.

Expression for Jump to Report

Hi Experts,
Can anyone tell me how to specify an expression to be mentioned in the "Jump
to Report" in the Navigation tab. I basically dont want the hyperlink for
some values.
= iif( Fields!ItemCount.Value = 0, "", "Detail")
this is the expression which I have currently given. I dont want the
hyperlink when the ItemCount = 0. But now it points to the same page since I
have given empty string. How can I handle this.
Thanks in Advance
GaneshHi,
Instead of empty string just put "Nothing" word. This will solve your problem.
Regards
Amarnath
"Ganesh Ramamurthy" wrote:
> Hi Experts,
> Can anyone tell me how to specify an expression to be mentioned in the "Jump
> to Report" in the Navigation tab. I basically dont want the hyperlink for
> some values.
> = iif( Fields!ItemCount.Value = 0, "", "Detail")
> this is the expression which I have currently given. I dont want the
> hyperlink when the ItemCount = 0. But now it points to the same page since I
> have given empty string. How can I handle this.
> Thanks in Advance
> Ganesh
>
>|||Thanx Amar for the reply,
i tried that = iif( Fields!ItemCount.Value = 0, "Nothing", "Detail")...
I get the following error
The item '/Reports/Nothing' cannot be found. (rsItemNotFound)
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:3FEC77CE-9386-48E4-87CB-171F9EBBC053@.microsoft.com...
> Hi,
> Instead of empty string just put "Nothing" word. This will solve your
> problem.
> Regards
> Amarnath
> "Ganesh Ramamurthy" wrote:
>> Hi Experts,
>> Can anyone tell me how to specify an expression to be mentioned in the
>> "Jump
>> to Report" in the Navigation tab. I basically dont want the hyperlink for
>> some values.
>> = iif( Fields!ItemCount.Value = 0, "", "Detail")
>> this is the expression which I have currently given. I dont want the
>> hyperlink when the ItemCount = 0. But now it points to the same page
>> since I
>> have given empty string. How can I handle this.
>> Thanks in Advance
>> Ganesh
>>|||Amar..
Sorry for the Previous reply...now it is working correct...I had put Nothing
in quotes...
now it is working fine...quite a long time since worked in VB...
Thanks again
Ganesh
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:3FEC77CE-9386-48E4-87CB-171F9EBBC053@.microsoft.com...
> Hi,
> Instead of empty string just put "Nothing" word. This will solve your
> problem.
> Regards
> Amarnath
> "Ganesh Ramamurthy" wrote:
>> Hi Experts,
>> Can anyone tell me how to specify an expression to be mentioned in the
>> "Jump
>> to Report" in the Navigation tab. I basically dont want the hyperlink for
>> some values.
>> = iif( Fields!ItemCount.Value = 0, "", "Detail")
>> this is the expression which I have currently given. I dont want the
>> hyperlink when the ItemCount = 0. But now it points to the same page
>> since I
>> have given empty string. How can I handle this.
>> Thanks in Advance
>> Ganesh
>>

expoting data from reporting srvcs to PDF

Hi,
I am trying to export a report to pdf and it does not keep all teh
columsn in the same page. I could not find any options to specify. Has
faced the same problem?
JaideepCheck the margins in the Report properties, layout tab. Also the page width
and Page height. FYI for Portrait Page width must be 21cm and Height 29,7cm.
For landscape the opposite.
"jai" wrote:
> Hi,
> I am trying to export a report to pdf and it does not keep all teh
> columsn in the same page. I could not find any options to specify. Has
> faced the same problem?
> Jaideep
>