Wednesday, February 15, 2012

Excel ouput

Hi All,
I have a requirement where I need to create a report book (7 reports) making
use of RS. The challenge is that the client need this in excel. A button on
the intranet must generate the excel output.
Has anyone done something like this as I can't find any docs on RS and excel
output.
1. When generating an excel file from RS does it xls keep formulas
2. Can each sheet be a different report (sheet name must be report name)
3. Limitations'
Any help appreciated!
ThanksExcel isn't a database reporting tool
Tell them to screw themselves.
-Aaron
Dewald wrote:
> Hi All,
> I have a requirement where I need to create a report book (7 reports) making
> use of RS. The challenge is that the client need this in excel. A button on
> the intranet must generate the excel output.
> Has anyone done something like this as I can't find any docs on RS and excel
> output.
> 1. When generating an excel file from RS does it xls keep formulas
> 2. Can each sheet be a different report (sheet name must be report name)
> 3. Limitations'
> Any help appreciated!
> Thanks|||Hi Dewald,
The known issue I know of is if you have a complex design in RS, in
Excel cells will have been merged and once that is done, the row size
will not want to expand to the appropriate (considering the text in it
would require so.)
Cheers
Dewald a =E9crit :
> Hi All,
> I have a requirement where I need to create a report book (7 reports) mak=ing
> use of RS. The challenge is that the client need this in excel. A button =on
> the intranet must generate the excel output.
> Has anyone done something like this as I can't find any docs on RS and ex=cel
> output.
> 1. When generating an excel file from RS does it xls keep formulas
> 2. Can each sheet be a different report (sheet name must be report name)
> 3. Limitations'
> > Any help appreciated!
> Thanks|||Hi,
Thanks for the reply
Yes,the more complex the look and feel is the less desired output you will
get in XSL.
I have managed to created XSL outputs from a hyperlink in a simple HTML page
that generates a XLS file and add different reports on seperate sheets
If anyone is interested on how to do this let me know...
I also found this site helpfull
http://msdn2.microsoft.com/en-us/library/ms156268.aspx
Thanks for the reply
Cheers
"Sébastien Richer" wrote:
> Hi Dewald,
> The known issue I know of is if you have a complex design in RS, in
> Excel cells will have been merged and once that is done, the row size
> will not want to expand to the appropriate (considering the text in it
> would require so.)
> Cheers
> Dewald a écrit :
> > Hi All,
> >
> > I have a requirement where I need to create a report book (7 reports) making
> > use of RS. The challenge is that the client need this in excel. A button on
> > the intranet must generate the excel output.
> >
> > Has anyone done something like this as I can't find any docs on RS and excel
> > output.
> >
> > 1. When generating an excel file from RS does it xls keep formulas
> > 2. Can each sheet be a different report (sheet name must be report name)
> > 3. Limitations'
> >
> > Any help appreciated!
> > Thanks
>

No comments:

Post a Comment