tags:

views:

31

answers:

1
Q: 

MicroSoft Reporting Services: hide footer depending on export format?

I'm using MicroSoft Reporting Services (MSRS) 2008. Currently I'm designing reports that can be rendered both as PDF and Exel, which works fine in general. If I define a footer in the designer, I'll see it in PDF and do not see it on the Excel sheet. Although when I print out the Excel file, the footer is there again (in the page preview also).

Is there any way to tell MSRS to hide/not include the footer if Excel is chosen as output format? I want to have it in PDF and I don't want it in Excel. Designing two reports would be a way to achieve that, but a most unconvenient one.

+1  A: 

In sql server 208 R2 you can achieve this behavior using the RenderFormat Global Variable. I don't think this is possible in prior versions.

http://blog.datainspirations.com/2010/03/03/sql-server-2008-r2-reporting-services-as-you-like-it/

JasonHorner  2010-07-22 02:48:18

related questions

How do I render a partial of a different format in Rails?
Warnings using format strings with sprintf() in C++
C++ format macro / inline ostringstream
c# Treeview Node with formatted text e.g. tabs & new lines
Format integer to string with 5 digits
What's the best 3d model format for loading and displaying inanimate textured objects in an OpenGL program?
How can I change the format of a date from the command line?
cout Formatting
In Delphi 7, how do I escape a percent sign (%) in the Format function?
Quick & Dirty way to update "IDs" in a string formatted as XML (C#)
.Net Converting a number from one culture to another
What other languages have features and/or libraries similar to Perl's format?
Setting a DBGrid column format in Delphi
How do I set the formatting of tinyMCE?
Integer formatting, padding to a given length
Automatic image format detection in PHP
Which graphic file formats are supported by browsers?
How can I convert a number to its multiple form in Perl?
Which image format is cost effective in terms of network operation for iPhone?
How does the .doc format work?
Parse DICOM files in native Python
Best Way To Format An HTML Email?
C++: how to get fprintf results as a std::string w/o sprintf
How do you typeset code elements in normal text?
Format string to title case