Export crosstab report data to PDF using SAS VA v7.1

[Sanjay_Shukla]

Hi Team,

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.

Many Thanks.

Sanjay.

[Sam_SAS]

Hi Sanjay,

The PDF created from VA will only contain the part of the crosstab (or list table) that is currently visible.

A possible workaround would be to export the crosstab data to Excel format and print from a third party program (such as Excel).

There may be other options, hopefully other users can offer some advice.

Thanks,
Sam

[LluisPiqueras]

Dear Sam,

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.

Best regards

Lluis

[Sam_SAS]

Hello Lluis,

This topic in the user's guide covers exporting a table in a report to excel:

https://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p0e7gix09rfudzn1w55f...

I hope that helps,

Sam

[LluisPiqueras]

Hi Sam,
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.

Best regards

Lluís

[Sam_SAS]

Sorry, I believe you can only export from the report designer.

[Joy_SAS]

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.

-Joy

[Jaaake]

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.

[Sam_SAS]

Jaaake is correct, the "Expand Clipped Content" option in 7.3 adds the functionality you are looking for.

[TejaSurapaneni]

Hello Jaaake and Sam,

It sounds Good, really i am so excited to work on SAS VA - 7.3.....

Thanks & Regards,

Teja Surapaneni.

[Mohamed-Salem]

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 ,

Mohamed Salem 

[MichelleHomes]

Hi @Mohamed-Salem,

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.

Kind Regards,

Michelle

[Mohamed-Salem]

HI Michelle,
Thanks for your Replay , I have Created a new Message .
thanks for your advise

Regards,
Mohamed Salem

[parth_patel]

Hi Sanjay,

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.

Regards,
Parth Patel