Home » Platinum Collections » DNN Modules » PDF Reports

PDF Reports

SKU: PDFReports

Sample Report

Generates PDF Files

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.

High Quality PDF: Use high quality PDF documents with PDF Templates. Generates one PDF per record.
New Chart Types: Pie, Bar, Bubble, Candle, Gantt, HiLo, Histogram, Polar, Radar, Step and XYPlot
Create Certificates (used by ReZults)
Connect to any data source using custom connection strings in every report
Easily create custom reports using many different report display types
Download reports as PDF or Microsoft Word files
View reports directly on your web site
Share report design files with other DotNetNuke web sites

Dynamic Report Names 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-REGROLEID] Registered Role 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.
  • You provide template creation services and want to add OnyakTech Report Templates to your product line.

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.

  • DNN 6.0 or newer
  • .Net 3.5 or newer
 Purchase includes older versions of the product that support DNN 4.9 and newer.
Supported on the following versions of DNN
  • DNN 6.x
  • DNN 7.x
  • DNN 8.x
  • DNN 9.X