Report Parameters - can you export to Excel

When I export my report to Excel I would also like it to carry the
report parameters with it - put it up the top or on a separate sheet.
Is this possible?
PhilYou can in your report designer.
Add a Table header.
And then go to Expressions -> parameters => and place them|||Hi Phil,
what we do is put a table of the parameters at the top of a report and
hide it with a toggle button at the top...our standard report designs
include a set of toggle buttons at the top to toggle visible/invisible
sections of the reports...so we might have 2 or 4 charts and then 2 or
4 tables on the report which are all rendered but some are
hidden...then by pressing the tabs they appear/disappear...this closely
emulates the excel worksheets for reports and the business objects
worksheets......if we went further we could appear/disappear sets of
reports based on toggle buttons...
We wanted the parameters on the top of the report because when it is
printed you need the parameters to tell you what you are looking
at....and of course, when you export to excel all this stuff goes into
the workbook.
Though I have noticed the colours do not translate very well into
workbook..red turns into a horrible grey colour so far...though I am
sure htat will be fixed...
Peter|||thanks. Not ideal because then they effectively show twice in the main
report viewer but at least they go into the report.
thanks again|||good idea - i might try that
thanks|||sorry, not clear who i was replying to - first reply to first one,
second to second etc|||Hi Phil,
yes, we default them hidden on the report so the user does not see them
unless he/she specifically opens the parameters as he/she would do if
he/she wanted to print the report.
The interesting thing was that when sent to excel the hidden portions
of the report are always sent....I mean, that;s the most sensible
thing to do, but it is not always the case that programmers do the most
sensible thing..LOL!!
We quite like this style of solution or presenting the parameters...if
you come up with something better let us know!!!
Best Regards
Peter Nolan
www.peternolan.com