Is it possible to generate a PDF from a telerik report from a .NET console application? The data source will be SQL 2000 and we cannot modify that server in any way. Is it possible to deploy all components necessary to another server and generate PDF reports designed in the telerik report designer, and without a web server or other additional servers? Where might I find more info on getting started with running telerik reports in this way?
1 Answer, 1 is accepted
0
Hi Benjamin,
As of Q2 2013 Telerik Reporting is built against .NET4 supported in Visual Studio 2010+ versions.
You can use the SqlDataSource to directly connect to your SQL database. The SqlDataSource component uses standard ADO.NET classes and the installed on the machine .NET data providers to establish the connection and retrieve data. Details how to configure the component are available in the SqlDataSource Wizard.
Also you may prefer to use a custom data access layer, and load the data in a custom business object. Then you can use the ObjectDataSource/ EntityDataSource/ OpenAccessDataSource component, depending on the type of data model you are building.
Once you have designed a report, including the data-binding part, you can export it programmatically on the server machine with the ReportProcessor.RenderReport - Exporting Report Programmatically.
Regards,
Stef
Telerik
As of Q2 2013 Telerik Reporting is built against .NET4 supported in Visual Studio 2010+ versions.
You can use the SqlDataSource to directly connect to your SQL database. The SqlDataSource component uses standard ADO.NET classes and the installed on the machine .NET data providers to establish the connection and retrieve data. Details how to configure the component are available in the SqlDataSource Wizard.
Also you may prefer to use a custom data access layer, and load the data in a custom business object. Then you can use the ObjectDataSource/ EntityDataSource/ OpenAccessDataSource component, depending on the type of data model you are building.
The usage of a data model, will allow you to use the collection properties of the main business object to supply data to data items in the report. For more details about data-binding scenarios, please refer to the following articles:
- How to use the ReportItem.DataObject property in expressions
- How to Databind to Collection Properties
Once you have designed a report, including the data-binding part, you can export it programmatically on the server machine with the ReportProcessor.RenderReport - Exporting Report Programmatically.
Regards,
Stef
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.