topic Re: pdf report issue: landscape format and no csv data in Reporting

pdf report issue: landscape format and no csv data

karche — Thu, 22 Sep 2011 21:02:35 GMT

I schedule report and recevie mail from the pdf report server. However there are 2 issues.

I selected the results in email as csv option in the configuration but the csv in the mail has no data
the bar graph in the pdf only showed half of the data set but the UI shows 24 hours. How do i change this pdf report to landscape format? I couldnt find any charting option for that.

Thanks

Re: pdf report issue: landscape format and no csv data

ChrisG — Thu, 22 Sep 2011 22:40:40 GMT

Here's an answer about the page orientation part, from the Troubleshooting manual (http://docs.splunk.com/Documentation/Splunk/5.0/Troubleshooting/PDFTS#I.27m_getting_a_PDF_generated.2C_but_the_output_is_not_what_I_expected): to set the page orientation to landscape, use Settings > Email settings (I think that's Manager > System Settings > Email Alert Settings).

Re: pdf report issue: landscape format and no csv data

karche — Fri, 23 Sep 2011 00:22:31 GMT

Hi ChrisG, thanks for the reply. This setting will affect all the reports. Is there a setting for individual report?

Re: pdf report issue: landscape format and no csv data

ChrisG — Fri, 23 Sep 2011 20:44:03 GMT

Hi again--no, there is only the global setting; you can not set page orientation on a per-report basis.

For your CSV issue, it looks as if it doesn't work to select both CSV and PDF at the same time. If you check only "As CSV," you should get your data.

Re: pdf report issue: landscape format and no csv data

karche — Tue, 27 Sep 2011 04:57:14 GMT

Hi Chris, i select the "include results in email" either "As CSV" or "inline" still no data. May be report have 4 graphs?

Re: pdf report issue: landscape format and no csv data

ChrisG — Tue, 27 Sep 2011 17:46:02 GMT

Hi, I am not sure what is causing the problem. It's possible that you are transforming the data in some way that makes it not work in CSV. Without knowing more about your original search and what the results look like in table format, it's hard to say. You might want to ask for help on this through the IRC channel--or create a separate Answers posting that's just about the CSV export and includes more information about your search and results.

Re: pdf report issue: landscape format and no csv data

ytamura — Sat, 15 Oct 2011 02:44:33 GMT

With regards to your second problem...
We used to have issues with graphs in PDFs, where only half of the data was visible in portrait format. I have not explored the option of using landscape, however the following 2 workarounds has been effective.

If it's a timechart, for example going back 24 hours, instead of only defining earliest=-24h, do this earliest=-24h latest=24h. The chart will appear weird in your browser, but the PDF version will cut off the right half.
Edit the xml to add a fake legend with huge width on the right. You'll have to play around with the numbers a little bit, but you can choose to either hide the legend or not, depending on where Splunk's PDF server cuts your chart...

370
right

Re: pdf report issue: landscape format and no csv data

kjagpal — Thu, 03 Nov 2011 17:56:51 GMT

I have a report that has two sets of bar charts side by side showing data for last 7 days and both charts get chopped off using portrait (only shows 2 days of data). One chart has legend on bottom and the other has no legend. I had tried to use landscape and A0 paper size and it managed to show 6 days but still not enough to display all of the data. I've tried the workaround given above and no luck. I understand this is a bug. When is the issue going to be addressed?

Re: pdf report issue: landscape format and no csv data

karche — Thu, 03 Nov 2011 18:09:23 GMT

I fixed the issue by editing the xml, adding the following option. I kept playing the numbers (170 in this case) and sent yourself email for testing to make sure the chart fit.

(0,170,10,0)

Re: pdf report issue: landscape format and no csv data

CerielTjuh — Thu, 28 Mar 2013 08:45:29 GMT

My collegue was searching for a way to change the layout of the page and in the current version (5.0.2) it is possible to change the layout to landscape in the scheduled search.