I am creating a report using Standalone Report Designer. The report is based on a SQL Server stored procedure that returns multiple tables. I have already created and linked the C# DLL method GetData() that returns a DataSet (consisting of two DataTables having TableName as dtHeader and dtDetails). I have successfully assigned GetData to the ObjectDataSource (odsData) by following the steps in the Wizard. Now the DataSource property of odsData shows the DLL name and DataMember property shows the method name - GetData().

I have assigned odsData as the DataSource of the report.

I noticed that unlike SQLDataSource, the ObjectDataSource did not show the output (So does it mean that it cannot figure out the output tables metadata?). Also the "Data Explorer" tab shows only odsData (I was expecting DataTables and columns under it).

I added a textbox and opened the "Edit Expression" dialog. Then I clicked on the "Fields". I find that only odsData appearing but not the tables - dtHeader and dtDetails. (Screenshot attached).

So, how do I see the fields (columns) of the DataTables dtHeader and dtDetails in the report (since it looks like that metadata is not available)?

P.S. I have tested the DLL successfully. i.e. it returns two DataTables (in a DataSet) with rows.

I have imported a crystal report, which had 4 XML data sources which the Import Wizard of Standalone Report Designer has correctly converted to 4 SQL Data Sources.

Now, I must assign 4 SQL Server Stored Procedures (returning a dataset), 1 each for the 4 SQL Data Sources. Each stored procedure has some parameters. I can do this in the Configure Data Source Command window by selecting Stored Procedure.

My problem is that the SQL Database is determined at runtime. i.e. there are two databases having the same 4 stored procedures. So, it becomes a Dynamic command. So, I have to use "Select Statement" and not the "Stored Procedure" in the Command window.

It becomes something like EXEC {DBName}.[dbo].[StoredProc1] @prm1, @prm2 for 1st Data Source, EXEC {DBName}.[dbo].[StoredProc2] @prm for the second and so on for others.

DBName is determined at runtime. If there was only 1 SQL Data Source, I would have created a report parameter and created a binding like DataSource.SelectCommand= Format("{0}.[dbo].[StoredProc1]", Parameters.DBName.Value)

However, since there are 4 SQL Data Sources with each having a different stored procedure as its command, I cannot do this.

Any idea as to how to proceed in this situation?

Hello, I have a report that shows Barcodes for persons. In my development environment (Win11, .NET10), where I have installed the Report Designer for .NET10, it works perfectly (Barcode_Working_Dev.png).

When I deploy it in the production server where Telerik Report server is installed and run the report I get the underlying barcode number and not the barcode (Barcode_NotWorking_Server.png).

I am using Code39AzaleaNarrow3 Regular font (which is shown in the Font Property of the TextBox in the report).

I downloaded the Code39Azalea font from their website and installed on the server; however the issue still persists. Can you please let me know what should be done?

Thank you,

Nitin.

I have a class representing a SQL Server stored procedure output. The SP returns two datasets. I have a C# method that takes in parameters and runs the SP. It returns a ValueTuple (2 Lists - 1 each for the SP returned dataset). I tried to assign this method as the data source to an ObjectDatasource in the report (using standalone Report Designer); however I get an unexpected error (screenshot attached). Probably, it doesn't support a ValueTuple since if I connect to the class itself then it connects. If this is the case, what is the workaround?

We have been running in a little bit of an issue. We have tried adding a binding to the report itself for culture to be linked to parameter but it wont change the culture of the report. We can set the binding on individual text boxes and it works fine. The other issue is from what we have found is that the culture of the report is supposed to be defaulted to the what the locale is for the computer that is running the report and we have a few international customers that are reporting that is not working.

Telerik Reporting Report Globalization - Telerik Reporting

When I launch the Telerik Report Designer i now get the the error below, also pictured in the attachment. I was able to launch and use the application once before, but now only get this error.

"An error has occurred while merging the resource dictionaries. Make sure that no assemblies with Telerik Controls for WPF reside in the same directory as the application executable.

Error of type 'Telerik.ReportDesigner.Core.AppResourceMergeException' was thrown."

 

This seems to be the same issue mentioned here in another question on this forum.

Below is the folder with the exe files for the application. I have tried restarting the computer, reinstalling the application, and repairing the application. None of these have fixed the issue.

 

Dear Telerik Support Team,

I am reaching out to request technical assistance regarding the implementation of a "Terms and Conditions" section that should function as a completely independent additional page at the end of my report.

Current Report Structure: My main report includes Page Header, Detail, and Page Footer (containing total calculations) sections.

Current Configuration (Attempted without success): To force the legal text into an independent final page, I have configured the following:

• Section used: ReportFooterSection to contain the legal text.
• PageBreak Property: Set to Before.
• Text Component: HtmlTextBox with CanGrow set to True.
• KeepTogether Property: I have tested both True and False settings.

Persistent Issues: Despite these settings, the text is not being isolated correctly:

• Section Merging: The long text starts rendering immediately after the Details section on the main page, ignoring the page break or fragmenting erratically.
• Page Footer Conflict: The Page Footer elements (invoice totals and page numbers) from the main invoice continue to print on the pages where the legal text appears, causing visual overlaps.

Questions for the Support Team:

1. What is the cleanest way to add this final page? Given the standard report flow, how can I insert this block so it "breaks" the flow and takes over a full page without inheriting the layout (Header/Footer) of the previous pages?
2. Conditional Visibility Control: How do you recommend hiding the Page Header and Page Footer specifically on these final "Terms" pages?
3. Report Architecture: For text that spans one or more full pages, is it better to continue using the ReportFooterSection, or would you recommend using a SubReport or a Group Footer without a grouping expression?

Special Request: I have attached my report definition file (.trdp). Could you please review my current structure and modify the attached report using the most robust configuration to solve this behavior?

Dear Telerik Support Team,

I am reaching out to request technical assistance regarding the implementation of a "Terms and Conditions" section that should function as a completely independent additional page at the end of my report.

Current Report Structure: My main report includes Page Header, Detail, and Page Footer (containing total calculations) sections.

Current Configuration (Attempted without success): To force the legal text into an independent final page, I have configured the following:

• Section used: ReportFooterSection to contain the legal text.

• PageBreak Property: Set to Before.

• Text Component: HtmlTextBox with CanGrow set to True.

• KeepTogether Property: I have tested both True and False settings.

Persistent Issues: Despite these settings, the text is not being isolated correctly:

• Section Merging: The long text starts rendering immediately after the Details section on the main page, ignoring the page break or fragmenting erratically.

• Page Footer Conflict: The Page Footer elements (invoice totals and page numbers) from the main invoice continue to print on the pages where the legal text appears, causing visual overlaps.

Questions for the Support Team:

1. What is the cleanest way to add this final page? Given the standard report flow, how can I insert this block so it "breaks" the flow and takes over a full page without inheriting the layout (Header/Footer) of the previous pages?

2. Conditional Visibility Control: How do you recommend hiding the Page Header and Page Footer specifically on these final "Terms" pages?

3. Report Architecture: For text that spans one or more full pages, is it better to continue using the ReportFooterSection, or would you recommend using a SubReport or a Group Footer without a grouping expression?

Special Request: I have attached my report definition file (.trdp). Could you please review my current structure and modify the attached report using the most robust configuration to solve this behavior?

Hello,

I have the following scenario and would like guidance on how to achieve the desired behavior.

I have a panel that contains:

• some common elements (for example, a title and metadata textboxes), and

• an outer list, which itself contains an inner list.

The data source has the following structure (simplified):

[
  [
    { "Text": "exampleText1", "Value": 1 },
    { "Text": "exampleText2", "Value": 2 },
    { "Text": "exampleText3", "Value": 3 }
  ],
  [
    { "Text": "exampleText21", "Value": 1 },
    { "Text": "exampleText22", "Value": 2 },
    { "Text": "exampleText23", "Value": 3 }
  ]
]

The outer list is bound to the main data source.
The inner list uses a data source binding like:

DataSource = Fields.Item

The panel that contains the lists also includes common elements (title, metadata) that should only be visible when there is data.

The issue I am facing is related to visibility:
I would like to hide the entire panel (including the common elements) when there are no elements at all in the data structure (for example, when the outer list is empty or when it does not contain any inner items).

I have already tried the following approach:

• creating a report parameter bound to the data source,

• attempting to evaluate a condition such as Count(Fields.Item) > 0,

• setting the parameter to true or false based on that condition,

• and then binding the panel’s Visible property to this parameter.

However, I was not able to make this approach work as expected.

Could you please advise on the recommended way to detect this condition and properly control the panel’s visibility in this scenario?

Thank you in advance for your help.

Best regards,
Balazs

Hello.
I am using ASP.NET Framework, and in the Telerik.Reporting.Graph section I have a chart that is populated by a stored procedure.
The output of my stored procedure has three columns: DayOfMonth, ProductionType, and Value, and it is structured as follows.

DayOfMonth	ProductionType	Value
1	Staple	1244
1	SumAll	3066.2
1	Tow	1822.2
2	Staple	624.9
2	SumAll	3984.6
2	Tow	3359.7
3	Staple	1865.38
3	SumAll	5126.18
3	Tow	3260.8

ProductionType has three values: Tow, Staple, and SumAll.

I need SumAll to be displayed as a line chart, and Tow and Staple to be displayed as bar (column) charts within the same chart.
DayOfMonth should be displayed horizontally on the X-axis and represent the days of the month.

No matter how much I tried, I could not limit the ProductionType values in the line chart using the filters in:

• series < lineSeries1 < GraphGroup < Filters
• series < SeriesGroup < Filters

so that only ProductionType = SumAll is shown in the line chart.

The only place where I managed to apply this filter was in:

• Data < SeriesGroup < Filters

but that filters the entire dataset, causing the bar chart to be filtered as well.

Please help me with this issue.
A sample of my code is attached.

Thank you.