Qlik Community

Techspert Talks

Here you'll find the recordings of our Techspert Talks sessions (formally Support Techspert Thursdays).

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Troy_Raney
Digital Support
Digital Support

STT - Top 5 Things to Know About Qlik Reporting Service

This session addresses:
-Understanding new SaaS capability
-How to get started
-Troubleshooting common issues


00:00
- Intro

01:08 - What is Qlik Reporting Service

01:45 - Difference from NPrinting

04:28 - 1st: Sheet Size should match Paper Size

05:32 - 2nd: Reports based on Public Sheets

06:18 - Creating an Automation from Templates

07:30 - Creating Report Automation from scratch

10:18 - Previewing the Report File Size

11:02 - Troubleshooting automation workflow

11:50 - How to skip a block

12:25 - Reviewing Automation logs in QMC Catalog

13:02 - Identifying and correcting errors

13:43 - Information to create a Support Case

14:34 - Limitations

15:18 - QnA: Can you see the file size of a report?

15:56 - QnA: Can you see how many times a report is downloaded?

16:18 - QnA: How does this compare to NPrinting?

16:59 - QnA: Does this work with QlikView?

17:08 - QnA: Can any app be used to generate a report?

17:32 - QnA: Can Reporting be added to a button?

18:12 - QnA: How can you preview the report?

18:55 - QnA: Email attachment or file storage for download?

19:31 - QnA: Is it available for QSEoW?

19:57 - QnA: Rights to generate reports?

20:10 - QnA: Possible to use different report colors than in App?

20:34 - QnA: Possible to adjust font size or resolution?

 

Resources:

Triggering an automation from a button on a sheet

Help page documentation - Limitations

Qlik Application Automation Info Checklist

Reporting Service Forum

Q&A:

Q: How does this compare to NPrinting?

A: NPrinting is a fully developed, on-premises product for QlikView and Qlik Sense, which offers a wider range of report formats besides pdf.

Q: How much of NPrinting functionality does Reporting Services cover and how is the roadmap?

A: Qlik Reporting Service is not a replacement of NPrinting; it is a new reporting service in Qlik Cloud. More features will be added. We have a dedicated forum: 

https://community.qlik.com/t5/Reporting-Service/bd-p/reporting-service.

If you have any ideas to improve the service, please submit it as feature request: https://community.qlik.com/t5/Suggest-an-Idea/idb-p/qlik-ideas

Q: How to send out emails with Excel report? pdf is fine.

A: The current format option is pdf only.

Q: Is this available on Qlik Forts?

A: No, Qlik Reporting Service cannot access data stored in Qlik Forts.

Q: Can we deliver a report as a spreadsheet? If not, is that a feature for the future?

A: You can accomplish it by using Qlik Application Automation:

https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-create-and-d...

Q: Does this apply to QlikView, as well?

A: QlikView is not supported.

Q: Does it matter how many people are distributed to in an automation "run"?

A: No limit on the number of report recipients, but automation jobs have limitations such as the duration of execution. https://help.qlik.com/en-US/cloud-services/Subsystems/Sense_QlikAutomation/Content/Sense_QlikAutomat...

Q: If we purchase the additional license there will be another additional limitation?

A: It would be up to its license. For further information, please contact your account manager.

Q: Does QRS use our organizations SMTP Server? If so, is the send rate customizable, one of the issues with NPrinting is that the send rate exceeds the allowable by Office365?

A: Any SMTP server should work.

Q: Isn't it possible to combine content from different applications/tabs?

A: A report is generated from a single app.

Q: Is report automation intended for normal users of the application? If so, what security rules are needed to enable this capability?

A: You can only make a report automation with Qlik Sense apps you have permission to access.

Q: Can't the report filter data for each different user that is going to receive it?

A: Yes, you can. Please watch this demo: Did you say Report Bursting? Show me more!

Q: Could you please let me know how can we migrate our Qlik Sense apps from Qlik Sense Enterprise on Windows as well as QlikView apps to Qlik Sense SAAS?

A: Please refer to our help site: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/moving-from-client...

Q: Will the generated reports look exactly like the sheet export to pdf? What happens to elements like tables that don't fit the screen? As far as I remember, they are simply cut in the pdf extract but can flow over to a next page in NPrinting.

A: Please leverage Manual download in PDF. The preview shows you a final outcome in advance.

Q: What about the 100 reports mentioned on the price list?

A: The 10,000 reports per tenant per day is a technical limitation and is listed in the help documentation. However, the 100 reports per month is a license allowance at a specific licensing tier. Andrew Kruger helps clarify this here:  https://community.qlik.com/t5/Qlik-Product-Innovation-Blog/Qlik-Reporting-Service-a-new-approach-to-...

Q: Is it possible to add filters based on the different user when distributing the report, like NPrinting, Example John Doe only wants to see Country US, but Jane Doe want to see US & Canada?

A: Yes, you can. Please watch this demo: Did you say Report Bursting? Show me more!

Q: What NPrinting functions cannot be done in Qlik Reporting? My question is: why the client usually makes those evaluations about what functionality he will not have anymore if he has to choose to change from NPrintng to Qlik Repoprting?

A: Qlik Reporting Service is a part of the Qlik Application Automation Connector, which facilitates the report distribution tasks. While NPriting is a separate on-premises product with more mature features. Having said that, more features on the road map.

Q: Where can you send the files to?

A: You can send a report as attachment or a public storage using the following connectors: Amazon S3, Dropbox, FTP, Google Cloud Storage, SFTP.

Q: Hi, about launch an automation from a Qlik Sense app, which rights are needed so users  can launch this automation or report?

A: You don’t need a specific right unless your tenant admin disable the Application Automation.

Q: Is there a limit of the size of the PDF that can be generated?

A: No file size limit, there are other factors you may want to consider. Please see the limitations: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Reporting-serv...

Q: When will other file formats (for example, PowerPoint) be supported?

A: They are on road map, so please stay tuned.

Q: Can you use only complete sheets or also specific diagrams?

A: Yes, as long as they are public sheet. You may want to consider the size of the sheet; otherwise, the sheet may not fill a report well.

Q: Can you repet please how much reports can we send for free?

A: The 10,000 reports per tenant per day is a technical limitation and is listed in the help documentation. However, the 100 reports per month is a license allowance at a specific licensing tier. Andrew Kruger helps clarify this here:  https://community.qlik.com/t5/Qlik-Product-Innovation-Blog/Qlik-Reporting-Service-a-new-approach-to-...

Q: Can you "print" a whole Table? Or only the first 20 Rows, which are seen?

A: You can make a selection in a block and filter it. https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Create-reporti...

Q: Hi, you talk about 5000 free runs : it is about automation or report number ?

A: This is the automation number. 

Q: Can you use filter?

A: Yes. https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Create-reporti...

Q: Are there plans to be able to send Excel format as the report?

A: Application Automation can distribute data in a Excel format: https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-create-and-d...

Q: Can you add the company graphical profile?

A: If you can add it as image on a sheet, then yes.

Q: In the future will be possible to generate other report formats such as PowerPoint?

A: If you have an idea, please submit it in our Ideation: https://community.qlik.com/t5/Ideation/ct-p/qlik-product-insight

Q: Can you include 3rd party chart types (e.g., Vizlib charts) in Qlik Reporting Service?

A: Yes, what you can see in the sheet will be in a report.

Q: If you need native reports as PPT you should use NP?

A: Yes, Qlik Reporting Service only generates a report in PDF.

Q: Do you have central place to monitor all automation/reporting tasks? To see errors, last execution time or status?

A: Tenant admin is able see all the automation on the list in Management Console.

Q: Any plans on bringing this to Qlik Sense Enterprise on Windows?

A: No, this is a feature in Qlik Cloud.

Q: Please forgive if this has already been covered as I joined late, can we select landscape or portrait paper format?

A: You can adjust a sheet size, which will be your report size.

Q: When do combination of apps in one report come?

A: Please submit your idea in our ideation page: https://community.qlik.com/t5/Ideation/ct-p/qlik-product-insight

Q: Is multi-format reporting on the roadmap for QRS? or will multi-format reporting stay with NPrinting only? Do you believe that eventually QRS can complete all NPrinting tasks?

A: Qlik Reporting Service is a different feature in Qlik Cloud. If you are looking for a solutin in Excel format, you can use Application Automation to generate and distribute a Excel spreadsheet: https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-create-and-d...

Q: Can you use it for on-demand reporting?

A: You can trigger a report from the sheet by implementing an action button: https://community.qlik.com/t5/Knowledge/Triggering-an-automation-from-a-button-on-a-sheet/ta-p/18528...

Q: The actual limit of 100 report, is 100 runs or 100 reports? I mean, can I send one report to 200 users with 200 different filters?

A: The 10,000 reports per tenant per day is a technical limitation and is listed in the help documentation. However, the 100 reports per month is a license allowance at a specific licensing tier. Andrew Kruger helps clarify this here:  https://community.qlik.com/t5/Qlik-Product-Innovation-Blog/Qlik-Reporting-Service-a-new-approach-to-...

Q: I heard about a limit of 100 free reports by tenant by months?

A: The 10,000 reports per tenant per day is a technical limitation and is listed in the help documentation. However, the 100 reports per month is a license allowance at a specific licensing tier. Andrew Kruger helps clarify this here:  https://community.qlik.com/t5/Qlik-Product-Innovation-Blog/Qlik-Reporting-Service-a-new-approach-to-...

Q: Can you show us how you set the screen size of the report so that it matches the page layout?

A: You set the sheet size in the app, which will be your report. The reporting service will try to optimize for portrait/landscapes.

Techspert-Talks_Imagery_Community-590x310.jpg

Click here for video transcript

 

2 Replies
SimonHeap_S-cubed

Hi Troy and Ayaka. Thanks for a great presentation! I missed the live session on Feb 17th and I have just gone through the recording. One often likes to compare with NPrinting, and I too have a question here: I'm still quite new to Qlik Automation and maybe my question can be resolved through more advanced automation, anyway...: in NPrinting you can iterate your report output over a dimension. Say you want a specific sheet from your app printed multiple times for each region of sales as a selection. How would you do that with the QS SaaS Reporting Service? 

SimonHeap_S-cubed

Ah, I just found the answer watching Tarallo's demo on YouTube: Qlik Reporting Service - Brief Overview with Detailed Demonstrations - Part 1 and Part 2 - YouTube - it's using more advanced features in the automation blocks as I expected...