Export to Excel
-
Hi. I have searched this forum and there are quite a few posts related to how Reporting Services exports report format into excel.
I have a Sales Invoice report that end users wish to manipulate in excel.
Originally the export returned 'Data Regions within table/matrix cells are ignored'. To resolve this I moved tables nested within tables.
The report footer contains text + Report Totals + Page Number.
When exported to excel the footer is only viewable via 'Print Preview' as the datat is exported to the Header Footer. However not all the footer data is exported. The Report Totals are missing + the data that is exported to the Header Footer loses its formatting (continous string, no carriage returns). I believe there is a limitation of 255 characters for excel Header Footer.
Not sure there is a resolution. Does anyone know of any third part apps that may help?
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
-
Thanks I will check it out. How would the end user use the tool as at present they simply select the report they wish to run, once rendered thet choose export to excel option. Where does RAQ fit in?
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
-
Q1: Does RAQ Report support Solaris/Unix/Linux?
RAQ Report Server is developed by Java, so it is platform independent and support all Solaris, Unix and Linux. RAQ Report IDE only support Windows for now.
Q2: What technical support methods do you offer?
Remote support and technical support forum, please refer to Technical Support Forum.
Q3: How can I find solutions to my business?
Please contact our sales, sales@raqsoft.com for more details.
Q4: Do I have to install a web server or java environment on my computer?
No, the RAQ Report installer package will install them on your computer automatically.
Q5: What is the report format generated by RAQ Report?
The report generate by RAQ Report is .raq file, and it is RAQSOFT’s own format.
Q6: What data sources does RAQ Report support?
RAQ Report support JDBC2.0 and higher versions of relational database, such as Oracle, SQL Server, Sybase,DB2, Informix etc, it also support XML, file system, Java object etc.
Q7: Does RAQ Report support pure Html browse pattern?
RAQ Report support two browse patterns, Swing and pure Html.
Q8: Does RAQ Report have any specific requirement on the computer?
CPU: minimum 1.8 GHz
Memory: minimum 512MB, recommend 1G
Hard Disk: minimum 300MB
OS: Windows2000/XP/Vista and Linux/Unix
It's from http://www.raqsoft.com/. If you want to know more, you can ask RAQ Report's technical support:support@raqsoft.com or call +86 10 51668441.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply