09-10-2015 11:58 AM
I have this crosstab report which runs into numerous rows. i have a requirement to export the crosstab report data into PDF. While I tried doing the same, I found that only the content which is visible over screen gets exported in PDF and rest all data gets clipped off. Is there a limitation in SAS VA v7.1, to export crosstab report content to PDF? Is there any work around how I can overcome this and have all the content exported in PDF.
09-10-2015 03:57 PM
01-04-2016 04:27 AM
Thanks for your comments. Please, how can i export to Ms-Excel from a report Visualization? The users are using the browser and we need export a Table to Ms.Excel.
01-04-2016 09:04 AM
This topic in the user's guide covers exporting a table in a report to excel:
I hope that helps,
01-04-2016 09:14 AM
Perfect but it's possible using Report Viewer (without addin Office Analytics)? We now we can create a PDF but I need export a table from Report Viewer to Ms-Excel and we don't have SAS OA.
01-04-2016 05:04 PM
You can use the classic version of the SAS Visual Analytics Viewer in 7.2 and 7.3 to export data and images. See the Open a Report in the Classic Viewer topic in the SAS Visual Analytics User's Guide. There's a limitation with the modern viewer in 7.2 and 7.3, so you can't use it to export data or images.
09-14-2015 10:20 AM
I've had the same issue of print to PDF being bizarrely limited to a single page. One workaround is to select a larger paper size in the 'Print to PDF' options - more will fit on a sheet of A3 than a sheet of A4, for example, though if you then print that on A4 then it will obviously be smaller.
Otherwise it looks like 7.3 fixes this:
"The new feature in SAS Visual Analytics Designer is a new Expand clipped content option, which is available for printing to PDF. This option enables you to print the entire content of tables, crosstabs, gauges, and containers with content that is only partially available in the layout of the report section."
I'm trying to arrange a demo of this to make sure it does what it sounds like - seems worth checking before upgrading, since print to PDF in 7.2 and earlier doesn't work as I expected.
03-30-2016 06:11 AM
Hello Dears ,
how can you solve this problem ??
I Have atable with 32,000 and i want to export all data to pdf ?? Only one page exported to pdf
any solution ??
Thanks & Regards ,
03-30-2016 06:38 AM
This appears to be a new question and unrelated to the existing thread. If it is a new question, please create a New Message (click on the blue New Message button on the top left) and delete it from this post.
In your question, please elaborate what you are doing and what you are wanting to achieve. Are you using SAS Visual Analytics and if so, what version. Are you using a table object that you want to export from? Or are you programming in SAS and wanting to export your table to pdf? Is it your expectation that the entire 32,000 rows (or it is cells) appear on 1 pdf page?
With further explaination on your requirements (with screenshots), the community will be in a better position to help answer your question.
09-18-2015 08:43 AM
Even I am facing the same issue at client side.
So we found a way to resolve this issue within same VA version by using "SAS Excel Add-On".
If you have above mentioned Add on in your order, you can install and open your VA reports as it is in excel and save it as pdf.
As other members said, it's a limitation of SAS VA 7.1 and resolved in 7.3.