topic Re: Printing to PDF in 7.3 in SAS Visual Analytics

Printing to PDF in 7.3

RichardPaterson — Sat, 19 Sep 2015 15:09:05 GMT

Hello,

Can anyone share some experiences with printing to PDF in 7.3? We have 7.1 and have some wide reports which are being truncated during the print to PDF. I am hoping this is improved in 7.3.

regards,

RIchard

Re: Printing to PDF in 7.3

MichelleHomes — Sat, 19 Sep 2015 18:32:59 GMT

Hi Richard,

There was a recent discussion on this at https://communities.sas.com/t5/SAS-Visual-Analytics/Export-crosstab-report-data-to-PDF-using-SAS-VA-v7-1/m-p/224984#U224984 where the "Expand clipped content option" seems to be what your after.

Did you search the community before posting a question? This is a good first step as @BeverlyBrown suggests at https://communities.sas.com/t5/Getting-Started/How-to-get-fast-helpful-answers/ta-p/226133

Kind Regards,

Michelle

Re: Printing to PDF in 7.3

RichardPaterson — Mon, 21 Sep 2015 06:41:50 GMT

Michelle,

thanks for your input. Yes I am aware of this feature in 7.3. However I am looking for someone who has actually used it in 7.3 and can share their experiences. In the discussion you refer to, the best I can assess is that "it seems" to solve the issue. Seeing is believing 😉

kind regards,

Richard

Re: Printing to PDF in 7.3

Sam_SAS — Mon, 21 Sep 2015 13:50:24 GMT

Hi Richard,

When you enable the Expand Clipped Content option, large objects are handled as follows:

1. Any expanded report objects that are too big for the page are shown in truncated form, with a link to a full version at the end of the report.

2. A complete, expanded version of any objects that were too big is placed at the end of the report. (Note: Crosstabs are limited to 5,000 cells)

3. Each expanded object is placed on a single page in the PDF, so if they are very large (for example, a crosstab with thousands of cells) they might print very small if you print to a standard paper size. However, in Acrobat (not the browser plugin, I find) you can print as "Poster" to span the objects across multiple standard pages. In some versions of Acrobat there might be a "Tile Large Pages" option instead.

As an additional note, the Expand clipped content option uses the current state of any hierarchies in your object (whether the hierarchy is expanded, collapsed, or drilled). If you want to fully expand a hierarchy, right-click the hierarchy name and then select Expand <hierarchy-name>

There's a little more about the option here:

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

I attached a simple demo PDF to give you an idea how it works.

I hope that helps,

Sam

Re: Printing to PDF in 7.3

RichardPaterson — Sat, 26 Sep 2015 09:02:37 GMT

Thanks for the example. Playing with the paper sizes seems like a workaround. I hope to have 7.3 installed soon so I can play around with this.

regards,

Richard

Re: Printing to PDF in 7.3

Carrot17 — Tue, 05 Apr 2016 01:15:35 GMT

Hi,

We are facing print issue. The client wants to print a multiple charts on 1 page. But we noticed that the sas va 7.1 print to pdf is just like a screenshot only and also the custom graphs were not able to print even there's data when running in I.E or google. Any solutions or document to code the print to pdf? Thank you.

Best Regards,
Carrot17

Re: Printing to PDF in 7.3

Sam_SAS — Tue, 05 Apr 2016 15:15:29 GMT

Hi Carrot,

Can you clarify the problem you are having? What do you mean when you say that the print is like a screenshot?

Also, what custom graphs are not printing for you? I did a quick test in 7.1 and was able to print a butterfly chart.

Thanks,
Sam

Re: Printing to PDF in 7.3

Carrot17 — Wed, 06 Apr 2016 02:29:57 GMT

Hi Sam,

Thanks for the response. Yah, what I mean with "like a screenshot" is it seems like Snipping tool kinda. The only difference with snipping tool is snipping tool is need to select the screen while in sas when we click print-to-pdf it only print the current screen.

All our custom graphs are not able to print. Like custom graph with combination of line and bar chart, combination of multiple bar charts, custom butterfly chart etc.. When I print-to-pdf we got this warning message: "the server did not understand the application request for data".

I tried as well the sas default butterfly chart and it able to print. Only the custom graph cannot. And the requirements is to print all charts on 1 page. Thanks again.

Best Regards,
Carrot17

Re: Printing to PDF in 7.3

Sam_SAS — Wed, 06 Apr 2016 13:35:38 GMT

When you print a graph that has scroll bars, only the part of the graph that is currently visible is printed.

I made a custom graph with a combination of line and bar chart and it was able to print. Can you test printing your custom graphs with a different, simple data set?

About printing everything on 1 page -- in the report, are all of the charts in the same section? It is difficult to put 12-16 charts in the same section, but I was able to get 12 charts in the same PDF page in VA 7.1 (see attached.)

Re: Printing to PDF in 7.3

Carrot17 — Wed, 06 Apr 2016 13:51:02 GMT

Thanks Sam. I will try to create custom graph with simple data set and will let you know.

Can you share with us how did you do to print the 12 graphs on 1 page using VA7.1?

Regards,
Carrot17

Re: Printing to PDF in 7.3

Sam_SAS — Wed, 06 Apr 2016 14:01:24 GMT

I just dragged all of the graphs into the same section. You can drag a new object to the right edge of an existing object to place it to the right in a new column, or to the bottom edge to place it below in a new row.

In my opinion the graphs do not respond well to being crowded to this extent and they become difficult to read.

Re: Printing to PDF in 7.3

Carrot17 — Wed, 06 Apr 2016 14:04:50 GMT

That's what I did. Or maybe our dashboards are crowded because our dashboards have 6 controls on the left.

Best Regards,
Carrot17

Re: Printing to PDF in 7.3

Carrot17 — Wed, 06 Apr 2016 14:06:23 GMT

May I know what pdf version do you use?

Re: Printing to PDF in 7.3

Sam_SAS — Wed, 06 Apr 2016 14:21:15 GMT

It is conceivable that the controls are the issue. Can you try with no controls?

I built the PDF from VA 7.1, the build date is 17SEP2014.

I have Acrobat 11.0.13 but I don't think that should matter.

Re: Printing to PDF in 7.3

Carrot17 — Wed, 06 Apr 2016 14:24:14 GMT

Ok. I will try tomorrow and let you know. Thanks for the quick response.

Re: Printing to PDF in 7.3

Carrot17 — Fri, 08 Apr 2016 02:39:01 GMT

Hi Sam,

I tried to removed the Controls and Text objects (Title Heading) on the top of the dashboard still the same. But when I tried to decrease the size of the graph it can print up to 7 graphs only. So, I tried to added two more Sections, first Section includes the control and others objects text, 7 graphs etc., 2nd Section has 4 graphs and 3rd Section has 5 graphs and they were successfully printed to pdf but with 5 pages. 3 pages for 3 Sections and 2 pages for filters, so 1 section equals to 1 page. However, the client's requirement is to print the 16 graphs on 1 page.

Best Regards,
Carrot17

Re: Printing to PDF in 7.3

Sam_SAS — Fri, 08 Apr 2016 13:01:25 GMT

Hi Carrot,

Sorry you are still not able to get the 16 graphs on 1 page. This is a long shot, but you might have better luck if you choose Portrait orientation when you create the PDF (you might already be doing so.)

Re: Printing to PDF in 7.3

HowardNewstadt — Fri, 16 Dec 2016 21:41:47 GMT

OK this works, but it is a ridiculous work around. How could SAS not anticipate the need to print several hundred rows. The print to pdf function that gives you a screenshot and then compresses complex cross tabs into a single page is not a workable product. This is development stage stuff that SAS is asking its customers to upgrade to and then find out what doesn't work. This is just one of many problems with 7.3 and we are not happy.