I have a standalone report that gets all the data from the table.  I added a bitmask filter to my SQL query, and I get the results I expect in SQL Studio.

SELECT 
    [Item],
    STRING_AGG([RuleNo], ', ') WITHIN GROUP (ORDER BY [RuleSort]) AS GroupedRuleNos
FROM [SFB_Annex].[dbo].[tblAnnex01]
LEFT JOIN [SFB_Annex].[dbo].[tblProducts] ON [tblAnnex01].[ProductID] = [tblProducts].[ProductID]
WHERE ([tblProducts].[QuadrantBitMask] & 32) != 0
GROUP BY [Item]
ORDER BY [Item];

When I try to add the bit mask as a filter, I keep getting an error "Cannot perform '<>' operation on System.Boolean and System.String."

Here is the filter I am trying to use:

                    Telerik.Reporting.Filter filter = new Telerik.Reporting.Filter();
                    filter.Expression = "=([tblProducts].[QuadrantBitMask] AND " + QuadrantBitMask.ToString() + ")";
                    filter.Operator = Telerik.Reporting.FilterOperator.NotEqual;
                    filter.Value = "!=0";
                    report.Filters.Add(filter);

How would I add the bitmasked value into the filter?

I'm getting below error while installing Telerik Reporting 2024 Q1 (18.0.24.130) Installation Error. I have downloaded the .msi file from Telerik site. Kindly Help.

I have been following the tutorials on creating PDFs of existing reports.  I have a function where I pass in the path name to the report (TRDP file).

Can you add filter or parameter to the report?

I just started to evaluate the Trial Version of Reports. The good news is that I was able to re-create one of my existing Crystal Reports to a Telerik Report using the Designer. The bad news is I can't get the report to display in my existing .NET Core App(.net 9). I get the same error message in this link:

https://docs.telerik.com/reporting/knowledge-base/cannot-access-the-reporting-rest-service

I used this link below to get started. 

https://docs.telerik.com/reporting/embedding-reports/host-the-report-engine-remotely/asp.net-core-web-api-implementation/host-reports-service-in-.net-with-controllers

It says at the bottom of the link that there is a full example in the install folder, but the example only contains the REST service piece, not a full example where a REST is attached to a project.

Anyways, I am not having any luck troubleshooting this error message.  There is a mention of creating a .log file, but that file is not being generated for me. I tried Fiddler - have never used that before. I see this message below popped up., but no idea what that means. Do you have a full working example somewhere with a project and attached REST service?

{"message":"An error has occurred.","exceptionMessage":"Invalid URI: The hostname could not be parsed.","exceptionType":"UriFormatException","stackTrace":null}

Hello,

I want to introduce some conditional parameters in my reports. Let me illustrate my case as follows:

Parameter_main - determines what other parameter will be visualized. Values are 1, 2, 3

Parameter_1, Parameter_2- only one is visualized depending on the selected value in Parameter_main.

If Parameter_main = 1 -> show only Parameter_1
If Parameter_main = 2 -> show only Parameter_2
If Parameter_main = 3 -> hide both Parameter_1 & Parameter_2 as they will not be used

Is there any way to achieve this only within the standalone report designer? I know that I can use the "Visible" property for the parameters but I cannot change it dynamically (through bindings) based on other parameters. Any ideas?

Regards,
Krasimir Baylov

Hello,

I am using Telerik Reporting and have a report that exports perfectly to PDF. However, when exporting to Excel, the formatting is incorrect, and some data appears to be missing (for exmaple POI which is location name under each time).

I would truly appreciate any guidance on how to resolve this. 

Hi,

I want to generate a table with n columns and m rows, depending of the data source, I think using the crosstab is the best option, but I don't understand how to pass the datasource.

Data for columns are a list of StartProcess, and data for rows are a list of EndProcess

public class ProcessTreatment()
{
    public List<StartProcess> StartProcesses { get; set; } = [];
    public List<EndProcess> EndProcesses { get; set; } = [];
}

public class StartProcess()
{
    public int Id { get; set; }
    public string Code { get; set; }
}

public class EndProcess()
{
    public int Id { get; set; }
    public string Code { get; set; }
}

I would to show the code of the process for each one.

I tried to bind the datasource [=Fields.ProcessTreatment] at the tab, then put the value [=Fields.StartProcesses] at the column header, but only one column with this "System.Collections.Generic.List`1[OptaPlanning.Business.Reports.StartProcess]" is shown.

Can someone would help me how to insert properly the datasource please ?