# Report Generation issue in from Kibana Visualize

**URL:** <https://discuss.elastic.co/t/report-generation-issue-in-from-kibana-visualize/269322>\
**Category:** Kibana\
**Tags:** elastic-stack-reporting\
**Created:** [April 6, 2021, 10:58am UTC](https://discuss.elastic.co/t/report-generation-issue-in-from-kibana-visualize/269322 "2021-04-06T10:58:09Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![jancodenew](https://avatars.discourse-cdn.com/v4/letter/j/87869e/32.png) [@jancodenew](https://discuss.elastic.co/u/jancodenew)\
**Post date:** [April 6, 2021, 10:58am UTC](https://discuss.elastic.co/t/report-generation-issue-in-from-kibana-visualize/269322/1 "2021-04-06T10:58:09Z")

</div>

Hello,

I want send the report with event count of each devices in last 24 hours by email. I have created new visualization by aggregating with src.ip feild. When i am downloading the report as PDF, full infromation is not reflecting in pdf. only the line count in a single screen is populating in the report.

I am using ELK 7.8 here.

Please help me to resolve this issue.

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![jportner](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jportner/32/75692_2.png) [@jportner](https://discuss.elastic.co/u/jportner)\
**Post date:** [April 7, 2021, 4:08pm UTC](https://discuss.elastic.co/t/report-generation-issue-in-from-kibana-visualize/269322/2 "2021-04-07T16:08:25Z")

</div>

So we can help troubleshoot the issue, can you please provide the following?

1. Screenshot of the PDF report
2. The configuration for the visualization which you're using to generate the report (you can navigate to Stack Management \> Saved Objects, find your visualization, click the "..." action button and click "Inspect", and share the JSON output here)

---

<div class="post-metadata">

**Author:** ![jancodenew](https://avatars.discourse-cdn.com/v4/letter/j/87869e/32.png) [@jancodenew](https://discuss.elastic.co/u/jancodenew)\
**Post date:** [April 7, 2021, 4:36pm UTC](https://discuss.elastic.co/t/report-generation-issue-in-from-kibana-visualize/269322/3 "2021-04-07T16:36:36Z")

</div>

I cannot share the report due to sensitive information.

PDF is capturing more line items when i zoom out the whole browser size before generating the PDF. But this is not a permanent solution since the actual report contains more than 1000 device count( more than 1000 line items) .

When downloading csv by clicking formatted CSV button is capturing complete information in the report. But there is no option to copy the post url of generate CSV for visalize in kibana.

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![jportner](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jportner/32/75692_2.png) [@jportner](https://discuss.elastic.co/u/jportner)\
**Post date:** [April 7, 2021, 5:20pm UTC](https://discuss.elastic.co/t/report-generation-issue-in-from-kibana-visualize/269322/4 "2021-04-07T17:20:44Z")

</div>

Thanks for clarifying, I think I understand your problem better now. You have a Saved Search (from the Discover application) which you are rendering in a Dashboard, and you want to generate a report with _all_ of that data in a PDF, is that right?

Our documentation on this for 7.8 is a bit more sparse, but [in 7.9 onward the documentation states](https://www.elastic.co/guide/en/kibana/7.9/reporting-getting-started.html#manually-generate-reports):

> NOTE: When you export a data table or saved search from a dashboard report, the PDF includes only the visible data.

This is a limitation in Kibana's Reporting feature right now. There is an enhancement request open for this already:

> <https://github.com/elastic/kibana/issues/17950>
>
> \*Original comment by @tbragin:\*
> 
> Right now only the preview of the data table sh…ows up in the PDF report, because we essentially take a screenshot of the first page of the table. We should consider how to improve this. 
> 
> Possibilities to discuss:
> - Option to export data tables (not saved search tables) to CSV (to accompany the PDF)
> - Option to export a full data table as a formatted PDF table (limited to N results, IBM Qradar does max of 500)
> 
> This is similar to the problem we have with saved search export LINK REDACTED

The issue description is focused on data tables and CSV reports, but in the discussion in the comments, users have asked for support for saved searches and PDF reports as well.

You can subscribe to that issue to get updates on progress. It seems like something that lots of people have asked for, and we were unable to implement due to technical limitations until a related issue was completed a few weeks ago.

---

<div class="post-metadata">

**Author:** ![jancodenew](https://avatars.discourse-cdn.com/v4/letter/j/87869e/32.png) [@jancodenew](https://discuss.elastic.co/u/jancodenew)\
**Post date:** [April 7, 2021, 5:50pm UTC](https://discuss.elastic.co/t/report-generation-issue-in-from-kibana-visualize/269322/5 "2021-04-07T17:50:17Z")

</div>

Thank you for your prompt reply.

A small correction on the above statement. I am not trying to generate report from Discover app, instead i am trying to generate report from Visualize(aggregation query) and there is no CSV report option in kibana visualization, only option is to generate pdf.

I have gone through the github link shared above, but i am not able to identify a successful resolution for this issue in that link.

Thanks

---

<div class="post-metadata">

**Author:** ![jancodenew](https://avatars.discourse-cdn.com/v4/letter/j/87869e/32.png) [@jancodenew](https://discuss.elastic.co/u/jancodenew)\
**Post date:** [April 7, 2021, 6:03pm UTC](https://discuss.elastic.co/t/report-generation-issue-in-from-kibana-visualize/269322/6 "2021-04-07T18:03:09Z")

</div>

i have attached the screenshot of csv download button option in bottom of visualization page. Please let me know if there any option to get post url of 'formatted CSV' button.

![test](https://us1.discourse-cdn.com/elastic/original/3X/f/7/f79ea931b17955ebd99779b8f4295fb07da21f7a.png)

---

<div class="post-metadata">

**Author:** ![jancodenew](https://avatars.discourse-cdn.com/v4/letter/j/87869e/32.png) [@jancodenew](https://discuss.elastic.co/u/jancodenew)\
**Post date:** [April 11, 2021, 10:37am UTC](https://discuss.elastic.co/t/report-generation-issue-in-from-kibana-visualize/269322/7 "2021-04-11T10:37:55Z")

</div>

#elastic-stack-reporting  
Please help on above mentioned issue.

---

<div class="post-metadata">

**Author:** ![jancodenew](https://avatars.discourse-cdn.com/v4/letter/j/87869e/32.png) [@jancodenew](https://discuss.elastic.co/u/jancodenew)\
**Post date:** [April 12, 2021, 8:01pm UTC](https://discuss.elastic.co/t/report-generation-issue-in-from-kibana-visualize/269322/8 "2021-04-12T20:01:29Z")

</div>

@jportner @elastic-stack-reporting  
Requesting for your valuable feedback on the above mentioned concern.

---

<div class="post-metadata">

**Author:** ![jportner](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jportner/32/75692_2.png) [@jportner](https://discuss.elastic.co/u/jportner)\
**Post date:** [April 13, 2021, 3:26pm UTC](https://discuss.elastic.co/t/report-generation-issue-in-from-kibana-visualize/269322/9 "2021-04-13T15:26:32Z")

</div>

Oh OK, I guess I misunderstood.

So you have a visualization, and the "Formatted" CSV option gives you the information that you want -- you are just looking for a URL so you can automate these CSV exports externally, is that right?

Sorry for the confusion, this CSV export is actually totally separate from Kibana's Reporting feature.

There is no URL to copy for this, unfortunately. The reason there is no URL is that the Kibana client already has all of this data loaded into memory, and it dynamically generates a CSV file for you as a download.

If you'd like to be able to download CSV Reports (with a URL), you could [add a feature request issue on our GitHub repository](https://github.com/elastic/kibana/issues/new?assignees=&labels=&template=Feature_request.md). Unfortunately there is no way that I can think of to accomplish that today.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 11, 2021, 3:27pm UTC](https://discuss.elastic.co/t/report-generation-issue-in-from-kibana-visualize/269322/10 "2021-05-11T15:27:15Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
