Hello,

I want to display all the data of the table by default without selecting any option from dropdown filtering.

Or add a option "ALL" to the dropdown list to select all the data from the dropdown filtering.

I just try Telerik Reporting and try to connect to my index in Elasticsearch.

I use WebService Data Source and use this url

http://localhost:9200/[indexname]/_search?pretty=true&q=*:*

I am using the Telerik standalone Report designer - and connecting to SQL database. Tried to link to a stored procedure with dynamic query. The stored procedure executes fine and returns the results in SQL database.

Even "Execute Query" on the Telerik report wizard works fine and returns data rows.

When trying to add as a Telerik datasource it fails throwing the following error

 System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'UNION'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at Telerik.Reporting.Processing.Data.SqlSchemaAdapter.<GetFields>d__1.MoveNext()
   at Telerik.Reporting.Processing.Data.SimpleSchemaAdapter.Fill(SimpleDataModel model)
   at Telerik.Reporting.Processing.Data.SimpleDataProvider`1.GetSchemaCore()
   at Telerik.Reporting.Processing.Data.DataProvider`1.Telerik.Reporting.Processing.Data.IDataProvider.GetSchema()
   at Telerik.Reporting.Data.Design.DataSourceDesignerBase.Telerik.Reporting.Design.Interfaces.IDataSchemaProvider.GetSchema()
   at Telerik.Reporting.Data.Design.DataSourceService.GetSchemaFromContext(Object context)
   at Telerik.Reporting.Design.DataExplorerControl.<>c__DisplayClass2.<RefreshDataSource>b__0()
ClientConnectionId:b24a70f0-fdac-4dda-94a8-a732936c2ad9
Error Number:156,State:1,Class:15

How can I determine if the Parameters Area is visible on the HTML5 ReportViewer using javascript?

I know how to toggle it but I need to check if it is visible first before toggling.

I'm using HTML5 report viewer and I can access the report remotely and view it, but none of "Print", "Export to excel or PDF" works.

Also I tried accessing the report locally and I have tested each of the mentioned non-working functions, all of them were OK.

I thinkthe problem related to permissions but I don't know where and how I should change permissions to allow remote users be able to export report like a local user.

I have a problem with the placement of some text.

In my Word template there is a text in the footer (TextWord.png) and this text is on the first page next to the letter text. Unfortunately, I can't do that in the Report Designer. I have already tested with parent groups, but unfortunately it does not behave as I imagine it would.

Every Time my html field is growing the textboxes moves with the html box down.

Is what I want even possible?

If so, how is that possible?

Hi,

how should I transform data from my DataSource to show spaces correctly in HtmlTextBox?

The HTML renderer ignores repeated spaces (as I expeceted), so I thought about replacing space character " " with the non-breaking space HTML entity "&nbsp;".

It is actually feasible with HtmlTextBoxes with a constant content, but the space collapse is also applied on strings from DataSource, and this behavior is not acceptable, as those spaces are meaningful.

Is there a way to transform values from DataSource? I tried to wrap Fields references with the Replace() expression, trying to replace spaces with related HTML entity, but it does not work.

I paste a TRDX with embedded JSON data source down here:

What do you think I'm doing wrong?

Hi all,

In our app to show report we use HTML5 Report Viewer and Web Report designer. Our project based on .Net5.

There is a problem with report web designer after updating to R1.2021version. I used web service datasource in a report and created @url inline parameter and $expand query parameter into that datasource to make OData query. But as you see from the attached file, value of those parameters shown Object (see Invoice.png attached picture) instead of showing real value. I see this issue after updating to R1 2021, but in previous version it was showing correctly. If you open the report via Standalone Report Designer it shows correctly (second attached picture). Is it problem in R1 2021 or should I change something?