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.
Is there a repository of FREE OnyakTech PDF Reports? We are putting together a repository now and publish the reports for free on www.OnyakTech.com. If you wish to submit reports for distribution, please email them to Support@OnyakTech.com.