For reasons of hiding customer details from other customers, I've elected to create some custom reports for my application using the standalone report designer. The idea is that I can create any number of customized reports and drop them into place on each customer's machine as appropriate.
I initially used .TRDP format, and it works fine; however, when branching a codeline with SVN, I realized I couldn't merge binary files very well, so I decided to go with .TRDX format for the ability to diff & merge report definitions.
In turn I created a bit of stand-alone code to run in my build environment that would convert all the TRDX files to TRDP for distribution.
This uses the same method shown on the Telerik Reporting documentation; that is:
using (var targetStream = File.Create(destfn)) {
var xmlString = File.ReadAllText(sourceName);
reportPackager.Package(xmlString, targetStream);
}
However, when I do this, and try to load the resulting TRDP in either stand-alone Report Designer or load into my ASP.NET code, I get errors saying "Resource Not Found".
My reports typically have a customer-specific PictureBox, so there's an embedded resource block, which I believe is the issue.
I tried converting my original TRDP and "packaged" TRDP file names to .zip so I could inspect them. The original TRDP has two XML files and a folder Images with a JPG file - "pictureBox1.Value.JPG". The packaged TRDP just has two XML files, and there's a very long BASE64-like block, no separate image files.
How can I achieve this goal in an automated fashion?
Which is the correct DataSource to use for an Azure Database, SQL Data Source?
Documentation here doesn't seem to mentioned Azure Databases at all:
http://docs.telerik.com/reporting/quick-start-create-simple-report
I don't see how to specify the report library in the ReportsControllerBase, is this the idea?
public class ReportsController : ReportsControllerBase { /* original from wizard - static Telerik.Reporting.Services.ReportServiceConfiguration configurationInstance = new Telerik.Reporting.Services.ReportServiceConfiguration { HostAppId = "Application1", ReportResolver = new ReportFileResolver(HttpContext.Current.Server.MapPath("~/Reports")) .AddFallbackResolver(new ReportTypeResolver()), Storage = new Telerik.Reporting.Cache.File.FileStorage(), };*/ static Telerik.Reporting.Services.ReportServiceConfiguration configurationInstance = new Telerik.Reporting.Services.ReportServiceConfiguration { HostAppId = "Application1", ReportResolver = new ReportTypeResolver(), Storage = new Telerik.Reporting.Cache.File.FileStorage(), }; public ReportsController() { this.ReportServiceConfiguration = configurationInstance; } }
Sorry for all the questions, it would be great to have documentation on this basic stuff.
Following the instructions online and I'm receiving the error "Could not find schema information for the element 'Telerik.Reporting'" in Web.config.
In which reference is the schema information?
I'm following the instructions here:
http://docs.telerik.com/reporting/quick-start-add-report-visual-studio
It says that you need to create a Report Library to use reports in a REST API. But VS 2016 it gives two options, ReportLibrary1 and RestService1. What is the difference between them and which should I choose?
Am I looking at outdated documentation, seems pretty basic stuff to include?
Hi All,
I've been attempting to setup WebAPI/MVC with a (very) basic Reporting example. I've been following the instructions here:
http://docs.telerik.com/reporting/telerik-reporting-rest-host-http-service-using-web-hosting
But the instructions appear to be out of date, does anyone know of any up-to-date documentation? (ie using .Net 4.5.2 and WebAPI 2)
(I've tried my paid Telerik support tickets, but they only reply with stock written answers which don't answer the question.)
Thanks in advance,
Jon
We are using currently embeded Telerik Report Standalone Designer to make possible to change Reports used in our software.
Is it possible to say Report Designer to Save current report to File from outside?
Hi,
We have few reports where there is a crosstab which shows product details with segments and values for the segment. There is a column grouping on segmentname column. Data shown by the report will be as follows
___________________________________________________________________________________________
ID Code Description Barcode Active? Sellable? Redeemable? Size Color Class Department
__________________________________________________________________________________________
1 ABC123 Pink Teddy ABC123 'Y' 'N' 'Y' 'S' 'Pink' B1 N1
2 XYZ456 Blue Teddy XYZ456 'Y' 'N' 'Y' 'S' 'Blue' B1 N1
3 CBV256 Chota Bheem CBV256 'Y' 'N' 'Y' 'S' 'Brown' B2 N1
3 NIV256 Ninja Sword NIV256 'Y' 'N' 'Y' 'M' 'Brown' B2 N2
4 BBN267 Big Basket Ball BBN267 'Y' 'Y' 'Y' 'B' 'Orange' B3 N3
___________________________________________________________________________________________
Columns up to 'Reemable?' are static columns. All columns after 'Reedeemable?' are segments. Segments are defined in a different table and are dynamic. Column grouping on segmentname is used to get all segment details for a product in a single row. There are filters on crosstable to see if only active products should be shown or only redeemable or sellable products should be shown.
We have clients who have a big list of products. They would want to look for details with different combinations of segmentname and segment values. For example the filter could be as follows
((segmentname = 'Color' and value = 'Brown') or (segmentname = 'Class' and value = 'B3'))
Since the segments are dynamic and there could be different combinations, adding segments as a parameter to the report will not help. We did not find anyway to add the filters to a string variable and append the string variable to the crosstab's datasource commandtext. Is there anyway in telerik reports for the user to open a window from the report where he could create such combinations and the filter string thus formed in addition to filters in the report could be passed to the crosstab? Please suggest what could be done.
We are using Report designer and creating reports for windows forms applications. The same reports are being used by Asp.net webforms.