PDF Reports

OnyakTech Reports is a report writing module for DNN that produces high quality PDF documents of your DNN data (via SQL Statements) by designing your reports inside OnyakTech PDF Reports module or you can upload your own PDF Template. Reports can be executed at any time from within the module or you can use the Report Link to share or display on your DNN web site.

You can now have reports generated with dynamic file names using tokens (current date, current user name, report name, etc)

Set Paper Type

Choose from over 30 different page sizes (Legal, Tabloid, Envelope and more!)

Report Layout

You can now change between Portrait and Landscape layout

Web Report Viewer

A new module has been added to OnyakTech PDF Reports for viewing reports. Show a single report or allow people to choose the report to display.

Generates PDF

Reports can be downloaded in PDF created dynamically based on user information and parameters passed into the report.

Charts

You can now render charts! Create professional reports with charts easily by entering a SQL Statement and the chart data series.

RTF-SQL

This is the ultimate in data format control. Use this to create dynamic catalogs, price lists, etc. Just enter the field names in << >> brackets in your Rich Text and the report will render each record into your RTF. You can also use the Parameters in this Item Type as well. " data format control. Use this to create dynamic catalogs, price lists, etc. Just enter the field names in << >> brackets in your Rich Text and the report will render each record into your RTF. You can also use the Parameters in this Item Type as well.

Security

You can now secure your PDF documents with a password and prevent people from printing, copying and editing the contents.

Compression

Use compression to make the size of your reports smaller. Three levels are provided (Best Compression, Best Speed and Default).

Page Breaks

Use page breaks to split areas of your report to better organize the contents and get control of the flow of your report.

Share Individual Reports

Each report can be downloaded to a binary source file that can be imported into ANY DNN site.

DNN Data Friendly

SQL Statements are parsed for Object Qualifiers and Database Owners to allow you to share your report templates with other DNN sites that may have different qualifiers.

Attachments

Add unlimited number of attachments to your reports. They embedded directly into the PDF Document!

Parameters

Generate dynamic reports using parameters. Choose from over 20 different parameters you can use in your Reports. Some parameters include the current user id, portal id, active tab, etc. Perfect for generating custom and user specific reports.

Current Parameter Keys:

[USR-USERID] - Current Users User ID

[USR-LASTNAME] - Current Users Last Name

[USR-USERNAME] - Current Users User name

[USR-FULLNAME] - Current Users Full Name

[USR-FIRSTNAME] - Current users First Name

[USR-AFFILIATEID] - Current Users Affiliate ID

[ATB-ISDELETED] - Active Tab Deleted Value

[ATB-URL] - Active Tab URL

[ATB-TITLE] - Active Tab Title

[CPT-EXPDATE] Portal Expiration Date

[CPT-ADMID] Portal Admin ID

[CPT-ADMROLEID] Portal Admin Role ID

[CPT-ADMROLENAME] Portal Admin Role Name

[CPT-HOMEDIR] Portal Home Directory

[CPT-HOMETABID] Portal Home Tab ID

[CPT-HOSTSPACE] Portal Disk Space

[CPT-LOGTABID] Portal Login Tab ID

[CPT-PORTALALIAS] Portal Alias

[CPT-PORTALID] Portal ID

[CPT-PORTALNAME] Portal Name

[CPT-REGROLEID] Registered Role ID

[CPT-USRTABID] User Tab ID

New Editor

The report editor has been improved to make it really easy to modify existing reports.

Custom Report Footer

You can now alter the footer displayed on the reports generated from your site. Add your web sites URL to each report to improve site visits.

Report Source Types: Reports are created by adding Source Types one-by-one to the report source using the report editor. The current available types are:

RTF

HTML

Charts

SQL

Images

Attachments

Text

RTF - SQL

OnyakTech PDF Report FAQ

What happens when I run a report? The report is generated every time you run a report and downloaded in Adobe PDF format.

What type of content can I add to a report? You can add images, text and SQL statements. The SQL Statements are executed against your DNN data and displayed in a Data Grid in the PDF Report.

Can I use SQL Statements that collect data from non-core DNN modules? Yes, you can create SQL Statements using all of the tables and views in your DNN site. If you create a report for a specific module, anyone you share that report with will need that module in order to run the report.

Why would I share my reports? Keep in mind that you are not sharing rendered reports. You are sharing the report source file that contains all of the formatting to render the report. Some reasons to share your report source files are...

You manage all DNN Portals for your company and have created a Portal for each division in your company. Use OnyakTech Reports to provide reporting to each division with data from their portal.

You host DNN Portals and create reports your clients can use to analyze site site traffic, billing, etc.

You are a module developer and wish to provide your customers with reports specific to your module.

How can I share my reports if the Object-Qualifier is different for other sites? PDF Reports uses the same SQL processing that DNN uses when parsing statements. All you need to do is code the SQL Statements properly with the ObjectQualifier and DatabaseOwner tags. Here is a quick example of some code you could use to display user information:SELECT Username, FirstName, LastName
FROM {databaseOwner}{objectQualifier}Users

Do I have to use the ObjectQualifier and DatabaseOwner tags? No, you can use straight SQL if you won't be sharing your reports with the community or if you will be sharing the reports with other DNN sites that have the same ObjectQualifier and DatabaseOwner as your site.

How can I share reports with images? Images are not actually stored in the report. When you add an image to a report, you type in the URL of the image on the web. When the reported is executed, the image is downloaded from the URL you specified and inserted into the report. This makes it possible to change images in reports by altering the source image at the URL you specify.

How many elements (Data Grids, Image, etc) can I add to a single report? There is no limit. You can add as many images, data grids and text elements to an individual report as you want.

How do I download the Report Source file? Click on the link to edit the report and then click on the Report Download link. PDF Reports will generate a .ORP "OnyakTech Report" file and download it to you.

How do I upload Report Source files? Click on the link to create a new report and then click the Browse button at the bottom of the form to upload reports. Select the .ORP file and upload to your site. After the file has been loaded you will be taken back to the Report List screen and you can run it from there.

Do I need a license to distribute reports I create with OnyakTech PDF Reports? No, you can create and distribute as many reports as you want. You only need a license of OnyakTech PDF Reports DNN Module to create and view reports.

Is my name stored with the reports I created? Yes. The creator and modifier of the reports are stored with the report as well as the date and time the report was created and modified. This information is displayed in the Report List.