Telerik Forums
Reporting Forum
16 answers
1.0K+ views
I have a multi-value parameter, @CountryID, that can also be set to null.  

I have a sql database query that uses this parameter like such:

"select * from Countries where CountryID is null or CountryID in (@CountryID)

Running the report, everything works as expected when I set the parameter value to NULL or to a single value.  However, if I set it equal to two or more values I get the following error:

An error has occurred while processing Table 'crosstab1': An expression of non-boolean type specified in a context where a condition is expected, near ','.

What am I missing?  How do I configure the parameter and/or adjust the query so that it works with NULL, single values and multiple values?

Thanks!
Jon
Top achievements
Rank 1
Iron
Iron
 updated answer on 14 Aug 2024
2 answers
86 views

Hello Telerik,

Please see the below 2 errors and 3 screenshots.   Thank you in advance for your assistance.


When I try to install Telerik.Reporting.Services.AspNetCore.Trial.18.1.24.709 I get the below errors.

 

When I try to install Telerik.UI.for.Blazor.Trial.6.1.0.nupkg  I get the below errors

 

 

This is the screenshot from the Virtual Classroom for Telerik Reporting.

Peter
Top achievements
Rank 1
Iron
Iron
Iron
 answered on 07 Aug 2024
1 answer
120 views

Hi,

I want to pass parameters to the report so that the font size in the Style of the report can be set according to the content of the parameters. For example, if the parameter ReportFontSize=9, then the font size of the content in the Label control and Table control in the report will be 9pt. Is there a way to achieve this currently?

Dimitar
Telerik team
 answered on 07 Aug 2024
1 answer
67 views

Hi 

I wanted to setup Telerik report in on of my asp.net web from application i am getting issue in-order to setup this please help me.

0 answers
51 views

Hi , we are reading some worksheet data using  Telerik.Web.Spreadsheet and most of the time it works fine but  also few times it fails and gives us the following error messsage 

Not supported to value: /xl/worksheets/sheet1.xml'  I have 2 examples one works fine and other is not. can you please guide us why one file is failing and other is not?

 

Kind Regards

 

 

Khawar
Top achievements
Rank 1
 asked on 07 Aug 2024
1 answer
61 views

Hello, 

I am trying to get the total rows from a table in my detail section that is bound to a secondary data source, that is, not the data source of the report.

The report is bound to a header data source that contains client information, and has one row.  The table in the detail section is bound to a second data source that contains all that client's products.

I would like to put a footer textbox with the total products from the table's total rows.

 

 

Momchil
Telerik team
 answered on 05 Aug 2024
1 answer
59 views

I'm trying the query builder for the first time, trying to create a very simple query. IDItemMaster and ItemMasterID are the keys. I click on add new relationship but nothing pops up and when I click on edit on the blank relationship the relationship tab closes. 

 

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 02 Aug 2024
1 answer
93 views

We converted the .rpt file to .trdp file using Telerik Standalone Report Wizard. We have a header and the details consist of many sub reports. we need to display the values in the sub reports getting the data from different select queries. We are not sure about specifying the data source for each sub report. 

Need help on the below items

1) How to set the data source to main report? how to set the separate data source to each sub report?

2) When we tried to set the data source for one of the sub report, we are able to only invoke the fields of that data source in another sub report. But we are able to create a separate data source in common. Can you help us with this?

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 02 Aug 2024
0 answers
368 views

Have been making some changes and updates to an existing Blazor web assembly project, and I have most things fixed/resolved regarding the reporting.   However, I get the following when trying to actually display a report:

 

"The version of the Report Viewer '18.1.24.606' does not match the version of the Reporting REST Service '18.1.24.709'. Please make sure both are running same version"

 

The dependencies in the projects all show Telerik Packages with version 18.1.24.709... so clearly I am overlooking something.  Clean & Rebuild does not help -- what am I overlooking.

 

Thanks.

 

Thanks in advance.

 

 

 

Bob Nonnemann
Top achievements
Rank 1
 asked on 01 Aug 2024
1 answer
253 views

Trying to integrate the native blazor report view into my we app, but running into all kinds of issues...I have the Rest Api installed, and the reportviewer.  I keep getting      

 Failed to load resource: the server responded with a status of 404 (Not Found)
telerik-report-viewer:1 Uncaught (in promise) Report '%2FReports%2FSampleReport.trdp' cannot be resolved. 

 or         

Failed to load resource: net::ERR_CONNECTION_REFUSED
telerik-report-viewer:1 Uncaught (in promise) Invalid ClientId  

 

The documentation is horrible and I can't get a response from support...hope somebody has some experience with this.

 

Also, .net 8 web app in auto mode...

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 31 Jul 2024
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?