
Hi, I have master report with subreport (Report Source set as XML Markup). Everything works fine when I preview it on Report Designer, but after import file to our app I have data only from master report. In subreport section I have error:
An error has occurred while processing SubReport 'subReportDetails': 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 ------------- Initialization string format is out of specification starting at index 0.
It works when I save login data for report but I don't want to save passwords in XML expression.
I wanted to try Assign connection string dynamically using report parameter and bindings - Telerik Reporting, but I don't know how to pass connection string from master report to subreport.
protected override void OnNeedDataSource(object sender, EventArgs e)
{
base.OnNeedDataSource(sender, e);
var report = sender as Telerik.Reporting.Processing.Report;
//// Report Post Formatting.
// Apply Sorts.
if (report.Parameters["Sortings"].Value != null)
{
Common.ApplySort(this, report.Parameters["Sortings"].Value.ToString());
}
}public static void ApplySort(Report report, string sortingColumns)
{
// sorting Columns string format: ColumnName:Asc;ColumnName:Desc
if (sortingColumns == null)
return;
foreach (var item in sortingColumns.Split(','))
{
// Get The field value for the column to sort by... IE. SellthroughValuePercent is an iff calculation.
report.Report.Sortings.Add(new Sorting
{
Expression = string.Format("=Fields.[{0}]", item.Split(':')[0]),
Direction = item.Split(':')[1] == "Asc" ? SortDirection.Asc : SortDirection.Desc,
});
}
}
// Create report source
var reportSource = new Telerik.Reporting.UriReportSource
{
Uri = Server.MapPath("Manifest.trdp") // Replace "PathToYourReport" with the actual path to your report
};
// add parameters to report source
reportSource.Parameters.Add(new Telerik.Reporting.Parameter("@shipmentId", shipmentsId.Value.ToString()));
// Create report processor
var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
// Render the report to PDF
var result = reportProcessor.RenderReport("PDF", reportSource, null);
if (result.HasErrors)
{
throw new Exception("There were errors during report processing: " + result.Errors[0].Message.ToString());
}
// Set the content type to PDF
Response.ContentType = "application/pdf";
// Write the PDF data to the output stream
Response.OutputStream.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
// End the response to force it to client
Response.End();I have a table in my report where i have the borders for the row and column headers set to solid 1pt borders
I also have conditional formatting set on the rows so that every other row has a light grey background color for readability
The problem is, that any row/column header that touches one of the detail rows with the conditional formatting loses the border that touches that cell.
I have attached screenshots of the report in preview mode and in design mode

Hello guys,
I want to set up a DateTime property from my DB to use the Bulgarian culture inside a TextBox in the Report Designer. It should use one of the following formats "MMMM yyyy" or "Y" (example: декември 2015).
Using the following code I have found that the Culture does not change even though I have specifically set it to Bulgarian in the code, also in the Report culture and TextBox culture:
Fields.ProductionDate.ToString("Y", CultureInfo.GetCurrentCulture("bg-BG"))What I have found up until now. is that using the following syntax, with the cultures of the Report and TextBox set. including setting the DateTime formatter for the TextBox to be July 2023 fixes the issue:
=Fields.ProductionDate
However, this does not work for me as the TextBox I am using the property in, includes a lot of text and the only way I have found to write code that way is using Curly Braces which do not seem to apply the selected format.
Result when using =Fields.ProductionDate:
Result when using {Fields.ProductionDate}:
Question 1: Is there a way to change the DateTime Format and Culture using the first approach, if so could you please attach a sample as everything so far that I have tried does not seem to work.
Question 2: Is there a way to go around the curly braces and use the =Fields.ProductionDate with square braces without the need to create a separate TextBox.
Thank you in advance.

Is it possible to filter by columns in a table from Telerik reporting like a grid view?
Eg. the Image is attached.
I tried to follow the instructions here:
https://docs.telerik.com/reporting/designing-reports/report-designer-tools/web-report-designer/how-to-set-up-in-blazor-application
"Use NuGet package manager to add the Telerik.WebReportDesigner.Services package. This will also resolve other..."
Later on we have:
...
services.TryAddSingleton<IReportServiceConfiguration>(sp => new ReportServiceConfiguration
{
ReportingEngineConfiguration = sp.GetService<IConfiguration>(),
HostAppId = "BlazorWebReportDesignerDemo",
Storage = new FileStorage(),
ReportSourceResolver = new UriReportSourceResolver(Path.Combine(sp.GetService<IWebHostEnvironment>().WebRootPath, "Reports"))
});But some of the types are not available. E.G. FileStorage()
Which is a part of
Assembly Telerik.Reporting, Version=17.1.23.718, Culture=neutral, PublicKeyToken=a9d7983dfcc261be
So the instruction is misleading for beginners :-)
Which additional pakets are needed?
Btw: A link to a ready made project may helpful.
:-)
Hello,
I have a page where I load the same report, but with different parameter values each time. What happens is that after the first loading, the Report is not considering the new parameters and keeps bringing the report with the first parameter.
I have tried removing and adding the Report DIV programatically to see if it would clear the Report Viewer contents, but after doing that the Report stops loading, although the HTML DIV Structure is the same as the original.
Any ideias?
Regards,
Alexandre
