I have a report which includes some parameters.  One parameter pulls a list of organizations for which to pull data into the report.  There is another parameter which populates depending on which/how many organizations are chosen.  When all organizations are chosen, the second parameter will cause a time out because there can be a lot of values that are returned.

Is there a way to load these values in batches so that there is no wait time in loading of parameter values?

One idea I was thinking was to load in batches (although this may not be an option).

Any ideas will be much appreciated.

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?