Hello guys.
We are storing the TRDX files in the Windows Azure Cloud Storage in a Asp.Net MVC application. Given the *.trdx files are not on the disk, we need to verify at runtime (in a class that implements IReportResolver) if the report has a subreport. If it has, we try to get the trdx (xml content) an set the reportSource of a subReport as a XmlReportSource. Actually, we need to replace a UriReportSource to a XmlReportSource. It works when we do not have parameter, but does not work when we have parameters. Look at the code bellow:
// find a detail section and a subReport on it.
foreach
(var section
in
reportInstance.Items.Where(i => i
is
DetailSection))
foreach
(var item
in
section.Items.Where(i => i
is
SubReport))
{
var subReport = (SubReport) item;
// if the subReport is an UriReportSource
if
(subReport.ReportSource
is
UriReportSource)
{
// we try to convert the UriReportSource to XmlReportSource
var subReportUriSource = (UriReportSource) subReport.ReportSource;
// get an object that represents a report in our system
var subReportViewModel = reportService.GetSubReportFileName(reportId, subReportUriSource.Uri);
// create an instance of our helper to get the content from the windows azure cloud storage
var storage = CloudStorageFactory.Create();
// get the xml content
var xmlContent = storage.GetContent(subReportViewModel.FileName);
// create a XmlReportSource with the xmlContent
var xmlReportSource =
new
XmlReportSource() {Xml = xmlContent};
// set the parameters
foreach
(var parameter
in
subReportUriSource.Parameters)
xmlReportSource.Parameters.Add(parameter);
// set on the ReportSource
subReport.ReportSource = xmlReportSource;
}
}
I am not sure if I can do it at runtime, or what I am doing wrong but it is giving an error like this:
Internal Server Error:
An error has occurred while processing the report. Processing canceled. Check the InnerException for more information.Invalid value of report parameter 'PersonID'.
Does anybody know what I can try?
I must be missing something. I have a WPF app that I have a report that was designed within VS. I then followed the docs to create a Report Viewer. If I add a value to the report parameters from the designer the report works well. What I would like to do is display a window so the user can make choices mostly check boxes. Then pass the choices to the parameters of the report thru the report viewer.
Thank you,
John
Hello guys.
I have an application with Telerik Reporting working fine in my environment. Now, we need to publish it on an environment that uses Azure Cloud Storage to store files. We have reports that uses Subreports and it works fine with FileSystem when the trdx file of the subreport is on the same folder of the main trdx. How should it work on the cloud storage? We do not have physical folders in cloud storage, and how subreports should be resolved by Telerik Reporting Viewer?
I would like to know if is there any solution for it on Telerik Reporting? Is there any link or tutorial I can follow?
Thank you.
in development server its working fine but after migrate to production.
i using db mysql
impossible connector .net to mysql got problem because data access working fine.
here is the error
An error has occurred while processing Report 'Report2': Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application. ------------- InnerException ------------- Unable to find the requested .Net Framework Data Provider. It may not be installed.
connection string also same with data access connection string.
my code
public
class
CustomReportResolver : IReportResolver
{
protected
TokenBasedView tokenBased {
get
;
set
; }
public
Telerik.Reporting.ReportSource Resolve(
string
reportCode)
{
Telerik.Reporting.Report report =
new
Report2();
Telerik.Reporting.InstanceReportSource irs =
new
Telerik.Reporting.InstanceReportSource();
irs.ReportDocument = report;
return
irs;
}
}
i hope somebody can help me out.
thank you so much
When I print my report with a watermark from code behind, the Watermark text prints as dotted as opposed to printing from the ReportViewer which prints the watermark as solid. How can I get the watermark to print solid like it does in the ReportViewer from code behind?
// Obtain the settings of the default printer
System.Drawing.Printing.PrinterSettings printerSettings = new System.Drawing.Printing.PrinterSettings();
// The standard print controller comes with no UI
System.Drawing.Printing.PrintController standardPrintController = new System.Drawing.Printing.StandardPrintController();
// Print the report using the custom print controller
Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
reportProcessor.PrintController = standardPrintController;
Telerik.Reporting.TypeReportSource typeReportSource = new Telerik.Reporting.TypeReportSource();
// reportName is the Assembly Qualified Name of the report
typeReportSource.TypeName = typeof(BuildPlanReportLib.Traveler3).AssemblyQualifiedName;
Report3 rep2 = Report3();
rep2.PageSettings.Landscape = true;
reportProcessor.PrintReport(rep2, printerSettings);
I have one textbox on my report with the value of .55 and the format is set as {0:N2}. Now when I export to excel the format for said cell becomes [$-1010409]#,##0.00;-#,##0.00 under the Custom Category . I would like some help in understanding why the format is not behaving as expected for the excel. I researched and saw this thread:
http://www.telerik.com/forums/report-lose-formatting-after-export-in-excel
The answer that {0:N2} would be the solution isn't working for me for some reason. Just in case it's needed I am using the ReportProcessor.RenderReport method for my generation.
Thank you
Hi there
I have some reports that I want to export as .pdf with a custom document name set. While debugging I can see the .DocumentName property is set properly in the report object.
When the report opens inline in the browser (IE11 with acrobat add-on) and I select "Save as..." the suggested filename is still the default name and not my custom document name.
What am I missing here?
Thank you